To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from [EMAIL PROTECTED] Tue May 3 18:16:32 -0700 2005 ------- Doing this: "Change column C to Default number format and it will work (Cell format->Number format->Standard)." as mentioned in a comment below does not work, at least not with Openoffice 2.x I had a wedding guestlist and the number of invitees per invitation in a column. Some of these numbers were text for some reason. I tried and tried again and again to change the numbers into numbers but it would never work. I finally got it fixed by converting to csv, then re-importing. I had a similar problem with the postal codes and zip codes in openoffice. It thinks the postal codes, like V6Y1G2 are strings (fair enough), but it thinks the zip codes are numbers. I could not get this column to change to "string format) by using the Cell format->number format->standard prescription. This causes big problems when I create an Openoffice Base (database) linked to this spreadsheet for the data. The databse will assume the data in that field/column is a certain datatype and ignore those things which aren't in the same datatype. So many of the records are missing any content in that field. Again, I had to convert to csv, then re-import the file. Big huge pain in the ass. Might be just a 2.x issue for me, I've never seen this before. The major broken functionality here is the Cell format->number format->standard part. Are there any other bugs for this? --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
