I used following Macro in MS-Excel to remove link and formulas and paste values. Whats should I use in LibreOffice Calc
Sub MakeValues()
Dim wSheet As Worksheet
For Each wSheet In Worksheets
With wSheet.UsedRange
.Copy
.PasteSpecial xlPasteValues
End With
Next wSheet
Application.CutCopyMode = False
End Sub