Extentech Inc. RSS Feeds powered by Sheetster Server

Open Requests: Add ExtenXLS handling to correctly manage maximum sheet name length

The maximum length of a name for a worksheet is 31 characters. Currently the ExtenXLS API puts no limits on the length that can be set. We need to determine the best way to go forward with this type of handling. Exceptions? Warning and truncation?

Open Requests: RTD Server Support

Provide an equivalent formula function that allows mapping real time data:

http://msdn.microsoft.com/en-us/library/aa140059%28office.10%29.aspx

Open Requests: Add No-Calc Mode for ExtenXLS

Customer has requested a performance setting which would completely bypass formula calculations during formula cell adds.

Most of the impact would be in error handling around accessing uncalced formula values -- something that is currently not allowed with ExtenXLS.

To provide ability to not calculate newly added formula cells, we can utilize the CALC_EXPLICIT setting in conjunction with a nulled stored value.

A FormulaException will need to be thrown if any uncalculated formula cell value is accessed.

Open Requests: JDK 1.3 Compatible Version

Problem is the extensive use of java.nio.* packages in the 4.x branch.

Open Requests: Set Cell Indentation

Ability to set cell indentation using CellHandle and FormatHandle.

Open Requests: Ability to read individual sheets from a workbook without loading entire workbook into RAM.

This is a sub-task of OOXML/XLSX project.

We will use XLSX file format to allow for reading individual sheets into ram -- dispensing with many internal BIFF8 structures such as DBCELL.

Currently, in order to preserve all references and provide fast updates to multiple-sheet references, ExtenXLS loads the entire workbook file into RAM from disk.

Open Requests: Implement new Formula Functions

Implement the following formula functions:

ACCRINT.
AVERAGEIF
ODDFPRICE
ODDFYIELD
AVERAGEIFS
COUNTIFS
IFERROR
SUMIFS
BESSELI
BESSELJ
BESSELK
BESSELY
GAMMALN
BETAINV
BINOMDIST
CHIDIST
CHIINV
ERF
CONFIDENCE
ERFC
CRITBINOM
GAMMADIST
LOGEST
GAMMAINV
GROWTH
HYPGEOMDIST
LOGNORMDIST
NORMSDIST
NORMSINV
WEIBULL
CHITEST
AREAS
FTEST
OFFSET
TRANSPOSE
TYPE
TTEST
PROB
DEVSQ
GEOMEAN
HARMEAN
SUMSQ
KURT
SKEW
ZTEST
SMALL
TRIMMEAN
TINV
YEARFRAC
CELL
BAHTTEXT
SUMIF
THAIDAYOFWEEK
THAIDIGIT
THAIMONTHOFYEAR
THAINUMSOUND
DATEDIF
THAINUMSTRING
DATESTRING
THAISTRINGLENGTH
NUMBERSTRING
ISTHAIDIGIT
CLEAN
ROUNDBAHTDOWN
ROUNDBAHTUP
THAIYEAR
MMULT
RTD
MAXA
MINA
STDEVPA
STDEVP
VARPA
STDEVA
VARA

Open Requests: Implement Media in RSS Feeds for Attachments

Media RSS
http://search.yahoo.com/mrss

Open Requests: Improved Error Handling

We need to improve the error handling and exceptions throughout the public API.

Open Requests: Bulk Insert of Rows

The ability to rapidly insert a bulk list of rows, without incurring the overhead of shifting subsequent rows down, or copying formats for each individual row.

This is primarily a performance enhancement over existing single-row-insert functionality.

Open Requests: Sheetster formula auto-complete and range selections

The following Formula Editing enhancements are all grouped under this request:

Function auto-complete: When a user begins entering a function in a cell, code completion should popup to allow selection of available functions from a list.
Range select: When user is editing a formula cell range and the shift key is held during arrow key navigation, or mouse selection, the selected range should be auto-entered in the formula function.
Range select: When a range in a formula is being edited, the range should be highlighted with a blue border.
Formula Errors: when an erroneous formula is entered the cell should have a red border.

Open Requests: Digital Signing of ExtenXLS output

A request to add support for digitally signing of output files so that warnings are not prompted to end users about VB code contained in spreadsheets and docs.

Should be do-able as JCE supports signing of documents. We need to determine the Excel-specific details.

As this is an unplanned feature, needs to be prioritized.