https://bugs.freedesktop.org/show_bug.cgi?id=62431
Priority: medium
Bug ID: 62431
Assignee: [email protected]
Summary: Wrong unit calculation for inherited formatting
Severity: enhancement
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.3.0 Beta2
Component: Spreadsheet
Product: LibreOffice
I did my tests with "LibreOffice 3.6.5.2 " German UI/ German Locale
[Build-ID: 5b93205] {pull date 2013-01-18} on German WIN7 Home Premium (64bit),
but that's all the same for all other versions.
Currently LibO does a wrong automatic unit calculation.
Introduction:
Units have to be integrated into calculation. Examples:
You an add 2 Apples + 3 Apples, the result will be 5 apples
Aou can't add Apples and Beans, 2 Apples + 3 Beans = 2 Apples + 3 Beans
(or may be 5 Apples + Beans)
To Calculate the area of a square:
2m * 2m = 4m²
To calculate a velocity you divide a distance by a time,
20 km km
----- = 10 ----
2 h h
for Calculations LibO calculation results inherit formatting of parts of
calculation.
This works correct in Calc for
SUM: SUM(2 €;3 €) = 5 € (same correct result for addition
2 € + 3 € = 5 €
Division: 2 € / 3 € = 0,66666 without unit
This does not work correctly for Multiplications:
Current result: 2 € * 3 € = 6 €
Should be: = 6 €²
This does not work at all for user defined units
It would be great to get some more mathematical correctness here.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
