GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC

[rajat vijay]

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 <rajatvijay5 at gmail.com> 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 <rajatvijay5 at 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 <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/20150326/2811ecd2/attachment.html>