https://bugs.documentfoundation.org/show_bug.cgi?id=149125
Bug ID: 149125
Summary: Formulas saved in Excel 97-2003 open wrong in MS Excel
2003 SP3
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Simple column with some data and a second column dividing that data by a fixed
3rd value won't open correctly in MS Excel 2003 SP3 and OpenOffice Calc
Steps to Reproduce:
1.Introduce some data in column A
2.Insert value in B1
3.Use column C with formula =A1/$B$1 and drag down
4.Save as .xls excel 97-2003
Actual Results:
Open in MS excel 2003 SP3, C column is always A1/$B$1 , A1/$B$1... instead of
increasing A (A2, A3...)down the column.
Open in Apache OpenOffice Calc 4.1.3 C1 should be A1/$B$1 instead becomes
=C1/$B$1, C2/$B$1 ...
Expected Results:
Expected MS Excel and OpenOffice to open with correct formula in column C being
A1/$B$1 , A2/$B$1,A3/$B$1... the same as it opens in Libreoffice Calc
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Tested on Windows 8.1. Not tested in Linux. Realized problem first in 7.3.2.2
(might be earlier bug), updated to 7.3.3.2, problem remains.
--
You are receiving this mail because:
You are the assignee for the bug.
