https://bugs.freedesktop.org/show_bug.cgi?id=45372
Bug #: 45372
Summary: Provide a WALKUP() function
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: All
OS/Version: Linux (All)
Status: NEW
Severity: enhancement
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
I would like to propose a walkup function. The purpose of the function is to
walk up a column testing for a value that is displayed. When it finds a
displayed value, it returns the row.
Spreadsheets originally tried to mimic a ledger. A ledger uses a few
columns on the left that have identifying info like, a date, a description, and
a dollar amount of the purchase or expense. The columns to the right of those
normally indicate various logical accounts with the effect of the transaction
on that particular account. An entry is made in the transaction amount in the
first set of columns and then in the appropriate column, same row, showing how
much is added/subtracted from that particular account.
This leads to a very clean and easily understood array of cells that join a
particular credit/debit (the row) to a particular account (the column).
Since each entry in an accounts column is dependent on the last balance for
that account, anyone maintaining a spreadsheet has to constantly update the
cell references to ensure each transaction is properly posted using the last
previous balance of that particular account or column.
The function would have a single argument, the column to walk up. The row
would be assumed to be the row value of the cell calling the function. It
would walk up that column from the cell's row, subtracting 1 from the row each
time until it found the last value of the account from the last transaction.
It then would return that value. If an intervening row were inserted and a new
transaction affecting that account were put in that new row, the next
recalculate would deliver that new row value of that column.
In that way, the running value of that account is maintained, all the way
down the spreadsheet regardless of changes made above.
Enhancements for later might be to allow an argument using a different row
or column. But I think that is for later. I will provide more visuals upon
request. I am going to work on a simple sample spreadsheet demonstrating the
idea which I'll add as an attachment.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
