Post Reply 
Spreadsheet Cell Color
11-27-2014, 01:55 AM
Post: #1
Spreadsheet Cell Color
I've read the manual and is possible formatting the Cells in Spreadsheet, changing the color. Is it possible changing it programmatically?

Thank you very much for your help
Rogerio
Find all posts by this user
Quote this message in a reply
11-29-2014, 12:15 PM (This post was last modified: 11-29-2014 12:16 PM by Tyann.)
Post: #2
RE: Spreadsheet Cell Color
(11-27-2014 01:55 AM)rbiondi Wrote:  I've read the manual and is possible formatting the Cells in Spreadsheet, changing the color. Is it possible changing it programmatically?

Thank you very much for your help
Rogerio

hello
yes with cell (row, column, 6) := n for text and cell (row, column, 7):=n to the bottom
with 0 <= n < = 32768 .
Find all posts by this user
Quote this message in a reply
11-29-2014, 02:27 PM
Post: #3
RE: Spreadsheet Cell Color
Note that I would recommend using the RGB function for setting your color. That way it will be compatible when/if color depth changes for future revisions/software versions.

TW

Although I work for the HP calculator group, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
11-29-2014, 04:23 PM
Post: #4
RE: Spreadsheet Cell Color
(11-29-2014 02:27 PM)Tim Wessman Wrote:  Note that I would recommend using the RGB function for setting your color. That way it will be compatible when/if color depth changes for future revisions/software versions.

Hello Tim
I thought RGB did not work, I have to repeat some tests , in fact it is necessary to limit the values ​​to not exceed 32768 .
RGB ( 0,0 to 127 ,0 to 255 ) .
From what I understand .
Sorry for my english : google translation.
Note that you can use the syntax: A6 (6) in place of cell ( 6,1,6 ) for example.
Find all posts by this user
Quote this message in a reply
11-29-2014, 10:35 PM
Post: #5
RE: Spreadsheet Cell Color
Hmm. Indeed. I think that needs to be fixed.

TW

Although I work for the HP calculator group, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
11-30-2014, 11:47 AM
Post: #6
RE: Spreadsheet Cell Color
Thank you very much for the help!
I'm still learning more about the calculator and loving it so much!

Best regards,
Rogerio
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)