Bug 1390776 - [fix available] relative row references in MS Excel 2003 XML files are computed incorrectly
Summary: [fix available] relative row references in MS Excel 2003 XML files are comput...
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Red Hat Enterprise Linux 6
Classification: Red Hat
Component: libreoffice
Version: 6.8
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: rc
: ---
Assignee: David Tardon
QA Contact: Desktop QE
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-11-01 23:59 UTC by Carl Byington
Modified: 2017-11-06 10:14 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-11-06 10:14:46 UTC
Target Upstream Version:

Attachments (Terms of Use)
sample xml/xls file showing the 17 line offset error (4.00 KB, application/xml)
2016-11-01 23:59 UTC, Carl Byington 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Description Carl Byington 2016-11-01 23:59:39 UTC 
Created attachment 1216279 [details]
sample xml/xls file showing the 17 line offset error

Description of problem:

Libreoffice calc (and MS Excel) can load a spreadsheet from an xml file. The sample is attached.

Version-Release number of selected component (if applicable):
libre office version 4.3.7.2, build id 4.3.7.2-2.el6

How reproducible:
Always

Steps to Reproduce:
1. ooffice test.xls

Actual results:
Cell A28 contains contain a formula "=SUM(A35:A40)"

Expected results:
Cell A28 should contain a formula "=SUM(A18:A23)"

Additional info:
The xml file represents that formula as "=sum(R[-10]C:R[-5]C". Row 28-10 is row 18. Other production files that I am working with also have the same error. All the relative row numbers are off by 17.
Comment 1 David Tardon 2016-11-02 09:16:29 UTC 
For some reason the import filter thinks it is at row 45 when translating the formula (my guess is that it counts the Column elements in addition to Row).
Comment 2 David Tardon 2016-11-02 09:17:55 UTC 
(In reply to David Tardon from comment #1)
> (my guess is that it counts the Column elements in addition to
> Row).

Yeah, it's that.
Comment 4 David Tardon 2016-11-02 18:35:50 UTC 
Fixed with https://gerrit.libreoffice.org/gitweb?p=core.git;a=commit;h=30e2171b6eac8e373e31f20de4a0cee6d5d64a08
Comment 6 Red Hat Bugzilla Rules Engine 2017-11-06 10:14:46 UTC 
Development Management has reviewed and declined this request. You may appeal this decision by reopening this request.
Note You need to log in before you can comment on or make changes to this bug.