Am Montag, den 11.07.2005, 18:16 +0200 schrieb Eike Rathke: > 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.
Ah, I see. =:) > 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 I stumbled across something like that. Assuming it is documented in the dev guide, I'll have a deeper look there. Thank you very much, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
