TomW-3 wrote: > > TerryJ wrote: >> >> >> Calc is behaving normally and appropriately. This requires a simple >> amendment of the formulas. The sheet references in the formulas should >> be >> absolute, not relative. > > I find this behavior illogical. Maybe it is my MS background with > Excel. I would expect that when I link a cell to another worksheet, > that the reference would be to that sheet and not to its tab position in > the workbook. Gnumeric works as Excel. The link references the > worksheet itself. I never purchased the trial version of Quattro Pro > that came with my Dell, so I can see what its behavior would be. > > I use Excel at work and only use OO at home for simple spreadsheets. But > I have been using this mailing list to see what others are having > problems with and what I would do to correct or explain the issue. > Hence my occasional replies. > > And, Calc does come in handy for correcting corrupt or malfunction Excel > workbooks: removing the bloat that builds up from repeated use. > > TomW > >
The Calc way is consistent. All elements of a cell's address can be relative or absolute: Sheet, Column and Row. I would not use M$ ****ware as a benchmark for anything. -- View this message in context: http://www.nabble.com/OO-Calc-2.04-Cell-linking-and-Copy-and-Paste-error-tf3432528.html#a9658319 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]