Ask Your Question

LibreOffice Calc Macro to Remove Link and Formulas

asked 2019-02-15 07:49:47 +0100

Aniruddha Mohod gravatar image

updated 2019-02-15 08:08:51 +0100

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
            .PasteSpecial xlPasteValues
        End With
    Next wSheet

Application.CutCopyMode = False
End Sub
edit retag flag offensive close merge delete


Edited code for readability

SM_Riga gravatar imageSM_Riga ( 2019-02-15 08:11:37 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-02-15 07:56:02 +0100

You may use DataText to Columns to do that. Just make sure that all separators are disabled in the dialog.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-15 07:49:47 +0100

Seen: 98 times

Last updated: Feb 15 '19