use vectors in spreadsheet

10102014, 10:21 PM
Post: #1




use vectors in spreadsheet
Wondering if anyone can help me.
I have a spreadsheet like this P1 P2 D [5,5] [9,8] I set column D to P1P2 but it give me 2. Can I not do vector subtraction in the spreadsheet? 

10112014, 12:31 AM
Post: #2




RE: use vectors in spreadsheet
Vector subtraction works, but you will need to press the 'CAS' softbutton in order to enter the '=P1P2' correctly. (I get a 'syntax error' otherwise)


10112014, 12:53 AM
Post: #3




RE: use vectors in spreadsheet
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. 

10112014, 01:04 AM
Post: #4




RE: use vectors in spreadsheet
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 colheading 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 

10112014, 01:14 AM
Post: #5




RE: use vectors in spreadsheet
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. 

« Next Oldest  Next Newest »

User(s) browsing this thread: 1 Guest(s)