Alpha Video Training
Results 1 to 5 of 5

Thread: Export to excel adding extra columns

  1. #1
    Member
    Real Name
    John Berry
    Join Date
    Nov 2007
    Location
    Maryland, USA
    Posts
    626

    Default Export to excel adding extra columns

    Hello again,

    I'm following Selwyn's video for advanced Excel export. I create a simple test report, convert it to layout and then from the grid I have a button that uses the advanced Excel export. When the spreadsheet opens there is a blank column between every cell.

    Here is how it looks in design view:

    Excel1a.jpg


    Here it is if I print it to the screen:

    Excel1.jpg

    and here it is when exported to Excel

    Excel2.jpg

    Does anybody know why there are blank columns? It happens even if I try to export to Excel from the preview screen.

    Thanks.

    -John

  2. #2
    "Certified" Alphaholic Lance Gurd's Avatar
    Real Name
    Lance Gurd
    Join Date
    Jun 2005
    Location
    Southampton, UK
    Posts
    1,419

    Default Re: Export to excel adding extra columns

    Just used an existing list, an existing report and added a button to export to excel and it worked with no blank columns.

    The thing that stops me using this feature is the apparent lack of conditional formatting and word wrapping of cells available.

    With fear of getting this post wiped, just tried the same in Filemaker and got a similar result to Alpha, although I did not have to add the buttons for excel or pdf they were already there in preview mode.

  3. #3
    Member
    Real Name
    John Berry
    Join Date
    Nov 2007
    Location
    Maryland, USA
    Posts
    626

    Default Re: Export to excel adding extra columns

    It appears that it is adding columns if you start the report initially as a freeform report, save it, then convert it to a layout. On both my home PC and my work PC it adds the blank columns. If I create the report directly as a layout report then it works. Would somebody be kind enough to just double-check that for me on your PC.

    I just had a simple test table with some random numbers, IE:

    ID, Males, Females

    Created a Freeform report (in projects) [ID][MALES][FEMALES] (no spaces) and then converted it to Layout. From a button on a grid I used Advanced Export, nothing fancy, and I always get blank columns.

    Then I created a Layout report {ID}{MALES}{FEMALES} and From a button on a grid I used Advanced Export, nothing fancy, and it shows in Excel with no blank columns.

    Thanks

    -John

  4. #4
    "Certified" Alphaholic Lance Gurd's Avatar
    Real Name
    Lance Gurd
    Join Date
    Jun 2005
    Location
    Southampton, UK
    Posts
    1,419

    Default Re: Export to excel adding extra columns

    Hi John,

    I tested this and do get the same as you are seeing, but I believe it is part of the conversion from a freeform report to a layout table report.

    It seems no matter how close together your fields are in your freeform report (even overlapping which throws up a warning) once it is converted to a layout table report there is a column inserted between them in the layout. You can select and delete these columns in your layout, but be careful because some cells can be merged to make the layout table look as close to the freeform layout as possible, best to have visible gaps between your fields in your original freeform report, and then when exporting to excel you do not get the rogue columns appearing.

  5. #5
    Member
    Real Name
    John Berry
    Join Date
    Nov 2007
    Location
    Maryland, USA
    Posts
    626

    Default Re: Export to excel adding extra columns

    Hi Lance,

    Thanks again. At least I now know I'm not imagining it. Funny enough, I didn't even notice those rogue columns, now you pointed them out, it seems so obvious.

    -John

Similar Threads

  1. Customize columns in export to Excel
    By YigalAyalon in forum Mobile & Browser Applications
    Replies: 3
    Last Post: 06-11-2017, 07:48 AM
  2. Choose grid component columns for excel export
    By jwilliamson in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 09-14-2015, 02:47 PM
  3. Export with collapsing columns and rows to Excel
    By nahuelg in forum Application Server Version 11 - Web/Browser Applications
    Replies: 4
    Last Post: 01-12-2012, 03:29 PM
  4. export excel autofix rows columns
    By rlgiordano in forum Alpha Five Version 10 - Desktop Applications
    Replies: 1
    Last Post: 01-31-2011, 07:12 PM
  5. Replies: 3
    Last Post: 09-01-2010, 07:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •