On Saturday 25 November 2006 02:07 pm, Joe Conner wrote:
> This spreadsheet does use macros and visual basic. Calc
> uses a different basic, which while similar is not
> compatable in a number of regards.
Translation: you have to rewrite the macros used in Excel if you
are going to use the spreadsheet in OOo. This is one area in which
the two are not as compatible as many would like.
Dan
> Sasa Kelecevic wrote:
> > Kirill S. Palagin wrote:
> >>> -----Original Message-----
> >>> From: Terry [mailto:[EMAIL PROTECTED]
> >>> Sent: Friday, November 24, 2006 2:10 PM
> >>> To: [email protected]
> >>> Subject: Re: [users] Calc, tricky .xls is not fully functional
> >>> in Calc
> >>>
> >>> Kirill S. Palagin wrote:
> >>>> Hello.
> >>>>
> >>>> I was given an .xls file, that is not fully functional in
> >>>> Calc. Seemingly macros are not involved.
> >>>>
> >>>> In the file http://www.mytempdir.com/1080206 I am supposed to
> >>>> fill cells on Sheet 4 (it is in Russian in the file) and
> >>>> "rectangles" on Sheet 1 are linked to cells in Sheet 4.
> >>>> Specifically, if I enter something in
> >>>> Sheet4 cell I21 it will go onto sheet 1, Rectangle 1188
> >>>
> >>> (next to cell
> >>>
> >>>> G27).
> >>>>
> >>>> This works in Excel, but not in Calc.
> >>>> What could be the reason and fix?
> >>>>
> >>>> Thanks a lot for any clues.
> >>>> WBR,
> >>>> K. Palagin.
> >>>
> >>> Hello.
> >>>
> >>> I can confirm that entering new data in I21 on the fourth
> >>> sheet does not result in the data appearing on the first sheet.
> >>
> >> It does if I use Excel.
> >>
> >>> I do not understand the process whereby it should. Perhaps
> >>> it would help if you explained the setup.
> >>
> >> I do not really understand setup myself. Otherwise I would
> >> describe the problem better.
> >>
> >> Thanks.
> >> WBR,
> >> K. Palagin.
> >>
> >> ----------------------------------------------------------------
> >>----- To unsubscribe, e-mail: [EMAIL PROTECTED]
> >> For additional commands, e-mail: [EMAIL PROTECTED]
> >
> > Check Tools - Cell Content - AutoCalculate.
> >
> > HTH
> >
> > sasa k.
> >
> > -----------------------------------------------------------------
> >---- To unsubscribe, e-mail: [EMAIL PROTECTED] For
> > additional commands, e-mail: [EMAIL PROTECTED]
>
> -------------------------------------------------------------------
>-- To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
