Ask Your Question
0

LibreOffice Calc Macro to Remove Link and Formulas

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

Aniruddha Mohod gravatar image

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

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
edit retag flag offensive close merge delete

Comments

Edited code for readability

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

1 Answer

Sort by » oldest newest most voted
0

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

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

Stats

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

Seen: 29 times

Last updated: Feb 15