Spreadsheet - Strange Content
03-22-2015, 07:48 AM (This post was last modified: 03-22-2015 08:10 AM by Dirk..)
Post: #1
 Dirk. Junior Member Posts: 41 Joined: Mar 2015
Spreadsheet - Strange Content
After working some time with the spreadsheet and transfering between the emulator and the calculator it shows

-:.00000>:000e-369098747

in lots of previously empty cells. In my case E1 to ZZ4.
When entering a number into the cell and deleting it again, the same shows up again.

Is it somehow possible to get rid of this strange content?

Many greetings
Dirk.
03-22-2015, 09:35 AM
Post: #2
 Thomas_Sch Senior Member Posts: 309 Joined: Dec 2013
RE: Spreadsheet - Strange Content
in the entry line:
Code:
E1::ZZ4:={{}}
03-22-2015, 10:49 AM (This post was last modified: 03-22-2015 10:50 AM by Dirk..)
Post: #3
 Dirk. Junior Member Posts: 41 Joined: Mar 2015
RE: Spreadsheet - Strange Content
Thank you,
I think I'm missing something. When entering E1:={{}} somewhere in the spreadsheet I get {{}} as a result in E1. Deleting leads to the same strange content of E1.

Greetings
Dirk.
03-22-2015, 11:44 AM (This post was last modified: 03-22-2015 12:25 PM by Thomas_Sch.)
Post: #4
 Thomas_Sch Senior Member Posts: 309 Joined: Dec 2013
RE: Spreadsheet - Strange Content
my fault. the double colon is wrong.
E1:ZZ4:={{}} should to it.
If you want to erase only one row or one column, e.g. E1:E4, or E1:ZZ1, use {}
E1:E4:={}
E1:ZZ1:={}
Don't enter this in a cell, use the "entry line".

Edit.
If you want to erase a single cell, like E1, use the Backspace or [<X ] key, directly below 'CAS'.
Otherwise the contents you mentioned is really strange.
If the mentioned steps don't work, you could reset the spreadsheet by using Shift Esc (labeled 'Clear').
03-22-2015, 12:28 PM (This post was last modified: 03-22-2015 12:57 PM by Dirk..)
Post: #5
 Dirk. Junior Member Posts: 41 Joined: Mar 2015
RE: Spreadsheet - Strange Content
Thank you,
writing a number to E5 and typing E1:ZZ5:={{}} shows that it in principle deletes something (the content of E5) but E1:ZZ5 still contain the strange content.
So maybe this is the third bug in three day I found in the spreadsheet. Quite Disappointing.

Greetings
Dirk.

Edit: Hitting delete of course does no delete the crap in the cell... It only brings it back after something else was in the cell. And I will for sure not clear the spreadsheet to lose my content.
Edit2: Same result for E1:ZZ5:={} ... deleting content, but not crap.
03-22-2015, 01:24 PM
Post: #6
 Thomas_Sch Senior Member Posts: 309 Joined: Dec 2013
RE: Spreadsheet - Strange Content
Have a look at
http://h30499.www3.hp.com/t5/Calculators...-p/6510996
Maybe there are more hints & tips.

I don't think, that this is a general bug in the spreadsheet.
What did you do exactly before you've got the entries "-:.00000>:000e-369098747" ?

You could also copy the relevant content to a matrix (see http://h30499.www3.hp.com/t5/Calculators...192#M14642) , reset the spreadsheet (or create a copy of the spreadsheet), and copy your data back to a fresh spreadsheet.
03-22-2015, 03:04 PM (This post was last modified: 03-22-2015 03:05 PM by Thomas_Sch.)
Post: #7
 Thomas_Sch Senior Member Posts: 309 Joined: Dec 2013
RE: Spreadsheet - Strange Content
There is another possible reason for the weird contents:
The data could be entered & stored to the complete row!
If you select for example the row 2, and enter something ("test"), this will be stored to all (empty) cells in row 2.
To delete this entries, select row 2, and press backspace.
Individual contents of single cells is still remaining, but "global" contents of the row will be erased.
03-22-2015, 04:09 PM (This post was last modified: 03-22-2015 04:11 PM by Dirk..)
Post: #8
 Dirk. Junior Member Posts: 41 Joined: Mar 2015
RE: Spreadsheet - Strange Content
Hello Thomas,
I've given up.

Thank you very much for all your effort
Dirk.
03-22-2015, 04:23 PM
Post: #9
 Thomas_Sch Senior Member Posts: 309 Joined: Dec 2013
RE: Spreadsheet - Strange Content
Have you tried my last suggestion?
(Select entire row, (in your case 1, 2, 3, 4) press Backspace)?
03-22-2015, 05:02 PM
Post: #10
 Dirk. Junior Member Posts: 41 Joined: Mar 2015
RE: Spreadsheet - Strange Content
Hello Thomas,
yes, I did. Moved the cursor into the row-number-column, pressed <x-key. Well, didn't help. Rebuild the table, deleted the old one.

Thank you very much, viele Grüße
Dirk.
03-23-2015, 06:39 AM
Post: #11
 Thomas_Sch Senior Member Posts: 309 Joined: Dec 2013
RE: Spreadsheet - Strange Content
Sorry for this bug.

Hopefully someone related to HP should read and answer.

greetings from Erlangen,
Thomas
03-23-2015, 09:54 AM
Post: #12
 Gerald H Senior Member Posts: 1,428 Joined: May 2014
RE: Spreadsheet - Strange Content
(03-23-2015 06:39 AM)Thomas_Sch Wrote:  Sorry for this bug.

Hopefully someone related to HP should read and answer.

greetings from Erlangen,
Thomas

Saying sorry makes it sound like you're responsible for the bug - which I don't think is really the case.
03-24-2015, 07:33 AM
Post: #13
 Thomas_Sch Senior Member Posts: 309 Joined: Dec 2013
RE: Spreadsheet - Strange Content
Hello guys from HP (Tim, Cyrille, Parisse, ..),

Is this a bug, what do you mean (or know) ;-) ?
03-25-2015, 06:22 AM
Post: #14
 cyrille de brébisson Senior Member Posts: 934 Joined: Dec 2013
RE: Spreadsheet - Strange Content
Hello,

This strange "content" is how a "bad" real will display (your mileage will vary depending on your value of "bad").

This means that the memory was corrupted, somehow.

Since I am perfection incarnated, it could not have been my programming, so the memory corruption has to have been caused by some "act of God" (insurance definition thereof). Have you been in a place with a high level of cosmic radiation lately?

So, what can you do?
Well, corrupted memory, usually means that the device is likely to crash at one point in the session where the memory was corrupted.
Interestingly enough once corrupted memory gets saved to file and reloaded, the data stays corrupted, but the memory structure itself is NOT corrupted anymore!

So, let us look at the possible cases:
1) Memory is good, Some data is in spreadsheet in RAM, Some data is in spreadsheet in Flash.
- Reboot means loosing data in RAM (Flash data remains)
2) Memory is corrupted, Spreadsheet data in RAM is corrupted. Calculator will crash at one point.
- If you can SAVE the corrupted RAM data in Flash, AND if a subsequent reload does not Crash, you will end up with a NON corrupted memory, BUT Spreadsheeet content containing BOTH corrupted AND uncorrupted data...
3) Calculator crashed, spreadsheet DID reload (ouf!)
- You have ALL your DATA + corrupted stuff

1) is the normal state.
2) is bad as you will loose data in case of reboot/crash.
3) is "good" as your data is NOT lost. All you need to do is erase the crud.

So, obviously, what you want to do is go from step 2 to step 3 so that you can cleanup the "mess".

To do that, turn the calc OFF (which saved all the files to Flash), turn it back on and reboot (ON+Symb). This places you in step 3 (if all goes well), at which point you can recup your data if all goes well.

I am sorry to hear that this is happening to you. If you can find a reliable way to reproduce it, please do tell me!

Cyrille
03-25-2015, 08:12 PM (This post was last modified: 03-25-2015 08:13 PM by Dirk..)
Post: #15
 Dirk. Junior Member Posts: 41 Joined: Mar 2015
RE: Spreadsheet - Strange Content
Hello Cyrille,
thank you very much for your effort. After rebuilding the table it did not happen again. Since I'm a novice using the prime I might do strange things and managed to crash the device two or three times. Thus, if I manage to reproduce it, I'll tell you.

By the way:
Quote: 'Have you been in a place with a high level of cosmic radiation lately?'
The natural radiation level here is 2.2µSv/day.

Dirk.
 « Next Oldest | Next Newest »

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