OLD FORUM - Use new one: https://www.CaptainCasa.online/forum

Hi Captain,

I am using 20171122 cc version, then I tried to export my fixgrid to Excel. But i wasnt able to open it. It has an error with regards to its file extension.

Hi,
please give us more details:

...what was the error?
...is the file created at all?
...attache the file (if < 100kB to the forum, otherwise send by mail)

Thanks! Björn

Hi Captain,

The file is created but cannot be opened.

And I tried sending it via email to you, but it says the file is 0 bytes so I cant send it to you.

Seems like the file is created but there is no data.

...please check the server log.

Default location: tomcat/work/Catalina/localhost/<app>/

The export processing seems to stumble somewhere.

Please note: By default the export processing tries to find the cell value by analyzing the GRIDCOL-<containedControl> construction: e.g. if it is GRIDCOL-LABEL then the LABEL-TEXT binding is used for finding the cell value.
If there is some complex construction within the Cell, for example...

Code:

 GRIDCOL
   PANE
     ROW
       LABEL
     ROW
       LABEL

...then you may support the finding of the value by defining GRIDCOL-SORTREFERENCE, which contains some binding to the cell data.

Example:

Code:

 GRIDCOL SORTREFERENCE=".{someProperty}"
   PANE
     ROW
       LABEL
     ROW
       LABEL

But: please check the log for dome stack traces...

Regards, Björn