Sir, Here are two more errors that i would like to implement-- > Calculation error on numbers formatted as text or preceded by an apostrophe > 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 RAJAT VIIJAY On Wed, Mar 25, 2015 at 9:37 PM, rajat vijay <rajatvij...@gmail.com> 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 <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
