![]() It's based on Adam's script, but with the extension to swap CONCAT from horizontal to vertical, while still keeping the delimiters in order. I never understood why they didn't include such an essential function right from the start, really. If you wanted to join a bunch of email addresses, you could use: =STRJOIN(C3:C50 ", " "")Īnd the result would be something like, ,, Įver so often I'd enjoy the ease and quickness of replace & calculation Options as well as in general the quick handling & modifying Options, when once again sitting in front of a dumped-file-lists or whatsoever. ![]() To customise the delimiter, instead use something like: =STRJOIN(C3:C50 " / ") Replacing C3:C50 with the range of strings you want to join. Now save the macro, go to the cell where you want the join to appear, I renamed it STRJOIN since "join" is the typical name of thisįunction in several popular languages, such as Perl, Python, and Ruby. Strings which go before and after each non-blank entry in the range The above code has some slight improvements from Markus' original:ĭoesn't start with a delimiter when the first cell in the range is empty.Īllows optional choice of the delimiter (defaults to ","), and the Result = result & before & range(row, col) & after It with: Function STRJOIN(range, Optional delimiter As String, Optional before As String, Optional after As String)įor row = LBound(range, 1) To UBound(range, 1)įor col = LBound(range, 2) To UBound(range, 2) ![]() Now enter a new Macro name and click New to open the OO.org Basic IDE. Stored directly in the current spreadsheet. it can be in your own macro library (My Macros / Standard) or Fill them with values of 1.0 (for a, b, c, d, and f) and 0.0 (for t ). Last, add a list of parameter cells labeled a, b, c, d, f, and t. Below the last column add a cell for the sum of F. Besides, add another two columns labeled F (calc.), and F. Now select from the explorer tree where you want your function live,Į.g. Open a blank spreadsheet in Excel or OOCalc and insert these values in two columns pH and F (meas.). Tools -> Macros -> Organize Macros -> Basic. Here are some slightly more detailed instructions for the benefit of OpenOffice Basic newbies like myself. (c) A workbook is a collection of Worksheet. ![]() (b) The Cell is a fundamental element of a worksheet. (a) An application that can be used to organized numerical data in the form table and perform calculations on it called a Spreadsheet application. Thanks a lot Markus for finding a solution to this. Introduction to OpenOffice Calc Questions & Answers Question 1: Fill in the blanks. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |