Post Reply 
use vectors in spreadsheet
10-10-2014, 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 P1-P2 but it give me 2.
Can I not do vector subtraction in the spreadsheet?
Find all posts by this user
Quote this message in a reply
10-11-2014, 12:31 AM
Post: #2
RE: use vectors in spreadsheet
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)
Visit this user's website Find all posts by this user
Quote this message in a reply
10-11-2014, 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.
Find all posts by this user
Quote this message in a reply
10-11-2014, 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 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
Visit this user's website Find all posts by this user
Quote this message in a reply
10-11-2014, 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.
Find all posts by this user
Quote this message in a reply
Post Reply 




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