https://bugs.freedesktop.org/show_bug.cgi?id=54975
Bug #: 54975
Summary: Value Highlighting incorrectly highlights entered
values as 'variable' formulas
Classification: Unclassified
Product: LibreOffice
Version: 3.6.1.2 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: d...@wieers.com
I have various spreadsheets for calculating income and costs. I discovered a
very valuable feature in LO 3.6 named "Value Highlighting" however it
incorrectly highlights fixed mathematical calculations as a formula, while it
should have been considered as a value. Let me explain.
In a cost-calculation, certain costs are montly, quarterly or yearly costs.
Since you ought to have them on a (say) monthly basis, the quarterly and yearly
costs need to be recalculated.
So a column stating:
20
=180/12
=34/3
each displaying the monthly cost for a given item, each should be considered a
value since each of them are a fixed entry. It shouldn't matter whether this
fixed entry was in fact a value on a monthly basis or a refactored value (still
indicating a number that is traceable e.g. through an invoice).
So I would propose that LibreOffice considers formulas with no references to
other cells or ranges as values for Value Highlighting. That would make more
sense in all cases. And since it's 'Value Highlighting' is confusing in this
case too, I would rename it to 'Input Highlighting' because that's what is
really relevant. Everything is a value, but not everything is considered input.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
