Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi :)  
Is it possible to change the way Calc handles it's formulas by doing 

Tools - Options - Calc - Formula 

and then use the drop-down to make them use MS Excel ways.  I can't
The problem with this setting is that there is no explanation of what 
it really means / implies (other than "=$Sheet2.C4" vs. 

The difference between "R1C1" and "A1" is likely clear enough for 
anyone that might want / need to use it. But what are the differences 
between "Calc A1" and "Excel A1"? Are "row_only" references accepted 
when setting it to "Excel A1"?

Even if I try and test the possible difference regarding "1:1" and 
"A:A" references, I don't know what else could change. Without 
documentation, I can't know of pros and cons, or compatibility or any 
other implications of this particular setting.

help thinking that trying to copy MS Excel at a time when they have
finally admitted, and corrected, some very fundamental errors in their

Regards from  Tom :)   

FWIW, I should point out that Excel is no the only one accepting this 
type of reference.

I'm not saying that Calc should promote "bad practices" or anything 
like it. I'm not saying that using row_only references is better in 
any way. I am not promoting its use.

But when receiving a file from other sources and it errors, it is not 
always easy to track down the problem or the incompatibility. And 
even then, it is not always possible for one user to edit and share 
the file with others.

Additionally, if a user of Calc searches for some method or formula 
to achieve something he doesn't know how to do it by himself, it is 
common to find such solution expressed in the context of other 
spreadsheet software (typically, Excel).

From a final user's perspective, I don't see a reason not to support 
it. Of course there might be technical / development reasons, but 
this is a *users* mailing list :).

So, I left with several questions here. Hopefully, someone has some 
answer(s) or can point into the right direction?


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.