https://bugs.documentfoundation.org/show_bug.cgi?id=86575
Timur <gti...@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gti...@gmail.com Version|4.4.0.0.beta1 |3.3.0 release Summary|FILEOPEN: LO4.4.00beta1 |FILESAVE to .xslx with |when save *.ods to *.xslx |named ranges deleted gives |and open in excel give |error in Excel |error | --- Comment #18 from Timur <gti...@gmail.com> --- This has always been the same, from LO 3.3. I change title from " FILEOPEN: LO4.4.00beta1 when save *.ods to *.xslx and open in excel give error" to "FILESAVE to .xslx with named ranges deleted gives error in Excel". (In reply to Beluga from comment #17) > Seems to be because of non-existing references (#REF!) in the named ranges. > Same category as bug 92841 Good catch. That one looks like a duplicate. Comment https://bugs.documentfoundation.org/show_bug.cgi?id=92841#c7 probably applies here: "If someone could try out what MS-Excel exactly saves when saving such named expression that contains a reference to a deleted sheet we could mimic that if it differs." Isn't that seen from OXML standards? Here is how it looks like: LO content.xml: <office:spreadsheet> <table:named-expressions> <table:named-range table:name="nameA2" table:base-cell-address="" table:cell-range-address="$#REF!.$A$2"/> </table:named-expressions> </office:spreadsheet> MS workbook.xml: <workbook> <definedNames> <definedName name="NA2t">#REF!</definedName> </definedNames> </workbook> raal's XLSX test files make no sense, instead there should be ODS minimal test file for this error. Because it's not clear when this happens. I tried with a single named range in ODS, later deleted and saved as XLSX, and there's no error. So, looks like this bug should be a request to adjust non-existing references (#REF!) in the named ranges when saving as XLSX, but only after the cause is found. BTW: When saving or opening as ODS or XLSX, there is no warning in LO or MS that named ranges don't exist anymore. I'm not aware of some validation technique. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs