GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC

[rajat vijay]

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 <antlists at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20150325/8e6990be/attachment.html>