Bug 149125

Summary:	Formulas saved in Excel 97-2003 open wrong in MS Excel 2003 SP3
Product:	LibreOffice	Reporter:	LPC <luispdecarvalho>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.3.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=148993
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	simple .xls example

Description LPC 2022-05-17 10:31:11 UTC

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.

Comment 1 LPC 2022-05-17 10:33:41 UTC

Created attachment 180152 [details]
simple .xls example

Comment 2 Mike Kaganski 2022-05-17 10:54:30 UTC

Likely a dupe of tdf#148993.

Comment 3 LPC 2022-05-17 15:17:24 UTC

(In reply to Mike Kaganski from comment #2)
> Likely a dupe of tdf#148993.

yes, does sound like the same, I did a search before submitting but it didn't show up as it doesn't mention excel in the title. Glad to know it will be fixed in 7.3.4

Comment 4 m_a_riosv 2022-05-17 15:18:01 UTC

For me works fine, creating from scratch.
Version: 7.3.3.2 (x64) / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
and
opens fine with Microsoft® Excel® for Microsoft 365 MSO (Version 2204 Build 16.0.15128.20210) 64-bit

Comment 5 LPC 2022-05-18 10:43:45 UTC

I suppose "Microsoft 365 MSO" overcomes the error just like libreoffice (the .xls file opens fine in LO, but wrong in MS Excel 2003 SP3 and Apache OO Calc 4.1.3, with different errors btw).

Tried the latest dev build and now the file saved in .xls opens fine in MS Excel 2003 SP3 and Apache OO Calc 4.1.3


Version: 7.3.4.0.0+ (x64) / LibreOffice Community
Build ID: 54f0c89ef7a93b12e6be67716bc55a47b69cb9a6
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

So I guess that's fixed same bug as reported in https://bugs.documentfoundation.org/show_bug.cgi?id=148993

Comment 6 LPC 2022-05-18 10:44:08 UTC


*** This bug has been marked as a duplicate of bug 148993 ***