Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
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 rajatvij...@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 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
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
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 rajatvij...@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 rajatvij...@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 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
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
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
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
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
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
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
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
Dear MARKUS, Sir, Just for once let me know the format of the proposal to be submitted for GSoC 2015 for the topic AUTOMATED ERROR CHECKING IN CALC And just give a look at my ideas and my proposal for the same. Then decide whether or not to allot me this project. And then I promise to give my 100% to complete this project with the accuracy desired by you, as I will not be having any of my academic work from MAY mid when the coding period starts !!! Anticipating your reply Yours sincerely On Mon, Mar 23, 2015 at 9:53 PM, rajat vijay rajatvij...@gmail.com wrote: Dear MARKUS, Sir, while I am working on the easy hack of libre office -- I would like to discuss with you about my idea regarding the AUTOMATED ERROR CHECKING IN CALC as the deadline for registrations are nearer - I would like to add the the automated error checking by ADDING DIFFERENT CURRENCIES BY AUTOMATICALLY CONVERTING THEM USING CURRENT CONVERSION RATES THROUGH INTERNET AND IF OFFLINE, THE USER HAS AN OPTION TO ADD MANUAL CONVERSION RATES OR TO USE THE PREVIOUS ONE --your feedback for the idea is expected ! Sir, I am sending this mail as the deadline is getting nearer and also am having my university exams. Your help will be appreciated. Thanks in advance ! RAJAT VIJAY INDIA ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
Hi rajat, On Monday, 2015-03-23 21:53:08 +0530, rajat vijay wrote: I would like to discuss with you about my idea regarding the AUTOMATED ERROR CHECKING IN CALC as the deadline for registrations are nearer - I would like to add the the automated error checking by ADDING DIFFERENT CURRENCIES BY AUTOMATICALLY CONVERTING THEM USING CURRENT CONVERSION RATES THROUGH INTERNET AND IF OFFLINE, THE USER HAS AN OPTION TO ADD MANUAL CONVERSION RATES OR TO USE THE PREVIOUS ONE I doubt that such a currency conversion would be related to automated error checking. The idea of the extended error-checking is that mixing currencies (or other unrelated/non-convertible units) of different types is not allowed, not automatic conversion. Note also that Calc has a CONVERT() function (unfortunately named identical but different to the Excel CONVERT() function, which currently is available as CONVERT_ADD()) that obtains it's conversion factors from configuration values. Your idea seems more suitable for an independent extension that obtains values from somewhere in the net and saves them to the conversion configuration or provides some currency conversion Add-In function(s), instead of wiring it into the core code. Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GPG key ID 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/ Care about Free Software, support the FSFE https://fsfe.org/support/?erack pgpw4Csm4rQkw.pgp Description: PGP signature ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
Eike Rathke wrote: Your idea seems more suitable for an independent extension that obtains values from somewhere in the net and saves them to the conversion configuration or provides some currency conversion Add-In function(s), instead of wiring it into the core code. Which even exists - there's Ted Schlossmacher's GetQuote extension. Cheers, -- Thorsten signature.asc Description: Digital signature ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
Sir, I have already started working on an easy hack 82641 Currency drop down menu !!! I got your point just one more detail I need, that only currency unit checking is enough or we need more errors to be checked for the GSoC 2K15 project. And finally as mentioned above I will not be able to finish my work on easy hack by the deadline 27 MAY then, what will be the procedure for my selection in GSoC 2K15 !!! Yours sincerely RAJAT VIJAY On Tue, Mar 24, 2015 at 11:55 PM, Markus Mohrhard markus.mohrh...@googlemail.com wrote: Hey, On Tue, Mar 24, 2015 at 3:14 PM, rajat vijay rajatvij...@gmail.com wrote: Dear MARKUS, Sir, Just for once let me know the format of the proposal to be submitted for GSoC 2015 for the topic AUTOMATED ERROR CHECKING IN CALC And just give a look at my ideas and my proposal for the same. Then decide whether or not to allot me this project. And then I promise to give my 100% to complete this project with the accuracy desired by you, as I will not be having any of my academic work from MAY mid when the coding period starts !!! Anticipating your reply Yours sincerely On Mon, Mar 23, 2015 at 9:53 PM, rajat vijay rajatvij...@gmail.com wrote: Dear MARKUS, Sir, while I am working on the easy hack of libre office -- I would like to discuss with you about my idea regarding the AUTOMATED ERROR CHECKING IN CALC as the deadline for registrations are nearer - I would like to add the the automated error checking by ADDING DIFFERENT CURRENCIES BY AUTOMATICALLY CONVERTING THEM USING CURRENT CONVERSION RATES THROUGH INTERNET AND IF OFFLINE, THE USER HAS AN OPTION TO ADD MANUAL CONVERSION RATES OR TO USE THE PREVIOUS ONE 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). We are only interested in finding user errors with this GSoC project. So you should think about which mistakes a typical user does in his spreadsheets that he normally does not or only with a lot of work detects. I'm not sure if you have already started working on an Easy Hack otherwise I would recommend to start that as soon as possible. While it is not necessary to finish the EasyHack before the submission deadline it is hard requirement to be selected. Regards, Markus --your feedback for the idea is expected ! Sir, I am sending this mail as the deadline is getting nearer and also am having my university exams. Your help will be appreciated. Thanks in advance ! RAJAT VIJAY INDIA ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
Hey, On Tue, Mar 24, 2015 at 3:14 PM, rajat vijay rajatvij...@gmail.com wrote: Dear MARKUS, Sir, Just for once let me know the format of the proposal to be submitted for GSoC 2015 for the topic AUTOMATED ERROR CHECKING IN CALC And just give a look at my ideas and my proposal for the same. Then decide whether or not to allot me this project. And then I promise to give my 100% to complete this project with the accuracy desired by you, as I will not be having any of my academic work from MAY mid when the coding period starts !!! Anticipating your reply Yours sincerely On Mon, Mar 23, 2015 at 9:53 PM, rajat vijay rajatvij...@gmail.com wrote: Dear MARKUS, Sir, while I am working on the easy hack of libre office -- I would like to discuss with you about my idea regarding the AUTOMATED ERROR CHECKING IN CALC as the deadline for registrations are nearer - I would like to add the the automated error checking by ADDING DIFFERENT CURRENCIES BY AUTOMATICALLY CONVERTING THEM USING CURRENT CONVERSION RATES THROUGH INTERNET AND IF OFFLINE, THE USER HAS AN OPTION TO ADD MANUAL CONVERSION RATES OR TO USE THE PREVIOUS ONE 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). We are only interested in finding user errors with this GSoC project. So you should think about which mistakes a typical user does in his spreadsheets that he normally does not or only with a lot of work detects. I'm not sure if you have already started working on an Easy Hack otherwise I would recommend to start that as soon as possible. While it is not necessary to finish the EasyHack before the submission deadline it is hard requirement to be selected. Regards, Markus --your feedback for the idea is expected ! Sir, I am sending this mail as the deadline is getting nearer and also am having my university exams. Your help will be appreciated. Thanks in advance ! RAJAT VIJAY INDIA ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
GSoC IDEA- AUTOMATED ERROR CHECKING IN CALC
Dear MARKUS, Sir, while I am working on the easy hack of libre office -- I would like to discuss with you about my idea regarding the AUTOMATED ERROR CHECKING IN CALC as the deadline for registrations are nearer - I would like to add the the automated error checking by ADDING DIFFERENT CURRENCIES BY AUTOMATICALLY CONVERTING THEM USING CURRENT CONVERSION RATES THROUGH INTERNET AND IF OFFLINE, THE USER HAS AN OPTION TO ADD MANUAL CONVERSION RATES OR TO USE THE PREVIOUS ONE --your feedback for the idea is expected ! Sir, I am sending this mail as the deadline is getting nearer and also am having my university exams. Your help will be appreciated. Thanks in advance ! RAJAT VIJAY INDIA ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice