On Wednesday 27 April 2005 16:47, [EMAIL PROTECTED] wrote:
> A oo user forward me an excel doc that have behavior that i can't
> understand:
> - using excel : the first change in any cell after opening the doc is make
> in all sheet. Next change will not affect other sheet.
> - using calc : any change at any time will affect all the sheet in the doc.
> If i create a new sheet in the doc the next change wont affect other sheet.
> may be there is an option that i don't know
> no macro,.doc have multiple sheet witch contains a number table that sum
> rows and sum cols.(test with oo_1979 & oo 1996)
>
> Any help will be appreciated. I'm sorry for the approximate english.
> Gilles.
It sounds as if all of the sheets are selected. Look at the bottom of your
spreadsheet window (normally "Sheet1" "Sheet2" "Sheet3"). Click on only one
of the names to input data in only one sheet. To input data in multiple
sheets, use Control and the left mouse button to select additional sheets.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
