You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/09/15 21:16:10 UTC

[Issue 126527] New: Formulae Keep Getting Additional Spaces Added

https://bz.apache.org/ooo/show_bug.cgi?id=126527

          Issue ID: 126527
        Issue Type: DEFECT
           Summary: Formulae Keep Getting Additional Spaces Added
           Product: Calc
           Version: 4.1.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P5
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: jimoconnor100@hotmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the issue.