Hi Gerhard,
Yes. XFRX don not use MS Excel for saving because (XFRX) generate output file in OpenXML format.
Martina Jindrová
>Hi Martina,
>
>Thank you for your quick and helpfull response.
>
>The only question open for me is if the NATIVE_XLSX is EXCEL 2007 only or EXCEL 2007 and higher?
>
>TIA
>Gerhard
>
>>Hi Gerhard,
>>
>>
http://office.microsoft.com/en-us/excel-help/worksheet-compatibility-issues-HA010172659.aspx>>
>>Your "excel output" has rows more then 65536. XFRX use Excel COM for saving to xls and default format is XLS (Excel 97-2003).
>>Because XFRX 14.x - 15.0 has bug ( XFRX#LISTENER use always plain mode for XLS/XLSPLAIN - ignore SHEET_PER_PAGE) it's way using XFRX#INIT.
>>Another way is upgrade to 15.0.3 and use NATIVE_FXLSX output (MS Excel 2007).
>>
>>Martina Jindrová
>>
>>
>>>Hello Martina,
>>>
>>>While trying to collect test data I found, that the problem exists only with greater data volumes. I tested with 40 records I got no error. Having a data source with 1.350 records I get an error that says (translated from German) :
>>>
>>> The sheet contains data in cells out of the line and column limit of the format selected.
>>> All data outside of the 256 (IV) columns by 65.536 lines will not be saved.
>>>
>>>
>>>Do you see a reason for this behaviour?
>>>
>>>TIA
>>>Gerhard
>>>
>>>
>>>>>Hello,
>>>>>
>>>>>I use XFRX version 14.5. When creating an XLS from a report I get a problem like that:
>>>>>
>>>>>EXCEL warns, that there are „massive losses saving as XLS” (translated as good as I know from German ;-)). If my app is used in fullscreen, which normally is the case, the message is not coming to the front and therefore it looks like the app is hanging.
>>>>>
>>>>>The real solution to the problem would be to create a XLS_X_. But I do not find a way to achieve this.
>>>>>
>>>>>Any idea what to do here would be appreciated.
>>>>>
>>>>>TIA
>>>>>Gerhard
>>>>
>>>>What is Excel's version?
>>>>
>>>>Please, can you send your report, example data and code snippet of calling XFRX to
support@eqeus.com?
>>>>
>>>>
>>>>Martina Jindrová
