Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 17 Jun 2012 09:40:42 +0200What's the difference between "Calc A1" and "Excel A1"https://ask.libreoffice.org/en/question/3294/whats-the-difference-between-calc-a1-and-excel-a1/I can choose between Calc A1, Excel A1 and Excel R1C1 syntax for formulas.
I understand what R1C1 does. It's in Excel's documentation. However I can't find what separates Calc A1 from Excel A1.
What's the difference?Thu, 14 Jun 2012 02:16:18 +0200https://ask.libreoffice.org/en/question/3294/whats-the-difference-between-calc-a1-and-excel-a1/Comment by chimak111 for <p>I can choose between Calc A1, Excel A1 and Excel R1C1 syntax for formulas.</p>
<p>I understand what R1C1 does. It's in Excel's documentation. However I can't find what separates Calc A1 from Excel A1.</p>
<p>What's the difference?</p>
https://ask.libreoffice.org/en/question/3294/whats-the-difference-between-calc-a1-and-excel-a1/?comment=3311#post-id-3311I can't answer but the choice has been around since at least [2009](http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=52294#52294). And the closest I got to an explanation is in the section titled "Microsoft Excel Compatibility" [here](http://www.novell.com/doc).Fri, 15 Jun 2012 18:44:55 +0200https://ask.libreoffice.org/en/question/3294/whats-the-difference-between-calc-a1-and-excel-a1/?comment=3311#post-id-3311Comment by Pedro for <p>I can choose between Calc A1, Excel A1 and Excel R1C1 syntax for formulas.</p>
<p>I understand what R1C1 does. It's in Excel's documentation. However I can't find what separates Calc A1 from Excel A1.</p>
<p>What's the difference?</p>
https://ask.libreoffice.org/en/question/3294/whats-the-difference-between-calc-a1-and-excel-a1/?comment=3318#post-id-3318I can't answer either and it is not explained in the current documentation. However I reported this to the LibreOffice Documentation team and hopefully it will be included in the documentation for version 3.6Sat, 16 Jun 2012 09:40:28 +0200https://ask.libreoffice.org/en/question/3294/whats-the-difference-between-calc-a1-and-excel-a1/?comment=3318#post-id-3318Answer by moggi for <p>I can choose between Calc A1, Excel A1 and Excel R1C1 syntax for formulas.</p>
<p>I understand what R1C1 does. It's in Excel's documentation. However I can't find what separates Calc A1 from Excel A1.</p>
<p>What's the difference?</p>
https://ask.libreoffice.org/en/question/3294/whats-the-difference-between-calc-a1-and-excel-a1/?answer=3328#post-id-3328Calc and Excel use different separators and different syntax for addressing files.
Just two short examples:
=Sheet1!D23 is the Excel syntax for addressing a cell in another sheet
=Sheet1.B14 is it in Calc
='Untitled1'#$Sheet1.$B$14 is the calc syntax to reference a cell in another file
=[Book1]Sheet2!$F$17 is it in Excel
Please also note that all special character from CalcA1, ExcelA1 and ExcelR1C1 are forbidden in names.Sun, 17 Jun 2012 09:40:42 +0200https://ask.libreoffice.org/en/question/3294/whats-the-difference-between-calc-a1-and-excel-a1/?answer=3328#post-id-3328