xlsx file has hidden rows

[cxbrooks]

I'm not sure if this is a macOS problem, but recently editcp started exporting .xslx files that have hidden rows.

I'm using editcp 1.0.23, which I built today. Before building, I removed

~/go/src/github.com/dalefarnsworth-dmr
~/go/src/github.com/google/gousb/
~/go/src/github.com/tealeg/xlsx/

and reinstalled them with

$ go get -d github.com/dalefarnsworth-dmr/editcp/...
$ go get github.com/google/gousb
$ go get github.com/tealeg/xlsx

I built and ran with:

~/go/src/github.com/dalefarnsworth-dmr/editcp/
qtdeploy build desktop
./deploy/darwin/editcp.app/Contents/MacOS/editcp

1. Connect my UV-390
2. Radio -> Read codeplug from radio
3. Confirm that my channels are there
4. File -> Export -> Export to spreadsheet
5. Open the file in macOS Excel

Here's the file
codeplug1.xlsx

Notice that the rows of Basic Information start at 3:

I'm not way up on Excel, but I tried un-hiding the rows two ways:

1. Select row 3, right click and select unhide - The above rows do not appear, though the file is marked as modified
2. In the Home tab, click on the Format icon in the tool bar (needed to expand the window horizontally), then select unhide - the rows do not appear.

If I save the BasicInformation tab as a .csv
(File -> Save As, select .csv, click on OK to save only the active sheet, click on Yes to ack format problems),
Then the .csv file has the data for the rows that are hidden in the .xslx view.

If I reopen codeplug1.xslx, save it as a .xls file and reopen the .xsl file, then I can unhide the 1st row by using the Format icon. However, row 1 is very tall. If I select row 1, right click and select Row Height, then the height is reported as 409.5. If I change this to 15, then the row height makes more sense. Perhaps this is a clue?

Exporting a .xslx file used to result in a .xslx file that worked fine until I updated my go libraries. I think the version of the libraries that worked was from mid-November, 2019.

The way I would narrow this down is by trying different versions of the libraries. Offhand, I'm not sure how to do that, but I can look in to it.