03-16-2015, 07:28 AM
Post: #1
 Dirk. Junior Member Posts: 41 Joined: Mar 2015
Using the ASC()-function in the spreadsheet, e.g. =ASC(B1) in D1, leads to {78} when there is "N" in B1. To further process this result I need 78, not {78} but I did not find a way to get the first element of the list. Is it somehow possible without writing a "user function"?

Greetings from the River Lahn,
Dirk.
03-16-2015, 08:37 AM (This post was last modified: 03-16-2015 08:42 AM by Thomas_Sch.)
Post: #2
 Thomas_Sch Senior Member Posts: 310 Joined: Dec 2013
RE: Spreadsheet - Extracting from List
Hello Dirk,
unfortunately the method to address an element in an list, like =B1(1) ist not working within spreadsheet.
=B1(1) does habe an other meaning in the conext of spreadsheet. See page 200 "Format parameters" in the english manual.

Now I've tried something weird, and =MAX(ASC(B1)) (or MIN) does the job, if you have only on character.
If B1 contains more characters, =MIN(CAS.left(ASC(B1),1)) delivers the ascii value off the first character.
03-16-2015, 09:05 AM
Post: #3
 Dirk. Junior Member Posts: 41 Joined: Mar 2015
RE: Spreadsheet - Extracting from List
Hello Thomas,
luckily I have only one letter per cell and your solution using MAX() is working fine. Thank you very much. I'm a bit disappointed I did not find this nice solution by myself.

Dirk.
03-17-2015, 07:18 AM
Post: #4
 Thomas_Sch Senior Member Posts: 310 Joined: Dec 2013
RE: Spreadsheet - Extracting from List / small error in spreadsheet app /
Hello Dirk,

it's a pleasure to assist.
Besides that, we have thus found a small error in the spreadsheet app,
"overloading" the List index operator (ist this expressed correctly?) with the cell type function.
It would be helpful, if HP could change this behavior.

Thomas
07-10-2015, 06:30 AM
Post: #5
 Thomas_Sch Senior Member Posts: 310 Joined: Dec 2013
RE: Spreadsheet - Extracting from List
(03-17-2015 07:18 AM)Thomas_Sch Wrote:  Hello Dirk,

it's a pleasure to assist.
Besides that, we have thus found a small error in the spreadsheet app,
"overloading" the List index operator (ist this expressed correctly?) with the cell type function.
It would be helpful, if HP could change this behavior.

Thomas
@HP: