[go: nahoru, domu]
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.

Sign up for GitHub

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

Jump to bottom

Modify Worksheet#rows to enable returning numeric rows #377

Open
wants to merge 1 commit into
base: master
Choose a base branch
from
Open

Modify Worksheet#rows to enable returning numeric rows #377

wants to merge 1 commit into from

Conversation

Drowze
Copy link
@Drowze Drowze commented Jul 19, 2020 •
edited
Loading

concept for #378

Given the test spreadsheet: link ("Transactions" worksheet)

(unmodified) #rows will return:

[["", "", "", "", "", "", ""],
 ["", "Category Transfers", "", "", "Select a Category to view funding details", "Monthly Amount", ""],
 ["", "", "", "", "Dining Out", "€200.00", ""],
 ["", "Available to budget", "", "DOL", "To meet your monthly target for this category, budget another", "", ""],
 ["", "€11,505.00", "", "DOL", "€200.00", "", ""],
 ["", "", "", "", "", "", ""],
 ["", "DATE", "AMOUNT", "FROM CATEGORY", "TO CATEGORY", "MEMO", "✱"],
 ["", "29/5/20", "€375.00", "Available to budget", "Groceries", "Monthly target", ""],
 ["", "29/5/20", "€120.00", "Available to budget", "Electric Bill", "Monthly target", ""]]

#rows_with_numerics should return:

[["", "", "", "", "", "", ""],
 ["", "Category Transfers", "", "", "Select a Category to view funding details", "Monthly Amount", ""],
 ["", "", "", "", "Dining Out", 200.0, ""],
 ["", "Available to budget", "", "DOL", "To meet your monthly target for this category, budget another", "", ""],
 ["", 11505.0, "", "DOL", 200.0, "", ""],
 ["", "", "", "", "", "", ""],
 ["", "DATE", "AMOUNT", "FROM CATEGORY", "TO CATEGORY", "MEMO", "✱"],
 ["", 43980.0, 375.0, "Available to budget", "Groceries", "Monthly target", ""],
 ["", 43980.0, 120.0, "Available to budget", "Electric Bill", "Monthly target", ""]]

and #rows_with_inputs should return:

[["", "", "", "", "", "", ""],
 ["", "Category Transfers", "", "", "Select a Category to view funding details", "Monthly Amount", ""],
 ["", "", "", "", "Dining Out", "=IF(Calculations!B6 <= 0, \"N/A\", Calculations!B6)", ""],
 ["",
  "Available to budget",
  "",
  "DOL",
  "=\nIF(F3 = \"N/A\", \"This category does not have a Monthly Amount set\",\nIF(SUMIF(UserDefCategories, E3, UserDefGoals) > 0, \n\nIF(Calculations!C9 > 0, \"To complete your goal for this category, budget another\", \"You've completed your goal for this category\"), \nIF(Calculations!C8 > 0, \"To meet your monthly target for this category, budget another\", \"You've met your target this month\")))",
  "",
  "=IF(F3 = \"N/A\", BackendData!AO6, IF(SUMIF(UserDefCategories, E3, UserDefGoals) > 0, IF(Calculations!C9 <= 0, BackendData!AO3, BackendData!AO5), IF(Calculations!C8 <= 0, BackendData!AO3, BackendData!AO4)))"],
 ["",
  "=ROUND(Calculations!Q2, 3)",
  "",
  "DOL",
  "=\nIF(F3 = \"N/A\", \"N/A\",\nIF(SUMIF(UserDefCategories, E3, UserDefGoals) > 0, \n\nIF(Calculations!C9 > 0, Calculations!C9, \"No additional funds necessary\"), \nIF(Calculations!C8 > 0, Calculations!C8, \"No additional funds necessary\")))",
  "",
  ""],
 ["", "", "", "", "", "", ""],
 ["", "DATE", "AMOUNT", "FROM CATEGORY", "TO CATEGORY", "MEMO", "✱"],
 ["", "43980", "375", "Available to budget", "Groceries", "Monthly target", ""],
 ["", "43980", "120", "Available to budget", "Electric Bill", "Monthly target", ""]]

@Drowze Drowze mentioned this pull request Jul 20, 2020
Open
@Drowze Drowze force-pushed the return-numeric-rows branch 2 times, most recently from 3cd41ea to 0d7a653 Compare July 21, 2020 22:15
@Drowze
Modify Worksheet#rows accept a block
2c05551 
Add Worksheet#rows_with_numerics and #rows_with_inputs
@Drowze Drowze mentioned this pull request Jul 23, 2020
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
1 participant
@Drowze