Bug 207850 - Reversed Ranges from OpenOffice not handled
Summary: Reversed Ranges from OpenOffice not handled
Status: CONFIRMED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (show other bugs)
Version: 2.1
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-19 04:51 UTC by Colin
Modified: 2022-12-23 20:47 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Colin 2009-09-19 04:51:04 UTC 
Version:           2.1 Beta 2 (using KDE 4.3.1)
OS:                Linux
Installed from:    Ubuntu Packages

I had an ods spreadsheet created in OpenOffice.org.
It contains many formula with ranges.
When I loaded it in KSpread 2.1b2 several of the cells had reversed ranges (eg B79:B$78 ) and this causes SUM, COUNT etc to return 0.

I checked the original ods and found that OO.o had written the range in reverse.

I note that in OO.o if I enter a range in reverse it displays it forwards (e.g H96:H94 is displayed as H94:H96).

I would expect KSpread automatically to convert reverse ranges to forward ranges.
Comment 1 Andrew Crouthamel 2018-11-09 00:59:15 UTC 
Dear Bug Submitter,

This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond.

Thank you for helping us make KDE software even better for everyone!
Comment 2 Andrew Crouthamel 2018-11-18 03:24:24 UTC 
Dear Bug Submitter,

This is a reminder that this bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? This bug will be moved back to REPORTED Status for manual review later, which may take a while. If you are able to, please lend us a hand.

Thank you for helping us make KDE software even better for everyone!
Comment 3 Colin 2018-11-18 21:47:58 UTC 
I now use LibreOffice rather than OpenOffice.
LibreOffice Calc saves the range in the correct order.
 
You can close this bug.
Comment 4 Justin Zobel 2022-12-23 00:28:10 UTC 
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!