Created attachment 96250 [details]
Document for reproducing
Steps to reproduce:
1. Open the attached file "Export_Standard.xls"
2. You, that there are named items like "ExportTitle" and "ExportName"
3. Duplicate the sheet
The new sheet does not have the named items. If you open this file in MS Excel and copy the sheet, the named items are duplicated too.
I think the reason ist, that in the original Excel file the named items are local in the sheet, but treated global in LibreOffice. That's why they are not copied.
Named items are duplicated too. Treat them as local in the sheet or treat them as they are defined in Excel.
I do not reproduce it on 188.8.131.52 and 184.108.40.206 using Win7x64
I did these steps:
- right click on the sheet tab
- select move/copy
- click OK
the duplicated sheet looks exactly the same as the original
am I missing something?
I just reproduced it on 220.127.116.11 using Win7x64:
Yes, the sheets look exactly the same after duplication, but there is a small difference:
In Calc/Excel you can give ranges/cells specific names. In general, a cell can be accessed by its "coordinates" like A1 (the top-left cell). But you can give it a "name" which can be used in formula or by external programs filling data into the sheet.
If you open the example xls and select the top-left cell (A1), you see in the combo box left of the formula field, that it has a name "ExportTitle". The same is with cell B2, which has the name "ExportDate".
If you duplicate this sheet in Calc, the new sheet is missing this names. If you do this with MS Excel, the cells A1 and B2 keep their names in the new sheet.
Hope, that this makes the problem more clear.
Hi Torge, please see Bug 75372. Looks very similar..
Btw I can confirm cell names not copied to another sheet, just the values that copied. I also saw in different bugs, indeed there are some problems in copying cell names (to internal & external file).
Tested in 18.104.22.168 (Ubuntu 12.04 x86)
(In reply to comment #0)
> I think the reason ist, that in the original Excel file the named items are
> local in the sheet, but treated global in LibreOffice. That's why they are
> not copied.
Anyway..you said those names is local name ? I saw those as global name.
Your file created using Excel? Which version?
(In reply to comment #3)
> Hi Torge, please see Bug 75372. Looks very similar..
> Btw I can confirm cell names not copied to another sheet, just the values
> that copied. I also saw in different bugs, indeed there are some problems in
> copying cell names (to internal & external file).
> Tested in 22.214.171.124 (Ubuntu 12.04 x86)
Yes, that bug looks very similar.
(In reply to comment #4)
> (In reply to comment #0)
> > I think the reason ist, that in the original Excel file the named items are
> > local in the sheet, but treated global in LibreOffice. That's why they are
> > not copied.
> Anyway..you said those names is local name ? I saw those as global name.
> Your file created using Excel? Which version?
Yes, that file is created with Excel, since the application is used in different environments. Some (still) with Excel, some with Calc. File is created using MS Excel 2003 SP 3 (11.8404.8405).
As I understand, names are always local in Excel. But I'm not sure.
> As I understand, names are always local in Excel. But I'm not sure.
Unfortunately I don't have Excel so can't confirm :(
Because, maybe, dev need new bug report for that import problem.
I don't know whether this should be mark as duplicate to Bug 75372 ?
Just add that bug in See Also..
Hi, this is not a bug, see my comment in https://bugs.freedesktop.org/show_bug.cgi?id=75372#c2
For attachment 96250 [details], if you copy the first sheet, names are not duplicated because they are global. Cells in the duplicated sheet will refer to cell values in the 1st sheet.
Also, I do see that in MSO if you copy the first sheet, names are duplicated and scopes are set as sheet2. But I dont think this is a bug in libreoffice.
If you want the names be duplicated, you should set the scope as not global.
Set as NOTABUG. Feel free to reopen if someone disagree.
Sorry, I think I'd rather reopen this bug....
If I copy the 1st sheet to "New File", the named ranges are lost (no matter if the scope is Global or not). This is really a bug, and I think this is want the bug reporter is talking about.
If copy and append to the same file, it works as I expected.
I just wanted to comment in Bug 75372 about global name. But I think comment should be put here.
Set Platform All as I can also reproduced in LO 126.96.36.199 - Ubuntu 12.04x86
Taken from https://bugs.freedesktop.org/show_bug.cgi?id=75372#add_comment :
> In MSO 2010, if you copy a sheet (to the same file), when named ranges in
> the original is "global", then: it created a new named range with the same
> name, but the scope is set to the duplicated sheet.
I saw Kingsoft 2013 behaves similar with MSO 2010, like your observation.
And copied sheet will be local name, but original sheet still global.
So LO behaves a bit different. (same as AOO 4.1.0)
@Kevin, what do you observed in MSO (comment 6 and comment 7) ? Should we open new import bug if you confirm that ?
(In reply to comment #10)
> Taken from https://bugs.freedesktop.org/show_bug.cgi?id=75372#add_comment :
Ehm..should be: https://bugs.freedesktop.org/show_bug.cgi?id=75372#c4
(In reply to comment #6)
> As I understand, names are always local in Excel. But I'm not sure.
Names are by default Global in MSO.
(They don't call it "Global", they call it "Workbook", which means the current spreadsheet file.)
(In reply to comment #12)
> Names are by default Global in MSO.
> (They don't call it "Global", they call it "Workbook", which means the
> current spreadsheet file.)
So it's the same as Kingsoft then. no problem with LO import
I am hesitantly moving this to NEW - if confirmation is still needed please place into UNCONFIRMED. Thanks
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later)
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for your help!
-- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
This bug is still present in 188.8.131.52 on Linux and Windows. No change of behaviour yet.
*** This bug has been marked as a duplicate of bug 75372 ***
Hum.. this is not exactly a duplicate of bug 75372, the names aren't referenced anywhere in formulas hence are not copied with a sheet-copy action, reopening.
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":
Resolves: tdf#76523 copy used names or pointing to sheet to other document
It will be available in 5.2.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
I can confirm that this is now (184.108.40.206) working and the bug is fixed for me.