Bug 120457 - Support subtotal drop-down formula menu in Calc
Summary: Support subtotal drop-down formula menu in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: https://contexturesblog.com/archives/...
Keywords: filter:xlsx, needsDevAdvice
Depends on:
Blocks: Function-Subtotal
  Show dependency treegraph
Reported: 2018-10-09 13:47 UTC by Daniel
Modified: 2022-02-05 19:08 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Sample Template Invoice Screenshot (113.92 KB, image/png)
2018-10-09 13:49 UTC, Daniel
Service Invoice (109.15 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-10-09 13:50 UTC, Daniel
Another Screenshot (107.34 KB, image/png)
2018-10-09 13:53 UTC, Daniel

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel 2018-10-09 13:47:40 UTC
Just pick-up some template like "service invoice" originally from Excel app. And save it and open in Calc just little mess design color table

Actual Results:
It should show all content correctly, including table design and drop-down formula menu.

Expected Results:
Drop-down formula menu doesn't support and table design color incorrect in Calc

Reproducible: Always

User Profile Reset: No

Additional Info:
I hope this will fixed in next version.
Comment 1 Daniel 2018-10-09 13:49:26 UTC
Created attachment 145523 [details]
Sample Template Invoice Screenshot
Comment 2 Daniel 2018-10-09 13:50:20 UTC
Created attachment 145524 [details]
Service Invoice
Comment 3 Daniel 2018-10-09 13:53:46 UTC
Created attachment 145525 [details]
Another Screenshot
Comment 4 Timur 2018-10-09 16:29:26 UTC
Bugzilla is "issue based", so a single issue must be pointed at, after a search for not being a duplicate. Bugzilla is not "document based", like "this document doesn't display nice". Those are 2 issues. 

"Table design" request is a dupe of Bug 112371. 

As for "Drop-down formula menu", that seems to be Excel subtotal drop down list of functions. This bug could be converted to that request, should it be confirmed.
Comment 5 Timur 2018-10-15 10:34:19 UTC
Per previous comment, this bug is about "subtotal drop down list of functions".
It's obvious Calc doesn't have it but whether this bug should be confirmed depends on a decision.
I'm not sure if this is more NeedsUXEval or NeedsDevAdvice.
Comment 6 Heiko Tietze 2018-10-15 12:34:51 UTC
We do have subtotal() but not with a fancy menu (or any good support). https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633

I suggest to create a new ticket as the style aspect is discussed in the other bug. The solution could be a menu entry (resp. UNO command) that pops-up the dropdown and asks after click for the range if none has been defined before.
Comment 7 Timur 2018-10-16 08:21:02 UTC
I didn't understand why a new ticket. I'll confirm per previous comment as enhancement.