Created attachment 53787 [details] Speadsheet with two sheets that both contain a graph How to reproduce: 1) Create a spreadsheet with two sheets 2) Put graphs on both sheets, referencing data from the same sheet or: 1+2) Get the spreadsheet in the attachment and then: 3) Select both sheets 4) Copy the sheets Expected result: The copied graphs reference data on the corresponding copied sheet. This is the result for the active sheet (the one with the tab "on top") Actual result: Some of the copied graphs reference data on the original sheets. This is the result for the non-active sheets. Problem observed in: LibreOffice Portable 3.4.3 - OOO340m1 (Build:302) LibreOffice 3.4.2 - OOO340m1 (Build:1206) on openSuSE 11.4 (32-bit)
Problem getting worse (!) in: LOdev 3.5.0 Build ID: 7362ca8-b5a8e65-af86909-d471f98-61464c4 tested on openSuSE 11.4 (32-bit) Now both copies contain graphs that reference the original sheets. Copying one sheet with graph at a time works as expected (copied graph references copied sheet).
Thanks for bugreport When I copy sheet1, appears sheet1_1 where diagram points to sheet1, but when I delete sheet1, it points to sheet1_1. Strange.
(In reply to comment #1) > Copying one sheet with graph at a time works as expected (copied graph > references copied sheet). Ah well, in daily version 3.6.0alpha0+ Build ID: 5c2c03e this results in a diagram with a separate data table, and not a reference to the data on the sheet..
@stephan: this was correct in version 3.3.x ? Then we should set as regression. And also add it to a MAB, in my opinion. OK?
Very relieved to see the extremely serious problem in comment 1 and 3 tackled. The problem in the original description never worked properly in OOo and LibO, so it can't be considered a regression. In OOo 3.3.0 it started working correctly when copying 1 sheet at a time. In my opinion it definitely is Most Annoying, so it qualifies for the MAB list.
Reproduced in LO 3.4.0, 3.3.2, OO 3.2.1 on Mandriva 2010 64 bit Steps to reproduce: open attachment, select both sheet, copy, change cell B5 on First sheet for testing to which sheet points chart. What is interesting: delete first two sheet (two copied remains) undo deletion Now all 4 sheets point to first sheet (change cell B5 on first sheet to verify) So, no regression
@sacha, @stephan thanks. Before entering for MAB - aren't there more related chart updating issues, that you know? - isn't there (honest) a reasonable work around by doing sheet per sheet ?
On your question of related Issues: Although not involving charts, very probably technically related is: https://bugs.freedesktop.org/show_bug.cgi?id=47662 EDITING: Inconsistent / unintuitive reference link handling for check boxes and other form fields when Copying Sheets IMHO The whole issue of how Calc deals with charts, form fields etc. on sheets needs some serious attention. I imagine that the dev's time will be spend most effectively when they deal with these issues simultaneously. On your question of the reasonable work around. Yes, this work around is do-able. Still annoying: Yet another work around when doing work with LO.
(In reply to comment #8) > On your question of related Issues: > [...] thanks. > IMHO The whole issue of how Calc deals with charts, form fields etc. on > sheets needs some serious attention. I imagine that the dev's time will be > spend most effectively when they deal with these issues simultaneously. I guess so. We/I can ask one of the devs what fits them best (contrainer, just issues, MAB, ...) > Yes, this work around is do-able. OK, then a MAB is not so logic, sorry. > Still annoying: Yet another work around when doing work with LO. Time for a MUW list ;-) (Most Used Workarounds :-\ )
Reproducible in MASTER on Ubuntu 12.04 (32-bit): Version: 4.2.0.0.alpha0+ Build ID: c2530b02311c46529eed53ee688bf6c83ce4b86
*** Bug 51702 has been marked as a duplicate of this bug. ***
Reproducible in master on openSuSE 12.3 (64-bit) Version: 4.4.0.0.alpha0+ Build ID: 8b499cea76577b4221fccb17703aa9e86b625e90
** 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 (4.4.1 or later): https://www.libreoffice.org/download/ 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 If 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) http://downloadarchive.documentfoundation.org/libreoffice/old/ 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-07-18
Reproducible in MASTER under OpenSuSE Tumbleweed (64-bit) Version: 5.1.0.0.alpha1+ Build ID: 0a7375e372ee9583d31d44a7cc7b6a21e6197bf1 Locale: en-GB (en_GB.UTF-8) It is already established that the bug predates LO (see comment 6). Setting the version field accordingly.
When copying sheet containing a chart, for example, if i copied sheet 'A' to sheet 'B', all data reference about A must be replaced with B in new sheet. But chart still refers to 'A' sheet data. Is there any way to fix this libreoffice bug ? I am using libreoffice 4.2.8.2 under Ubuntu 14.04.4 LTS
*** Bug 102910 has been marked as a duplicate of this bug. ***
*** Bug 102057 has been marked as a duplicate of this bug. ***
Reproducible on Windows 7 (64bit) Version: 5.2.6.2 (x64) Build ID: a3100ed2409ebf1c212f5048fbe377c281438fdc
This bug looks like a quite fundamental problem in the internal process of references of LiberOffice Calc. It degrades the reputation of LibreOffice Calc severely in my opinion. This bug has been reported six years ago, and still its state is 'not assigned'. I see the importance of this bug is marked as medium (major). Shouldn't its priority be changed to a higher one?
(In reply to snowboard975 from comment #19) > This bug looks like a quite fundamental problem in the internal process of > references of LiberOffice Calc. > It degrades the reputation of LibreOffice Calc severely in my opinion. > This bug has been reported six years ago, and still its state is 'not > assigned'. > I see the importance of this bug is marked as medium (major). > Shouldn't its priority be changed to a higher one? Thank you for this endorsement. Note however that: MS Excel 2007 and 2010 exhibit the exact same behavior; Gnumeric 1.12.23 seems to lack the ability to copy more than 1 sheet at the time. So, saying it degrades the reputation of Calc may be a bit too strong.... It may help though if you add yourself to the cc list. This may influence the priorities of the devs.
(In reply to Stephan van den Akker from comment #20) > (In reply to snowboard975 from comment #19) > > This bug looks like a quite fundamental problem in the internal process of > > references of LiberOffice Calc. > > It degrades the reputation of LibreOffice Calc severely in my opinion. > > This bug has been reported six years ago, and still its state is 'not > > assigned'. > > I see the importance of this bug is marked as medium (major). > > Shouldn't its priority be changed to a higher one? > Thank you for this endorsement. > > Note however that: > MS Excel 2007 and 2010 exhibit the exact same behavior; > Gnumeric 1.12.23 seems to lack the ability to copy more than 1 sheet at the > time. > > So, saying it degrades the reputation of Calc may be a bit too strong.... > > It may help though if you add yourself to the cc list. This may influence > the priorities of the devs. This bug not only happens when copying two sheets together, but also happens when copying one sheet only. You marked it as duplicate bug as in comment #17. I tested your example worksheet with Excel 2017, but the same problem does not occur in Excel 2017.
(In reply to Stephan van den Akker from comment #20) > (In reply to snowboard975 from comment #19) > > This bug looks like a quite fundamental problem in the internal process of > > references of LiberOffice Calc. > > It degrades the reputation of LibreOffice Calc severely in my opinion. > > This bug has been reported six years ago, and still its state is 'not > > assigned'. > > I see the importance of this bug is marked as medium (major). > > Shouldn't its priority be changed to a higher one? > Thank you for this endorsement. > > Note however that: > MS Excel 2007 and 2010 exhibit the exact same behavior; > Gnumeric 1.12.23 seems to lack the ability to copy more than 1 sheet at the > time. > > So, saying it degrades the reputation of Calc may be a bit too strong.... > > It may help though if you add yourself to the cc list. This may influence > the priorities of the devs. I understand LibreOffice is mostly developed by volunteers and have said the words in the hope that it will be developed better. I'm sorry if my words sounded too strong.
Created attachment 132282 [details] The problem also happens when copying a single sheet with graphs. Similar problem also happens when copying a single sheet with graphs. The copied graph looses its reference to the proper data table. How to reproduce: 1. Download the attached ods file. 2. Copy the second sheet, Blad2, to the left side of the first sheet as its default new name, Blad2_2. 3. Copy the second sheet, Blad1, to the left side of the first sheet as its default new name, Blad1_2. 4. Copy the second sheet, Blad2_2, to the left side of the first sheet as its default new name, Blad2_2_2. 5. Copy the second sheet, Blad1_2, to the left side of the first sheet as its default new name, Blad1_2_2. 6. Click the second sheet, Blad2_2_2, and check the data range of the top left graph. Its expected value is $Blad2_2_2.$A$2:$B$7,$Blad2_2_2.$B$1. However, it points to $Blad2_2.$A$2:$B$7,$Blad2_2.$B$1. I thought this is the example of bug reported in comment 17, but because it was marked as duplicate before, I post it in this thread. My test environment is as below. OS: Windows 7 (64-bit) LibreOffice Version: 5.2.6.2 (x64) Build ID: a3100ed2409ebf1c212f5048fbe377c281438fdc Should this be regarded as an independent bug?
This should file this as a separate bug. I can not reproduce it with my own (single graph per sheet) example file. I can reproduce with your own (4 graphs per sheet) example file on: Versie: 5.3.1.2 Build ID: 30m0(Build:2) CPU Threads: 8; Versie besturingssysteem:Linux 4.4; UI Render: standaard; VCL: kde4; Layout-Engine: nieuw; Locale: en-GB (en_GB.UTF-8); Calc: group Version: 5.4.0.0.alpha0+ Build ID: 17e872c3fa87bb596ec8b263b7a2e692b927dcef CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; VCL: kde4; Locale: en-GB (en_GB.UTF-8); Calc: CL
(In reply to Stephan van den Akker from comment #24) > This should file this as a separate bug. I can not reproduce it with my own > (single graph per sheet) example file. > > I can reproduce with your own (4 graphs per sheet) example file on: > > Versie: 5.3.1.2 > Build ID: 30m0(Build:2) > CPU Threads: 8; Versie besturingssysteem:Linux 4.4; UI Render: standaard; > VCL: kde4; Layout-Engine: nieuw; > Locale: en-GB (en_GB.UTF-8); Calc: group > > Version: 5.4.0.0.alpha0+ > Build ID: 17e872c3fa87bb596ec8b263b7a2e692b927dcef > CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; VCL: kde4; > Locale: en-GB (en_GB.UTF-8); Calc: CL Thank you for your comment. I added the procedure of reproducing it in bug 12057 and changed its status as new.
** 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 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: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
The worse behavior mentioned in comment 1 is still present in: Version: 6.0.4.1 Build ID: 00m0(Build:1) CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: gtk3; Locale: nl-NL (en_GB.UTF-8); Calc: group Master is an improvement, but the OP is still present in master from the first week of May 2018: Version: 6.1.0.0.alpha1+ Build ID: 25c0988b87b71f93577837f4a300f5f17366d145 CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); Calc: CL On a side note: Both of the tested versions make it much harder to copy multiple sheets. Right-click of one of the selected sheets now un-selects it. Copying in 6.0.4.1 and in master only works with Ctrl-drag-and-drop.
Behaviour in comment 1 still present in: LO version: 6.0.7.3 (x64) Build ID: dc89aa7a9eabfd848af146d5086077aeed2ae4a5 CPU-threads: 4; OS: Windows 10.0; UI-render: GL; Locale: nl-NL (nl_NL); Calc: group LO version: 6.3.3.2.0+ Build ID: 30(Build:2) CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: kde5; Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB Calc: threaded Version: 6.5.0.0.alpha0+ Build ID: 16f8807a9255359da53e980185591e356166e414 CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: kf5; Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB Calc: threaded
*** Bug 139190 has been marked as a duplicate of this bug. ***
Ouyang Leyan committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3078044653f1e1b0a055c47eeb8d27834c07268a tdf#43175: Adapt ranges when copying or moving several sheets It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I can confirm this is fixed in: Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 3fe274dcfeca17ee7713b306fcd36183f6cf4689 CPU threads: 16; OS: Linux 5.10; UI render: default; VCL: kf5 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded While still present in: Version: 7.1.0.3 / LibreOffice Community Build ID: 10(Build:3) CPU threads: 16; OS: Linux 5.10; UI render: default; VCL: kf5 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded Good work, Ouyang Leyan!
Noel committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a2d5b5224aff4358865e73c3c0f67d47ce4b9b99 Revert "tdf#43175: Adapt ranges when copying or moving several sheets" It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I can confirm the problem is back in: Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: a9f82c7c6ac645dd9263b435dbc7695951a70098 CPU threads: 16; OS: Linux 5.10; UI render: default; VCL: kf5 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded Not sure I feel the need to thank anyone now....
@Andreas Heinisch, I thought you might be interested in this issue...
I can reproduce the error in comment 1, but copying a single sheet works for me in: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: ff673ce838a5538b1432daf9007c047f6455a5ba CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: CL Do I miss any step in order to reproduce the error with a single sheet? For the other problem, I will have a look.
A note on comment 27: if you select both of the sheets and make a right click anywhere besides the selected sheets, you can simply choose your preferred action.
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d55bf8aab008d84fac673f3cd907f5199347ce77 tdf#43175 - Adjust chart references on every copied sheet It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/55fc9ea0f40fced82d71379b535fc0c4a24061b0 tdf#43175: sc: Add UItest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Andreas Heinisch committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/b2fc048cb2d5f5bd1095a8110fa4a16a305a8acc tdf#43175 - Adjust chart references on every copied sheet It will be available in 7.1.4. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to Commit Notification from comment #38) Confirmed fixed in: Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 5295bc11e41166258fde5dc57b60f9677b5956e1 CPU threads: 8; OS: Linux 5.12; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: CL
(In reply to Commit Notification from comment #40) Problem observed in: Version: 7.1.3.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 8; OS: Linux 5.12; UI render: default; VCL: kf5 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded Confirmed fixed in: Version: 7.1.4.0.0+ / LibreOffice Community Build ID: a67a30227ef32ab9fc3026bb19e48d4447df25d1 CPU threads: 8; OS: Linux 5.12; UI render: default; VCL: kf5 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: CL The commit in comment #40 indeed fixes the problem in the 7.1 branch.