String instead of number

  • Resolved wozdareden56

    (@wozdareden56)


    5 years, 4 months ago

    INFOS :
    php 7.2.23
    WordPress 5.2.4
    Gravity Forms 2.4.14
    Gravity PDF 5.1.5
    Gravity Forms Advanced Post Creation Add-On 1.0-beta-3
    Gravity Forms Survey Add-On 3.4
    Entries in Excel : 1.7.0

    Hello Doeke,
    I have a survey in one of my gravity forms.
    Users have to answer for each question whether they completely agree/completely disagree. From 1 to 5.
    When I download the .xls file, I have the columns with all these numbers. Thats’ fine. Except that they are not interpreted as number but string. In the cell bar of the .xls document (upper left), there is an apostrophe before each number even if it doesn’t appear in the table (numbers are left-aligned, just like strings, instead of being right-aligned). Even if I change format from General to Number, it doesn’t work (bloody apostrophe).
    Which means that I cannot manipulate them as numbers with formulas.

    Is there a way to solve this problem? To delete that apostrophe.
    I don’t know if I am clear. Maybe it has to do Gravity Forms Survey Add-On first.

    Thank you very much for your plugin and your time.

    Florent

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘String instead of number’ is closed to new replies.