search

anmaikul / gcal2excel

Automatically exported from code.google.com/p/gcal2excel
0 stars 0 forks source link

Error: Unrecognized function #6

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What is the expected output? What do you see instead?
I can see my calendar items in the console window, but while trying to
create the excel spreadsheet, the following exception happens:

Warning:  Unrecognized function when parsing formula SUM(C3:C35) in cell
The Sheet!C38
Error: jxl.biff.formula.FormulaException: Unrecognized function
at jxl.biff.formula.StringFormulaParser.handleFunction(StringFormulaPars
er.java:338)
at jxl.biff.formula.StringFormulaParser.parseCurrent(StringFormulaParser
.java:136)
at jxl.biff.formula.StringFormulaParser.parse(StringFormulaParser.java:1
06)
at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:110)
at jxl.write.biff.FormulaRecord.initialize(FormulaRecord.java:177)
at jxl.write.biff.FormulaRecord.setCellDetails(FormulaRecord.java:243)
at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1072)
at Converter.writeExcel(Converter.java:117)
at Converter.convert(Converter.java:67)
.... (and so on)

What version of the product are you using? On what operating system?
Latest gcal2excel on Win XP Pro 32bit.

Please provide any additional information below.
I have a German system and a German Office. The Sum-Function is translated
as "Summe" - so i think that it tries to find the English function name "Sum".

Original issue reported on code.google.com by daniel.a...@gmail.com on 17 May 2009 at 9:42

GoogleCodeExporter commented 8 years ago 
Just change one line in Converter.java from :

jxl.write.Formula formula = new jxl.write.Formula( 2, (row+2), 
"SUM(C3:C"+row+")" );

to

jxl.write.Formula formula = new jxl.write.Formula( 2, (row+2), 
"SOMME(C3:C"+row+")" );

where SOMME is the excel function translated in French language, put SUMME for 
German ...

Original comment by une.belette@gmail.com on 28 Oct 2009 at 10:06

GoogleCodeExporter commented 8 years ago 
Thank you! 

It's bad that excel doesn't accept the english functions for compatibility. 
Would be
great to be able to avoid hardcoding things like that.

Original comment by daniel.a...@gmail.com on 1 Nov 2009 at 4:25

GoogleCodeExporter commented 8 years ago 
You can try the online version, it should work for you 
http://gcal2excel.syamantics.com/

Original comment by anupom....@gmail.com on 1 Nov 2009 at 4:52

GoogleCodeExporter commented 8 years ago 
I'm encountering the same issue. Although I could use the online version I 
prefer the
desktop one.

I've found Converter.java in the source code on this site but I can't find it 
in the
zip-file I downloaded.
How do I include Converter.java (which I have changed to my language) into the 
program?

Original comment by gerjohul...@gmail.com on 9 Nov 2009 at 2:22

GoogleCodeExporter commented 8 years ago 
Hi,

you can extract the entire source project via svn from 

http://code.google.com/p/gcal2excel/source/checkout

and compile the project vian NetBeans IDE from

http://netbeans.org

bye.

Original comment by une.belette@gmail.com on 9 Nov 2009 at 5:09

GoogleCodeExporter commented 8 years ago 
an ods export will be great too. Thanks.

Original comment by jmf.ren...@gmail.com on 13 Oct 2010 at 10:55