Created attachment 113054 [details] file demonstrating the problems I have found two issues with Conditional Formatting Databars in Calc: First: The Value renders exactly the same when setting to percent and entering any non-zero value Second: when merging Cells the Databar only fills the first cell and ignores the rest of the merged cells. I have attached a document to illustrate these problems. Thank you very much!
(In reply to berndnewsreader from comment #0) > Created attachment 113054 [details] > file demonstrating the problems > > I have found two issues with Conditional Formatting Databars in Calc: > > First: The Value renders exactly the same when setting to percent and > entering any non-zero value > Hello, you have to set range to A2:A4. In your document have every cell own data bar.
(In reply to berndnewsreader from comment #0) > Second: when merging Cells the Databar only fills the first cell and ignores > the rest of the merged cells. I can confirm with Version: 4.5.0.0.alpha0+ Build ID: 60143f4f7bc50054dcef923218b8c7c3bc154933 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-21_04:58:34
(In reply to raal from comment #1) > (In reply to berndnewsreader from comment #0) > > Created attachment 113054 [details] > > file demonstrating the problems > > > > I have found two issues with Conditional Formatting Databars in Calc: > > > > First: The Value renders exactly the same when setting to percent and > > entering any non-zero value > > > Hello, > you have to set range to A2:A4. In your document have every cell own data > bar. When i select a cell it shows data range A3 in the data bar dialogue (for example when selecting cell A3). Where can i see the data range A2:A4 ?
Created attachment 113078 [details] file with range data bar https://help.libreoffice.org/Calc/Conditional_Formatting#Manage_Conditional_Formatting
(In reply to raal from comment #4) > Created attachment 113078 [details] > file with range data bar > > > https://help.libreoffice.org/Calc/ > Conditional_Formatting#Manage_Conditional_Formatting Yeah but in my example i wanted to show the data bar according to a percentage from 0 to 100, and it does not work. Of course when selecting a range of cells and set the range to automatic it shows the data bars relative to each other. I want to show the data bar relative to 100% though.
(In reply to berndnewsreader from comment #5) > (In reply to raal from comment #4) > > Yeah but in my example i wanted to show the data bar according to a > percentage from 0 to 100, and it does not work. Of course when selecting a > range of cells and set the range to automatic it shows the data bars > relative to each other. I want to show the data bar relative to 100% though. I'm not sure, because I'm not using bars in this way. I cannot find documentation, but I tried in excel and in excel it's the same. All bars have the same width. If you mean it's a bug, please create new bugreport - only one bug per bugreport. Thank you.
** 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.5 or 5.1.0) 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: 2016-02-21
** 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.2.5 or 5.3.0 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 helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170306
Created attachment 154447 [details] created various databars w/ merged cells under current calc version included documentation of how they were created and observed behaviors
Issue persists in current version (6.3.1.2 build b79626edf0065ac373bd1df5c28bd630b4424273) on windows 10 version 1803 build 17134.765
Also, when adding a data bar across a merged cell that consists of multiple rows, you must have the target in the firs cell of each row before merging the cells, and when asked, you must keep that data or else each row that does not start with the target will not have a data bar. adding attachment to illustrate this better in a few moments.
Created attachment 154486 [details] multiple row merged cell only recognize first cell for data entry causing databar to display in an unexpected manner unless every cell in the first column of the multirow merged cell is filled
Dear berndnewsreader, 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 https://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 second issue seems resolved in the last version of LO, indeed, there is now a pop-up where we can define if we want to put together the content of the cells or choose just one content (and hide the other one or delete the other one). Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: df3b95a39472e18ea8acdaae447b7176e37a9256 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: threaded