Uploaded image for project: 'Content Translation Support'
  1. Content Translation Support
  2. MGNLCTS-29

XLS integration: handling the numbers

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Neutral Neutral
    • 1.1.4
    • None
    • None
    • 4.5.13

      Excel wraps any numeric values into a non-string cells by default. Importing such content fails then on the exception attached so one needs to encode all these cells with a single quote beforehand, in fact they become strings.

      Similarly if you have a property of just a numeric value that is a subject of export, Excel is not able to read it properly at the moment, unless it's converted to a string cell.

      The module can easily be more content editors friendly. Alternative XLS editors, like LibreOffice, used to be able to cope with it as they cast to string implicitly.

        Acceptance criteria

              chunhua.liu Chunhua Liu
              zdenekskodik Zdenek Skodik
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Task DoD