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