Post Reply 
Bugs in (7820) 2 Spreadsheet
05-29-2015, 09:23 PM
Post: #1
Bugs in (7820) 2 Spreadsheet
1. We put matrix M1 to a spreadsheet cell A1 without sign =. After the change of an array M1 in the matrix editor also changes the contents of A1.
2. We put a list L1 to a spreadsheet cell A1 with the sign = "=L1". When you change the content of the list L1 in list editor does not immediately change the contents of cell A1.
3. We put matrix M1 to a spreadsheet cell A1 with the sign = "=M1". After the change of an array M1 at Home did not immediately change the contents of A1.
Find all posts by this user
Quote this message in a reply
06-01-2015, 04:24 PM
Post: #2
RE: Bugs in (7820) 2 Spreadsheet
(05-29-2015 09:23 PM)slawek39 Wrote:  1. We put matrix M1 to a spreadsheet cell A1 without sign =. After the change of an array M1 in the matrix editor also changes the contents of A1.

I'm not able to see this at all. Using default settings (textbook entry, etc) - this is what steps I followed:
1. Open matrix editor, type a 2x2 matrix of [[1,2],[3,4]]
2. Open spreadsheet, select cell A1 and type M1. See the text data.
3. Open matrix editor, modify M1 to have a 3rd row with [5,6].
4. Return to spreadsheet num view. Cell remains the same. I do not see it change.

Quote:2. We put a list L1 to a spreadsheet cell A1 with the sign = "=L1". When you change the content of the list L1 in list editor does not immediately change the contents of cell A1.
3. We put matrix M1 to a spreadsheet cell A1 with the sign = "=M1". After the change of an array M1 at Home did not immediately change the contents of A1.

This one I think I see a way to get it. Do you have "2D display" turned on for these cells? I think the content is actually updating, but with 2D display for those cells it is not invalidating the draw from prior. The calculations shouldn't be impacted at all though.

TW

Although I work for the HP calculator group, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
06-01-2015, 05:19 PM
Post: #3
RE: Bugs in (7820) 2 Spreadsheet
(06-01-2015 04:24 PM)Tim Wessman Wrote:  
(05-29-2015 09:23 PM)slawek39 Wrote:  1. We put matrix M1 to a spreadsheet cell A1 without sign =. After the change of an array M1 in the matrix editor also changes the contents of A1.

I'm not able to see this at all. Using default settings (textbook entry, etc) - this is what steps I followed:
1. Open matrix editor, type a 2x2 matrix of [[1,2],[3,4]]
2. Open spreadsheet, select cell A1 and type M1. See the text data.
3. Open matrix editor, modify M1 to have a 3rd row with [5,6].
4. Return to spreadsheet num view. Cell remains the same. I do not see it change.

Quote:2. We put a list L1 to a spreadsheet cell A1 with the sign = "=L1". When you change the content of the list L1 in list editor does not immediately change the contents of cell A1.
3. We put matrix M1 to a spreadsheet cell A1 with the sign = "=M1". After the change of an array M1 at Home did not immediately change the contents of A1.

This one I think I see a way to get it. Do you have "2D display" turned on for these cells? I think the content is actually updating, but with 2D display for those cells it is not invalidating the draw from prior. The calculations shouldn't be impacted at all though.

Ad 1:
1. Open matrix editor, type a 2x2 matrix of [[1,2],[3,4]]
2. Open spreadsheet (by pressing Num), select cell A1 and type M1 (wihout "=" sign). See the text data.
3. Open matrix editor, modify M1 to [[3,2],[3,4]].
4. Return to spreadsheet num view by pressing Num.

Ad 2 and 3:
I have Format/Textbook set to Auto in this cell. After entering "=2*A1" in cell A2 (for example) the content of A1 is repaired.
Find all posts by this user
Quote this message in a reply
06-01-2015, 05:45 PM
Post: #4
RE: Bugs in (7820) 2 Spreadsheet
(06-01-2015 05:19 PM)slawek39 Wrote:  I have Format/Textbook set to Auto in this cell. After entering "=2*A1" in cell A2 (for example) the content of A1 is repaired.

Ok, even #1 is the same issue. Without textbook on it works like you'd expect.

TW

Although I work for the HP calculator group, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
06-01-2015, 09:11 PM (This post was last modified: 06-01-2015 09:14 PM by slawek39.)
Post: #5
RE: Bugs in (7820) 2 Spreadsheet
Very old bug similar to #1 from first post. Occurs even in the emulator HP 39gII. Changing the M1 matrix in the matrix editor from [[1,2], [3,4]] to [[2,2], [3,4]] also changes the matrix M2 if M1 was previously written to the M2.
Find all posts by this user
Quote this message in a reply
Post Reply 




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