This spreadsheet does use macros and visual basic. Calc uses a different basic, which while similar is not compatable in a number of regards.

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]

Reply via email to