[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 #3 from V Stuart Foote <vstuart.foote at utsa.edu> ---
Existing ODF table cell "value" content is text, alphanumeric, or numeric
(either fp or int). Beyond the display formatting of cells in some currency
format/label the cell content has no awareness it is currency.

Performing mashups-- tracking exchange rate(s) and applying dynamic conversions
to cell values based on some preferred working currency would likely require
extending the class of fp numeric cell content with a set of "currency"
functions.  

Establishing a numeric-currency would require extending ODF (making any
extended .ODS documents non-standard).

Handling arbitrage and currency exchange natively is simply too specialized
usage to merit the effort, or divergence from ODF.

This can of course be done programmatically to our existing fp cell "value"
content with the SDK and external helpers (e.g. wget) applying to templated
sheets, and otherwise can be implemented with a proper mix of
sheets/cells/formulas and conversion rates. So either extension or
template--just not in the core.

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