Re: text mode columns strip leading "+"?



Morten Welinder wrote:

If you are using the text importer, be sure to set the format to "Text" for
any columns you do not want to be interpreted as numbers, dates, etc.

Morten
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list



Yes, unfortunately, it was. In fact, in the "validation" tab of the "format cells" dialog, the criteria "Any Value (no interpretation)" was set.

Now, Jean Bréfort pointed out that if you put an apostrophe as the first character of the cell, it forces the cell to be interpreted as text. And in fact, that worked. However, it must be a simple bug that the validation criteria is not honored.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]