Re: [libreoffice-users] MS Office woes

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: users+unsubscribe@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