Skip to content

General

52 results found

  1. Upgrade notice redirects to 404

    In v0.37.6.6, when it displays an update notice on top of Excel's titlebar, clicking the notice redirects to:
    https://www.formuladesk.com/404-2/

    However, «Settings : Check for updates» on the FormulaDesk ribbon goes correctly to:
    https://www.formuladesk.com/update/index.html?version=0.37.6.6

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Workbook Detective - Add warning for Excel 2016 QueryTable Bug

    Excel's formula filldown feature, which is used by Excel's QueryTable, has a serious flaw in Excel 2016 all newer versions (as of 2020-02-10). Symptoms include all or part of the header row of a QueryTable being copied into the body of the QueryTable, and formulas in adjacent columns (or inserted between columns of the QueryTable) being destroyed. The most common trigger is a query that returns less than two rows of data. Consequently, it would be nice to put a /!\ warning triangle /!\ in the Workbook Detective's list next to QueryTables that are less than two rows high, with…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Workbook Detective - Connection String and Command Text (SQL)

    Would be nice to get quick access to each connection's Connection String and Command Text (SQL)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Create a feature to show hidden named ranges in name manager

    Typically if you copy over the data from one excel file to another. Excel creates hidden named ranges, and this typically doesn't show in name manager unless you write a VBA code. If you use the Inspect document feature, it will tell you if you have hidden names in your file. It would be nice to have a button that would run this VBA code to unhide hidden named ranges, so then you can go to name manager and delete them. I used the below code from the website below to unhide hidden ranges and code is listed below site:

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Display just the result

    This is a really great formula debugger, but most of the time I just need to see the formula and the result simultaneously. When the Formula Explorer is open, it takes up a lot of room and I already see the formula in the built-in formula bar. It would be great if above or below the formula bar, there was just the result in a thin bar. Extra points if the text is selectable so I can copy/paste part of whatever I'm referencing. Thanks!

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Formulaexplorer External References

    The Formula explorer cant seem to resolve External References properly. I've tested it with an UDF and the input arguments are wrong when opening the Formula explorer but are working just fine in excel.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Advanced formula manager

    The management of formulas in Excel has long been unchanged. Perhaps the sentence described by reference will fit into the FormulaDesk concept.
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31326916-advanced-formula-manager

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. Option to disable shortcuts

    Include the shortcuts for subscript/supscript (CTRL+= and CTRL+?) in the "Disable keys" option menu since they may interfere with current shortcuts on non US keyboard layouts.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Copy Pivot Links

    Copy a range, row or column, and paste as linked cells to another location and be able to pivot, from row to columnar or vice versa, without losing the links. Cell references will remain the same.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. Being able to type in the math viewer

    It'd be really good if you could just type in it. I know you can type in that style but it's very hard to figure out how to do and it would be good if I could just click on a cell and start typing

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Establish the link between the precedents/dependents and the active cell

    When a precedent or dependent is selected from the treeview window, the active cell will move to the referenced cell accordingly.

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Add feature to be able to copy formulas as text, and paste as formulas

    Sometimes when you copy a formula from a cell from one excel file to another file, the excel formula adds the formula but also brings the location of the file in the formula. Its annoying the Microsoft has not fixed this issue yet. Any other solutions are welcomed..

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. Be able to add comments to parts of a formula

    It would be useful to be able to put comments on parts of a formula so that it would be easy to see at a quick glance what is happening.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Merge to Center Across Selection conversion

    Add a feature where all instances of 1-row-high clusters of merged cells can be unmerged and use the Center Across Selection alignment instead. The reverse case might be worthwhile as well.

    The advantage of Center Across Selection is that you can rearrange columns without worrying about the "merged cell" warning. You still need to redo the alignment, but this is still less work than unmerging and merging.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Custom QAT (Quick Access Toolbar) alternative

    An alternative to the built-in QAT, allowing more control over placement, width and spacing of buttons, different types of buttons (dropdowns etc), auto-expand when mouse hovers over it to display more detailed options but stay unobtrusive when mouse is not over.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Flowchart of formula composition

    Display a formula as a flowchart, with nested expressions and functions feeding into the next node until the result is displayed at the lowest level.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. add "completion indicator" in workbook detective

    in the workbook detective, when finding cells with: errors ... only the formula errors option displays "--- no cell found" upon completion if nothing is found.

    that same type of indicator would be nice for all the other error find options ... note that feedback is provided (no cell found) when finding all other choices besides that indicated above

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. default paste option

    A default paste option.

    ctrl+v = transpose / forumla / keep source formattong / etc.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Ability of Formula explorer to work with offsets

    Trace the precedent cell range given by an offset formula similar to the formula explorer of Spreadsheet studio

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Pivot Customizer

    I'm always changing my default pivot setup e.g. tabular layout, no totals, always sum, remove the words "sum of" etc. It should be available either in options or in the pivot design menu. I created short VBA's just to do all these by recording my steps.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3
  • Don't see your idea?

General

Categories

Feedback and Knowledge Base