Hello Harold
Thanks for your reply and the hints.
On Friday 16 March 2007 14:23, Harold Fuchs wrote:
> I don't have Excel, nor a computer on which I'm willing to install it,
> but if you are willing to upload a sample sheet to mytempdir
> (www.mytempdir.com) and send us the file reference number ("ID") plus a
The problem with that is that I'm not allowed to make the file public. I can
send it to single people under an impromptu NDA, but wide distribution is out
of the question. Let me just say that some people spend way too much money on
Excel spreadsheets.
> In the meantime, you might like to think about answers to the following
> as part of your analysis:
> 1. **Exactly** what doesn't work when compared to Excel?
That's a good hint, I will compare results one by one. The spreasheet is
a "simple" timesheet. One odd thing is that Excel and Gnumeric highlight
cells marked as Saturday or Sunday in a special color, while OO Calc marks
different ones (in some months Wed/Thu, in some Mon/Tue etc.). Also, the end
result of the calculations for year's end are the same in Excel and Gnumeric
but different by only a percent or so in OO Calc.
I can't even figure out how you get Excel to color cells depending on certain
conditions, that's why I was hoping to find an Excel expert to help with the
analysis of those two cases :)
> 2. Are you *sure* that the Excel answer is right and the OO answer
> wrong? For example, Excel thinks 1900 was a leap year when, in fact, it
> wasn't.
No, I can't be sure, I'll go through the document trying to find out if any
leap year calculation is necessary in the formulas leading to the end result.
> 3. Are you using the latest version (2.1) of OpenOffice?
Not yet, as Ubuntu still has 2.0. As soon as I can find a package for OO.o 2.1
that does not come in the form of a bunch of RPMs, I will try it out. It may
very well solve our problems, if the VBA support has changed for example.
Thanks a lot for your hints, as soon as I have any results I will post them
(if they turn out to be interesting).
Ramon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
