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
