B
BC
I'm using Visual Studio 2005 and I have several windows apps in which I put a
AxMicroSoft.Office.Interop.owc11.axspreadsheet on a form. The cells are
programmatically populated. The code runs through a small data table, field
by field.
My problem is that I have several columns that need to display string data
fields exactly as stored. For example if the string field contains "+1.23"
it has to display exactly that. (For the purpose of this app, 1.23 and +1.23
have very different meanings.) Unfortunately the control is wiping out the +
sign.
There have been other similar problems as well, "02" displaying as 2 for
example. A "00" Numberformat will take care of that but what I'd really like
is the security of knowing formatting is turned off completely. Any way to
do that?
AxMicroSoft.Office.Interop.owc11.axspreadsheet on a form. The cells are
programmatically populated. The code runs through a small data table, field
by field.
My problem is that I have several columns that need to display string data
fields exactly as stored. For example if the string field contains "+1.23"
it has to display exactly that. (For the purpose of this app, 1.23 and +1.23
have very different meanings.) Unfortunately the control is wiping out the +
sign.
There have been other similar problems as well, "02" displaying as 2 for
example. A "00" Numberformat will take care of that but what I'd really like
is the security of knowing formatting is turned off completely. Any way to
do that?