Applying Number Formats

From Apache OpenOffice Wiki
Jump to: navigation, search



To format numeric values, an XNumberFormatsSupplier is attached to an instance of a com.sun.star.util.NumberFormatter, available at the global service manager. For this purpose, its main interface com.sun.star.util.XNumberFormatter has a method attachNumberFormatsSupplier(). When the XNumberFormatsSupplier is attached, strings and numeric values are formatted using the methods of the NumberFormatter. To specify the format to apply, you have to get the unique index key for one of the formats defined in NumberFormats. These keys are available at the XNumberFormats and XNumberFormatTypes interface of NumberFormats.

Numbers in documents, such as in table cells, formulas, and text fields, are formatted by applying the format key to the NumberFormat property of the appropriate element.

NumberFormatter Service

The service com.sun.star.util.NumberFormatter implements the interfaces com.sun.star.util.XNumberFormatter and com.sun.star.util.XNumberFormatPreviewer.

XNumberformatter

The interface com.sun.star.util.XNumberFormatter converts numbers to strings, or strings to numbers, or detects a number format matching a given string.

  void attachNumberFormatsSupplier ( [in] com::sun::star::util::XNumberFormatsSupplier xSupplier )
  com::sun::star::util::XNumberFormatsSupplier getNumberFormatsSupplier ()
 
  long detectNumberFormat ( [in] long nKey, [in] string aString ) 
 
  double convertStringToNumber ( [in] long nKey, [in] string aString ) 
  string convertNumberToString ( [in] long nKey, [in] double fValue ); 
 
  com::sun::star::util::color queryColorForNumber ( [in] long nKey, [in] double fValue, 
                                               [in] com::sun::star::util::color aDefaultColor )
  string formatString ( [in] long nKey, [in] string aString ); 
 
  com::sun::star::util::color queryColorForString ( [in] long nKey, [in] string aString, 
                                               [in] com::sun::star::util::color aDefaultColor )
 
  string getInputString ( [in] long nKey, [in] double fValue )

XNumberformatPreviewer

  string convertNumberToPreviewString ( [in] string aFormat, [in] double fValue, 
                                 [in] com::sun::star::lang::Locale nLocale, 
                                 [in] boolean bAllowEnglish ) 
 
  com::sun::star::util::color queryPreviewColorForNumber ( [in] string aFormat, [in] double fValue, 
                                 [in] com::sun::star::lang::Locale nLocale, 
                                 [in] boolean bAllowEnglish, 
                                 [in] com::sun::star::util::color aDefaultColor )

This interface com.sun.star.util.XNumberFormatPreviewer converts values to strings according to a given format code without inserting the format code into the underlying com.sun.star.util.NumberFormats collection.

The example below demonstrates the usage of these interfaces.

  public void doSampleFunction() throws RuntimeException, Exception
  {
      // Assume:
      // com.sun.star.sheet.XSpreadsheetDocument maSpreadsheetDoc;
      // com.sun.star.sheet.XSpreadsheet maSheet;
 
      // Query the number formats supplier of the spreadsheet document
      com.sun.star.util.XNumberFormatsSupplier xNumberFormatsSupplier =
          (com.sun.star.util.XNumberFormatsSupplier)
          UnoRuntime.queryInterface(
          com.sun.star.util.XNumberFormatsSupplier.class, maSpreadsheetDoc );
 
      // Get the number formats from the supplier
      com.sun.star.util.XNumberFormats xNumberFormats =
          xNumberFormatsSupplier.getNumberFormats();
 
      // Query the XNumberFormatTypes interface
      com.sun.star.util.XNumberFormatTypes xNumberFormatTypes =
          (com.sun.star.util.XNumberFormatTypes)
          UnoRuntime.queryInterface(
          com.sun.star.util.XNumberFormatTypes.class, xNumberFormats );
 
      // Get the number format index key of the default currency format,
      // note the empty locale for default locale
      com.sun.star.lang.Locale aLocale = new com.sun.star.lang.Locale();
      int nCurrencyKey = xNumberFormatTypes.getStandardFormat(
          com.sun.star.util.NumberFormat.CURRENCY, aLocale );
 
      // Get cell range B3:B11
      com.sun.star.table.XCellRange xCellRange =
          maSheet.getCellRangeByPosition( 1, 2, 1, 10 );
 
      // Query the property set of the cell range
      com.sun.star.beans.XPropertySet xCellProp =
          (com.sun.star.beans.XPropertySet)
          UnoRuntime.queryInterface(
          com.sun.star.beans.XPropertySet.class, xCellRange );
 
      // Set number format to default currency
      xCellProp.setPropertyValue( "NumberFormat", new Integer(nCurrencyKey) );
 
      // Get cell B3
      com.sun.star.table.XCell xCell = maSheet.getCellByPosition( 1, 2 );
 
      // Query the property set of the cell
      xCellProp = (com.sun.star.beans.XPropertySet)
          UnoRuntime.queryInterface(
          com.sun.star.beans.XPropertySet.class, xCell );
 
      // Get the number format index key of the cell's properties
      int nIndexKey = ((Integer) xCellProp.getPropertyValue( "NumberFormat" )).intValue();
 
      // Get the properties of the number format
      com.sun.star.beans.XPropertySet xProp = xNumberFormats.getByKey( nIndexKey );
 
      // Get the format code string of the number format's properties
      String aFormatCode = (String) xProp.getPropertyValue( "FormatString" );
      System.out.println( "FormatString: `" + aFormatCode + "'" );
 
      // Create an arbitrary format code
      aFormatCode = "\"wonderful \"" + aFormatCode;
 
      // Test if it is already present
      nIndexKey = xNumberFormats.queryKey( aFormatCode, aLocale, false );
 
      // If not, add to number formats collection
      if ( nIndexKey == -1 )
      {
          try
          {
              nIndexKey = xNumberFormats.addNew( aFormatCode, aLocale );
          }
          catch( com.sun.star.util.MalformedNumberFormatException ex )
          {
              System.out.println( "Bad number format code: " + ex );
              nIndexKey = -1;
          }
      }
 
      // Set the new format at the cell
      if ( nIndexKey != -1 )
          xCellProp.setPropertyValue( "NumberFormat", new Integer(nIndexKey) );
  }
Content on this page is licensed under the Public Documentation License (PDL).
Personal tools
In other languages