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

[email protected] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #34 from [email protected] ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to