use vectors in spreadsheet - Printable Version +- 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: use vectors in spreadsheet (/thread-2267.html) use vectors in spreadsheet - dalupus - 10-10-2014 10:21 PM Wondering if anyone can help me. I have a spreadsheet like this P1 P2 D [5,5] [9,8] I set column D to P1-P2 but it give me 2. Can I not do vector subtraction in the spreadsheet? RE: use vectors in spreadsheet - dbbotkin - 10-11-2014 12:31 AM Vector subtraction works, but you will need to press the 'CAS' soft-button in order to enter the '=P1-P2' correctly. (I get a 'syntax error' otherwise) RE: use vectors in spreadsheet - dalupus - 10-11-2014 12:53 AM ok that works. 1 more question on these spread sheets. If I enter in something in say C1 and then later decide I want to just define something for the entire column C instead, I can't get it to use what I define for the column in C1 as well since I had something in there. I've tried everything I can think of to clear it out but can't get it to clear. Also the switching in and out of cas seems to be a little flakey. Now it is working without cas but giving a list of the concatenation of everything in columns 1 and 2 in every column 3 when I turn on cas. RE: use vectors in spreadsheet - dbbotkin - 10-11-2014 01:04 AM I'm not sure I understand the question, but here's what I found. If there is a formula in a cell (e.g. C1), it remains as it was after the column is set to some value or formula. If the column is cleared (by going to the col-heading and deleting its contents), the formula in the 'C1' cell is still there. If the 'C1' cell is cleared while a column is set to something, the 'C1" takes on that object as well. Hope this helps, D RE: use vectors in spreadsheet - dalupus - 10-11-2014 01:14 AM Thanks that comment helped me figure out what was going on. If you click edit and clear it then it stays as empty, but if you just hit the delete key without clicking edit first it will clear and take on the value of the column. Starting to get the hang of this calculator now.