[Libreoffice-bugs] [Bug 42877] absolute adressing in formulas kills highlighting

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Aug 13 22:21:52 UTC 2018


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

Gerhard Weydt <gerhard.weydt at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #3 from Gerhard Weydt <gerhard.weydt at t-online.de> ---
(In reply to arian from comment #0)
> Usually in Formulas Cell Adresses are highlighted, so if you type in a cell
> 
> =F3
> 
> "F3" is written blue and F3 gets a blue box around.
> 
> However introducing absolute adressing in any of the cell adressess breaks
> this, so if you have something like:
> 
> =$B$13/(B7*2)*(F7-F3)*$B$7
> 
> you don't know what you are mesing with...

This bug report seems to me outdated: I just copied the complicated formula
"=$B$13/(B7*2)*(F7-F3)*$B$7" at the bottom of your comment to a new Calc
document in LibO 6.0.4.2. The different parts of the formula are coloured with
different colours (in the display of the cell content), and the concerned cells
are coloured with the same colours, even for the references with absolute
addressing.
I set this bug to resolved.

-- 
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/20180813/599bd6a4/attachment.html>


More information about the Libreoffice-bugs mailing list