OK, exporting data to Excel, I must put the text 000 in a cell. Excel displays the little green triangle in the cell, indicating that they know better than I do what I want. Ignoring for a moment the components used to access the sheet, is there an API access to turn off the little triangles in cells which have them? I have not yet found a solution the (Axolot) components, but if anyone knows of an API I could search in source for that....

Comments

  1. Arun Singh Thanks. It appears this is not supported through the components we use.

    ReplyDelete
  2. As far as I remember, there is no component that expose that Excel configuration. Also, I think it is a per workbook config, not absolute sure.

    ReplyDelete

Post a Comment