Daniel Carrera wrote:
Randomthots wrote:
I guess the workaround for this is to save as xls for those spreadsheets that deal with a lot of data that you're manipulating statistically. It's not ideal but it's a lot faster.
For your situation, that might be best. But please make backups. If you are going to use .xls for your work, it's very important that you do backups.
The same thing that makes OpenDocument slow (XML, zip) also make it very reliable and less likely to get corrupted. The same thing that .xls fast (binary dump) also makes it unreliable, and easily damanged.
It's a trade-off.
Cheers, Daniel.
I was thinking the exact same thing after I hit the send key. Sometimes my fingers work faster than my brain - especially at 2:30 am. ;)
A long-ish file save at the end of the day is a small insurance against data loss. Now I just need to find a text editor that can open a file that big -- Wordpad choked on it and I know Notepad isn't designed for files that big.
Heh! Just on a lark, I opened that content.xml file in Writer. SEVERAL minutes later the page counter (Page 1/x in the status bar) stopped spinning and settled at 10893 pages. 36 MB is a BIG text file.
I honestly have no idea how I would go about recovering data from something like that. I suppose you could just start out with some global find-and-replaces to get rid of the tags and try to get closer to something that looked like a csv. I guess an xml editor would be handy. Maybe you could use some of the infamous *nix tools like grep and sed to pull stuff out. Not a trivial task in any case.
BTW, here's what just one row looks like:
<table:table-row table:style-name="ro1"><table:table-cell office:value-type="string"><text:p>arin</text:p></table:table-cell><table:table-cell office:value-type="string"><text:p>US</text:p></table:table-cell><table:table-cell office:value-type="string"><text:p>ipv6</text:p></table:table-cell><table:table-cell office:value-type="string"><text:p>2001:4880::</text:p></table:table-cell><table:table-cell office:value-type="float" office:value="32"><text:p>32</text:p></table:table-cell><table:table-cell office:value-type="date" office:date-value="2005-04-04"><text:p>04/04/05</text:p></table:table-cell><table:table-cell office:value-type="string"><text:p>allocated</text:p></table:table-cell></table:table-row>
Later,
Rod
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
