Hylton Conacher (ZR1HPC) wrote:
Hi,
I have 'developed' a spreadsheet system that allows me to keep track of my online time, costs and MB in/out on a yearly basis, from data exported from the kppp log viewer ie I have one file for 2003 and another for 2004.
A single line, of 4 columns, in the 2003 spreadsheet is linked to the 2004 one so that the yearly averages can be carried across from year to year.
Each time I open the 2004 spreadsheet the averages from 2003 are also included and hence the 2003 spreadsheet also opens. This is something I have accepted BUT in the last couple of days the averages have not been imported from 2003, nor has the 2003 spreadsheet been opened as OOo reports an error as listed below:
Error loading document <doc path and name> Read error Format error discovered in sub document styles.xml at 2.39117{row,col)
Each year has approx 16 sheets in it and those containing data only have
100 rows of information in 8 columns.
Where do I start in solving this OOo error? I would of course prefer not to lose the data for 2003.
I have tried rebooting and then opening the sxc file with no luck. I have looked at OOo help for 'Validity of Cell Contents' and others, also with no help.
Ideas I have asked the same question on the OOo Users mailing list, so don't all rush to answer. :) Thanks to those who did though.
-- The Little Helper ======================================================================== Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 Licenced Windows user ========================================================================