Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 77)

6
●
Spreadsheets
●
●
●
●
●
69
Note that you can also edit function syntax directly by pressing F2 to edit
in the Excel formula bar. Press Ctrl+Shift+Enter to save the edits when
complete.
Resize Arrays
When a spreadsheet is called up at different times, a different number of
values may be available for a defined function. If the number of values
exceeds the current size of the array, the array does not expand to display
the additional values unless you manually recalculate (page 65) the
function.
If fewer than the original number of retrieved values exist, empty values
are returned to fill the recalculated array, and are marked #N/A if specified,
or left blank. If additional values exist that cannot be displayed, the text
Resize to show all values appears at the bottom of the function array,
unless you set a preference to disable (page 29) this message.
To resize the array to fit available data:
Right-click in any part of an array and choose Recalculate (Resize)
Function from the context menu.
Empty values are typically added when a function references a time range
that extends to the current time, using relative start and end times. When
the function is recalculated, the time range covers a new interval which
may include more data variance, and thereby a different number of
recorded events in the archive.
For example, consider a compressed data function created to request 40
values beginning at midnight the previous day. When the function is
recalculated a week later, and only 35 event values (including filtered
events) are recorded, the final five cells of the original array are filled with
blank strings to preserve the array size.
Empty values may change the appearance of a spreadsheet, but help to
ensure that variances in recorded data are incorporated without updating