Bug 60167

Summary: Database ranges don't get saved when saving to Excel 97/XP/2003
Product: LibreOffice Reporter: Kohei Yoshida (inactive) <libreoffice>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: iplaw67
Version: unspecified   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: test doc

Description Kohei Yoshida (inactive) 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 (inactive) 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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.