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. |
|||
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. |
|||
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. |
|||
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 |
|||
07-10-2015, 06:30 AM
Post: #5
|
|||
|
|||
RE: Spreadsheet - Extracting from List
(03-17-2015 07:18 AM)Thomas_Sch Wrote: Hello Dirk,@HP: Please change this behavior according to list adressing. (see above postings) Thank you! |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 4 Guest(s)