Feedback by UserVoice

David Tetard

My feedback

  1. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    David Tetard commented  · 

    To reproduce, try to enter that formula in a cell of coordinated B2 of standard width where all coordinated are entered by clicking on their cells:
    =ln(C8+C7+C6+C5+C4+C2)

    You won't be able to enter C2 by clicking on that cell (the caret will go in the formula, not insert the cell's coordinates), you will have to manually edit the formula.

    David Tetard shared this idea  · 
  2. 19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    David Tetard commented  · 

    If I enter this formula:

    = ln(B6+B7)
    whith B6 and B7 having been entered automatically by clicking on the corresponding cell, but if I want:
    = ln(B6+$B$7) ,
    I have to manually edit the formula.

    What would be nice is for the B7 to be inserted if I click on the cell without the Ctrl key and $B$7 to be inserted if I click on the cell while the Ctrl key is pressed. You could also imagine the Shift key inserting $B7 and the Alt key inserting B$7, this way all combinations are covered.

    David Tetard supported this idea  · 

Feedback and Knowledge Base