https://bugs.documentfoundation.org/show_bug.cgi?id=168991
Bug ID: 168991
Summary: New Subtotal Function not Backwards Compatible
Product: LibreOffice
Version: 25.8.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
