Hi Marina,

I take your answer as Yes for 2007 and higher.

Thank you again.
Gerhard

>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á