Excel (.ods) count rows doesn't work

[avalongits]

I have a .ods file (excel created with openoffice) with 21 rows

I tryed to get the number of the rows, but the first time I got 23 rows, and the second time (after deleting lots of rows under the 21 rows) I got 25, as you can see in the image attached

 

[rostonix]

Try to use xlxs or csv or txt format for your tables. And mke sure file is closed when you modify it with ZP.

 

[avalongits]

CSV worked! thank you

 

[avalongits]

Ops, I spoke too soon.

CSV (saved in openoffice from the ods file) get the right lines number but doesn't split columns (I've tried also "Own format" options)

XLS (Microsoft 97-2003) worked!

 

[rostonix]

I use Microsoft office and if you would like to view data separated by column you'll need to set which separator you wanna use here:
http://www.mediafire.com/view/?9xukiq9wk1vxlfr
I think OpenOffice should have the same function somewhere