~update~ Now that I've taken some time to dig around a bit - I found something that should explain a few things using an example:
The data in the first two rows of the data file looks like this: timestamp raw 0.2Hz 213.200000E+0 279.000000E-6 290.183295E-6 While this is what OOCalc has apparently done with the data when importing it using default settings: timestamp raw 0.2Hz '213.200000E+0 '279.000000E-6 '290.183295E-6 This is by using "Insert -> Sheet From File", btw, in case there's some other method I'm unaware of. I didn't initially notice this in Gnumeric when I opened the OOCalc file, but this certainly explains why the "numbers" won't take changes to their format. My bad - I should have caught that before the last post. The weird thing is that, when I selected an entire column of this data, it wasn't indicated as text - as I would have expected. The cell format showed as Category "Number", Format Code "General", with the example showing as "123.456789E-6". Something seems to have changed in the default way that OO is importing the data. The older version of OOCalc that I have on the OpenSUSE box imports the data properly using the default settings, whereas here I had to turn on "detect special numbers" to get the data to come in properly. I blew away my home openoffice directories to ensure that there was no lurking config that was messing stuff up, and the default behavior produced what I describe above. I currently don't have access to the OpenSUSE box to check on its OO version and the default import settings, sorry. Diogo: can you verify any of this matches what you're seeing? -M -- OpenOffice spreadsheet is not working properly (e.g. drawing bar graphs and importing data) after I updated to Ubuntu 9.10 https://bugs.launchpad.net/bugs/485008 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs