On 2/7/2014 9:10 PM, Carl Paulsen wrote:
The biggest problem is that if the formula doesn't meet MSO's
standards, you can't leave it in place to work on later. I've had
formulas which took me days to work out, and if I can't leave them in
place even when faulty, then I have to re-create them each time. When
they are so terribly long, with many layers of nested functions,
losing them is a disaster. Yet Excel prevents you from saving them
unless they "work." BAH!
I have no experience with M$O specifically, and have no interest in
making excuses for its failings, but with those s.sheets that I do use,
"all" you have to do in this situation is put a quote at the start of
the formula, thereby making it text. The formula should then be
preserved as text, and can be saved as such, until you want to work on
it again; removing the quote makes it back into formula. Isn't that a
reasonable work-around for their unreasonable default action?
--
To unsubscribe e-mail to: [email protected]
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
