The Indian government agency that runs the Income-Tax portal "incometaxindiaefiling.gov.in" has very thoughtfully provided an electronic filing facility for its citizens which enables all tax-payers to file their Tax returns without a trip to the local Income Tax Office. However, their thoughtfulness only extends to Windows users as they have provided the e-forms only in the MSOffice .xls format which will not run any macros on a non-Windows platform. Now, I have not used Windows for many years now and having been forced to pay for a half-baked edition pre-installed on my laptop, I could not wait for my warranty to finish and free up that disk space.
Last week, I found two Open-Office hacks for the ITR forms 1 and 2 at:ITR-2 form from KSEB is borked -- has locked cells which will not work nor retrieve macros in Open-Office and many fields and cells are protected, making it impossible to enter data so that the Tax macros work properly. The ITR-2 form (available from the above link) has some errors in the conversion for Open Office --In Part B - TI in Computation of total income. It does not allow you to enter any figures in the following fields:
1. Salaries (6 of Schedule S)
2. Income from house property (C of Schedule-HP) (Enter nil if loss)
3. Capital gains
4. Income from other sources
This prevents the macro from tabulating the Total (Example: A + B +Total of (I) for all fields), due to which its not possible to tabulate the final tax payable.
Does anyone know how to get locked cell macros to work in Open-Office? All help and pointers to get these hacks working on Open-Office would be a big help. TIA.
PS: FWIW, I had asked this question on the local LUG list, which was a waste as one list member, who didnt read the question, chose to focus his undivided attention on the terrible mistake I made -- used the word 'company'. Thereafter, it was a fun exercise in "I-am-the-loudest-jerk-and-bully-here" ad hominem and logical fallacies. Yeah, total WIN on the technical help scale. The smartz knocked my socks off!