none
How to set cell type 'text' to avoid '=cmd|'/C calc'!A0' issue RRS feed

  • Question

  • Hi,

    We use xsl stylesheet to define attribute and created xsl-fo page and at last come to an html page, which will be stored into excel file(xls).

    As in excel, cell format is General, and the value '=cmd|'/C calc'!A0' will call a remote object and open the calculator.

    We can set the cell format to text to keep the cell value.

    In html page, we know css setting

    td{mso-number-format:\@;}

    can help to set cell format to text when opening in html.

    But we use xsl stylesheet to create the xsl-fo file and html file. So is there any way I can set the 

    <fo:table-cell

    like the one in css style?

    Thanks

    Friday, February 3, 2017 2:53 AM

All replies

  • Hi,

    This forum is used for discussing development issues related to Excel object model, I think your issue is out of scope.

    Besides, after searching, I think Excel does not support xsl-fo format and  I think we could not set numberformat of fo:table-cell like in Excel css.

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, February 7, 2017 5:30 AM
    Moderator