I suppose you're right. With some work I could have found a workaround,
and I appreciate your idea. My issue is much more about the way MSO is
set up by default, and changes to that are not especially apparent.
But your point is well taken.
Carl
On 2/7/14 11:26 PM, marianne-x wrote:
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?
--
Carl Paulsen
Dover, NH 03820
--
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