Post Reply 
Spreadsheet - Extracting from List
03-16-2015, 07:28 AM
Post: #1
Spreadsheet - Extracting from List
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.
Find all posts by this user
Quote this message in a reply
03-16-2015, 08:37 AM (This post was last modified: 03-16-2015 08:42 AM by Thomas_Sch.)
Post: #2
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.
Find all posts by this user
Quote this message in a reply
03-16-2015, 09:05 AM
Post: #3
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.
Find all posts by this user
Quote this message in a reply
03-17-2015, 07:18 AM
Post: #4
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
Find all posts by this user
Quote this message in a reply
07-10-2015, 06:30 AM
Post: #5
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:
Please change this behavior according to list adressing.
(see above postings)
Thank you!
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: