[Libreoffice-bugs] [Bug 63087] Detective "Trace Precedents" or "Trace Dependents" pointing to a different tab does not provide reference cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

gte.ejecutivo at ecosa.com.co changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gte.ejecutivo at ecosa.com.co

--- Comment #34 from gte.ejecutivo at ecosa.com.co ---
This is, imho, the most important issue if LO is to be considered a replacement
for Excel in business. Without it, only simple sheets can be reviewed on a
timely basis.

A workaround for tracing dependents in other sheets is to find/replace using
regular expressions as follows:

sheet\..*A.*1

where, for a given cell sheet.A1:
   sheet is the sheet name
   A is the column
   1 is the row

The regular expression characters used:
   \ to take the period as a literal
   .* any character any number of times (to search with/without absolute 
      references - $)

It's not perfect (it will find some references that are not the cell in
question) buy won't miss any case.

-- 
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/20200214/c1796729/attachment.htm>