Strange. I've just mirrored your settings (I'm on winXP and also have 1.1.4 installed) and again everything seems fine.
If the data is not that sensitive, you can send a portion of it to me (off list) and I'll see if I can get it going ... Other than that I'm not too sure what to suggest... /paul On 7/12/05, Leonard Sitongia <[EMAIL PROTECTED]> wrote: > Paul wrote: > > Not too sure what version of OOo your using, but I've tried to > > replicate your problem using 1.9.104 and cannot. I was able to create > > a spreadsheet (saved in .ods format) using both of your number formats > > below. I could query and diaplay all columns as they should have been. > > > > The only thing I can think of is whether your spreadsheet your using > > in OOo format or .xls? > > Hi, > > Thank you for your reply. I greatly appreciate your help. > > I'm using OOo 1.1.4 on Windows XP. Sorry I didn't describe my > environment before. I usually do that. :-) > > The spreadsheet was originally in Appleworks on a Mac. I saved it in > Excel format, and read that into OOo. Then I saved it in OOo format > (a .sxc file), and have been working with that file since. When I open > the .sxc file, I can see the 9-digit zip codes fine. It's just when I > open the data source that I created to reference the spreadsheet as a > database that the 9-digit zip codes are missing. > > The 9-digit zip codes are missing from the cells that show in the > spreadsheet-like window under the tools bars (and to the right of the > list of data sources). The spreadsheet is at the bottom of the page, > and does show the 9-digit zip codes. > > I'm probably being overly verbose here, but I want to be sure that my > description is pointing to the right part of what I see. I can send a > screenshot if you want. > > Thanks! > ==Leonard > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
