Hi,
I'm actually trying to export a repeater to excel, everything seems ok
but the problem is that the cells are not validated
This means that for example date, it is left-centered instead of been
right-centered when it is correctly validated, apprently excel doesnt
recognize the numbers with coma and it is not possible to calculate
formulas with this numbers.

Does anybody know how to do that? Is it possible to use
mso-number-format to do that?

<td style='mso-number-format:"Short Date";'>
<%#DataBinder.Eval(Container.dataitem,"date", "{0:d}")%>
</td>

Thanks

Julien

What technique are you using to export to Excel? There are a variety of
ways to do this, perhaps you should try one of the others. Here's a good
description of most of the techniques you could use:
http://SteveOrr.net/Articles/ExcelExport.aspx

Finally, if you find your needs become advanced, you could use a 3rd part
component:
http://www.SteveOrr.net/Reviews/AsposeExcel.aspx
http://officewriter.softartisans.com...writer-37.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net


"Julien" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> I'm actually trying to export a repeater to excel, everything seems ok
> but the problem is that the cells are not validated
> This means that for example date, it is left-centered instead of been
> right-centered when it is correctly validated, apprently excel doesnt
> recognize the numbers with coma and it is not possible to calculate
> formulas with this numbers.
>
> Does anybody know how to do that? Is it possible to use
> mso-number-format to do that?
>
> <td style='mso-number-format:"Short Date";'>
> <%#DataBinder.Eval(Container.dataitem,"date", "{0:d}")%>
> </td>
>
> Thanks
>
> Julien