Damian Small
|
| Posted: 06/27/2002, 2:48 PM |
|
When I export a page using the excel tips article it all works fine. However I cant seem to get numbers to work in the Spreadsheet. The field in the grid is set to be a number value in CC. Ive tried to muliply the cell by a number 1 however nothing seems to work. Any ideas?
Regards Damian Small
|
|
|
 |
Chris K.
|
| Posted: 06/27/2002, 3:11 PM |
|
Perhaps it is a problem with number formatting, esp. with decimal character? Maybe Excel understands different number format?
|
|
|
|
Damian Small
|
| Posted: 06/28/2002, 12:57 AM |
|
I found the problem. The after the field was the problem. I removed the after my field in this case {Cost} in the template and the numbers work fine.
Regards Damian Small
|
|
|
|
Damian Small
|
| Posted: 07/01/2002, 3:17 PM |
|
Sorry for the last reply what I removed was the non breaking space. This effects number cells in Excel. I removed the " " after the field.
Regards Damian Small
|
|
|
|
Patrick
|
| Posted: 07/02/2002, 1:23 AM |
|
I had something similar. I always get these spaces in numeric exports. How do I export an excel sheet without these spaces ? There's nothing in my code that includes them.
Regards
|
|
|
|
Chris K.
|
| Posted: 07/02/2002, 10:24 AM |
|
These spaces are generated in the html template. The reason for this is to avoid empty table cells that spoil grid layout (because no border and inside is drawn for them.
|
|
|
|
