Is there a way to change maximum cell width?

  • Resolved websherpa

    (@websherpa)


    5 years, 5 months ago

    I am using the link to export for another person who has limited experience using Excel. Some of our fields contain a LOT of text, and the GFEIE export file will widen fields that I would normally leave in a default width state.

    Is there a way to change the maximum cell width for a particular {Form ID} (or even better for setting widths for particular {Form ID}_{Field ID}’s)?

    [I do understand a delay in answering given your family’s recent addition!]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Doeke Norg

    (@doekenorg)

    Ah, on this one I have disappoint you. Every cell will automatically stretch to the maximum with needed. I’ve had more complaints about it being the default width, then it being the full with needed. It’s the targeting of this column thats a bit tricky to do; but I’ll put it on the feature list for now. You can see active open issues on the github repostiory. I’ll close this issue, and re-open it as a feature on the github repo. That’s kind of my todo list ??

    Plugin Author Doeke Norg

    (@doekenorg)

    https://github.com/doekenorg/gf-entries-in-excel/issues/47

    Thread Starter websherpa

    (@websherpa)

    Oddly enough on the Mac Excel it seems to add even MORE space than simply the longest width. I did a quick check through the base plugin code and couldn’t find the code lines that determines if it’s full or default so that I could temporarily fork the plugin for my own purpose… ??

    Plugin Author Doeke Norg

    (@doekenorg)

    You can open src/Renderer/AbstractPHPExcelRenderer.php and comment out line 100. Should do the trick.

    Thread Starter websherpa

    (@websherpa)

    You ARE the best! Thank you!

    I REALLY should take the time to fully learn PHP and coding one day, but I have been only “hacking” (as we called programming by the seat of your pants many decades ago) my way through object oriented coding since the late 70’s… jack of all trades, master of none.

    Thank you again!

    Thread Starter websherpa

    (@websherpa)

    (The strangest thing… this works just fine with one Form, but then doesn’t work with a different Form. I can’t figure out why that would be.)

    Plugin Author Doeke Norg

    (@doekenorg)

    Wait. Different question. Haha. Hmm not sure why this would happen. It should work for every form, unless the result is cached by a plugin.

    • This reply was modified 5 years, 5 months ago by Doeke Norg.
    Thread Starter websherpa

    (@websherpa)

    (Oddly I think you answered my other thread re Form ID hooks… lol).

    It’s too much to debug this unless there’s an obvious reason. I am pretty certain that all of the code in my plugins and custom code is applied the same for both of these Forms (at least they should be, they are very similar).

    If you do have time and like a mystery, then maybe I can set up access to the site directly (and donate).

    I was just hoping it might be something obvious, but I’ll give it a pluginless try tomorrow.

    Plugin Author Doeke Norg

    (@doekenorg)

    Sure. Email me the needed info on [email protected]. I’ll take a quick look.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Is there a way to change maximum cell width?’ is closed to new replies.