Julian Halliwell

Hi Alex. I'm afraid I don't have MS Excel to test with, but running the following code using version 2.1.1 results in a value of `30.1` as expected in OpenOffice...

I don't think the Lucee locale will make any difference, but it's possible your German Excel is treating the value as currency despite the specified "text" format. If you add...

Could you also try the following? ``` spreadsheet = New luceeSpreadsheet.Spreadsheet(); workbook = spreadsheet.newXlsx(); spreadsheet.setCellValue( workbook, "30.1", 1, 1, "numeric" ); spreadsheet.setCellValue( workbook, "30.1", 1, 2, "string" ); spreadsheet.download( workbook,...

Did you try adding the value manually in your German Excel formatting it as `@`? Does that result in `30.1` or `30,1`?

Try this, which forces the value to be inserted as a string and then formats it: ``` spreadsheet = New luceeSpreadsheet.Spreadsheet(); workbook = spreadsheet.newXlsx(); spreadsheet.setCellValue( workbook, "30.1", 1, 1, "string"...

I've changed my OpenOffice locale to German and I'm seeing the same results as you using the code above. But query VARCHAR values should be added as strings, and this...

Hi Samuel. Again I can't reproduce this. Using Lucee 5.3.2.38-SNAPSHOT via CommandBox on AdoptOpenJdk 1.8.0_202 I ran this code without any problem: ``` data = QueryNew( "column1,column2","VarChar,VarChar", [ [ "a",...

Does this solve the problem (i.e. `apt install fontconfig`)? https://dev.lucee.org/t/fixed-adoptopenjdk-and-fontconfig-error-ubuntu-18-04/5119

Pity. Your stacktrace does indicate the NPE is similarly related to the sun.awt.FontConfiguration class. Suggests there's something specific to AdoptOpenJDK and Linux (I'm not seeing any problem on WIndows as...

OK, OpenJDK generally and Linux then.