This repository was archived by the owner on Aug 5, 2021. It is now read-only.
This repository was archived by the owner on Aug 5, 2021. It is now read-only.
updateGoogleSheetFromStarRez leaving old data at bottom of sheet #9
Description
I'm running into an issue where old data is being left at the bottom of a sheet when calling updateGoogleSheetFromStarRez() and the new data is fewer rows than the existing sheet.
For example, if I have a sheet with 10 rows (1 header row and 9 rows of data) and call updateGoogleSheetFromStarRez and the result has 8 rows of data, the 9th row of data from before the call is being left at the bottom of the sheet (instead of being deleted). If there are blank rows at the bottom of the sheet they are deleted; however, any rows with data are not being deleted (as the number of results from a report may shrink in size from previous calls).