Reply to topic  [ 1 post ] 
Features 8.4 
Author Message

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 189
Location: Brasov, Romania
Reply with quote
Post Features 8.4

FeatureDescriptionAvailable for
Cell values
  • Strings
  • Numbers
  • Dates
  • Booleans
  • Formulas
  • Errors
Professional, Reader, Writer, Express Writer
Formulas
  • All functions supported by Excel
  • Arithmetic, logical and unary operators
  • Formulas with numbers, dates and strings
  • Formulas with cell references
  • Formulas with cell ranges
  • Formulas with named ranges
  • Formulas with arrays
  • Formulas in A1 or R1C1 reference style
  • Formulas with references to external documents
Professional, Reader, Writer, Express Writer
Formula computation engine
  • Formula computation engine is available
Professional, Reader, Writer
Worksheets
  • Title
  • Worksheet can be selected
  • Worksheet can be protected
  • Worksheet can be hidden
  • Zoom
  • Tab color
Professional, Reader, Writer
Chart sheets
  • Title
  • Chart sheet can be selected
  • Chart sheet can be protected
  • Chart sheet can be hidden
  • Zoom
  • Tab color
Professional, Reader, Writer
Format cells
  • Format a cell, a row, 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
  • Indent
  • Text direction
  • Text rotation
  • Font font name, font size, color, bold, italic, underline, strikethrough, superscript & subscript
  • Border style and color
  • Background & foreground
  • Pattern
  • Gradient fill
  • Protection locked & hidden
  • Merged cells
  • Rich text format
  • Themes
Professional, Reader, Writer, Express Writer
Auto-formats
  • Default Excel auto-formats
  • Custom auto-formats
Professional, Reader, Writer, Express Writer
Conditional Formatting
  • Conditional formatting for a range
  • Font - color, bold, italic, underline, strikethrough
  • Border - style and color
  • Background & foreground
  • Themes
Professional, Reader, Writer
Hyperlinks
  • URL's
  • Files
  • Cell references
  • Named ranges
Professional, Reader, Writer
Comments
  • Font name, font size, bold, italic, underline
  • Foreground
  • Location
  • Rich text format
Professional, Reader, Writer
Images
  • JPEG, GIF, PNG, WMF, EMF, BMP, TIFF images
  • Image file path
  • Location
  • Extract image bytes from an Excel document
Note: xls file format supports only JPEG images
Professional, Reader, Writer
Names
  • Title
  • Formula
  • Hidden
Professional, Reader, Writer
Data validation
  • Data entered in a cell can be restricted to certain values
  • Input message and error alert can be set
  • 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
Group and outline levels
  • Group the rows and the columns. Multiple and embedded outline levels are available.
Professional, Reader, Writer
Split and freeze panes
  • Split window views
  • Freeze rows and columns
Professional, Reader, Writer
Filter and AutoFilter
  • Auto-filter
  • Advanced filter
Professional, Reader, Writer
Chart objects
  • All chart types and chart formats supported by Excel are available
Professional, Reader, Writer
Pivot tables
  • Pivot table options: Layout&Format, Totals&Filters, Display, Printing, Data
  • Fields and their settings
  • Row labels
  • Column labels
  • Report filter
  • Value fields and their settings
Professional, Reader, Writer
Pivot tables
  • Pivot charts can be created based on a pivot table. All the features presented for charts are available also for pivot charts.
Encryption & password protection
  • Password protection for the workbook
  • Password to open and password to modify MS Excel documents
Professional, Reader, Writer, Express Writer
File properties
  • Document summary properties
  • Custom properties
Professional, Reader, Writer
Read as SQL result set
  • Read the sheet values of an XLS document (Office 97-2003)
  • Read the active sheet values of an XLS document (Office 97-2003)
  • Read the sheet values of an XLSX document (Office 2007)
  • Read the active sheet values of an XLSX document (Office 2007)
  • Read the sheet values of an XLSB document (Office 2007)
  • Read the active sheet values of an XLSB document (Office 2007)
  • Read the values from a TXT file
  • Read the values from a CSV file
  • Read the values from an XML file
Professional, Reader
Save as
  • XLS document (Office 97-2003)
  • XLSX document (Office 2007)
  • XLSB document (Office 2007)
  • TXT file
  • CVS file
  • XML file
  • HTML file
Professional, Writer, Express Writer
Load
  • An XLS document (Office 97-2003)
  • An XLSX document (Office 2007)
  • An XLSB document (Office 2007)
  • A TXT file
  • A CSV file
  • An XML file
  • An HTML file
Professional, Reader
Import/Export
  • SQL result sets
  • XML files
  • TXT files
  • CSV files
  • HTML files
  • Custom lists
Professional, Reader (only export), Writer (only import), Express Writer (only SQL and custom lists)
VB and macros
  • Preserve the macros when load/edit/write XLS, XLSX and XLSB files
Professional

_________________
EasyXLS Team
.NET and Java library to read and write Excel files
Facebook Twitter Reddit LinkedIn


Tue Apr 16, 2013 6:12 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.