Post Reply 
Direct writing to Spreadsheet
09-16-2015, 11:16 AM
Post: #1
Direct writing to Spreadsheet
hello,

Is it posible to write results direct to the Spreadsheet?
If yes where can I find Some example(s)

I working on a planet calculator,
so I calculate Some Numbers and wont
put them in a spreadsheet as a big overview.

Cheers,
Find all posts by this user
Quote this message in a reply
09-16-2015, 12:26 PM
Post: #2
RE: Direct writing to Spreadsheet
Are you looking for something like
Code:
Spreadsheet.Cell(1,4):=value
?
If you have more than one spreadsheet app, you have to
adjust the spreadsheet name accordingly,
for e.g.
Code:
spread1.Cell(2,3):=yourvalue

Cheers, thomas
Find all posts by this user
Quote this message in a reply
09-16-2015, 02:35 PM
Post: #3
RE: Direct writing to Spreadsheet
Note that if you aren't trying to access by a numeric algorithm, you can also do Spreadsheet.A1, Spreadsheet.B2 and just use the direct cell reference. The "Cell" command allows you to use a number form for accessing the cell reference.

TW

Although I work for HP, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
09-17-2015, 06:38 AM
Post: #4
RE: Direct writing to Spreadsheet
Hello,

You can also do:
A1:='A2+A3' to assign a formula to a cell.

You can also access the cell meta data/attributes using A1(n) or Cell(r, c, n)
Look at the help for Cell References and Cell for more information:

CELL ATTRIBUTES (n)
-1: all attributes. If the cell has nothing defined, returns -1, else return a list of 11 objects.
0: value (read only, you can not set the cell value)
1: formula
2: name
3: number format: Standard 0, Fixed 1, Scientific 2, Engineering 3, Floating 4, Rounded 5, unspecified –1
4: number of decimal places: 1 to 11, or unspecified = –1
5: font: -1: 0 to 6, unspecified = –1
6: background color: cell fill color (color, or 32786 if unspecified)
7: foreground color: contents color (color, or 32786 if unspecified)
8: horizontal alignment: Left = 0, Center = 1, Right = 2 , unspecified = –1
9: vertical alignment: Top = 0, Center = 1, Bottom = 2, unspecified = –1
10: show strings in quotes: Yes = 0, No = 1, unspecified = –1
11: textbook mode (as opposed to algebraic mode): Yes = 0, No = 1, unspecified = –1


Cyrille

Although I work for the HP calculator group, the views and opinions I post here are my own. I do not speak for HP.
Find all posts by this user
Quote this message in a reply
09-19-2015, 04:00 PM
Post: #5
RE: Direct writing to Spreadsheet
Any comments from user powersoft?
Are your questions answered?
Find all posts by this user
Quote this message in a reply
09-19-2015, 07:09 PM
Post: #6
RE: Direct writing to Spreadsheet
Thanks all for this wonderful help.
I have tried it, and wat I won't to do could now be done.

Is it posible to rename a spreadsheet?

Cheers,

Jan
Find all posts by this user
Quote this message in a reply
09-19-2015, 10:43 PM
Post: #7
RE: Direct writing to Spreadsheet
(09-19-2015 07:09 PM)Powersoft Wrote:  Is it posible to rename a spreadsheet?
real Prime or virtual Prime: Pressing "Apps", you can use the "Save" button to create a new App.
In the Connectivity Kit, right click on an app, there ist a option "Rename" if it is a copy of a build in App.

Cheers Thomas
Find all posts by this user
Quote this message in a reply
Post Reply 




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