Bug 38113 - [CALC] Not correct named range use in a formula (saved to xls format)
Summary: [CALC] Not correct named range use in a formula (saved to xls format)
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.0 release
Hardware: x86-64 (AMD64) Linux (All)
: medium major
Assignee: Markus Mohrhard
URL:
Whiteboard: target:3.5 target:3.4.2
Keywords:
Depends on:
Blocks:
 
Reported: 2011-06-09 07:40 UTC by Ismael Cedillo
Modified: 2011-12-23 14:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
the two files for testing the bug (error in named range from xls files) (6.93 KB, application/x-7z-compressed)
2011-06-09 07:40 UTC, Ismael Cedillo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ismael Cedillo 2011-06-09 07:40:13 UTC 
Created attachment 47770 [details]
the two files for testing the bug (error in named range from xls files)

Hello,

Version 3.4 rc2
SO: Ubuntu 11.04
Hardware: x86-64 (AMD64)

When a Calc document using formulas with named range included is saved as xls format, at reopening xls file the contents is marked as #NAME? instead the named range.

This problem is not present to open the file in odf native format...and the 3.3.2 version is opening the xls file very well.

Thanks
Comment 1 Rainer Bielefeld Retired 2011-06-10 02:58:14 UTC 
RC2 is bit by bit identical with release version, so separate items in the version picker are useless. Changes have been discussed with Michael Meeks.
Comment 2 Ismael Cedillo 2011-06-29 13:34:55 UTC 
(In reply to comment #1)
> RC2 is bit by bit identical with release version, so separate items in the
> version picker are useless. Changes have been discussed with Michael Meeks.

OK the error is present in:

3.4 release
3.4 RC2
3.4 RC3

Does any body know about a solution in progress?

Thanks
Comment 3 Ismael Cedillo 2011-06-29 13:35:58 UTC 
(In reply to comment #2)
> (In reply to comment #1)
> > RC2 is bit by bit identical with release version, so separate items in the
> > version picker are useless. Changes have been discussed with Michael Meeks.
> 
> OK the error is present in:
> 
> 3.4 release
> 3.4 RC2
> 3.4 RC3
> 
> Does any body know about a solution in progress?
> 
> Thanks

Pardon, say 3.4 RC2 should say 3.4.1 RC2 and 3.4.1 RC3  thanks
Comment 4 Liz Young 2011-07-15 05:18:52 UTC 
Issue exists on 3.4.2 rc1 -- named range does not save from ods to xls.

LibreOffice 3.4.2 
OOO340m1 (Build:201)

Ubuntu 11.04
GNOME 2.32.1

-Create a named range and save as Excel 97/2000/XP.
The named range does not exist after closing/opening the xls file.
Comment 5 Stefano Fraccaro 2011-07-18 04:35:45 UTC 
(In reply to comment #4)
> Issue exists on 3.4.2 rc1 -- named range does not save from ods to xls.
> 

I hope this bug is fixed before the final version... version 3.4.2 should be the one for enterprises.
Comment 6 Markus Mohrhard 2011-07-20 13:44:51 UTC 
I'll take it. As long as you don't set the component to Spreadsheet it is hard to find such bugs.
Comment 7 Markus Mohrhard 2011-07-21 02:20:49 UTC 
should be fixed in 3.4.2
Comment 8 Cor Nouws 2011-07-24 16:09:05 UTC 
Hi Ismael, *,
Could you please check this in the release candidate for 3.4.2?
http://www.libreoffice.org/download/pre-releases/
Thanks! Cor
Comment 9 Liz Young 2011-07-25 04:59:57 UTC 
(In reply to comment #8)
> Hi Ismael, *,
> Could you please check this in the release candidate for 3.4.2?
> http://www.libreoffice.org/download/pre-releases/
> Thanks! Cor

I can recreate this issue as in my comment #4 with 3.4.2 RC2. The named range is deleted when saving to Excel 97/2000/XP.  Perhaps this is a different issue than Ismael's?  Please advise to open a new issue, or this bug report re-opened.  Thanks.
Comment 10 Markus Mohrhard 2011-07-26 16:36:42 UTC 
Please be aware of the difference between database ranges(will not be exported to xls) and named ranges(will be exported to xls).

Excel does not support the concept of named database ranges and therefore we can't export them to xls.