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