Title/Subject: Calc: Improve Function Argument Hints for SUBTOTAL/AGGREGATE (Missing Function Index Dropdown)
1. Problem Description:
When typing the SUBTOTAL or AGGREGATE function in the Formula Bar of LibreOffice Calc, the user is required to manually input the Function Index number (e.g., 9 for SUM, 109 for hidden rows). Unlike Microsoft Excel (which uses IntelliSense), Calc does not provide a dynamic dropdown list or a function hint that shows the corresponding function name (e.g., AVERAGE, COUNT, SUM, MAX) next to its index number when the user types the opening parenthesis (().
2. Impact:
This issue significantly hinders the workflow of users who frequently use these functions, such as accountants and data analysts. Users are currently forced to memorize or constantly look up the index numbers (1-11 and 101-111), making the formula entry process slow and error-prone.
3. Desired Enhancement (How Excel works):
The requested enhancement is to implement an interactive Function Argument Hint/Dropdown (similar to Excel’s IntelliSense feature). This dropdown should appear immediately after typing SUBTOTAL( and list all the Function Index numbers (1-11 and 101-111) along with their respective function names (e.g., 9 = SUM, 109 = SUM(Ignore Hidden)).
4. Environment Details (Example):
- Operating System: Windows 11
- LibreOffice Version: 25.8.3
- Component: Calc
Thank you for considering this quality-of-life enhancement for professional users.