Issue 103677 - Modified formula in remote cells after an import from Excel 2003 (.XLS)
Summary: Modified formula in remote cells after an import from Excel 2003 (.XLS)
Status: CLOSED DUPLICATE of issue 95256
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa, regression
Depends on:
Blocks:
 
Reported: 2009-07-20 22:32 UTC by lanciaux
Modified: 2009-07-26 12:39 UTC (History)
6 users (show)

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

Attachments
Binary Excel 2003 file (.XLS) which has example of trouble in remote formula (31.50 KB, application/vnd.ms-excel)
2009-07-20 22:34 UTC, lanciaux 		no flags Details
Original file exported from OOO 3.1 with right formula (28.50 KB, application/vnd.ms-excel)
2009-07-20 22:35 UTC, lanciaux 		no flags Details
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 lanciaux 2009-07-20 22:32:15 UTC 
Hello,

I've noticed this bug a long time ago (for sure in 3.0.x). Today, I take a
strong example to help describing it. It happens when you open a binary 2003 XLS
file - some remote cells have their references in formula changed (shifted a lot
to the right in fact).

Here you will find 2 files - first is a OOO 3.1 Calc (Excel_formula_import.xls)
file exported to a Excel file (for convenience because same trouble arises also
with a "fresh" Excel file).

I've written back after one modification with Excel 2003 to a second file
(Excel_formula_import_in_OOO.xls).

So, those two files should be similar - they are almost ... here is the catch
with Excel (true formula in cell) compared to OOO (false formula in cell) :

Example 1 : EW6 (=N6 OK) compared to imported EW6 (=JJ6 NOK)

Example 2 : FA6 (=M6+N6 OK) compared to imported FA6 (=JI6+JJ6 NOK)

Hope this will help finding an issue because when you have a large file with a
lot of columns, it is quite tricky to find what is wrong.

Ludovic (Belgium)
Comment 1 lanciaux 2009-07-20 22:34:06 UTC 
Created attachment 63657 [details]
Binary Excel 2003 file (.XLS) which has example of trouble in remote formula
Comment 2 lanciaux 2009-07-20 22:35:33 UTC 
Created attachment 63658 [details]
Original file exported from OOO 3.1 with right formula
Comment 3 amy2008 2009-07-23 07:55:58 UTC 
Can reproduce it in DEV300m52 on WinXP.

Open the document Excel_formula_import_in_OOO.xls with OOo, 
 FA6 = JI6+JJ6 
 EW6 = JJ6
But if open the document Excel_formula_import_in_OOO.xls with MS office,
 FA6 = M6+N6
 EW6 = N6
Comment 4 kpalagin 2009-07-23 10:18:57 UTC 
As described by amy2008 - we incorrectly import some cells, specifically EW6 
and FA6.

This is regression as 2.4.1 imports those cells correctly.
I think this issue deserves P2.

Please consider for 3.1.1.

Ludovic,
thanks a lot for your report!
Comment 5 nbinont 2009-07-26 03:10:47 UTC 
Can also reproduce it in OOO300m9 Build 9358 (3.0.0) on Windows XP

Results as per amy2008

Could someone with MSExcel 2003 confirm that "Excel_formula_import_in_OOO.xls"
is correct in excel?
Comment 6 nbinont 2009-07-26 03:18:52 UTC 
can also confirm both files import correctly in 2.3.1
Comment 7 niklas.nebel 2009-07-26 12:38:27 UTC 
It's a duplicate.

*** This issue has been marked as a duplicate of 95256 ***
Comment 8 niklas.nebel 2009-07-26 12:39:01 UTC 
closing duplicate