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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.7.0
    • 3.6.0
    • None
    • None

      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

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

              Created:
              Updated:
              Resolved: