Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-853

A cell applied with text format is still evaluated as a formula

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.6.0
    • Fix Version/s: 3.7.0
    • Component/s: None
    • Labels:
      None

      Description

      Problem Description

      Users cannot enter a text starting with equal symbol, '=', because it is always evaluated as a formula.

      Steps to Reproduce

      1. right click A1, select format cell, set it to "text"
      2. enter =abc at A1

      Actual Result

      A1 is evaluated to #NAME

      Expected Result

      A1 is still =abc in Excel 2007.

      Workaround

      Enter a space character before '='.

      Excel's Solution

      • enter '= and it display just =
      • set the cell's format as Text

        Attachments

          Activity

            People

            • Assignee:
              henrichen henrichen
              Reporter:
              hawk hawk
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: