https://bugs.freedesktop.org/show_bug.cgi?id=37860
--- Comment #21 from James Fuqua <[email protected]> 2011-10-06 12:26:06 PDT --- (In reply to comment #16) > (In reply to comment #15) > > > but the plain fact is that you can no longer import Excel or OO spreadsheets > > that use such functions. > > BTW Excel behaves this way. OOo didn't. So it's not so plain fact, is it. Sorry to be so late replying.... to the snippy comment. However, I want to understand where you are coming from. This is a _prior_ bug that has existed... since I've been working on spreadsheets (some 20 years, now)? Just so you understand where _I_ am coming from. 1) I base my comments on Excel 98... it has been THAT long since I have used it. I have used OpenOffice almost from the beginning. I have used LibreOffice since the first day it went public. 2) Some of my spreadsheets are 10-15 years old (or at least parts of them are). I have been using some version of the formula: A1=if(x<1;"";x+y); A2=1; A3=A1+A2 for that entire time. It has always worked. It worked in LO 3.3. It worked in LO 1.0. 3) I, as a user, have significant amounts of man-hours invested in my spreadsheets. When you say, "Oh, that was a prior bug that we're just now getting around to fixing", you are in essence saying, "Not my problem, user error." As a user, I expect thing to no be broken on the coding side (elegant or no). 4) I have been an evangelist for the OpenOffice, then LibreOffice, suite and have convinced many individual users and a few offices to convert; however, I must rethink this if "correct" or "elegant" coding approaches are going to so cavalierly going to trump users needs. 5) The toggle option does not sound like a sound approach. If anything, there should be a toggle to turn on the current default, not to turn on what has been the default for more than a decade. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
