Reply to topic  [ 1 post ] 
Features 5.3 
Author Message

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 189
Location: Brasov, Romania
Reply with quote
Post Features 5.3
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
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
  • Zoom
Professional, Reader, Writer
Chart sheets
  • Title
  • Chart sheet can be selected
  • Chart sheet can be protected
  • Zoom
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 rotation
  • Font font name, font size, color, bold, italic, underline, strikethrough, superscript & subscript
  • Border style and color
  • Background & foreground
  • Pattern
  • Protection locked & hidden
  • Merged cells
  • Rich text format
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
Professional, Reader, Writer
Hyperlinks
  • URL's
  • Files
  • Cell references
  • Named ranges
Professional, Reader, Writer
Comments
  • Font name, font size, bold, italic, underline
  • Foreground
  • Location
Professional, Reader, Writer
Images
  • JPEG images
  • Image file path
  • Location
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
Chart objects
  • 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
  • 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
  • TXT file
  • CVS file
  • XML file
  • HTML file
Professional, Writer, Express Writer (only XLS)
Load
  • An XLS document
  • 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 files
Professional, Reader, Writer


Mon Nov 20, 2006 9:27 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.