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 45876] New: Support optional validationskipping of maximum sheet name constraint
Date Wed, 24 Sep 2008 13:44:37 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=45876

           Summary: Support optional validationskipping of maximum sheet
                    name constraint
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: sslavic@yahoo.com


Please support optional skipping of maximum (work)sheet name validation,
currently implemented in "validateSheetName(String sheetName)", static method
of org.apache.poi.hssf.record.BoundSheetRecord class. By default,
implementation can and should validate, but optional skipping (through
parameters, ...) would be very handy in specific scenarios, such as following
one.

Worksheet name longer than 30 chars can not be created in MS Office, but it can
be read and all more than 30 chars get displayed well, with exception that MS
Office does not allow editing of such worksheet name, not even to shorten it.
Nevertheless, OpenOffice can open such worksheets with worksheet name editable,
to be or if already longer than 30 chars. I'm mentioning this because of the
use case where it would be handy to have POI allow validation skipping of
maximum sheet name constraint. DBUnit, popular extension of JUnit, Java unit
testing framework, provides out-of-the-box support for using MS Excel files as
test data sets. For each test class one can create corresponding XLS file to be
used as test data set. In that XLS file, each worksheet corresponds to single
table in the database, and worksheet name corresponds to table name. As table
names can be longer than 30 chars, and because POI can be used to generate XLS
files used by DBUnit tests, it would be handy if POI would support worksheets
with name longer than 30 chars. As said earlier, such XLS files can be
modified/maintained using OpenOffice even though they have name of more than
"MS standard" maximum worksheet name length.


-- 
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


Mime
View raw message