In a column with existing number formatting (like 2 decimal places, or dollar sign), a new row inserted in the middle of the column has no assigned formatting. That forces me to clone the formatting every time I insert a new row. I see similar bugs reported in the "possible duplicates" list, but none that matches that description exactly. Anyway, their status is "resolved/fixed" and I assure you the problem is NOT fixed in version 7.5.9.2. Thanks.
Test with Menu/Tools/Options/LibreOffice Calc/General - Expand formatting.
Please reply here, don't send private message, except needed to send e.g. a sample file with private information. Replied by Stuart in a private message. ' Thank you -- that seems to work in all the cases I've tried so far. ' There is a forum to ask. https://ask.libreoffice.org/