On Saturday February 24 2007 1:24 pm, Gerald Glass wrote:
> I am using Openoffice ver. 2.1 and I cannot get a excell
> spreadsheet to work in Calc format. It is a spread sheet that I use
> in my business quite frequently. I obtained the spread sheet from a
> vendor for doing a specific job. When I convert it to openoffice,
> it does not calculate correctly when the macros are enabled. I am
> attaching the spread sheet in excell format. The problem is in the
> formula in D10. Any help will be appreciated. Gerald Glass
> [EMAIL PROTECTED]
Attachments are stripped from emails to prevent the spread of
viruses and trojan horses to the members of this list.
At the present time, Calc will not run macros written in VBA. It
uses Star Basic which is similar. Parts of the macro will have to be
rewritten for it to work in Calc. Formulas are not always written the
same either.
If we knew what formula was in D10 and what you wanted it to do,
someone one this list probably could tell you what the correct
formula should be. Changing the formula could solve your problem.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
