[Libreoffice-bugs] [Bug 86575] FILESAVE to .xslx with named ranges deleted gives error in Excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=86575

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |

--- Comment #23 from Eike Rathke  ---
Taking care of this.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 86575] FILESAVE to .xslx with named ranges deleted gives error in Excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=86575

--- Comment #22 from Eike Rathke  ---
(In reply to Timur from comment #18)
> LO content.xml:  
>  table:cell-range-address="$#REF!.$A$2"/> 
> 

Which btw is wrong as well, it should be only "#REF!"

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

The cause is simple. The sheet where the reference pointed to was deleted.
Which actually can be seen with the internal "#REF!.$A$2" display string, the
information would get lost when writing the correct "REF!" only, but that's how
it is defined.

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

The name does exist, just not the sheet it was pointing to.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 86575] FILESAVE to .xslx with named ranges deleted gives error in Excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=86575

--- Comment #21 from vlb  ---
The problem is already in LO 5.1.0.3 (x64).

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 86575] FILESAVE to .xslx with named ranges deleted gives error in Excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=86575

--- Comment #20 from vlb  ---
can solve this problem?

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

[Libreoffice-bugs] [Bug 86575] FILESAVE to .xslx with named ranges deleted gives error in Excel

[bugzilla-daemon]

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: workbookdefinedNames 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

[Libreoffice-bugs] [Bug 86575] FILESAVE to .xslx with named ranges deleted gives error in Excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=86575

Timur gti...@gmail.com changed:

   What|Removed |Added

 CC||andrej...@gmail.com

--- Comment #19 from Timur gti...@gmail.com ---
*** Bug 92841 has been marked as a duplicate of this bug. ***

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