Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous

Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

:: com :: sun :: star :: sheet ::

unpublished interface XExternalSheetCache
Usage Restrictions
not published
Description
Primary interface for the ExternalSheetCache service.
Since
OOo 3.1
See also
ExternalSheetCache
Methods' Summary
setCellValue It sets a cached value for a specified cell position. The value is expected to be either of type ::string or of type ::double. No other data types are supported.  
getCellValue It retrieves a cached value from a specified cell position. The cached value can be either ::string or ::double.  
getAllRows It returns a list of all row numbers where a cached cell or cells exist. The row numbers are sorted in ascending order.  
getAllColumns Given a row number, this method returns a list of all columns numbers that store cached cell values in that row. The column numbers are sorted in ascending order.  
Attributes' Summary
TokenIndex Index corresponding to this instance of an external sheet cache for usage in formula tokens.  
Methods' Details
setCellValue
void
setCellValue( [in] long  nColumn,
[in] long  nRow,
[in] any  aValue )
raises( ::com::sun::star::lang::IllegalArgumentException );
Description
It sets a cached value for a specified cell position. The value is expected to be either of type ::string or of type ::double. No other data types are supported.
Parameter nRow
row position (0-based)
Parameter nColumn
column position (0-based)
Parameter aValue
cell value to be cached
getCellValue
any
getCellValue( [in] long  nColumn,
[in] long  nRow )
raises( ::com::sun::star::lang::IllegalArgumentException );
Description
It retrieves a cached value from a specified cell position. The cached value can be either ::string or ::double.
Returns
any cached cell value
getAllRows
sequence< long >
getAllRows();
Description
It returns a list of all row numbers where a cached cell or cells exist. The row numbers are sorted in ascending order.
Returns
sequence list of all row numbers with cached cell(s)
getAllColumns
sequence< long >
getAllColumns( [in] long  nRow )
raises( ::com::sun::star::lang::IllegalArgumentException );
Description
Given a row number, this method returns a list of all columns numbers that store cached cell values in that row. The column numbers are sorted in ascending order.
Returns
sequence list of all columns numbers with cached cell values
Attributes' Details
TokenIndex
[ readonly ] long TokenIndex;
Description
Index corresponding to this instance of an external sheet cache for usage in formula tokens.

This index to the external sheet cache is expected in the SingleReference::Sheet member if it is part of an external reference token.

Each external sheet cache has a unique index value inside the ExternalDocLink instance.

See also
FormulaToken, ExternalReference
Top of Page

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

The ASF

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The ASF logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.