Programing questions about Spreadsheet App and PRINT.

[Han]

(11-22-2014 04:46 PM)rbiondi Wrote:  Hello,

I'm writing an application for my HP Prime and need some help. Do you know how may I get the following information from a Spreadsheet of Prime, programmatically?

- The name of the column. I've tried Cell(0,i) but didn't work.
- The number of filled rows and columns (row and column count)?
- Other question is if is possible clearing the screen after using several PRINT commands.

Thank you very much for your help,
Rogerio

1. There is currently no means (that I know of) to extract the name of a column if you've renamed it in the Spreadsheet app. Here's hoping something like A0, B0, etc will be allowed for reference to column names in future firmwares.
2. For this, the best you can do is to use (in Home screen):

count("x->(x<>0)", A1:A5)

and it will count the number of non-zero cells (similar to Microsoft's Excel). However, this is not a perfect solution since empty cells are considered to be filled with 0 (even if they physically are empty in the Spreadsheet). So this will miscount if you have an actual cell with value 0. Perhaps the devs will provide an actual COUNT, COUNTA, COUNTIF, and COUNTBLANK commands similar to those in Excel.
3. Typing PRINT() with no arguments should clear the screen.