RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

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.

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).

(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.

Fixed with https://gerrit.libreoffice.org/gitweb?p=core.git;a=commit;h=30e2171b6eac8e373e31f20de4a0cee6d5d64a08

Development Management has reviewed and declined this request. You may appeal this decision by reopening this request.