Win7 LO 7.1.5 conditional formating 'prevents' embeded objects from being repositioned properly on calc sheet 1: make calc sheet with data and chart on it 2:conditionaly format some column somewhere on sheet (no nessescarily used inchart) 3: try to move or resize chart .... :/... watch it bug-out and dissappear... 4:edit:undo move, chart reappers in old position... 5:clear the conditional formatting - try to move chart - ...same result, no move+chart dissappers (no ability to copy to another sheet either) :( sheets in same document without any conditional formating do not display this behaviour .. expected behaviour : ability to move/copy chart on sheet which also has conditional formating applied to it ... and not have them disappear ! LoveYouLibre!
(In reply to trowelandmattock from comment #0) > Win7 LO 7.1.5 > > conditional formating 'prevents' embeded objects (charts) from being repositioned properly on calc sheet > > > 1: make calc sheet with data and chart on it > 2:conditionaly format some column somewhere on sheet (no nessescarily used > inchart) > 3: try to move or resize chart .... :/... watch it bug-out and dissappear... > 4:edit:undo move, chart reappers in old position... > 5:clear the conditional formatting - try to move chart - ...same result, no > move+chart dissappers (no ability to copy to another sheet either) :( > > sheets in same document without any conditional formating do not display > this behaviour .. > > expected behaviour : ability to move/copy chart on sheet which also has > conditional formating applied to it ... and not have them disappear ! > PS: i just played around a bit > the above problem seems to only occur when a WHOLE column or row is conditionaly formated - selection of individual cells in a range for conditional formatting does not create this behaviour with embedded objects (charts)... > > LoveYouLibre!
Please attach a sample file.
Created attachment 174715 [details] sheet with charts, conditional colours, and linked csv file if you try to reposition a chart in the spreadsheet(manually or with X/Y values) it skips to row 1 .... if the sheet is copied, the new copy behaves as expected until saved/re-opened when it reverts to charts skipping to row1 when repositioned if the copy has conditional formating and freeze-view removed (maybe this is the issue?) then the copied sheet will behave properly when saved/re-opened. diffrent settings with snap-to-grid did not seem to make any diffrence....
Comment on attachment 174715 [details] sheet with charts, conditional colours, and linked csv file to follow up it may actually be the resized rows/columns that are the problem > removing all direct formating resolves the issue with moving charts around on sheet > will check again to confirm when i get chance.
after messing around a bit with differnt formating > > seems like row height was a problem ... setting row hieght to default fixes chart positioning first mentioned > undo the change and charts still behave, but save/re-open and they are broken again. >>>the example sheet can be fixed by just changing row height to default >!>!>! >>> any value for row height above 2.00 re-introduces the mis-behaviour again (?!)
[Automated Action] NeedInfo-To-Unconfirmed
I tested with attachment 174715 [details], moved the charts around, but they don't jump to row 1. I think you forgot to attach the CSV file, but probably it does not matter. Do you still see the problem in the latest version? Arch Linux 64-bit Version: 7.4.0.0.alpha1+ / LibreOffice Community Build ID: 47e8763114f12fe14e2a8dd94b5a339f614d23bc CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 20 May 2022
Dear trowelandmattock, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear trowelandmattock, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp