2011/12/5 Harold Fuchs <[email protected]>: > > "Johnny Rosenberg" <[email protected]> wrote in message > news:cado7t4d47+3comv6+rbhbloeb6wpilhf3isrfm0o5qmpkcx...@mail.gmail.com... > >> 2011/12/3 Pedro <[email protected]>: >>> >>> >>> 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: [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
