Spreadsheet rows are minimizing on their own

[lioness]

Just like the person who posted this question and hasn’t received an answer: spreadsheet columns keep minimizing on their own! . I am experiencing the same problem but with rows.

Every time I save and close the Libre Office Cal/Excel spreadsheet the rows keeps minimizing on there own.

It is a big file with 13 sheets. I have tried creating a new sheet and pasting the information in it. This has not resolved the issue. I have tried setting the row height. It does not resolve the issue. It is only happening with sheets 13 and over.

Edit for LeroyG clarification:

1. The document is created from scratch.

2. I do not use Microsoft Office(.xlsx) at all. I solely use LibreOffice so the file is saved as .ods

3. The issue is present only on this sheet(Sheet 13). However, if i create a sheet 14, Sheet 15 etc. It will minimize on its own for all those sheets. All the sheets prior to sheet 13 the row heights are not minimizing on their own.

4. A big file with sheets 13 and over

5. I have no issues setting the row height for Sheets 1-12. When i save and close the file the sheets remain how I set them.

6. Sheet 13 image(below) is what it happening to sheets 13 and over. Shrinking on its own.
   

   

7. Version: 7.2.4.1 (x64) / LibreOffice Community
   Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
   CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
   Locale: en-US (en_US); UI: en-US
   Calc: threaded

[LeroyG]

Hi @lioness,
Would you edit your question to clarify a few things?
You created the document from scratch in LibreOffice (or it is inherited from Excel)?
How do you save the document (.ods, .xlsx)?
The issue is present only in this “big file”?

@lioness

a big file with 13 sheets [or] sheets 13 and over

What if do you change the order of the sheets (its tabs)?
Can you share a reduced/anonymized sample file to test?
Thanks.

[lioness]

my question has been edited based on what you requested.

[LeroyG]

@lioness

what you requested

Oh. I forgot to ask for LibreOffice version and operating system. Thanks.

[lioness]

info has been updated

[lioness]

Hi, you asked me for all type of info a week ago. Is there any update?

[EarnestAl]

It might be related to this bug, fixed in 7.4.4 and above. Maybe the rows are still setting height, but slowly.
Bug 124098 - FILEOPEN: Calc sheet showing multiple “adapt Row Height” responses, slow loading

[LeroyG]

@lioness

a week ago

@LeroyG

Can you share a reduced/anonymized sample file to test?

Can you?
Or test installing a newer LibreOffice version, as @EarnestAl suggest.

[schiavinatto]

Hello @lioness, I already had this problem, the solution I found was, in a column any format, the font size is larger, even if the column is blank, so the line is adjusted by this column.
Observing that if you delete a column, the lines are resized again.

[lioness]

The only file I have is the one that is giving me the spreadsheet row problem. I do not know how to do or what you mean by “a reduce anonymized sample” of the file.

I uninstalled and reinstalled Libre Office. It made no difference, the problem is still occurring.
Version: 7.5.4.2 (X86_64) / LibreOffice Community

[lioness]

Hello @schiavinatto . Do you mind explaining what you said another way please. Week 3 and Week 4 are the only columns/rows that have the correct height. Week 1 and 2(as shown in the image) have the same information as Week 3 and Week 4. Yet the heights are not staying the same. I have to readjust the row height everytime I save and open the file.

[schiavinatto]

Ok, I didn’t know there were several lines in the cell.

Use this macro:

ROWS

Option Explicit
'(en)	 for use put in the worksheet =SETOPTIMALHEIGHT(NOW()), in any cell.
Function SetOptimalHeight(Optional oDummy As Variant) As String
Const MAX_HEIGHT = 10000
Dim oCurrentController As Variant
Dim oActiveSheet As Variant
Dim oCursor As Variant
Dim oRows As Variant
Dim oRow As Variant
Dim i As Long
Rem First of all, we find out the active sheet
    oCurrentController = ThisComponent.getCurrentController()
    oActiveSheet = oCurrentController.getActiveSheet()
Rem In order not to change all the columns on the sheet, we find the UsedRange
    oCursor = oActiveSheet.createCursor()
    oCursor.gotoEndOfUsedArea(True)
    oRows = oCursor.getRows()
Rem Now we optimize the width of each column in a given range
    For i = oRows.getCount() - 1 To 0 Step -1
        oRow = oRows.getByIndex(i)
        oRow.OptimalHeight = True
Rem We could stop at this
Rem But some columns may become so wide that they won’t fit on the screen
Rem In this example, we will limit the maximum width to 10 cm
        If oRow.Height > MAX_HEIGHT Then
            oRow.OptimalHeight = False
            oRow.Height = MAX_HEIGHT
        EndIf
    Next i
    SetOptimalHeight = "Clear this cell if you want to stop the automatic row height"
End Function

COLUMNS

Option Explicit
'(en)    for use put in the worksheet =SETOPTIMALWIDTH(NOW()), in any cell.
Function SetOptimalWidth(Optional oDummy As Variant) As String
Const MAX_WIDTH = 10000
Dim oCurrentController As Variant
Dim oActiveSheet As Variant
Dim oCursor As Variant
Dim oColumns As Variant
Dim oColumn As Variant
Dim i As Long
Rem First of all, we find out the active sheet
    oCurrentController = ThisComponent.getCurrentController()
    oActiveSheet = oCurrentController.getActiveSheet()
Rem In order not to change all the columns on the sheet, we find the UsedRange
    oCursor = oActiveSheet.createCursor()
    oCursor.gotoEndOfUsedArea(True)
    oColumns = oCursor.getColumns()
Rem Now we optimize the width of each column in a given range
    For i = oColumns.getCount() - 1 To 0 Step -1
        oColumn = oColumns.getByIndex(i)
        oColumn.OptimalWidth = True
Rem We could stop at this
Rem But some columns may become so wide that they won’t fit on the screen
Rem In this example, we will limit the maximum width to 10 cm
        If oColumn.Width > MAX_WIDTH Then
            oColumn.OptimalWidth = False
            oColumn.Width = MAX_WIDTH
        EndIf
    Next i
    SetOptimalWidth = "Clear this cell if you want to stop the automatic column width"
End Function