#StackBounty: #microsoft-excel #google-drive #google-spreadsheets When a Google Sheet is exported to Excel the line heights of wrapped …

Bounty: 50

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

screenshot from google sheets showing wrapped text

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.

screen from excel showing wrapped text

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


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!

#StackBounty: #windows-10 #google-drive #google-drive-file-stream Can't double-click to open Google Sheet document (Windows with Fi…

Bounty: 400

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-clicking on the document and choosing “Open with Google Drive File Stream”.

screen capture

If I right-click and choose “Open with…” I get this; I’ve already checked “Always use this app to open .gsheet files.”

screen capture

The entry in “Choose default apps by file type” is correct:

enter image description here

Is this something specific to my setup, or is this a change that affects all users?


Get this bounty!!!