Error: Unrecognized function

[GoogleCodeExporter]

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]

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]

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]

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]

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]

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]

an ods export will be great too. Thanks. 

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