Description: When a focused cell contains a FREQUENCY() result the function wizard toolbar button [fw] does not activate the wizard's pane to display the function's stages. Note: I only discovered this because the construction of a frequency table -assisted- by the function wizard automatically creates an "over/underflow" element beyond the defined range so I utilised [fw] to investigate the -lack of- contents. Steps to Reproduce: Demo sheet attached Focus any cell in column D containing data and utilise the [fw] key to visualise the formula and interim results. D17 is created automatically by the function wizard's assisted creation of the frequency enquiry C2:D16. Sorting Column A with the autofilter has no effect. Autofilter top ten selection and deselecting some of the numbers - which are in the same row range as the frequency array - also impact both the array and the chart. I guess this is computer logical as the FREQUENCY()rows are hidden but probably not quite user-centric. Actual Results: No display of the function's interim steps or results Expected Results: As the function of the [fw] button is to display interim steps and results to aid error analysis then the anticipation was something, anything - not a complete lack of response. Is there interim or final data to demonstrate? Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Version: 7.0.6.2 (x64) Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Created attachment 172430 [details] Simple Exmple CALC
When you when to edit an array formula you need to select the whole range of the array. [Ctrl /] Please take a look at the help https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html?DbPAR=CALC#bm_id3147273
(In reply to m.a.riosv from comment #2) > When you when to edit an array formula you need to select the whole range of > the array. [Ctrl /] > > Please take a look at the help > https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107. > html?DbPAR=CALC#bm_id3147273 But I didn't want to edit the formula - I just wanted to see how CALC arrived at the result. eg. in a simple formula A2 contains 10 A3 contains 5 A4 =A2*A3 produces 50 AND The [fw] button, when focused on A4, will display the contents of cells A2 & A3 and the nested actions together with the final result . A trace. This doesn't happen with the array processing - the [fw] button has no functionality. None of the array function help definitions identify that [fw] is inactive for array processing. Is it more of an inconsistency in the [fw] processing than a bug?