Issue 124139 - Spacing around Boolean Operators Grows with Each File Save
Summary: Spacing around Boolean Operators Grows with Each File Save
Status: CLOSED DUPLICATE of issue 15821
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.0.1
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-28 19:50 UTC by BrianJH
Modified: 2014-01-29 10:07 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description BrianJH 2014-01-28 19:50:55 UTC 
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)
Comment 1 Edwin Sharp 2014-01-28 20:42:13 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1560934
2014-01-27_04:11:25 - Rev. 1561585
Debian
Comment 2 hanya 2014-01-29 02:25:36 UTC 
Not only by save and reopen the file, this is happen on each editing of the cell 
in edit mode (F2 key).
Comment 3 Regina Henschel 2014-01-29 09:07:59 UTC 
There exist no operators AND or OR in ODFF. Use the functions AND() and OR(). I suggest to resolve to WONTFIX, see bug 104714. For details see bug 15821.

*** This issue has been marked as a duplicate of issue 15821 ***
Comment 4 Edwin Sharp 2014-01-29 09:16:12 UTC 
(In reply to Regina Henschel from comment #3)
> There exist no operators AND or OR in ODFF. 

Then why no error message?
Comment 5 Regina Henschel 2014-01-29 10:07:20 UTC 
(In reply to Edwin Sharp from comment #4)
> (In reply to Regina Henschel from comment #3)
> > There exist no operators AND or OR in ODFF. 
> 
> Then why no error message?

Because no one worked on it. If we want to keep these operators it would need a different formula name space than "of:=", or a change in the ODF specification. Making it clean or removing it, both are a lot of work and other areas are more important than repairing a not documented feature.

The file passes a check against Relax-NG Schema, because the type of the table:formula attribute is string, but it is invalid OpenFormula syntax nevertheless.