is there a way to do a WYSIWYG? or a bug?

Guest · Post by **Guest** » Thu Nov 02, 2006 12:46 pm

is there a way to program a wysiwyg? when reading a excel file i always get the correct value with highest precision. but values that are formated with lower precision are rounded.

example: 11,495 -> rounded to 11,50 (in excel UI)

can i somehow access this rounded value? or how do i achieve reading the value visible in Excel not the exact one? or how do i get the precision to round?

thanks in advance

Post by **larsa** » Thu Nov 02, 2006 5:25 pm

Hello

If you uses AsFmtString you shall get the formatted value.

Lars Arvidsson

Guest · Post by **Guest** » Thu Nov 02, 2006 7:51 pm

i get the correct decimal positions, but the value is not rounded as in excel. if a cell is formatted to show only two digits but has indeed three digits with AsFmtString i get a wrong value.

example:
in excel the cell value is 11,495
it is formatted to only use two digits and shows 11,50 in excel

when i use AsFmtString i get 11,49

seems to be a bug? isnt it?

Guest · Post by **Guest** » Fri Nov 03, 2006 9:47 am

OK. I located the problem.

Excel is rounding a value 123,5 up to 124. this is common in business. the component XLSReadWriteIII is not rounding up before 123,6. this is common in math.

i think this should be corrected?

thanks in advance