Hi Marc, On Sun, Jul 10, 2005 at 01:09:39 +0200, Marc Santhoff wrote:
> when asking a calc cell for it's number format > > cType = aCell.NumberFormat > > it does return this values: > > E F G H > 1,23 ? 01.01.75 12.10.05 12.06.39 00:00 > > NumberFormat > dez 106 37 50 30 > bin 1101010 100101 110010 11110 > > As you can see, the first column is a currency value and has it's second > bit set. This qualifies it as a time value according to > "css.util.NumberFormat". This is nonsense, isn't it? Yes ;-) Because the NumberFormat property is not the _type_ of the number format used, but the internal index key of the number format within one document instead. To query the type of such a key, feed that value to the getByKey() method of the css.util.XNumberFormats interface, which you can obtain from a css.sheet.SpreadsheetDocument service by using the getNumberFormats() method. XNumberFormats::getByKey() returns a NumberFormatProperties service of which you want the Type property. See also http://api.openoffice.org/docs/common/ref/com/sun/star/util/XNumberFormats.html Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
