org.apache.poi.ss.util

Class NumberToTextConverter

    • Method Summary

      Methods 
      Modifier and Type Method and Description
      static java.lang.String toText(double value)
      Converts the supplied value to the text representation that Excel would give if the value were to appear in an unformatted cell, or as a literal number in a formula.
      Note - the results from this method differ slightly from those of Double.toString() In some special cases Excel behaves quite differently.
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Method Detail

      • toText

        public static java.lang.String toText(double value)
        Converts the supplied value to the text representation that Excel would give if the value were to appear in an unformatted cell, or as a literal number in a formula.
        Note - the results from this method differ slightly from those of Double.toString() In some special cases Excel behaves quite differently. This function attempts to reproduce those results.

Copyright 2014 The Apache Software Foundation or its licensors, as applicable.