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

Excel numbers with commas pasted as text in ZSS

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2.6.0, 3.5.0
    • None
    • None
    • None

      If I have a number in a cell in an Excel sheet and format to use commas, then copy and paste it into a cell in on the demo site, it appears as it did in Excel. But, if I try to perform math on that cell, I get a #VALUE

      example:
      in Excel, enter the value 462345
      Then format as a number to use commas
      copy the cell
      paste in cell L15 in the demo sheet
      in cell L16 type =1+L15
      the answer will be #VALUE

      If we copy/paste values without commas, we do not see this behavior

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

              Created:
              Updated:
              Resolved: