Hi
Clients have reported a strange problem with Excel output from a grid; can anyone help?
It is serious because it is not obvious to the user that it has happened, so they see erroneous data, rather than an error message...
If a line of output in excel has an empty cell, then the content of the cell immediately below it moves up
to fill the space, as if all the columns are independent. The context is that the file is downloaded, then opened
on mac using Excel in Office for Mac 2011.
I could try writing a space character instead of of a null value but I am not sure that is the right answer.
The output is fine on PC, and also fine in the pdf version opened on Mac
Help!
Thanks
Clive
PS:
Mac OS: 10.6.5
Website server: windows server 2003, iis6, asp.net 4.0, RadAjax version is Q2 2009
Clients have reported a strange problem with Excel output from a grid; can anyone help?
It is serious because it is not obvious to the user that it has happened, so they see erroneous data, rather than an error message...
If a line of output in excel has an empty cell, then the content of the cell immediately below it moves up
to fill the space, as if all the columns are independent. The context is that the file is downloaded, then opened
on mac using Excel in Office for Mac 2011.
I could try writing a space character instead of of a null value but I am not sure that is the right answer.
The output is fine on PC, and also fine in the pdf version opened on Mac
Help!
Thanks
Clive
PS:
Mac OS: 10.6.5
Website server: windows server 2003, iis6, asp.net 4.0, RadAjax version is Q2 2009