bguthrie
Posts: 31
|
Posted: 06/22/2004, 8:58 AM |
|
I was wondering whether anyone else was getting the same results as I am when trying to export a CCS grid to Excel. I use the following to cause the open/download dialog box to appear and all seems to work properly.
Header("Content-type: application/vnd.ms-excel");
Header("Content-Disposition: attachment; filename=invoices.xls");
Header("Pragma: no-cache");
Header("Expires: 0");
If I open the file in the Openoffice Spreadsheet program, I'm able to sum monetary columns etc., but if I try to open the same file using M$ Excel then I'm unable to sum monetary columns.
I've noticed when openning the export in Openoffice, the grid indicates it's an HTML Table. I suspect this is why Excel is not handling the columns properly (i.e. after trying to convert an exported monetary column to a currency format nothing changes).
I've tried several variations of the Header Content with no success. Any advice would be appreciated.
_________________
Regards,
Bruce |
|
|
peterr
Posts: 5971
|
Posted: 06/22/2004, 12:27 PM |
|
I'm not sure what is the problem but I would suspect that there is probably no way to specify that a Grid column is monetary...
How did you do that?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
bguthrie
Posts: 31
|
Posted: 06/22/2004, 12:34 PM |
|
Within Excel I simply did a right-click and selected "Format Cells". My ability to manipulate / add columns isn't the same when using OpenOffice vs. M$ Excel . I don't know that anything can be done about it as long as my code within CCS is o.k. I assume I've coded everything correctly.
_________________
Regards,
Bruce |
|
|
peterr
Posts: 5971
|
Posted: 06/22/2004, 1:36 PM |
|
OK. I was concerned that you added "$" or other prefix to the numbers on the Web page.
In your case the problem could be with spaces as discussed in these 2 topics: http://forums.codecharge.com/search.php?s_keyword=numer...m[]=6&s_period=
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
bguthrie
Posts: 31
|
Posted: 06/22/2004, 1:42 PM |
|
Thank you Peter! The "Space" was it...
_________________
Regards,
Bruce |
|
|
crecalde
Posts: 13
|
Posted: 08/01/2004, 1:23 PM |
|
Bruce:
Can you provide an example of the code that you got to work? I find I now need to do the same thing, and would like to avoid trying all of the various suggestions posted in dozens of posts.
If you prefer to e-mail the result, please send it to: carlos@crecalde.com
Thanks,
C.
|
|
|