[Libreoffice-bugs] [Bug 117332] Conditional formatting: selecting a cell range with the mouse gets you every cell individually, but not the range

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Dec 4 13:10:58 UTC 2018


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

--- Comment #10 from Torsten <tbauersfeld at web.de> ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181204/734cf1ee/attachment.html>


More information about the Libreoffice-bugs mailing list