Re: [libreoffice-users] Re: Re: Stuck with 3.3 forever?

2011/12/5 Harold Fuchs <hwfa.gmanenews@gmail.com>:
> "Johnny Rosenberg" <gurus.knugum@gmail.com> wrote in message
> news:CADo7T4d47+3cOmv6+rbHbLoeB6wpiLHF3isRFm0O5qmPkcx62Q@mail.gmail.com...
>
> > 2011/12/3 Pedro <pedlino@gmail.com>:
> > > Johnny Rosenberg wrote
> > > > I could agree with that, but it would have been nice if they thought
> > > > of that since 1.0 and not changing it on the way, breaking a whole lot
> > > > of spreadsheets…
> > >
> > > I see your point. But this was wrong.
> > > It's not a change of plans it's simply a correction. And not fixing it
> > > would
> > > break a lot of other spreadsheets ;)
> > >
> > >
> > > Johnny Rosenberg wrote
> > > > Is there another way to make A2 look empty in
> > > > this case, making it useable for calculations? Something like the
> > > > following:
> > > > =IF(A1=6;SomethingNiceToPutHere;B1)
>
> <snip>
>
> What happens if you set A3 to be =((A2&"0")/10+27)
> So, for example, if A2 is 30, A2&"0" is 300; divide by 10 gives 30 again and
> then add the 27. But if A2 is "" (empty), A2&"0" should force a numeric zero
> which stays the same when divided by 10.

I can't test that right now, because I have 3.3.4 on this computer. I
left the other computer, with 3.4.4, at work. I usually only take it
home for weekends. Ok, I know how that sounds… ha ha ha…
Still, even if it works, the N() solution seems to be a more obvious solution…

Thanks to everyone who came up with ideas, though. I appreciate it.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+help@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