Examples of org.apache.poi.ss.usermodel.FractionFormat

org.apache.poi.ss.usermodel.FractionFormat

Format class that handles Excel style fractions, such as "# #/#" and "#/###"

As of this writing, this is still not 100% accurate, but it does a reasonable job of trying to mimic Excel's fraction calculations. It does not currently maintain Excel's spacing.

This class relies on a method lifted nearly verbatim from org.apache.math.fraction. If further uses for Commons Math are found, we will consider adding it as a dependency. For now, we have in-lined the one method to keep things simple.

 * Tests for the Fraction Formatting part of DataFormatter.
 * Largely taken from bug #54686
 */
public final class TestFractionFormat extends TestCase {
      public void testSingle() throws Exception {
        FractionFormat f = new FractionFormat("", "##");
        double val = 321.321;
        String ret = f.format(val);
        assertEquals("26027/81", ret);
    }

View Full Code Here

TOP

Related Classes of org.apache.poi.ss.usermodel.FractionFormat

org.apache.poi.ss.format.SimpleFraction

org.apache.poi.ss.usermodel.TestFractionFormat

org.apache.poi.ss.formula.eval.NotImplementedException

java.util.regex.Matcher

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.