[Libreoffice-bugs] [Bug 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

Andreas Heinisch  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |andreas.heini...@yahoo.de
   |desktop.org |
 Status|NEW |ASSIGNED

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #37 from Andreas Heinisch  ---
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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #36 from Andreas Heinisch  ---
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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 CC||andreas.heini...@yahoo.de

--- Comment #35 from Xisco Faulí  ---
@Andreas Heinisch, I thought you might be interested in this issue...

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #34 from Stephan van den Akker  ---
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

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Whiteboard|target:7.2.0|
 CC||xiscofa...@libreoffice.org

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #33 from Commit Notification 
 ---
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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #32 from Stephan van den Akker  ---
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!

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #31 from Commit Notification 
 ---
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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:7.2.0

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||paulyste...@web.de

--- Comment #30 from m.a.riosv  ---
*** Bug 139190 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
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #29 from Stephan van den Akker  ---
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

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #28 from QA Administrators  ---
** 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

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #27 from Stephan van den Akker  ---
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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #26 from QA Administrators  ---
** 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

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

Pénzes Dávid  changed:

   What|Removed |Added

 Blocks||90486


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=90486
[Bug 90486] [META] Chart bugs and enhancements
-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

Pénzes Dávid  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||2057

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #25 from snowboard975  ---
(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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #24 from Stephan van den Akker  ---
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

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #23 from snowboard975  ---
Created attachment 132282
  --> https://bugs.documentfoundation.org/attachment.cgi?id=132282=edit
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?

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #22 from snowboard975  ---
(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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

snowboard975  changed:

   What|Removed |Added

 CC||snowboard...@gmail.com

--- Comment #21 from snowboard975  ---
(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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #20 from Stephan van den Akker  ---
(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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #19 from snowboard975  ---
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?

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #18 from snowboard975  ---
Reproducible on Windows 7 (64bit)

Version: 5.2.6.2 (x64)
Build ID: a3100ed2409ebf1c212f5048fbe377c281438fdc

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #17 from m.a.riosv  ---
*** Bug 102057 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
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||marcdun...@gmail.com

--- Comment #16 from m.a.riosv  ---
*** Bug 102910 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
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #15 from ryec...@gmail.com ---
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

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

Stephan van den Akker stephanv...@gmail.com changed:

   What|Removed |Added

Version|3.4.3 release   |Inherited From OOo

--- Comment #14 from Stephan van den Akker stephanv...@gmail.com ---
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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

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

--- Comment #13 from QA Administrators qa-ad...@libreoffice.org ---
** 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

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #12 from Stephan van den Akker stephanv...@gmail.com ---
Reproducible in master on openSuSE 12.3 (64-bit)

Version: 4.4.0.0.alpha0+
Build ID: 8b499cea76577b4221fccb17703aa9e86b625e90

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

suokunl...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=50860

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

Stephan van den Akker stephanv...@gmail.com changed:

   What|Removed |Added

 CC||kg_oooh...@ashisuto.co.jp

--- Comment #11 from Stephan van den Akker stephanv...@gmail.com ---
*** Bug 51702 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

[Libreoffice-bugs] [Bug 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #10 from Stephan van den Akker stephanv...@gmail.com ---
Reproducible in MASTER on Ubuntu 12.04 (32-bit):

Version: 4.2.0.0.alpha0+
Build ID: c2530b02311c46529eed53ee688bf6c83ce4b86

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #4 from Cor Nouws c...@nouenoff.nl ---
@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?

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #5 from Stephan van den Akker stephanv...@gmail.com ---
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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #6 from sasha.libreoff...@gmail.com ---
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

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #7 from Cor Nouws c...@nouenoff.nl ---
@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 ?

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #8 from Stephan van den Akker stephanv...@gmail.com ---
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.

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #9 from Cor Nouws c...@nouenoff.nl ---
(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 :-\ )

-- 
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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
   Severity|normal  |major
 CC||c...@nouenoff.nl,
   ||markus.mohrhard@googlemail.
   ||com
 Ever Confirmed|0   |1

--- Comment #3 from Cor Nouws c...@nouenoff.nl 2012-05-10 06:11:35 PDT ---
(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..

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- 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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

Markus Mohrhard markus.mohrh...@googlemail.com changed:

   What|Removed |Added

  Component|Spreadsheet |Chart

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- 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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

sasha.libreoff...@gmail.com changed:

   What|Removed |Added

 CC||sasha.libreoff...@gmail.com

--- Comment #2 from sasha.libreoff...@gmail.com 2012-04-26 05:27:44 PDT ---
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.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- 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 43175] EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=43175

--- Comment #1 from Stephan van den Akker stephanv...@gmail.com 2011-12-21 
04:00:55 PST ---
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).

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- 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