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]