rajat vijay rajatvijay5 at
Wed Mar 25 09:46:11 PDT 2015

Here are two more errors that i would like to implement--
> Calculation error on numbers formatted as text or preceded by an
> Warning for a formulas inconsistent with other formulas in the region

Your guidance with code pointers on implementing the above these will be a
great help !!!

Yours sincerely

On Wed, Mar 25, 2015 at 9:37 PM, rajat vijay <rajatvijay5 at> wrote:

> 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>
> 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: <>

More information about the LibreOffice mailing list