NumberFormat not working

M

Mitsurugi

In my C# interop code I'm setting the NumberFormat property in the following
manner:

((Range)workSheet.Cells[rowIndex, columnIndex]).NumberFormat = "#0.0000";

Unfortunately this format is not being used in the generated spreadsheet.

What's weird is that if go to the "Format Cells" dialog and select "Custom"
the format string I set in code has been added to the format list. It's as if
it's been defined, but not been applied to the actual cell.

Any ideas on what's going on?

-Thx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top