archivespr

Previous chapterNext chapter Show allShow all    Hide allHide all

As a help for the definition this function can be selected from the menu entry Format/Functions (or with the right mouse button on the cell).

Value, Status or time of the archive entry can be read. Unlike the function "archive" no manual presettings can be set on the cels. These functions are employed, for example, if an entry in a log must be shown several times and may only be edited at one place. All entries of the time range of the log are shown in the log going downwards or rightwards from cell in which the function was given (see also: Function archivesp).

Parameter:

Archive variable

Archive variable number

Contents

"value", "state" "time" or"count"

direction

"right" or "bottom"

P1

Number of archive values to be output in the first row (only for archivespr)

P2

Number of blank cells between two value outputs (only for archivespr)

P3

Blank cells to next value row (only for archivespr)

Syntax: =archivespr(Archive variable,contents,direction,P1,P2,P3)

Example Example

=archivespr(1,value,bottom,12,1,3)