Date: prev next · Thread: first prev next last
February 2017 Archives by date, by thread · List index


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


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.