GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC

[rajat vijay]

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