sounds like an easy work-around;
which would also work as a bookmark to show where you left off
;-)
From: marianne-x <[email protected]>
Date: Fri, Feb 7, 2014 at 10:26 PM
Subject: Re: [libreoffice-users] MS Office woes
To: [email protected]
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
