https://bugs.freedesktop.org/show_bug.cgi?id=75951
Priority: medium
Bug ID: 75951
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: Calc - If statement modified by opening in
libreoffice 4.2.2
Severity: normal
Classification: Unclassified
OS: All
Reporter: mjceall...@msn.com
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 95411
--> https://bugs.freedesktop.org/attachment.cgi?id=95411&action=edit
Sample Spreadsheet, screen shots
Problem description: In an xls spreadsheet that I use for processing results in
athletics races I copy runners details from one sheet to another using IF
statements. When I upgraded from Libreoffice 4.1.5 to 4.2.2 the If statements
in 2 columns were modified when I opened the spreadsheet.
In the attached spreadsheet the “Print PS Boys” sheet, cell D6 contains the IF
statement below when the file is opened in Libreoffice calc V4.1.5.
=IF($'Primary Boys Res'.B7="","",$'Primary Boys Res'.B7)
When the same file is opened in Libreoffice Calc V4.2.2 the IF statement now
reads
=IF($'Primary Boys Res'.IX7="","",$'Primary Boys Res'.IX7)
The IF statements in Column E are also similarly affected however the If
Statements in Columns B, C and F are unaffected.
Also attached are screen shots showing the sample sheet when opened with Calc
V4.1.5 and with V4.2.2.
Using V4.2.2 I tried correcting the IF statements by replacing IX with B
however when the file was saved and re-opened columns D and E were again
showing the modified formula.
The problem occurred on Windows XP, Vista and 7 PCs.
Operating System: All
Version: 4.2.1.1 release
Last worked in: 4.1.5.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
