Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow dynamic cell row reference in table formula #1462

Closed
stevencohn opened this issue Jul 10, 2024 · 0 comments · Fixed by #1463
Closed

Allow dynamic cell row reference in table formula #1462

stevencohn opened this issue Jul 10, 2024 · 0 comments · Fixed by #1463
Assignees
Labels
feature-request New feature or request released Available in a released installer

Comments

@stevencohn
Copy link
Owner

New Feature/Solution

Suggestion from a user... Allow a special symbol or syntax to designate the bottom of a table, allowing for the dynamic expansion of the table without having to update the last cell reference in the formula.

Alternative Solutions

Update the formula whenever a row is inserted or deleted from the table above the formula cell.

Additional Context

This will be implemented as an allowed offset in the cell reference. For example

A1:A-1

will be interpreted as all cells in the A column from row 1 down through -1 rows from the cell containing the formula. The offset can be greater than 1 but must still reference a cell after the starting cell.

@stevencohn stevencohn added feature-request New feature or request next-release Addressed but not yet released labels Jul 10, 2024
@stevencohn stevencohn self-assigned this Jul 10, 2024
@stevencohn stevencohn linked a pull request Jul 10, 2024 that will close this issue
@stevencohn stevencohn added released Available in a released installer and removed next-release Addressed but not yet released labels Jul 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature-request New feature or request released Available in a released installer
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant