Border on merged cells disappears when downloading as Excel from Google Sheets

1
votes

I've created a spreadsheet in Google Spreadsheet. The spreadsheet contains merged cells and I've placed a border around the merged cells.

When I choose download to Excel and open it in Excel it looses the border for all the merged cells except the first cell in the merged range.

Is there a solution to be found or a bug? If I select to download as ods format it keeps the border around the merged cells but loose background fill instead..

/Magnus

1
google-sheetsexport-to-excelcell-formatting

1 Answers

1
votes

I almost put a huge bounty on this question, but I figured it out (worked for me at least).

  1. Select all the cells in the Google spreadsheet (ctrl + A)
  2. Clear formatting: Format > Clear formatting