Bug 34949 (dunbrokin) - When setting a conditional format relative to a non-fixed cell, the structure gets lost under certain conditions
Summary: When setting a conditional format relative to a non-fixed cell, the structure...
Status: NEW
Alias: dunbrokin
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.3.1 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-02 18:08 UTC by dunbrokin
Modified: 2014-07-25 11:36 UTC (History)
5 users (show)

See Also:
i915 platform:
i915 features:

Attachments
Test1 shows block before moving (11.56 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-03-02 18:08 UTC, dunbrokin 		Details
Position of the data block after moving (11.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-03-07 01:09 UTC, dunbrokin 		Details
FDO#34949 (43.81 KB, image/png)
2012-10-14 19:40 UTC, Joel Madero 		Details
View All

Description dunbrokin 2011-03-02 18:08:38 UTC 
Created attachment 44052 [details]
Test1 shows block before moving

If you set up a conditional format on a block of cells, as I have in Test1, and if that conditional format is liked to a relative cell, the correct changes are not made to the conditional format formula if the cell block is moves as in Test2.

Notice what happens to the conditional format in j16 (and others) in Test1 when I move the whole block to get to Test2

Bugger, this will only take 1 attachment. I will submit Test2 manually if you cannot see that the format of j16 changes when you move the whole block by highlighting it with the cursor and moving as a block.
Comment 1 Cédric Bosdonnat 2011-03-03 06:23:10 UTC 
Could you please provide detailed steps to reproduce the problem?
Comment 2 dunbrokin 2011-03-07 01:09:09 UTC 
Created attachment 44193 [details]
Position of the data block after moving

Note the way the relative cells have changed in the conditional formatted cells....they have not kept in sync with the move.
Comment 3 dunbrokin 2011-03-07 01:14:01 UTC 
(In reply to comment #1)
> Could you please provide detailed steps to reproduce the problem?

I have done.....I have even gone 1 better and set up an experiment showing before and after....do you mean you want me to say " go to cell j16, set it up as a conditional formatted in the following way"....you only have to go to the cells as I outlined above to see what the formatting is...then move the block to a new position as in test2....
Comment 4 Björn Michaelsen 2011-12-23 11:50:50 UTC 
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 5 Björn Michaelsen 2011-12-23 17:02:40 UTC 
needinfo keyword redundant by needinfo status.
Comment 6 Roman Eisele 2012-05-03 08:46:25 UTC 
This is a Calc bug, therefore changed Component accordingly.
Comment 7 Florian Reisinger 2012-08-14 14:02:51 UTC 
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 8 Florian Reisinger 2012-08-14 14:03:46 UTC 
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 9 Florian Reisinger 2012-08-14 14:08:21 UTC 
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 10 Florian Reisinger 2012-08-14 14:10:24 UTC 
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 11 sasha.libreoffice 2012-08-24 10:12:18 UTC 
reproduced in 3.6.0 on Fedora 64 bit
When I copy-paste cell J16 to another sheet, it looks the same. But when I copy-paste it with adjacent cell, it looks different. Format->Conditional formatting->Conditional formatting also differs.

I am not sure that have done all correct, therefore set status to Unconfirmed
Comment 12 Joel Madero 2012-10-14 19:40:06 UTC 
Marking as NEEDINFO. I don't see any different. Attaching an image showing what I see, if you could tell me exactly what I'm looking for I'll confirm it. 

LibO Version: Version 3.6.1.2 (Build ID: e29a214)
Comment 13 Joel Madero 2012-10-14 19:40:32 UTC 
Created attachment 68559 [details]
FDO#34949
Comment 14 mike.hall 2012-12-31 12:05:31 UTC 
If you create conditional formatting on A1:B1 using four formulas all like LEFT($B1)=”s”  the result of copy A1:B1 and paste special of formats only to eg A2:B4 gives garbage values for the tests.

Setting up conditional formatting separately on A1 and B1 each using four formulas like LEFT(B1)="s" and then doing copy and paste special of formate only to eg A2:B4 gives the correct result.

There is something clearly going wrong here in my first point, so setting status back to NEW.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.