Formula wizard

Posted by: tovarnakm on 25 July 2022, 1:02 am EST

  • Posted 25 July 2022, 1:02 am EST - Updated 3 October 2022, 12:10 am EST

    Hi,

    I would like to ask if there is any way to hide formula wizard (like Google sheets has), because it is large and in the way. It is not possible to reference cells behind formula wizard. And when I tried

    spread.options. enableFormulaTextbox = false
    then I am not able to reference any cell. If I try to reference some cell, the calculation ends.

    Thank you for your help!

  • Posted 25 July 2022, 4:29 pm EST

    Hi Martin,

    You can hide the formula popup by adding the following css:

    .gcsj-func-ac-popup {
       display: none !important;
    }
    
    .gcsj-func-help-popup {
       display: none !important;
    }
    

    Sample: https://jscodemine.grapecity.com/share/J3KK6cjSxU_jzNzhCuHuiA/

    In the sample, the css is applied in the index.html file.

    Regards

    Ankit

  • Posted 25 July 2022, 4:29 pm EST - Updated 3 October 2022, 12:10 am EST

  • Posted 26 July 2022, 4:21 am EST

    Thank you for your answer.

    Now I’m wondering if it is somehow possible to toggle between hidden and opened popup. The ways I was thinking about:

    1. Have a custom cell type with some clickable content (but I don‘t think it is good idea, because I need to convert every cell then to custom cell). And if I will have some other custom cell it may cause problems because of combination of them.
    2. Have a toggle button in “toolbar” (out of the canvas). But when I‘m clicking outside of the canvas the formula calculation ends.

    Are there any other ways to handle the toggle so that we can refer to the cells behind popup while typing the formula?

  • Posted 27 July 2022, 4:27 am EST - Updated 3 October 2022, 12:10 am EST

    Hi Martin,

    Clicking outside the canvas will end the formula. This is the expected behavior. For selecting the area under the formula popup, you can use either of the following options:

    1. Use Arrow Keys to select the cells(Preferred Option).

    1. Override the activateEditor method, check if the formula popup or formula help popup is available, adjust the position by some pixels.

    Sample: https://jscodemine.grapecity.com/share/F_xGx2mS7k2a_ne3dEsRdw/

    In the sample, I have adjusted the top and left to be “20px” and “30px”. You can handle the corner cases and set the position respectively.

    activateEditor method: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellTypes.Base~activateEditor.html

    I hope this will resolve your issue. Please let us know if you need further assistance with this query. We would be happy to help you.

    Regards

    Ankit

  • Posted 27 July 2022, 7:47 pm EST

    Hi,

    I try to come up with solution to be user friendly based on customer requirements:

    • “Use Arrow Keys to select the cells(Preferred Option).” - I am not sure that users will figure it out by themselves (without some helper) that there are this option. Popup (helper) does not include any information about this smart workaround using arrow down/up.

    • “Override the activateEditor method, check if the formula popup or formula help popup is available, adjust the position by some pixels.” - This suggestion does not help us to solve the problem, because popup is just positioned on another place. User is not able to reference cells directly behind popup.

    Thank you!

  • Posted 27 July 2022, 7:54 pm EST - Updated 3 October 2022, 12:10 am EST

    Hi Martin,

    Users can use the arrow keys to select the range(s) behind the formula popup. This is the easiest and best possible solution.

    In Microsoft Excel also, you need to use the arrow keys to navigate to the cells behind the formula popup.

    Regards

    Ankit

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels