[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 #5 from V Stuart Foote <vstuart.foote at utsa.edu> ---
(In reply to cheater00 from comment #4)
> Could this functionality (eg points 2 and 4) be executed using a plug-in

IIUC if you can do it manually now in the GUI it can be coded with the APIs
provided in the SDK, and then packaged as an .oxt extension. [1] For Calc there
is even the ability to add-in the extension as a service, i.e. implementing new
FUNCTIONs

But here, I still don't think you'd be able to overload the cell "value" making
it currency aware. You still would need to use additional columns/sheets to
perform the conversions and replace the fp numeric currency "value" with its
conversion and sort accordingly.

You probably also need to accommodate LibreOffice treatment of currency symbol
defaults[2][3] for the locale, and OS system input locale-language.

LibreOffice uses ISO 4217 code for Currency and Bank--these are just for
styling the display when the cell Value is set to currency.

=-ref-=
[1] https://wiki.documentfoundation.org/Development/Extension_Development

[2]
http://opengrok.libreoffice.org/xref/core/offapi/com/sun/star/i18n/Currency.idl
[3] http://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data/

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