Re: [libreoffice-users] [CALC] row_only and column_only cell references

> 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. 
"=Sheet2!C4").

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
> formulas.
>
> 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?

TIA,
Ady.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted