Support formula syntax highlighting

XMLWordPrintable

    • Type: New Feature
    • Resolution: Done
    • Priority: Normal
    • 6.0.0
    • Affects Version/s: None
    • Component/s: Formula
    • Security Level: Jimmy
    • None
    • None

      User Story

      As an end-user, I want to use syntax highlighting to improve the readability of my formula.

      Acceptance Criteria

      1. Use different colors to differentiate texts, numbers, and cell references in a formula. (Each reference is assigned a different color in a palette of eight).
      2. After clicking the formula bar or double-clicking the cell, highlight the cells and ranges on the sheet referenced in the formula with the corresponding colors.
      3. When the caret is positioned on a parenthesis using either the mouse or keyboard (left and right arrow keys), highlight the corresponding parenthesis pair (note only if there is a matching pair).

      Details

      Put document or specification reference

            Assignee:
            rebeccalai
            Reporter:
            rebeccalai
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: