I just upgraded my libreoffice (v. 8. to 25.8) with my Linux Mint OS (20.3 to 22.1). I upgraded Libreoffice and my primary tests prior to the upgrade were related to base and calc working with full Mysql functioning. I never dreamed a new Subtotal function would be rolled out without any backwards compatibility for existing templates. I was looking forward to finally being able to support LO financially for my businesses, but now I need the funds to compensate the nightmare of changes for many calc books and sheets I will need to make for this function change. The new changes are completly useless to me, but how could you replace the function instead of creating a new function e.g Subtotal2. I don't have enough time to recreate all of my templates that relied on static ranges for reusable duplicated worksheets with work books that would be improved, cleaned and reset as templates for the next year. I have used these refined workbooks for my IRS Federal, State, and Local tax reporting for a decade. Additionally, our payroll workbooks are in the same situation. Now if I have an audit I will not only need to redo the current workbookS and worksheetS (many), but all of my past records as well. I was a member of this group years ago under the name of David2 and said it then, please stop copying everything Microsoft does. Quality spreadsheets for users should be the goal. How could you replace a function with such magnitude, that ranges are recreated via incorrect cell referencing and incorrectly adapting to smaller ranges with each correction. I am sorry, but it looks like you have let us down. I am sure there are others like me, but they don't know it yet, because it is not easy to see. These worksheet products contain confidential information and I cannot upload the older sheets for your AI to resolve this issue with a modified template. Perhaps you could redo a template for me, such as was shared in the past, but I have so much work entering old data into a new template, I am overwhelmed! Why would you change a function like that instead of create a new one? Thank you, David
(In reply to David from comment #0) > libreoffice (v. 8. please clarify. see https://wiki.documentfoundation.org/QA/BugReport#Good_reports > The new changes which are ? for reference : - https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUBTOTAL - https://wiki.documentfoundation.org/ReleaseNotes/25.8
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
AMD 64, Linux Mint 22.2
(In reply to David from comment #2) > LO version 8.XX none > was redesigned. ? please see comment #1 and attach a clear file sample if you want to reopen.