direct read/write operations by enterprise software on office documents, and/or document-driven applications. replacement of old-style, proprietary, client-based macros for intensive and non-interactive document processing The main goal of the Open OpenDocument Connector (OODoc) is to allow quick application development in 2 areas: In addition, a general presentation in French can be downloaded at Overview There is an alternative intro for french-reading users. Just before reading this intro, it's a good idea to have a look at the short (and commented) examples provided in the distribution.Īnother general introduction to this Perl OpenDocument Connector has been published in The Perl Review (issue #3.1, dec. The present introduction, as well as the OpenOffice::OODoc main chapter, should be read in order to get the big picture before any attempt to dig in the detailed documentation.
The reference manual is a set of OpenOffice::OODoc::xxx separate documents, where xxx is the codename of a particular functional area. This introductory notice is intended to allow the user to understand the general principles and to learn some basic features of the OODoc module without browsing the whole reference manual. OpenOffice::OODoc::Intro - Introduction to the Open OpenDocument Connector DESCRIPTION
You will notice that only when added the OR clause the result become a cell from an array.Ī new version is available, closer to my wish: LayerDbase(NCS5).png, but is there any way to compact those long series of if/else, and make them more powerfull and universal? For example please have a look at the Line Type formula. In the first sheet you can find the single steps of the formula to reach my intent: LayerDbase(NCS5)test.png Please find attached the file (as always, rename it as *.ods). “ Keywords.F4:F11” is the array of words that, if “layername” has any of them, the output of the formula will be “ hidden”. “ layername” is the cell with the text wich content I have to analize Here’s a solution: first I had to learn arrays, and the final formula is: =IF(OR(ISNUMBER(SEARCH(Keywords.F4:F11 layername))) "hidden" "") Please find my work-in-progress calc file at this link: The Calc file will be distributed with a CC license. Is there any formula, possibly avoiding a macro?Īny help will be appreciated. Now I need a formula to check all the words inside the given cell range “bold Layers”. I found the text function “SEARCH” ( Ricerca in my Italian version) that can find a word inside a string. So now I shall check the content of the layer’s name if it contains ANY of the given words. So for keywords like “bold line” or “section” or “outline” a large line should be used. So I made new tables of keywords to associate keywords to, let’s say, line weight. Now I wish to suggest also line weight and line type to be used. The layer to draw Contractor/Shop Drawings: Walls, Redlines, Wood (Future work) shall be named Z-WALL-REDL-WOOD-F I can select what I’m going to draw from some lists and it gives me the suggested name, as an example: I made a “database” of keywords to build up Cad layer’s name from them. Is there any way to check if a given string cell contains any of the values in a given set of cells?