- hfscyoAsked on October 21, 2013 at 09:00 AM
When exporting to Excel, is there a reason the green header row with the column headings has to extend to column IV?
Every time I have to delete all of the blank columns at the end because there are some things you cannot do in Excel because of that row, like insert a column, or if you try to print it.
- KadeJMAnswered on October 21, 2013 at 09:50 AM
I sort of get your issue but I don't quite understand it mostly because I checked the associated form but it seemed normal to me. So I think that I'm not quite sure that I'm understanding this issue that you are speaking of. What do you mean by " Don't make the Header extend all the way to Column IV? Can you please explain this more? I don't think that this should be happening but we need to better understand your problem as a suggestion first.
Is this happening on one of your forms? If so which one and can you please provide us with a link it and the associated excel file. This way we can see exactly what you are speaking of in regards to this problem and suggestion?
Also if you are able to provide us with screenshots that would be greatly appreciated as well. You can use something along the lines of Jing which is free to use incase you are unfamiliar with screencapture softwares. Then you may upload it here via Our Image Tool or you can use a third-party service such as Imgur and link it if you prefer.
- hfscyoAnswered on October 21, 2013 at 10:22 AM
This happens with all of my forms.
For example, one of my forms has 25 fields. When I export to Excel, it exports all 25 fields (columns A - Y) plus two additional columns it inserts for Paypal data (Payer Info and Payer Address). These are in columns Z and AA.
When I look at the spreadsheet, the top row with the column headings extends all the way to column IA. See the first screen shot - even though the last column with data is AA, the green bar extends through the rest of the columns, all the way out to IA. The second screen show shows what happens when you try to insert a column without deleting all of the empty columns from (in this case) AB through IA.
Even if my form had only 10 fields, it would still extend the header out to the end of the worksheet and I can't insert columns without deleting those empty columns every time.
- KadeJMAnswered on October 21, 2013 at 11:03 AM
Thank You for the Extra Information and Screenshots, It's very much appreciated and I see exactly what you mean now.
I take it you are using the " Export to Excel " feature inside your Submissions Control Panel where you view and edit them correct? Can you confirm that is how you were downloading and getting it?
What version of Excel are you viewing it in on your end and what OS are you on?
Can you please try clearing your form caches on your end to see if this makes any difference then redownload and view the Excel File again.
The first time I was unable to replicate the problem which is why I became confused so I apologize about that since I can see in your screenshots that something is clearly wrong.
Here's what I keep seeing after trying to attempt to replicate the issue that you were having. As you can see this occurs normally on my end but it's obvious this is not the case on yours. I tried this with a few of your form submissions exported into excel to test it further but same thing for me everytime even in openoffice as an alternative method.
- KadeJMAnswered on October 21, 2013 at 11:06 AM
Come to think of it in comparison it seems like you are using the same latest version of Excel 2013 as I am using. Sorry about my mixup with that. Please allow me a little more time to look into this issue some more to try to get to the bottom of it. I will get back to you about it as soon as I know something more.
- hfscyoAnswered on October 21, 2013 at 11:12 AM
I am using the Download As button when viewing the Submissions.
I am using Excel 2013, but it did this when I used Excel 2010 on a different - it has always done this for me when downloading to Excel, across multiple computers, so I don't think it is a browser cache issue.
It's not a "problem", it is just an annoyance and I thought I would ask why it was like that and if it could be changed. Thanks!
- KadeJMAnswered on October 21, 2013 at 12:10 PM
Actually nevermind, I found the spacing so I apologize about that. I made a mistake and realized that in your screenshot you've scrolled really far to the right where I did not do that beforehand. I can now see the same issue that you've mentioned on my end also.
To my knowledge as far as I know it was programmed to read this way by " Default " so yes that it is not an actual issue, bug, or problem. I think this was intentional just in case some form owners whom might have created very long forms which is often the case possibly needed more space.
On the other hand though taking your point of view into consideration for this I can see what you mean by where this would become annoying and slightly confusing.
If you want I would be more then happy to request a feature on your behalf for our development team to consider which would control this more so that you can add or remove any unnecessary space when Exporting. It's not a guarantee though since it is possible to remove much of the space within the program itself if not needed and there are various other alternatives to this that show only close to the Rows and Columns you need and are actually using such as exporting it via a Grid Listing instead. So it is purely your decision as you have the right to request it if you would prefer it so just let us know.
Here's an example with most the rows full where it extends close to " Column IV " which is Our Default:
Excel Program's Normal Default is the Following of A - Z:
- hfscyoAnswered on October 21, 2013 at 03:51 PM
Most software that I have used that exports to Excel simply exports the number of columns necessary. If there are 25 fields, it should export 25 columns. I don't see the point of the extra empty columns in the header row.
In addition to the inability to insert columns without deleting those extra columns, if I just try to print the spreadsheet I get numerous extra pages.
For example, one of my forms has 200 submissions and 27 columns of data. If I just load it into Excel and print it in landscape orientation, I get 55 pages of data and 96 blank pages due to the empty column headings! Every time I export I have to delete those columns. They serve no function.
So it is my view that having those empty columns reduces the functionality of your Excel export.
So if you could, I would like to put in a suggestion that it not do that.
- KadeJMAnswered on October 21, 2013 at 05:27 PM
I do understand what you mean by this and I think that you have a valid point about it. So yeah, it's no trouble at all and I will gladly pass along your request to our Development Team. I won't be able to provide any estimated timeframe since it is up to them to prioritize and consider new features and improvements. But should this become implemented then we will certainly update you about it here as soon as we know something though you are more then welcome to check up on it after awhile if you like.