Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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





Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.