https://bugs.documentfoundation.org/show_bug.cgi?id=168991
--- Comment #2 from David <[email protected]> --- Mid-Air Collision Repost This issue can be replicated by creating a spreadsheet in LO version 8.XX that references about 10 cases of numeric data that starts about 20 rows down. (20 rows because the rows above in the real WB is filled with other calculations.) Enter 10 rows of data in a column e.g. "G" from row 20 to row 30. In row 19 enter =Subtotal(109,G20:g50) This cell formula function presents the sum of the data. Entering descriptors in columns A through F would allow filtering which works fine as well and only presents the correct sum of the data that is visible. Now Duplicate that page and delete all of the data, not the descriptors or the formula. Now duplicate that page 10 more times. Save the work book and enter data in page 2 (12 cases) and 3 (22 cases) and then the filter the data. The function still works with any data entered. This is a simple example that I have worked with for the past 5 years. Save the workbook again. Open the workbook in LO Flatpack 25.8 and enter data on pages 4 (12 cases) and page 5 (30 cases). The Subtotal function will only show the sum of the first two rows as an inspection will reveal the functions in the template sheets are modified from their original ranges. I have 10 years of data in multiple LO WBs and I hope there won't be other surprises with the functions used in those as they contain legal employment records that need to reflect accurate data for various government audits. In many businesses that hire to do their own private calculations, templates are used widely and without time to recreate wheels - changes in existing functions is problematic. I used AI to find some work-arounds for this months reporting, but after a final stable solution is identified, I will have to re-work those multiple workbook spreadsheets. Perhaps existing templates for various changing cases were not considered when this function was redesigned. Perhaps functions with major changes should have a different name. Thank you for your time! David -- You are receiving this mail because: You are the assignee for the bug.
