Re: HP Prime Spreadsheets (6218 Views)
Reply
JnC
Occasional Visitor
JnC
Posts: 3
Registered: ‎11-10-2013
Message 1 of 9 (6,281 Views)

HP Prime Spreadsheets

When double tapping a column in the spreadsheet app the column size is reduced to approx. 20px. Is there a way to prevent/undo this?

 

Trusted Contributor
Joseph Horn
Posts: 101
Registered: ‎09-25-2006
Message 2 of 9 (6,241 Views)

Re: HP Prime Spreadsheets

There's no way to prevent it, and there's no "Undo" button, the column can be returned to its original default width by tapping Format, Column, -1, Enter.  (This assumes that the column header is still selected after accidentally shrinking it).  Or, instead of -1, you can use an actual number of pixels, of course.

 

-Joe-

-Joe-
Honored Contributor
Miguel Angel Caporalini
Posts: 2,392
Registered: ‎02-09-2009
Message 3 of 9 (6,223 Views)

Re: HP Prime Spreadsheets

Hi!, JnC:

 

Welcome, to Forum!.

 

See, the images ... step by step ...

 

If your CASE is ...

Spreadsheet_1.JPG then press ... Spreadsheet_2.JPG now, you then ... Spreadsheet_3.JPG

 

Trusted Contributor
Joseph Horn
Posts: 101
Registered: ‎09-25-2006
Message 4 of 9 (6,218 Views)

Re: HP Prime Spreadsheets

Just a friendly warning: Miguel's tip is very handy if the column header contains no information, but be aware that pressing backspace on a column header not only resets the column width to its default, it also deletes everything else stored in the header (data and/or formula, name, and all formatting).  It deletes all that immediately, without asking "Are you sure?", and there is no way to undo the deletion.

-Joe-
Honored Contributor
Miguel Angel Caporalini
Posts: 2,392
Registered: ‎02-09-2009
Message 5 of 9 (6,200 Views)

Re: HP Prime Spreadsheets

[ Edited ]

Hi!, Joseph:

 

You have reason. In the header you must deleted all in the select column, but you didn't delete nothing, in the rest, if you press Backspace. Look, what if you explore the Backspace, is same to Column -1.

Spreadsheet_3.JPG Spreadsheet_4.JPG

 

JnC
Occasional Visitor
JnC
Posts: 3
Registered: ‎11-10-2013
Message 6 of 9 (6,169 Views)

Re: HP Prime Spreadsheets

Thanks a lot for the answers - didn't know the backspace trick. Is it possible to set the column width from a program?

 

JnC
Occasional Visitor
JnC
Posts: 3
Registered: ‎11-10-2013
Message 7 of 9 (6,113 Views)

Re: HP Prime Spreadsheets

It seems something like this should work

 

ColWidth(1):=100;

 

This sets the column width of column 1 using the active spreadsheet.

Occasional Visitor
BobKrohn
Posts: 1
Registered: ‎11-18-2014
Message 8 of 9 (109 Views)

Re: HP Prime Spreadsheets (missing Row Column adjustment in SpreadSheet)

I just got an HP Prime  (Nov 2014)

 

Playing with the SpreadSheet App I discovered the "pinch & spread fingers" method of adjusting the Column Width and Row Height.

Also, the ability to make Rows and Columns disappear with no obvious way to make them appear again.

However, this is not possible on the PC Emulator.

 

Then discovered another disturbing issue.

There is no Column Width or Row Height available in the Format Menu!!!

Even though the Help says there is and refers to it.

This is true on the actual machine as well as the Emulator

 

What's going on?  

Honored Contributor
Tim Wessman
Posts: 790
Registered: ‎01-08-2009
Message 9 of 9 (97 Views)

Re: HP Prime Spreadsheets (missing Row Column adjustment in SpreadSheet)

You can do this in the emulator. You need to hold down the right click button on the mouse, then the left down (while still holding the right) and move back and forth.

 

These other items appear when you are selecting the coloumn or row header. Selecting just a single cell doesn't apply the formatting to the entire row/column, so it doesn't make sure to appear anywhere except on the headers.

--

TW


Although I work for the HP calculator group, the views and comments expressed here are my own.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.