Problem Exporting data to excel

[#1]

While exporting data to an excel sheet, for some selections (i.e for some dates) it will fetch the data successfully to excel and for some others although it wil fetch correct data but will omit the column names as well as null values .. and show just the values in the excel sheet without proper format.

why the discrepency ..

i hope i can get a clue here.

Thanks

[fernandotoledo]

I didn´t get it.

The same Chart, in the same Aplication (QVW), is exported in the same way and generates XLS files with different structure from different selections?

If the export is made directly in the object like, "Send to Excel", I think it is a bug.

If it is generated by an action (macro) in a button, it should be what the macro does.

Therefore, there are many ways to export, copy and past data, with many output formats. See if you are exporting things always in the same way...

Best Regards,

Fernando

[#3]

Thanks Fernando,

Yes. You are right. In the same chart it will show different structure with different selections.

It was a simple export ,''Send to Excel'. While for some selections, the data fetched would be correct in proper format , for some others it will say "Unable to read file" then it will show a "repaired " version of excel with data in improper format.