+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Spreadsheet - Extracting from List (/thread-3391.html)
Spreadsheet - Extracting from List - Dirk. - 03-16-2015 07:28 AM
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.
RE: Spreadsheet - Extracting from List - Thomas_Sch - 03-16-2015 08:37 AM
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.
RE: Spreadsheet - Extracting from List - Dirk. - 03-16-2015 09:05 AM
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.
RE: Spreadsheet - Extracting from List / small error in spreadsheet app / - Thomas_Sch - 03-17-2015 07:18 AM
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
RE: Spreadsheet - Extracting from List - Thomas_Sch - 07-10-2015 06:30 AM
(03-17-2015 07:18 AM)Thomas_Sch Wrote: Hello Dirk,@HP:
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
Please change this behavior according to list adressing.
(see above postings)
Thank you!