https://bugs.freedesktop.org/show_bug.cgi?id=62431

--- Comment #8 from Robinson Tryon (qubit) <[email protected]> ---
(In reply to Jay Philips from comment #7)
> Spoke with beluga and matthiew in the IRC about this issue and as "dollars"
> is a formatting on a cell and when you are doing calculations it is only
> multiplying the contents in the cell and not its formatting,

Units are obviously more than just an afterthought in the model we're using in
Calc. As Rainer noted:

> Addition:        2 € + 3 €    = 5 €    (Retains units)
> Division:        2 € / 3 €    = 0,66666  (Loses units)

So IMHO we should either
1) Do nothing special to propagate units through a calculation, or
2) Try to push units through a calculation completely correctly, or
3) Clearly and fully document the inconsistency in the Calc Manual and Wikihelp
under a new section with a name like "Limitations and Bugs"

> multiplying "X
> dollars by Y dollars, ... should get XY dollars^2" is not possible.

It sounds like we'll have to go with (3).

-- 
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

Reply via email to