Summary: | Conditional formatting: selecting a cell range for the condition with the mouse gets you every cell individually, but not the range (see comment 10) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Torsten <tbauersfeld> |
Component: | Calc | Assignee: | Mike Kaganski <mikekaganski> |
Status: | VERIFIED FIXED | ||
Severity: | minor | CC: | 79045_79045, ilmari.lauhakangas, markus.mohrhard, mikekaganski, raal, xiscofauli |
Priority: | medium | Keywords: | bibisected, bisected, regression |
Version: | 5.3.4.2 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=117307 | ||
Whiteboard: | target:6.3.0 target:6.2.0.1 target:6.1.5 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 87351 |
Description
Torsten
2018-04-29 15:10:00 UTC
Works for me in Version: 6.1.0.0.alpha1+ Build ID: 4dbce627d3643babaf90a93c70b365ff08abfca6 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2; and 6.0.3.2 (x64); windows Seems to be fixed. Please upgrade to actual version and try again. http://www.libreoffice.org/download/libreoffice-fresh/ If have installed the new Version 6.1.0.0.alpha1 with no luck. You can add a cell but you can't select a cell. 1. click on cell you have $Tabelle1.$D$11 2. click another cell you have $Tabelle1.$D$11$Tabelle1.$D$15 With Version 5.0.6.3 you can select a cell. I could repro on Win and Linux. Bibisected with Win 5.4 repo to range 169bd7718264b0e312052757f9bbd2321e1399c2...ff8b873936aa72b17309da4bfc2775573a5b1f55 Examined the commit range and then on Linux master reverted this and did a build: https://cgit.freedesktop.org/libreoffice/core/commit/?id=42aece949ec96c775b31216bddd723aa5321e966 don't replace content of formula field when selecting range, tdf#58635 Change-Id: I85953fdd7c2b7f193b2a815564526d985ae2bba4 The problem was not seen in the build with the reverted commit. Adding Cc: to Markus Mohrhard Kompi alerted me about this and I no longer reproduce this on Windows or Linux. Closing Nothing has changed the Problem persists. Even in Version 6.1.3 Select Cells an getting a Range ist not working like in any other Calulation Program. Closing the Bug is not a Solution. Thanks Fine, let's set it to unconfirmed. We should find someone with a Mac to confirm Today I have checked all LibreOffice versions on all Systems. Linux LibreOffice 64 6.0.5.2 Windows 7 64 Libre Office 6.1.3.2 OSX (In reply to Torsten from comment #7) > Today I have checked all LibreOffice versions on all Systems. > Linux LibreOffice 64 6.0.5.2 > Windows 7 64 Libre Office 6.1.3.2 > OSX And you saw it on Linux and Windows as well? (In reply to Buovjaga from comment #8) > (In reply to Torsten from comment #7) > > Today I have checked all LibreOffice versions on all Systems. > > Linux LibreOffice 64 6.0.5.2 > > Windows 7 64 Libre Office 6.1.3.2 > > OSX > > And you saw it on Linux and Windows as well? Sorry, I did not notice you changed the OS to All. Today I have checked all LibreOffice versions on all Systems. Linux LibreOffice 64 6.0.5.2 Windows 7 64 Libre Office 6.1.3.2 OSX Libre Office 6.1.3.2 Same Bug New try of explain: 1. put in B10 any kind of text for conditional formating 2. put in C10 1, C11 2 ... C16 6 3. select conditional formating 3. select formula is 4. put in sum(C10:C16)>10 5. select a format for B10 6. press ok This works If you select the cells C10-C16 with your mouse you will get not the range for the formula like in any other calculation program you get: $Tabelle1.$C$10$Tabelle1.$C$10$Tabelle1.$C$10:$C$11$Tabelle1.$C$10:$C$12$Tabelle1.$C$10:$C$13$Tabelle1.$C$10:$C$14$Tabelle1.$C$10:$C$15$Tabelle1.$C$10:$C$16$Tabelle1.$C$10:$C$17$Tabelle1.$C$10:$C$18$Tabelle1.$C$10:$C$17$Tabelle1.$C$10:$C$16 I expected $Tabelle1.$C$10:$C$16 Ok, with the steps you mentioned, I can repro. Maybe in my comment 3 I was able to deduce the steps, but now I did not remember what they were. Arch Linux 64-bit Version: 6.3.0.0.alpha0+ Build ID: 9059457a1a8385cb80b5dd2c797cee77af4222a9 CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3_kde5; Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US Calc: threaded Built on 30 November 2018 I still cannot decipher the steps from comment 10, so I cannot reproduce. I assume I understand what "3. select conditional formating" should mean (it's "Format"→"Conditional"→"Condition" menu?); but is it important where the cursor is at that moment? Well, let's suppose it's unimportant. Next is: at what moment and where should I do "If you select the cells C10-C16 with your mouse"? and where should I look for the formula string "$Tabelle1.$C$10$Tabelle1.$C$10$Tabelle1..." then? Should it be something like "if in step X above, you do instead ...., then ..."? (In reply to Mike Kaganski from comment #12) > I still cannot decipher the steps from comment 10, so I cannot reproduce. > > I assume I understand what "3. select conditional formating" should mean > (it's "Format"→"Conditional"→"Condition" menu?); but is it important where > the cursor is at that moment? Well, let's suppose it's unimportant. Next is: > at what moment and where should I do "If you select the cells C10-C16 with > your mouse"? and where should I look for the formula string > "$Tabelle1.$C$10$Tabelle1.$C$10$Tabelle1..." then? Should it be something > like "if in step X above, you do instead ...., then ..."? After selecting Formula is, type into the input box =SUM( and then mouse-select the range. The formula string will appear in the input box after your =SUM( (In reply to Buovjaga from comment #13) Thanks! Repro. Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/6c5839d399c6277a7f2f0e214a20996761563525%5E%21 tdf#117332: select replaced text to properly replace it next time It will be available in 6.3.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. Verified in Version: 6.3.0.0.alpha0+ Build ID: 3911bf8364dae4c855ad37237c114f9007f70657 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @Mike Kaganski, thanks for fixing this!! Cherry-picked to 6-2: https://gerrit.libreoffice.org/#/c/65026/ 6-1: https://gerrit.libreoffice.org/#/c/65027/ Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/264c0bd303fa77932959e4265d2dd05a29a4da09%5E%21 tdf#117332: select replaced text to properly replace it next time It will be available in 6.2.0.1. 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. Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-6-1": https://git.libreoffice.org/core/+/9396cf7edb101983c56f44ae814029ce78f0fc71%5E%21 tdf#117332: select replaced text to properly replace it next time It will be available in 6.1.5. 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. Thank you for fixing. Tested with Version 6.1.5.2 on Windows. |