jasbet.blogg.se

REM The function must be used in array mode. VBA: Flip / reverse a range data order vertically in Excel.Ĭode: Select all Function CentralReflection(pRange()) Step 2: Click Insert > Module, and paste the following macro in the Module Window. Step 1: Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window. If you know how to use a VBA code in Excel, you may flip / reverse data order vertically as follows: My question is - do you have a way to run the macro below in OpenOffice so that we can flip numerical data vertically? I understand it can be done in MS Office 2013 with "flip vertically" from its ribbon menu but I want to do it in OpenOffice. I want to flip the vertical column of data with the latest lotto draw results to show at the bottom, how can this be done? GitHub: _posts/-openoffice-draw-vs-visio.I have a problem to flip data in vertical column (not in ascending/descending order)Ĭurrently the lottery results on the link below are shown with the latest lotto draw results to appear at the top of the table. While neither Visio or OpenOffice try to tackle UML diagrams, I was able to throw some together in Dia, and them import them into Draw. In the end, I was totally satisfied with what I produced in OpenOffice Draw. Draw even has some of its own features, like exporting to PDF. Granted, I'm not a Visio power user, but I'm hard pressed to find anything that Visio does that OpenOffice doesn't do.

It just feels like a modern, intuitive application. It's somewhat of a pain to install on Windows, but it was dead simple in Ubuntu just search for "clip art" in the package manager GUI.Īctually using OpenOffice Draw was a blast. However, there is a great royalty free library available called Open Clip Art. By default, OpenOffice has a very limited library. Visio comes with a clip art library that includes various depictions of servers, routers, networks, etc. The diagrams themselves might be anything from how SMTP traffic flows from our system, over the WAN and back again, to data-center architecture, to the internal workings of a particular piece of code. Would OpenOffice Draw work instead of Visio?Ī typical Visio I might produce is a collection of clip art, shapes, text, connectors and arrows. But, every once in a while, I need to make some diagrams for a feature spec. OpenOffice Writer and Calc have been very competent substitutes for Word and Excel. In an effort to get off of Microsoft Office, I have been trying to use alternatives instead.