Bug 60167 - Database ranges don't get saved when saving to Excel 97/XP/2003
Summary: Database ranges don't get saved when saving to Excel 97/XP/2003
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLS Calc-DataRange
  Show dependency treegraph
 
Reported: 2013-02-01 18:47 UTC by Kohei Yoshida
Modified: 2023-07-06 02:36 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
test doc (7.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-02-01 18:47 UTC, Kohei Yoshida
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kohei Yoshida 2013-02-01 18:47:33 UTC
Created attachment 74060 [details]
test doc

When saving a document with database range to Excel 97/XP/2003 format, the database range disappears.  That's because Excel didn't support this until 2007.

1. Open the attached ods document,
2. Save it as .xls.
3. Re-open it either in Excel or Calc.
4. You get error in B5.
Comment 1 Kohei Yoshida 2013-02-01 18:52:17 UTC
The tricky part with this is

1) We need to map our database ranges to Excel's Table for 2007 and newer, while mapping perhaps to named ranges for 2003 and earlier.

2) When mapping them to named ranges for 2003 and earlier, we need to figure out how to handle cases where named range and database range of identical name exist.
Comment 2 Alex Thurgood 2015-01-03 17:40:14 UTC
Adding self to CC if not already on
Comment 3 QA Administrators 2016-01-17 20:02:27 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2017-03-06 13:55:15 UTC Comment hidden (obsolete)
Comment 5 lol 2021-03-08 13:55:05 UTC
This is still present in

Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-GB
Calc: threaded
Comment 6 Diana Vides 2023-07-06 02:36:15 UTC
This bug is still able to reproduce in Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 6; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: hr-HR (en_US); UI: en-US
Calc: threaded

Also, it is still present in Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 105f057f5b994b7d79a55ca719240839c2d45b54
CPU threads: 6; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: hr-HR (en_US); UI: en-US
Calc: CL threaded