[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
bugzilla-daemon at bugs.documentfoundation.org
Mon Jul 17 22:05:01 UTC 2017
https://bugs.documentfoundation.org/show_bug.cgi?id=63087
Steve Cahill <svcahill at aol.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |svcahill at aol.com
--- Comment #25 from Steve Cahill <svcahill at aol.com> ---
For those using the LibreOffice calc tool for large projects (farm management,
complex taxes) where lots of data references cross many worksheets or separate
spreadsheet files, being able to look at a number and audit/inspect its chain
of sources is a necessary feature; lacking that, Excel remains the only tool
that can do the job. A good use-case example: You want to do your taxes, you've
been keeping your records in a spreadsheet file. You download an Excel-format
1040 tool (Glenn Reeves's for example) and you want to create links to your
existing spreadsheet work from the new 1040-formatted spreadsheet, then check
that data precedents were set correctly. Then you might want to update your
original source spreadsheet, you break something, and you need to find the
why-broken issue. All this is routine in Excel, but is not possible in
LibreOffice Calc V5.3.4.2 (x64) running on Windows 10 Pro. Lots of good things
in this tool, but I have to stick with Excel as long as this remains a
limitation.
--
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/20170717/7adf9a17/attachment.html>
More information about the Libreoffice-bugs
mailing list