Bug 149125 - Formulas saved in Excel 97-2003 open wrong in MS Excel 2003 SP3
Summary: Formulas saved in Excel 97-2003 open wrong in MS Excel 2003 SP3
Status: RESOLVED DUPLICATE of bug 148993
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-05-17 10:31 UTC by LPC
Modified: 2022-05-18 10:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
simple .xls example (6.50 KB, application/vnd.ms-excel)
2022-05-17 10:33 UTC, LPC 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***