https://issues.apache.org/ooo/show_bug.cgi?id=124139

            Bug ID: 124139
        Issue Type: DEFECT
           Summary: Spacing around Boolean Operators Grows with Each File
                    Save
           Product: Calc
           Version: 4.0.1
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: ui
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected]

Spreadsheet cell formulas that contain Boolean operators grow in length with
each spreadsheet file save&close&open. This is caused by Boolean operators
being padded with an extra leading and trailing space character at some point
in each save&close&open iteration.

This seems like a minor issue but it can cause real headaches in spreadsheet
files that are opened and closed dozens of times a week that contain numerous
complex Boolean formulas.

This affects cell formulas as well as formulas used in conditional formatting.

Example:

New File...
=(B10) AND (B11)
First Save&Close&Open...
=(B10)  AND  (B11)
Second Save&Close&Open...
=(B10)   AND   (B11)
Third Save&Close&Open...
=(B10)    AND    (B11)
.
.
.
Twentieth Save&Close&Open...
=(B10)                     AND                     (B11)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

Reply via email to