poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 49066] New: [PATCH] worksheet/cell formatting, with view and HTML converter
Date Wed, 07 Apr 2010 21:51:27 GMT

           Summary: [PATCH] worksheet/cell formatting, with view and HTML
           Product: POI
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: arnold@moonhill.org

Created an attachment (id=25244)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25244)
Patch and new files

This patch has updated org.apache.poi.hssf.contrib.view.SViewer to include the
ability to handle most border types, cell formats, and conditional formatting.

The cell formats include almost all formats as excel understands them for
numbers, dates, and strings.  The only format parts that aren't handled are
those that require the width of the cell in characters.  These classes are
separated out so they can be used in other contexts (see below).

The viewer panel and the JTable for showing the spreadsheet are built as
separate components that can be used in other applications.

The tests for excel formats are done by comparison to the actual results of
using the formats in an excel spreadsheet — that is, the tests compare the
results of the formatting with a row in a spreadsheet that formats the same
number according to the same format.

The same is done for conditional formatting.

Besides the view, a new example is provided that converts an spreadsheet into
HTML (read-only).  This can be included in any HTML page.

(The formatting stuff in Excel is very picky and very poorly documented, but I
tried to be as exhaustive as I could be.)

[Hm.  The instruction say to upload both patch and tar files, but bugzilla
seems to be allowing me to only upload one file.  I have therefore put the
"diff.txt" file into the tar.]

Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message