Hylton Conacher(ZR1HPC) 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 do not understand the difference between a relative and an absolute
> formula. Can you give an example of a relative formula and then the same
> formula in absolute syntax?
>
> Please indicate where on the spreadsheet there are relative formulae and
> what the syntax would be to correct them to absolute formulae.
>
> Tnx
> Hylton
>
>
This is the example you gave:
- - - - - quote - - - - -
The formula for E3 as per the master is =SUM((Totals.B5-D2))/(31-0) yet the
formula in E3 in April Month is =SUM(('Monthly usage'.B5-D2))/(31-0)
- - - end quote - - -
What you need to do is insert a $ before the sheet name so that the above
formula reads:
=SUM(($Totals.B5-D2))/(31-0) . If you do that, the sheet name will not
change when you copy the formula to another sheet.
You can change references to various shades of absolute and relative with a
keyboard shortcut (by default SHIFT+F4, not now working on my system for
some unknown reason). Look in the Help index under "absolute addresses in
spreadsheets".
--
View this message in context:
http://www.nabble.com/OO-Calc-2.04-Cell-linking-and-Copy-and-Paste-error-tf3432528.html#a9671701
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
