User manual NEUTRIK NPPATTS

[. . . ] However, the content of this document is provided "as is", without warranties of any kind with regard to its accuracy or reliability, and specifically excluding all implied warranties, for example of merchantability, fitness for purpose, title and non-infringement. In no event shall Picsel be liable for any special, indirect or consequential damages whatsoever resulting from loss of use, data or profits, arising out of or in connection with the use of this document. Picsel reserves the right to revise the document or withdraw it at any time without prior notice. [. . . ] Picsel reserves the right to revise the document or withdraw it at any time without prior notice. No licence is granted (nor any rights of whatsoever nature granted), express or implied, to any intellectual property by this document. Throughout this document, the trade names and trademarks of some companies and products have been used. No such uses are intended to convey endorsement of or other affiliations with the document. Based upon document number PICSEL-ESF-0012A of June 2002 http://www. picsel. com/ Picsel Excel File Format Support Page 3 Introduction On handheld computers, traditional applications typically rely on synchronization with a PC to convert content from the original document format into a simpler format used by the device. Firstly, some visual integrity is inevitably lost in the conversion process from a rich format to a simpler one, resulting in documents that do not look exactly like the original. Secondly, the reliance on a PC for synchronization means that direct network access is difficult, and the device is severely hampered when untethered from the PC. Thirdly, traditional applications take a monolithic approach, converting only a single format so that separate applications are needed for each different document type. This level of support already covers the vast majority of characteristics that occur in day to day documents of this type, and the specific features are described with notes where appropriate. Those features planned for future implementation are also described, for completeness. Excel Features Feature Supports Excel 5 format Supports Excel 95 Supports Excel 97 Supports Excel2000 Creates a viewable page for each worksheet in the original file Displays name of worksheet Support Yes Yes Yes Yes Yes Yes Notes BIFF5 BIFF7 BIFF8 Supports page size No Supports page margins Supports headers and footers Displays cell row and column headings Yes Yes No Page name exported by DA, displayed via application layer Not meaningful as view shows worksheet, not print veiw Margins applied around contents of worksheet Inserted on page Picsel Excel File Format Support Page 5 Feature Retains "frozen titles" for rows and columns when scrolling Displays variable column width and row height Supports merged cells Displays page breaks within a worksheet (both horizontal and vertical breaks) Supports background image on worksheets Supports cell border positioning on top, bottom, right, left of cells Supports cell border thickness and double line borders Supports cell background colours and shading Supports cell background fill pattern Supports absolute and relative cell references Supports 3D cell references (i. e. to different sheet in file) Provides facility to either hide or display rows, columns or sheets that are hidden Supports names and labels for cells Supports scenarios, displays names of scenarios contained in worksheet Provides facility to select scenario and display cell contents accordingly Supports all number formats: · Number · Currency · Accounting · Date · Time · Percentage · Fraction · Scientific · Special · Custom Support No Yes Yes No Yes Yes Yes Yes No Yes Yes No Yes No No Yes Notes Does not fit the ePAGE graphic model Not needed as sheet is not printed Not tiled images Hidden items not visible Displays only the default scenario Picsel Excel File Format Support Page 6 Feature Supports all function types: · Financial · Date & Time · Math & Trig · Statistical · Lookup & Reference · Database · Text · Logical · Information Supports array formulas Text with styling. International Language support Support Yes Notes Displays the resultant value of the function Yes Yes Yes Font face Yes Refer to the section on `Character Sets' for more information. ePAGE automatically selects the most suitable font from those available in the system Font size and colour Bold text Italic text Text with underline Rotated text in cell Horizontal Text alignment in cells Left Centre Right Vertical Text alignment in cells Top Middle Bottom Indentation Supports text wrap within cell Supports break points within wrapped text (hard carriage returns) Displays formula contained in a selected cell Provides facility to display comments associated with a cell Supports hyperlinks to other files and web pages Supports hyperlinks attached to graphics and images Supports hyperlinks to specific locations/cells within current workbook Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No Picsel Excel File Format Support Page 7 Feature Displays screen tips associated with hyperlinks Diagrams and Pictures WMF (Windows MetaFile) EMF (Enhanced MetaFile) Clip Art OLE objects and documents Supports the following chart types: Column, Line charts Supports the following chart features: Chart title, Titles on X axes, Gridlines, Chart legend in original position Displays embedded charts within worksheet in original position Displays chart sheet as a separate page Supports native JPEG images contained in Excel documents. Supports native BMP images contained in Excel documents Supports animated GIF images contained in Excel documents. Drawing - arrows Drawing ­ Text boxes Drawing ­ Autoshapes · Basic shapes Autoshapes · Block arrows Autoshapes · Flowchart symbols Autoshapes · Stars and banners Autoshapes · Callouts Autoshapes · Connectors Supports WordArt Supports worksheets styled with AutoFormat Marks cells that have been changed using the Excel Highlight Changes command Support No Most Notes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Most Most Most Most No No No Yes No Including vertical alignment of text within box Picsel Excel File Format Support Page 8 Feature Displays contents of protected worksheets and cells Displays lists according to any filters that are applied Supports pivot tables Displays worksheets created as forms (templates) including form data Displays form controls (buttons, check boxes etc) Runs macros or scripts associated with form controls Displays phonetic guides for Japanese text: · Hiragana · Full width katakana · Half width katakana Supports right to left languages Support Yes No No Yes No No No Notes No Character Sets ePAGE can work with all characters in the Unicode specification. Many documents are encoded in other encodings, and ePAGE handles these by automatically detecting the character encoding used, and converting it to UTF-16 Unicode. [. . . ] Drawing - arrows Drawing ­ Text boxes Drawing ­ Autoshapes · Basic shapes Autoshapes · Block arrows Autoshapes · Flowchart symbols Autoshapes · Stars and banners Autoshapes · Callouts Autoshapes · Connectors Supports WordArt Supports worksheets styled with AutoFormat Marks cells that have been changed using the Excel Highlight Changes command Support No Most Notes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Most Most Most Most No No No Yes No Including vertical alignment of text within box Picsel Excel File Format Support Page 8 Feature Displays contents of protected worksheets and cells Displays lists according to any filters that are applied Supports pivot tables Displays worksheets created as forms (templates) including form data Displays form controls (buttons, check boxes etc) Runs macros or scripts associated with form controls Displays phonetic guides for Japanese text: · Hiragana · Full width katakana · Half width katakana Supports right to left languages Support Yes No No Yes No No No Notes No Character Sets ePAGE can work with all characters in the Unicode specification. Many documents are encoded in other encodings, and ePAGE handles these by automatically detecting the character encoding used, and converting it to UTF-16 Unicode. The character encodings supported by ePAGE are shown in the following table. [. . . ]