[Libreoffice-ux-advise] [Bug 106058] EDITING: Make Calc understand currency

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=106058

--- Comment #8 from V Stuart Foote <vstuart.foote at utsa.edu> ---
(In reply to cheater00 from comment #7)
 > But this is exactly the kind of hack I'm trying to avoid.
> For each row you have to manually enter the conversion rate or at least a
> reference to it. Thatt's prone to error and takes a lot of time. Is there a
> less crappy way of doing things?

Sorry, not a "hack" as that *is* the "normal" way to build a spread sheet.
Making the work flow robust is up to the you as the user--the needed tools are
provided. We just can't overload the floating point numbers in cells to give
them attributes of currency--so your spread sheet has to provide for that. 

You have to make each value a tuple(pair) of amount and currency (using either
two cells, or within one alphanumeric cell with tagging) to then be able to
apply the desired exchange rate and convert the value for sorting. Using
additional sheets to hold the converted values in scratch columns and the
retrieved exchange rates would reduce clutter on your main sheet.  And of
course capturing this to a template would reduce errors and allow reproducible
results.

-- 
You are receiving this mail because:
You are on the CC list for the bug.