Re: [libreoffice-users] MS Office woes

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+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