[discuss] Absolute reference in the functions: SUM() and Subtotal()

[Josias Almeida]

When we use the function sum() ou subtotal() associated with a range of cells and we try to shift part of the cells, the new range of cell in the function box doesn's change as it is supposed to happen.

See the spreadsheet below.

Example SUM.ods
Description: application/vnd.oasis.opendocument.spreadsheet

---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 0540-8, 07/10/2005
Tested on: 9/10/2005 22:54:57
avast! - copyright (c) 1988-2005 ALWIL Software.
http://www.avast.com




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]