If the item field text starts with an equal sign '=', any ensuing text entered disappears (on pressing Enter).
I used use '=' to ensure sorting at the beginning in an A-Z sort, and was copying this text from an older file (where it had not been a problem). So,
pasted the guilty text into the item field -- which worked. But when I edited the text (leaving the = at the beginning) the text disappeared.
I see that I am unable to write text to the item field if '=' is at the beginning.
I know that it's taboo in spreadsheet to start with an = unless it's an equation, but the item field is text, so thought it would/should be okay here.
And as said, had not been a problem in the past.
IQ 92 portable
Win.7
Comments