4

File Format .as

ATTR_TABLE_END

"Attr Table End\n"

Represents the end of the attribute table.

ATTR_TABLE_START

"Attr Table Start\n"

Represents the beginning of the attribute table.

BACKCALC

"Calc Background Enabled: %d\n"

Sets the background calculation mode.

Argument :

1. 1 - Background Calc Enabled.
0 - Background Calc Disabled.

BMARGIN

"Bottom Margin: %d\n"

Sets the bottom page margin.

Argument:

1. The bottom margin in 1/1000ths of an inch.

BRC

"Bottom Right Corner %s\n"

Sets the last cell defined in the last most sheet.

Argument:

1. The last cell defined in all of the sheets.

CALCAUTO

"Calculation Automatic\n"

If present sets calculation to Automatic.

CALCBEFORESAVE

"Calc Before Save: %d\n"

Sets whether a spreadsheet is recalculated before saving.

Argument:

1. 1 - Recalculate the spreadsheet before saving
0 - Do not recalculate the spreadsheet before saving

CALCINT

"Calculation At Interval: %d\n"

If present sets the calculation to occur at a specified interval.

Argument:

1. Calculation interval in 1/1000ths of a second

CALCOC

"Calculation On Command\n"

1. If present calculation will occur on when the user chooses recalculate.

CALCONSCREEN

"Calc Visible Cells Only:%d\n"

Sets whether the entire spreadsheet is recalculated when a cell changes, or if only the cells in the current window are recalculated.

Argument:

1. 1 - Calculate on cells currently visible in the window
0 - Calculate all cells

CCALCSTYLE

"Calculation Style C%d\n"

If present sets the calculation to Column Based.

Argument:

1. Iteration count.

CHALIGN

"Horz Center Align: %d\n"

Sets whether the printed page is aligned to the center horizontally

Argument:

1. 1 - Pages are horizontally center aligned.
0 - Pages are not horizontally center aligned.

COLORMAP_END

"END COLORMAP"

Signifies the end of the color map.

COLORMAP_START

"COLORMAP"

Signifies the beginning of the color map.

COL_FORMAT

"Format Col %s !%s:%s \n"

Sets the formatting for a particular column.

Arguments:

1. Sheet (i.e. A, B, F)

2. Column (i.e. A, B, FF, CD)

3. Attribute String (see Creating an Attribute String)

CR_CALLBACK

"CR_CALLBACK: %s\n"

This defines what Elf Macro is called when a Carriage Return is typed in the spreadsheet.

Argument:

1. The name of an Elf Macro.

CURSOR

"Open Cell: %s\n"

This sets the currently active cell in each view.

Argument:

1. A cell reference (i.e. A:A1)

CVALIGN

"Vert Center Align: %d\n"

Sets whether the printed page is aligned to the center vertically

Argument:

1. 1 - Pages are vertically center aligned.
0 - Pages are not vertically center aligned.

DATENUMBERS

"Date Numbers Standard\n"

If this is present the dates in the file follow Excel/Lotus Date Format. This assumes that 2/29/1900 is 60.

DBL_CLICK_CALLBACK

"DOUBLE_CLICK_CALLBACK: %s\n"

This defines the Elf Macro to call when the user double-clicks on a cell in the spreadsheet.

Argument:

1. An elf macro.

DEFFONTSIZE

"Default Font Size %d\n"

This sets the default font size for the spreadsheet.

Argument:

1. The font size in points.

DFLABEL

"Default Label Style %s\n"

This is the default style used for labels in the spreadsheet.

Argument:

1. A style from ZUSAstlStrings.

DFNUMBER

"Default Number Style %s%s\n"

This is the default style used for numbers.

Arguments:

1. A style from ZUSAstlStrings.

2. A precision, or ZUSAnumStrings, or ZUSAdateStrings.

DFSYMBOL

"Symbols -%s- -%s- %d %d %d %d %d %d %d %d %d %d %s\n"

This specifies a number of default settings in the spreadsheet.

Arguments:

1. Symbol used for Currency

2. Leave as space.

3. Length of Money Symbol

4. Leave as 0

5. Decimal Separator

6. Thousands Separator

7. 1 - Currency symbol goes before number
0 - Currency symbol goes after number

8. Font size

9. Print font size

10. 1 - Grid lines on
0 - Grid lines off

11. Text Alignment (??????)

12. Number Alignment

13. Attribute String (???????)

DISPLAYCALC

"Calc On Display: %d\n"

This specifies whether all cells are calculated when Recalculation is selected, or only those that are currently displayed.

Argument:

1. 1 - Only calculate those cells that are currently displayed.
0 - Calculate all cells that are obsolete.

DOCCOLWIDTH

"Document Column Width: %d\n"

This is the default width for columns in a spreadsheet.

Argument:

1. A column width in characters.

DOC_REAL_NAME

"Current Doc Real Name: %s\n"

This is the documents name, when the document was saved. This is used for background printing, when the file is saved with a temporary name.

Argument:

1. The filename of the spreadsheet (i.e./home/johndoe/mysheet.as)

ELFHOOK

"elfHook:%s\n"

This specifies the Elf macro to run when the spreadsheet is first loaded.

Argument:

1. The name of an Elf macro.

END

"Spreadsheet End\n"

This signifies the end of an Applixware Spreadsheets file.

FACETABLE_END

"END TYPEFACE TABLE"

Signifies the end of the typeface table.

FACETABLE_START

"TYPEFACE TABLE"

Signifies the beginning of the typeface table.

FORMULA

"Formula: %d\n"

Specifies a unique number to reference a particular formula that is used in more than one cell. (see shared formulas).

Argument:

1. A unique integer.

LANDSCAPE

"Landscape: %d\n"

Specifies the orientation of the paper.

Argument:

1. 1 - The paper is landscape
0 - The paper is portrait

LMARGIN

"Left Margin: %d\n"

The left margin.

Argument:

1. The left margin in 1/1000ths of an inch

LOAD_CELL_CALLBACK

"LOAD_CELL_CALLBACK: %s\n"

An Elf macro to call when data is entered in a cell.

Argument:

1. An Elf Macro.

MCONTROL

"Double Sided: %d\n"

This specifies if the document is to be printed on both sides of the paper.

Argument:

1. 1 - Print Double Sided.
0 - Print Single Sided.

MINCALC

"Minimal Recalc: %d\n"

This specifies whether the calculation engine will do an optimal calculate.

Argument:

1. 1 - Do optimal Calculation.
2 - Do not do optimal calculation.

NAME

"Named Range, Name: .%s. Coordinate: %s\n"

Defines a named range in the spreadsheet.

Arguments:

1. A string that is the name of the named range.

2. A range (i.e. A:A1..A:A20)

NCALCSTYLE

"Calculation Style N\n"

If this line is present the calculation order for the spreadsheet is Natural.

NOGRIDADDR

"No Grid Adrress: %d\n"

Specifies whether Row/Column Headings are displayed.

Arguments:

1. 1 - Do not display Row/Column Headings
0 - Display Row/Column Headings

NUMEXTLINKS

"Num ExtLinks: %d\n"

This specifies the number of external links in the spreadsheet.

Argument:

1. An integer specifying the number of external links.

OPTCALC

"Optimal Calc: %d\n"

Specifies whether the optimal calculation algorithm is used.

Argument:

1. 1 - Use optimal calculation.
0 - Do not use optimal calculation.

PAGEHEIGHT

"Page Height: %d\n"

The paper height.

Argument:

1. The paper height in 1/1000ths of an inch.

PAGEWIDTH

"Page Width: %d\n"

The paper width.

Argument:

1. The paper width in 1/1000ths of an inch.

PAPERTYPE

"Paper Type: %d\n"

This specifies the paper type.

Argument:

1. The paper type (see paper types)

PLATEALIAS

"Sheet %s ~%s~\n"

This specifies the name of a sheet.

Arguments:

1. The sheet letter (ie A, B, C...)

2. The name to be used for the sheet.

PLATES_END

"END SHEETS TABLE"

This specifies the end of a sheet definition.

PLATES_START

"SHEETS TABLE"

This specifies the beginning of a sheet definition.

PRINTGRIDS

"Print GridLines: %d\n"

This controls whether gridlines will be printed or not.

Argument:

1. 1 - Print Gridlines.
2 - Do not print Gridlines.

PRINTTOFIT

"PrintToFit:%d Wide:%d Tall:%d\n"

Forces a spreadsheet to be printed on a certain number of pages.

Arguments:

1. 1 - Print To Fit enabled
0 - Print To Fit disabled

2. Number of sheets wide to print

3. Number of sheets tall to print

PRTLASTCELL

"DontPrintBeyondLastCell:%d\n"

Controls whether cells beyond the last one containing data are printed.

Argument:

1. 0 - Print Beyond the last data cell
1 - Print Only up to the last data cell

RCALCSTYLE

"Calculation Style R%d\n"

Sets the calculation direction to Row.

Argument:

1. The maximum number of iterations to perform.

REV

"Spreadsheet Dump Rev %2.2lf Line Length %d\n"

This line stores the revision of Applixware that the spreadsheet was saved in, and the maximum line length in the file.

Arguments:

1. The Applixware version as a floating point number. (ie 4.41)

2. The maximum line length in the file before a line is split. (ie 80)

RMARGIN

"Right Margin: %d\n"

The right margin.

Argument:

1. The right margin in 1/1000ths of an inch.

RNAME

"Relative Named Range, Name: .%s. tCol:%d tRow:%d tSheet:%d bCol:%d bRow:%d bSheet:%d tColAbs:%d tRowAbs:%d tSheetAbs:%d bColAbs:%d bRowAbs:%d bSheetAbs:%d\n"

This defines a relative named range

Arguments:

1. The name of the range

2. The Top Column reference or offset of the range (as an integer)

3. The Top Row reference or offset of the range (as an integer)

4. The Top Sheet reference or offset of the range (as an integer)

5. The Bottom Column reference or offset of the range (as an integer)

6. The Bottom Row reference or offset of the range (as an integer)

7. The Bottom Sheet reference or offset of the range (as an integer)

8. 0 - The Top Column is an offset
1 - The Top Column is a reference

9. 0 - The Top Row is an offset
1 - The Top Row is a reference

10. 0 - The Top Sheet is an offset
1 - The Top Sheet is a reference

11. 0 - The Bottom Column is an offset
1 - The Bottom Column is a reference

12. 0 - The Bottom Row is an offset
1 - The Bottom Row is a reference

13. 0 - The Bottom Sheet is an offset
1 - The Bottom Sheet is a reference

ROW_EMPTY_LIST

"Row List %s !%d: "

Sets formatting for a range of cells in a particular row.

Arguments:

1. The sheet (ie A, B, C, etc.)

2. The Row

3. One or more ROW_PER_EMPTY

ROW_FORMAT

"Format Row %s !%d:%s \n"

Specifies the formatting for an entire row.

Arguments:

1. The sheet

2. The Row

3. A format string.

ROW_PER_EMPTY

"%d-%d:%d "

This is part of the ROW_EMPTY_LIST, and is used to specify what attributes are applied to what range.

Arguments:

1. Start Column as an integer

2. End Column as an integer

3. An integer referring to a format in the Attribute table

RTINSERTDISPLAY

"Calc RtInsert On Display: %d\n"

This sets whether RTINSERT functions that are obsolete are recalculated if they are not currently visible.

Argument:

1. 1 - Only calculate visible RTINSERT functions.
0 - Calculate all RTINSERT functions.

RT_VALUES_END

"RT VALUES END"

The end of the RealTime state information.

RT_VALUES_START

"RT VALUES START"

The Beginning of RealTime state information. All information until RT_VALUES_END is undocumented.

SELECT_CALLBACK

"SELECT_CALLBACK: %s\n"

This is the macro that will. be called when a range of cell is selected.

Argument:

1. An Elf macro.

SHADOW

"Shadow Name, Spreadsheet: ~%s~ DocId: %s Name: .%s. Alias: .%s. Coordinate: %s UseExtAttrs: %d\n"

This is used to store information about external links.

Arguments:

1. The path to a spreadsheet file.

2. A string representing the filetype as an integer.

3. The named range in the file to link to

4. An alias to reference the name by in the current spreadsheet

5. The location of the link in the current spreadsheet.

6. 1 - Preserve Attributes on the linked data.
0 - Do no preserve attributes.

SHOWPAGEBRKS

"Show PageBreaks: %d\n"

Controls whether pages breaks are displayed on the sheet.

Argument:

1. 1 - Display page breaks
0 - Do not display page breaks

SS_OD_AUTO_START

"No Auto Start OD: %d\n"

Controls whether realtime formulas that are On Demand are requested the first time a spreadsheet is loaded.

Argument:

1. 1 - Do not request on demand RealTime formulas when the spreadsheet is loaded
0 - Request on demand RealTime formulas when loaded.

SS_RTI_AUTO_START

"No Auto Start Rt Insert: %d\n"

Controls if RTInsert formulas are automatically contributed when a spreadsheet is loaded.

Argument:

1. 1 - Do not contribute RTInsert functions when spreadsheet is loaded.
0 - Contribute RTInsert functions when the spreadsheet is loaded.

SS_RT_AUTO_START

"No Auto Start Rt: %d\n"

Controls if the RealTime engine is automatically started if there are any realtime cells in the spreadsheet.

Argument:

1. 1 - Do not automatically start the realtime engine.
0 - Automatically start the realtime engine.

TMARGIN

"Top Margin: %d\n"

The top margin.

Argument:

1. The top margin in 1/1000ths of an inch.

TOPLEFT

"Top Left: %s\n"

Defines the top left cell in a spreadsheet.

Argument:

1. A cell reference as a string (ie A;A1)

TYPECONVERSION

"Calc Type Conversion: %d\n"

Controls if strings that are numbers are automatically converted to their corresponding value for arithmetic.

Argument:

1. 1 - Convert strings containing digits to numbers automatically
0 - Do not convert.

ZOOMFACTOR

"Percent Zoom Factor: %d\n"

This sets the zoom for the entire spreadsheet.

Argument:

1. The zoom factor specified as an integer.

DSPEDITLINE

"Window Display Edit Line:%d\n"

Controls if the Edit Line is displayed or not.

Argument:

1. 1 - Display Edit Line.
0 - Do not display Edit Line.

DSPEXPRESSLINE

"Window Display Expressline:%d\n"

Controls if the Express line is displayed or not.

Argument:

1. 1 - Display Express Line.
0 - Do not display Express Line.

INCELLEDITLINE

"Window Edit In Cell:%d\n"

Argument:

Controls whether in-cell editing is enabled.

1. 1 - Edit in-cell.
0 - Do not Edit in-cell.

WINEND

"Window End: %d\n"

Specifies the end of a Window definition.

Argument:

1. A window number. Should correspond to WINSTART

WINNOGRIDADDR

"Window No Grid Adrress: %d\n"

Controls if the Row & Column Addresses are displayed. NOTE: The misspelling is correct..

Argument:

1. 0 - Display Cell Addresses.
1 - Do not display Cell Addresses.

WINNOSHEETS

"Window No Sheets: %d\n"

WINOPENCELL

"Window Open Cell: %s\n"

WINSTART

"Window Start: %d\n"

WINTOPLEFT

"Window Top Left: %s\n"

WINVIEW

"Window View: ~%s~\n"

WINX

"Window Width mills: %d\n"

WINXP

"Window X Pos mills: %d\n"

WINY

"Window Height mills: %d\n"

WINYP

"Window Y Pos mills: %d\n"

WX

"Window Width: %d\n"

WXP

"Window X Pos: %d\n"

WY

"Window Height: %d\n"

WYP

"Window Y Pos: %d\n"

COLWID

"View Column Widths: "

CRVLED

"View Columns Visible: %s\n"

DFCOLWID

"View Default Column Width %d\n"

DFROWHT

"View Default Row Height: %d\n"

EPAGESETUP_INFO

"View End Page Setup Info"

EPAGESETUP_INFO

"View End Page Setup Info\n"

ENDVIEW

"View End, Name: ~%s~\n"

VIEW_ENDHDRFTRS

"View Headers And Footers End\n"

VIEW_HDRFTRS

"View Headers And Footers\n"

PLATE_LOCKED

"View Locked"

VCURSOR

"View Open Cell: %s\n"

PAGEBRK

"View Page Breaks: "

VIEWPASSWD

"View Password: ~%s~\n"

PROPAGATE_BRK

"View Propagate breaks: %d\n"

PROPAGATE_HT

"View Propagate heights: %d\n"

PROPAGATE_WID

"View Propagate widths: %d\n"

ROWHEIGHT

"View Row Heights: "

RRVLED

"View Rows Visible: %s\n"

SPAGESETUP_INFO

"View Start Page Setup Info"

SPAGESETUP_INFO

"View Start Page Setup Info\n"

VIEW

"View Start, Name: ~%s~\n"

CTITLES

"View Title Column: %s\n"

RTITLES

"View Title Row: %s\n"

VTOPLEFT

"View Top Left: %s\n"

PLATE_UNLOCKED

"View Unlocked"

ENDHDRFTRS

"Headers And Footers End\n"

EVEN_ODD_PAGE

"EvenOddPage :%d\n"

EVEN_ODD_PAGE_TOKEN

"EvenOddPage"

FIRST_PAGE_SPECIAL

"FirstPageSpecial :%d\n"

FMARGIN

"Footer Margin: %d\n"

HDRFTRS

"Headers And Footers\n"

HFATTR_TOKEN

"HFATTRS"

HFTEXT

"HFTEXT"

HFTEXT_STR

"HFTEXT :%s\n"

HMARGIN

"Header Margin: %d\n"

LAST_PAGE_SPECIAL_TOKEN

"LastPageSpecial"

PRTHDRS

"Print Headers: %d\n"

LAST_PAGE_SPECIAL

"LastPageSpecial :%d\n"

CRITRANGE

"Criteria Range: ~%s~\n"

Specifies the Criteria Range for a database.

Argument:

1. A range (ie A:A1..A:B3)

DATABASE

"Database Range: ~%s~\n"

Specifies the range of a data in a database.

Argument:

1. A range (ie A:A1..A:B40)

DBASE

"Database, Name: ~%s~\n"

This marks the beginning of a Database definition

Argument

1. A string (ie My database)

ENDDBASE

"End Database, Name: ~%s~\n"

This signifies the end of a database definition for the specified database.

Argument:

1. A name of a database that matches the last DBASE entry.

EXTRANGE

"Extract Range: ~%s~\n"

This specifies the extract range for a particular database.

Argument:

1. A range (ie A:A20..A:C50)

LASTEXTRNG

"Last Extract Range: ~%s~\n"

This stores the last extract range that was selected to clear.

Argument:

1. A range

GROBJ

"Graphic Obj Start: ~%s~\n"

GROBJ_APPTYPE

"Object AppType: %d\n"

GROBJ_ATTRS

"Object Attrs: Hidden:%d, Locked:%d, Print:%d, Link:%d, NoBorder:%d\n"

GROBJ_CELL1

"Top Corner %s xoff = %lf yoff = %lf\n"

GROBJ_CELL2

"Bot Corner %s xoff = %lf yoff = %lf\n"

GROBJ_CENTERED

"Object Centered: %d\n"

GROBJ_CLIPMODE

"Object ClipMode: %d\n"

GROBJ_DOCTYPE

"Object DocType: %d\n"

GROBJ_DST_HYT

"Object Destination Height : %d\n"

GROBJ_DST_WID

"Object Destination Width : %d\n"

GROBJ_ELF_MACRO

"Object ElfMacro: %s\n"

GROBJ_END

"Graphic Obj End: ~%s~\n"

GROBJ_FILTER_MACRO

"Object Filter Macro: %s\n"

GROBJ_HYT

"Object Height : %d\n"

GROBJ_KIND

"Object Button Type : %d\n"

GROBJ_PATH

"Object Path: %s\n"

GROBJ_PLATE

"Object Plane: %s\n"

GROBJ_PROPERTY

"Object Property: ~%s~\n"

GROBJ_PROPERTY

"Object Property: ~%s~\n"

GROBJ_PROPORTIONAL

"Object Proportional: %d\n"

GROBJ_SOURCEINFO

"Object_Source_Info: "

GROBJ_SRC_HYT

"Object Source Height : %d\n"

GROBJ_SRC_WID

"Object Source Width : %d\n"

GROBJ_TITLE

"Object Title: ~ %s~\n"

GROBJ_TYPE

"Object Type: %s\n"

GROBJ_WID

"Object Width : %d\n"

GROBJ_XSCALE

"Object X Scale: %lf"

GROBJ_XSCALE

"Object X Scale: %lf\n"

GROBJ_X_LOC

"Object X Loc: %ld\n"

GROBJ_X_LOC

"Object X Loc: %ld"

GROBJ_YSCALE

"Object Y Scale: %lf"

GROBJ_YSCALE

"Object Y Scale: %lf\n"

GROBJ_Y_LOC

"Object Y Loc: %ld\n"

GROBJ_Y_LOC

"Object Y Loc: %ld"

OBJECT

"Graphic Object:.%s. Name:~%s~ Path:~%s~ Origin:(%ld %ld) Size:(%ld %ld) Property:~%s~ Macro:~%s~ Range:%s (%4.2lf,%4.2lf)\n"

AUTOCHART

"Charting Preference: %d\n"

CHART

"Chart Name: ~%s~\n"

CHARTEND

"Chart End\n"

CHARTTYPE

"Chart Type: ~%s~\n"

CHART_SERIES

"Chart Series: %s\n"

GROUP

"Chart Group %d: %s ~%s~ ~%s~ ~%s~\n"

GROUP_STATUS

"Chart Group Status %d: %s ~%s~ ~%s~\n"

LEGENDSTRS

"Legend Strings: ~%s~\n"

LEGEND_STATUS

"Legend Status: ~%s~\n"

AUDIO_OBJECT

"Audio"

BUILDER_OBJECT

"Builder"

BUTTON_OBJECT

"Button"

CHART_OBJECT

"Chart"

DATA_OBJECT

"Data"

EMBEDDED_OBJECT

"Embedded"

EQN_OBJECT

"Equation"

GRAPHIC_OBJECT

"Graphics"

HTML_OBJECT

"HTML"

SS_OBJECT

"Sheet"

UNKNOWN_OBJECT

"Unknown"

WP_OBJECT

"Words"

BGCOLORSTR

"BG"

BOLDSTR

"B"

DEF_BG_COLOR

"bg"

DEF_FG_COLOR

"fg"

FACESTR

"TF"

FGCOLORSTR

"FG"

FONTSIZE_STR

"P"

ITALICSTR

"I"

STRIKE_THRU_STR

"ST"

UNDERLINESTR

"U"

UNDERLINE_WORDS_ONLY_STR

"UWO"

VALIGN_BOT_STR

"VB"

VALIGN_CENTER_STR

"VC"

VALIGN_TOP_STR

"VT"

WRAPTEXTOFFSTR

"WTO"

WRAPTEXTSTR

"WT"

MAX_CELL_DUMP_STR

1024

SS_COPY

"Copy"

SS_CUT

"Cut"

SS_END

2

SS_LINE

1

SS_LINK

3

SS_XEOF

2

SS_XOK

1

Current

"Current"

BREAK

"%d "

ATTR_STR

"%s\n"