|
daniela
Joined: Fri Feb 03, 2006 12:23 pm
Posts: 199
Location: Brasov, Romania
|
 Features 5.0 | Feature | Description | Available for | | Cell values | - Strings
- Numbers
- Dates
- Formulas
| Professional, Reader, Writer, Express Writer | | Formulas | - All functions supported by Excel
- Arithmetic, logical and unary operators
- Formulas with numbers, dates and strings
- Formulas with internal cell references and cell references to external worksheets
- Formulas with internal range references and range references to external worksheets
- Formulas with named ranges
| Professional, Reader, Writer, Express Writer | | Worksheets | - Title
- Worksheet can be selected
- Worksheet can be protected
| Professional, Reader, Writer |
| Format cells | - Format a cell, a column or a specified range
- Number format - all text, number and date formats supported by Excel are available
- Alignment vertical & horizontal alignment, wrap & shrink text
- Font font name, font size, color, bold, italic, underline, strikethrough, superscript & subscript
- Border style and color
- Background & foreground
- Protection locked & hidden
- Merged cells
| Professional, Reader, Writer, Express Writer | | Conditional Formatting | - Conditional formatting for a range
- Font – color, bold, italic, underline, strikethrough
- Border – style and color
- Background & foreground
| Professional, Reader, Writer | | Hyperlinks | - URL's
- Files
- Cell references
- Named ranges
| Professional, Reader, Writer | | Comments | - Font name, font size, bold, italic
- Foreground
- Location
| Professional, Reader, Writer | | Images | - JPEG images
- Image file path
- Location
| Professional, Reader, Writer | | Named ranges | | Professional, Reader, Writer | | Data validation | - Data entered in a cell can be restricted to certain values
- Drop-down controls to select the allowable values for a cell are available
| Professional, Reader, Writer | | Header & footer | - Position left, center and right side
- Font font name, font size, underline, strikethrough, superscript, subscript
- Predefined texts: page number, total number of pages, date and time, file name
| Professional, Reader, Writer | | Page Setup | - Set page orientation (portrait, landscape), paper size
- Set scaling factor, fit to pages width/height
- Set paper margins
- Set print area
- Set rows to be repeated at top, columns to be repeated at left
- Print order
- Print gridlines, print black and white, print draft quality,
print row and column headings, print comments
| Professional, Reader, Writer | | Page breaks | - Horizontal and vertical page breaks
- Allows displaying the file in page break preview mode
| Professional, Reader, Writer | | Row & column dimension | - Row height & column width can be set for the grid
| Professional, Reader, Writer | | Charts | - All chart types and chart formats supported by Excel are available
| Professional, Reader, Writer | | Read as SQL result set | - Read the sheet values of an Excel document
- Read the active sheet values of an Excel document
| Professional, Reader | | Save as | | Professional, Writer, Express Writer | | Load | | Professional, Reader | | Import/Export | - SQL result sets
- Custom lists
| Professional, Reader (only export), Writer (only import), Express Writer (only import) |
_________________
EasyXLS Team
.NET and Java library to read and write Excel files
Facebook X Reddit LinkedIn
|
