|
From what I see, you are including the left parenthesis in the format:
TempStr = new_String('(#.00000_);[Red](#.00000)');
I am trying to create a new cell style for my spreadsheet for a field
that is defined as 6,5. It works fairly well with one exception, the
field is prefixed with a left parenthesis. Instead of getting 0.01234
in
my cell, I get (0.01234.
Anyone have an idea as to what I am doing wrong?
D Numeric_four s like(HSSFCellStyle)
D NumFmt3 s 5I 0
/free
Numeric_FOUR = HSSFWorkbook_createCellStyle(book);
DataFmt = HSSFWorkbook_createDataFormat(book);
TempStr = new_String('(#.00000_);[Red](#.00000)');
NumFmt3 = HSSFDataFormat_getFormat(DataFmt: TempStr);
HSSFCellStyle_setDataFormat(Numeric_FOUR: NumFmt3);
HSSFCellStyle_setAlignment(Numeric_four: ALIGN_RIGHT);
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.