Dear MARKUS, 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
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 Thu, Mar 26, 2015 at 2:14 PM, rajat vijay <[email protected]> wrote: > Dear MARKUS , > Please let me know the format of the proposal to be submitted as the 27 > march is the last date. > The topic is "AUTOMATED ERROR CHECKING IN CALC" FOR GSoC 2K15. > > I am working on the easy hack "Currency Dropdown Menu", you can also > confirm my work from there. > > I have already mailed you my ideas including the ones of my own. > > Yours Sincerely > RAJAT VIJAY > > > On Wed, Mar 25, 2015 at 10:16 PM, rajat vijay <[email protected]> > wrote: > >> 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 <[email protected]> >> 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 <[email protected]> >>> 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 [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice
