This macro will duplicate values in column A & B according to the value specified in column C. The results will be generated in columns D & E. The first row is the header. The macro is assigned to a button (named Push in this case). This macro works only in LibreOffice Calc and uses LibreOffice Basic Sample Data before running the Macro The Macro: Sub DuplicateRowsAsPerValue() Dim i As Double Dim j As Double Dim z As Double Dim w As Double sheet = ThisComponent.getSheets().getByIndex(0) For i = 0 To 10000 j = sheet.getCellByPosition(2, i).Value For z = 1 To j + 1 sheet.getCellByPosition(3, z + w).String = sheet.getCellByPosition(0, i).String sheet.getCellByPosition(4, z + w).String = sheet.getCellByPosition(1, i).String Next z w = w + z - 2 Next i End Sub The Macro (Adapted to run on LibreOffice Calc) Assign the Macro to a Button (in this case the the green one named Push) Duplicated values in columns D & E as per values in column C...
You can create a Subversion repository on your computer and use file:// scheme to interact with it locally. This approach can help you use Subversion locally to track personal files and single-person projects. The following procedure creates a minimal environment for an existing project. It converts a directory with a project into a working copy of a newly-created local Subversion repository. As result you can modify the files in the working copy and track the changes in your local repository. On Unix: Create a parent directory .svnrepos where you will place your SVN repositories: $ mkdir -p $HOME/.svnrepos/ Create a new repository MyRepo under .svnrepos: $ svnadmin create ~/.svnrepos/MyRepo Create a recommended project layout in the new repository: $ svn mkdir -m "Create directory structure." \ file://$HOME/.svnrepos/MyRepo/trunk \ file://$HOME/.svnrepos/MyRepo/branches \ file://$HOME/.svnrepos/MyRepo/tags Change directory to ./MyProject where your un...
Comments
Post a Comment