> 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+unsubscr...@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