On 9/1/07, Howard Coles Jr. <[EMAIL PROTECTED]> wrote: > > First, have you tried saving this current spreadsheet as a text based, csv > file? And then, importing the csv into OOo?
Would this break the formulas, etc? I have not tried this, because there are multiple tabs, and it is my understandinng that multiple tabs do not import / export well as CSV. Second, I don't think it would be hard to get the thing into a > database. The > hardest part is setting up the DB. Right, that is several hours of work, and then the problem remains that this solution needs to be adopted by all of the educators (teachers and staff) and that is not likely to happen any time soon. These educators are already somewhat suspicious of FOSS, simply because they are not familiar with it, and they think that it will require them to make major changes in their lives. > > Third, in Excel, break the spreadsheet out into multiple spreadsheets. > I'm assuming here that there are no advanced formulas and/or macros? That would be an obvious solution except, again, for institutional lethargy. They have a standardized template that they use, and the teachers are all expected to report in that format. And there are references back and forth among the several tabs, so breaking it out would, again, be a lot of work with not much time left. And, actually, I am assuming that there are advanced formulas and macros, because OOo does not accurately produce the sheet. There are a few broken cells.
