Given the following code ```spreadsheet = New spreadsheetLib cfml #cfml-general

Given the following code: ```spreadsheet = New spr...

davla

07/23/2022, 9:13 PM

Given the following code:

Copy code

spreadsheet = New spreadsheetLibrary.Spreadsheet();
reportname = "report.xlsx";
spreadsheet.downloadFileFromQuery( data=qRecords, filename=reportname, xmlFormat=true, streamingXml=true );

using the Spreadsheet library (https://github.com/cfsimplicity/spreadsheet-cfml) with Lucee (latest) on ubuntu and getting the error: “The parameter [filename] to function [downloadFileFromQuery] is required but was not passed in”. The above code clearly is passing the filename argument. Am I missing something?

Adam Cameron

07/23/2022, 9:28 PM

And the error context is def pointing to that third line of code? And the code it reproduces in the context struct is that same line of code. Is that code exactly what you have, or is it an approximation?

davla

07/23/2022, 9:32 PM

I simplified the reportname into a static string for the example, but otherwise that is the code. The query qRecords is a query result from a queryMap call where I am adding some cols. The error is def pointing to the line with the downloadFileFromQuery() call

Adam Cameron

07/23/2022, 9:34 PM

Yeah, check the value of

reportname

. I suspect it's null.

davla

07/23/2022, 9:38 PM

Actually, I think my Caching setting was hiding my code changes - I had set the Inspect Templates to Never - I wasn’t planning on making changes but discovered the reports not working.

davla

07/23/2022, 9:39 PM

Now onto the actual spreadsheet cfc error:

Copy code

java.lang.reflect.InvocationTargetException

Adam Cameron

07/23/2022, 9:39 PM

OK that's me out of my depth then. Gotta say it's quite odd to have code caching switched on in dev though.

➕ 1

davla

07/23/2022, 9:40 PM

It’s a legacy system - moving from an large EC2 instance to a new smaller instance as the client moves gradually away from using the application.

✅ 1

davla

07/23/2022, 9:41 PM

The exports were working on the old instance and I have a vague memory of missing fonts being an issue. The stack error is:

Copy code

lucee.runtime.exp.NativeException: java.lang.reflect.InvocationTargetException
at java.desktop/sun.font.FontManagerFactory$1.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.desktop/sun.font.FontManagerFactory.getInstance(Unknown Source)
at java.desktop/java.awt.Font.getFont2D(Unknown Source)
at java.desktop/java.awt.Font.canDisplayUpTo(Unknown Source)
at java.desktop/java.awt.font.TextLayout.singleFont(Unknown Source)
at java.desktop/java.awt.font.TextLayout.<init>(Unknown Source)
at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:285)
at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.<init>(AutoSizeColumnTracker.java:117)
at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:84)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:705)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:724)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:102)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at lucee.runtime.reflection.pairs.MethodInstance.invoke(MethodInstance.java:56)
at lucee.runtime.reflection.Reflector.callMethod(Reflector.java:877)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:831)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1762)
at spreadsheet_cfc$cf.udfCall4(/spreadsheetLibrary/Spreadsheet.cfc:736)

davla

07/23/2022, 9:42 PM

I have reverted back to the old cf_poi custom tag which will work for the most part - it falls over with larger reports.

✅ 1

davla

07/23/2022, 9:42 PM

Thanks for suggestions.

davla

07/23/2022, 9:47 PM

Just for personal reference if I have the “Never” setting for Inspect Templates set, which button in the Lucee admin clears those templates from the cache - or is that a manual remove of the compiled files?

Adam Cameron

07/23/2022, 9:53 PM

Dunno sorry. I always have to hunt around for settings in Lucee admin: I don't find it the most intuitive UX.

Adam Cameron

07/23/2022, 9:53 PM

(not as bad as the way CFAdmin is now, but not as good as how CFAdmin used to be).

😎 1

☝🏻 2

davla

07/23/2022, 9:56 PM

Thanks. Agree about admin ux. Some of the labelling/naming could be improved for an easy win. Haven't used ACF since v11 but the ui was a bit easier to understand.

zackster

07/24/2022, 6:10 AM

Install fonts if you're on Linux headless?

davla

07/24/2022, 6:38 AM

I have a feeling it was that but I can't seem to find a reliable source with installation instructions. Will do some more googling 👍

zackster

07/24/2022, 6:48 AM

Lucee JIRA or forum, on phone

👍 1

cfsimplicity

07/24/2022, 11:43 AM