Spreadsheet - Extracting from List

[Dirk.]

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.

[Thomas_Sch]

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.

[Dirk.]

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.

[Thomas_Sch]

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

[Thomas_Sch]

(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:
Please change this behavior according to list adressing.
(see above postings)
Thank you!