Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Formulae Keep Getting Additional Spaces Added|
|Component:||editing||Assignee:||AOO issues mailing list <issues>|
|Status:||UNCONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description Jim 2015-09-15 19:16:10 UTC
I typed the following formula with a single space between each element but when I revisit the cell I find Calc has added many unwanted spaces, so now it looks as below: =IF ( AND ( $F50 = "" ; OR ( $E50 <> "" ; AND ( $R50 <> "" ; $R50 > TODAY() ) ) ) ; $I50 * $J50 * ( $B$6 / 7 ) ; "" ) I don't know if this is a bug or a feature but thought I'd log it just in case....