https://bugs.documentfoundation.org/show_bug.cgi?id=106058
--- Comment #8 from V Stuart Foote <vstuart.foote@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.
Context
- [Libreoffice-ux-advise] [Bug 106058] EDITING: Make Calc understand currency · bugzilla-daemon
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.