1
0
Ive got an issue when exporting an Excel file form a Google Drive Sheet.
If i have a large amount of text / data in a cell in Google Sheets i use the wrap text feature so that all the text is displayed. The wrap text feature auto scales the line height of the row the cell is on, i order to accommodate the wrapped text.
See image below
If i export this Google Sheet as an Excel file, By going to File > Download As > Microsoft Excel (.xlsx)
, and open in Excel for OSX v. 16.25 , the wrapped text looks like this (See image below) Note how wrapped text in Excel respects the line height of the row and dose not expand the cell.
Ive noticed that if i set the line height in Google Sheets manually then export to Excel the line heights behave as expected.
Is there any way to change this so if someone receives an Excel file exported from Google Sheets they dont miss data in cells with text wrapping enabled ?
Ive shared a copy of the google sheet here, in case you would like to test (Please make a copy of this file if you would like to test with it.) https://docs.google.com/spreadsheets/d/1rLj0065fvlXC1mNPlO73_U9-KZ2gSHcX2tBdB18gBFI/edit#gid=1854366327
How are you exporting and to which format (CSV etc.)? – harrymc – 2019-06-04T19:13:10.527
@harrymc question updated to include the export method and format – sam – 2019-06-05T10:39:40.840
If the format of the Google Sheets exported to Excel is not suitable, maybe instead of giving out a Google Sheet URL, you could hand out an Excel spreadsheet containing VBA code to read this Google Sheet into itself with wrapped text, maybe even prompting the user for the URL. Would such a solution solve your problem? – harrymc – 2019-06-06T06:27:39.650
@harrymc i dont think it would, the plan is for lots of non technical users to use this document, and using VBA would over complicate it. I have had some success with setting the line height in Google sheets to "auto" which in certain circumstances rectifies the problem – sam – 2019-06-06T09:49:15.367
Then you already have the only solution which satisfies your criteria. So what do you expect of us? – harrymc – 2019-06-06T09:58:12.327
@harrymc See my comment "I have had some success", this only worked in limited situations, and was not fool proof. Re. "What do you expect of us" i dont "expect" anything. SO is a Q&A community, i had a question, perhaps someone else had a similar problem and had overcome it, and could answer it. – sam – 2019-06-06T10:30:29.613
I don't see any solution except to use VBA, which is invisible to the users, but problematic for the developer (meaning you), requiring some knowledge. I don't think Google Sheets API can help here. – harrymc – 2019-06-06T19:21:35.210