Sir, Here is a list of my ideas: > In the "data validation" feature, add two new types in the "Allow" list namely 1- "Customized". This feature will will allow the user to perform data validation with reference to formulas. 2- "Units". This feature will let the user associate an unit with a particular cell or a range. The "Data" field will have a list of units namely-meter, seconds, and most of the other scientific units. > Detecting an EMPTY cell in the range for formula, where the user put a cell range as an argument. > Adding different currencies error
On Wed, Mar 25, 2015 at 6:32 PM, Wols Lists <antli...@youngman.org.uk> wrote: > On 24/03/15 18:25, Markus Mohrhard wrote: > > As Eike mentioned that is not the idea behind this task. The task would > > be to integrate correct currency handling (that you show a warning/error > > when you try to sum across different currencies e.g. EURO + DOLLAR). For > > this the first requirement is most likely to get the unit feature branch > > merged into master (it also requires some more work before merging can > > be considered). > > And to my mind (I worked for a trade association that handled > calculations in most currencies - from Sterling to Italian and Turkish > lire, and hyperinflation currencies like Zimbabwe) the idea of automatic > conversion is actually extremely dangerous. > > Quite often it's an end-user requirement to use x dp (can be a daft > requirement) or x sf (we used 4sf, the eurozone had a LEGAL obligation > to use 6 back in the day). And if you're dealing with a Zimbabwe or the > like, do you really want to use today's exchange rate on yesterday's > transaction? > > Cheers, > Wol >
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
