Re: [libreoffice-users] Base macros
I have not dealt with Base for years now (say 15), but, I did create a database to track stuff that I own. The DB contained full scale images of the receipts. I did not do as our indicated, but, it does display properly scaled images in the image control. I took a look at the macros I wrote and I did nothing special in the macros (it seems) to properly scale. My biggest error was to embed the entire full size image into the DB. I do have buttons that Add an Image (so select, load and store in DB), Delete an image (delete from DB), replace an image (so select from file system, then replace existing), and extract from the DB I can directly email you a copy of an empy DB if it interests you, but I am not sure if it is useful or not. It sounds like you did it write, show a thumbnail stored in your DB and reference the actual file on disk. I am writing a database front end application in C++ and QT for specific collectibles and it will find the image using a naming scheme based on a catelog number (at least for the standard image). Probably a better solution. Andrew Pitonyak On Monday, March 25, 2024 01:01 EDT, Edwin Humphries wrote: Hi all, I have a database consisting of several flat-file tables with associated forms. They contain information about plants, including several photos (up to 6) per form. They are currently 150*150 "thumbnails", but the photos themselves are larger, sometimes much larger. I would like to add a feature that allows a viewer to open the photo up in a separate window to screen maximum. I have seen several macros online that purport to do that, but with limited documentation, and apparently suited only for one photo per form. Moreover, I have little experience with scripted macros, in Base (or any other program, for that matter). Can anyone help with this? -- Regards, Edwin Humphries Mobile: 0435 672 457 I acknowledge the traditional Wodi Wodi custodians, their elders and customs, of the Dharawal lands on which I live. "At every moment he beholdeth a wondrous world, a new creation, and goeth from astonishment to astonishment, and is lost in awe at the works of the Lord of Oneness." Bahá'u'lláh "... humans are interesting. With all the wonders there are in the Universe, they invented boredom." Terry Pratchett, Hogfather "The most beautiful thing we can experience is the mysterious. It is the source of all true art and all science. He to whom this emotion is a stranger, who can no longer pause to wonder and stand rapt in awe, is as good as dead: his eyes are closed." Albert Einstein "Stuff your eyes with wonder ... live as if you'd drop dead in ten seconds. See the world. It's more fantastic than any dream made or paid for in factories." Ray Bradbury -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] how to generate a re-scaled column
On Monday, October 02, 2023 09:02 EDT, Uwe Brauer wrote: So I thought | Marks | Scaled | |---+| | 1 | =A1/max(A1:A7) | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | That gives the correct entry for B1, however if now, drag with the mouse down that formula I obtain | Marks | Scaled | |---+| | 7 | =A1/max(A1:A7) | | 2 | =B1/max(A2:A7) | | 3 | | | 4 | | | 5 | | | 6 | | | 1 | | Which is not what I want. That is a very elementary question, but google does not help me. regards Uwe Brauer Your question is a good one. Either I misunderstand your question or you are doing something I do not know (so you can teach me something) and I will provide what I think can be a solution to your problem. Let me start with what I do not understand. Where you have B1/max(A2:A7), I actually expected it to be A2:A8, but I have never actually "dragged a formula" so some of what I am about to say could be wrong. Also, perhaps you can tell me how to "drag with the mouse". My best guess is that either (1) there is a feature I do not know or (2) you are doing some kind of selection while entering a formula (which I know can be done but again, somthing I do not usually do). I usually drag with a mouse when I am simply selecting cells, but I am unser how to drag a formula. Then again, I also do not remember how to do array formulas (I think that is what they call them) even if I did play with them once some years back. All that said, how I normally solve this problem would be as follows: 1. Enter the formula =A1/max(A1:A7) in cell B1 2. Select cell B1 and copy it to the clipboard. 3. Select cells B2:B7, and choose paste. The problem is that every cell reference is considered relative to the cell containing the formula. If I copy cell B1 and paste into cell B2, the column has not changed so column references stay the same but the row is now one greater so every row reference will increase by one. So in cell B2 I expect to see =A2/max(A2:A8) Paste into cell C2, so the row is one greater and the colun is one greater so the formula is =B2/max(B2/B8) All referenced cells are assumed to be relative to the cell where the formula is entered. If you place a dollar sign $ before a row or column in an address then it is taken to be an absolute address. So if I change the formula in cell B1 to be =A1/max(A$1:A$7) If I copy that formula from Cell B1 and paste that into cell D3, I have gone right two columns and down two rows so it will try to add two to every row and every column and I end up with the formula =C3/max(C$1:C$7) In your case this would have been sufficient because you were copying into cells B2:B7 and did not change the column. You could enter this as =$A1/max($A$1:$A$7) then the formula will always refence column A and only the very first row will increment because it is not preceded by a $. Note that if I insert a row into the middle, cell A7 becomes A8 and all references to A7, or even $A$7 will become $A$8. Finally, a cell address can include the sheet name, and the same applies to sheet names. My default sheet name is "Sheet1", so, I can set my formula to be =Sheet1.A1/max(A1:A7) If I copy this and paste it into cell B2 on Sheet 2 then my formula changes to =Sheet2.A1/max(A1:A7) If I had used $Sheet1.A1/max(A1:A7) then the first reference would still reference $Sheet1 Andrew Pitonyak -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] last cursor position
I loaded a roughly 700 page document that had been saved on page 35. I was left on page 51 (of 683), which is really page 47 with the way that I modify page numbering in the book. Shift+F5 takes me back to page 35 (real page 31) where I had left off. I am running on the latest release of Fedora and I have version 7.5.3.2 of LO. Pretty sure that LO was installed from the repos rather than a direct download, but I simply do not remember. On Sunday, July 23, 2023 17:30 EDT, Chuck Stuettgen wrote: This bug appeared beginning in version 7.1.0.1. Since then there have been 82 releases of LibreOffice. There have been 13 releases of 7.5 which was when it was supposed to have been fixed. Now 7.6 has been released. Apparently, we are in the minority of the more than 200 million users of LibreOffice for whom this is a problem. I can only surmise the rest of 200 million users are only editing short 1 or 2 page documents so never encounter the problem. I wasn't aware of the SHIFT F5 workaround and wound up removing the distro supplied version and installed 7.0.6.2 from the Document Foundation's download site. 7.0.6.2 is the last version without the bug. Would I prefer to use a more up to date version? Absolutely! But I routinely edit documents of 100 pages or more and having to hunt down the last edited location is a major problem. Some day, when I don't have anything else to do, I'll set up another computer and install the latest version to see if I can live with the SHIFT-F5 work around. Until then I'll stick with 7.0.6.2. Chuck On Sun, Jul 23, 2023 at 2:15 AM Thomas Blasejewicz wrote: > Good afternoon > I am sure, this question has been asked a million times. > When I open a document, the cursor is NOT in the position of the last edit. > In fact, it appears at random locations, different each time I open the > document. > > I have modified the user data section under tools, but that does not > change anything. > Deliberately editing the document at different locations, closing and > reopening it (same computer), > the cursor still pops up at totally unpredictable locations. > This happens apparently also with other (not created by me) documents. > > Is there a smart trick, anything short of resetting the user profile? > > Thomas > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] How to get the height of the text context
I'm pretty sure I have an example that does something about it either in OOME or in andrewmacro.odt on my website, but I'm not in a position that I can verify that right now. Try www.pitonyak.org I think the link on the page is something like macros. Get BlueMail for Android On Apr 27, 2023, 4:09 PM, at 4:09 PM, Johnny Rosenberg wrote: >Den tors 27 apr. 2023 kl 10:55 skrev Rose Gale >: > >> Hello: >>I don't know if anyone has encountered this problem, but I >haven't >> been able to find the right solution. I hope I can get some helpful >> suggestions here. >>I'd like to start by stating that I can only do this in c# for >a >> variety of reasons >>I need to get the height of the content on the last page of >the >> document. I have drawn a sketch below for your understanding. >> > >Only text is accepted in this mailing list, so everything else is >stripped >away. Upload it somewhere and give us the link instead. > > >> >>I have found some classes on the official website, but I do >not know >> whether they are useful or how to use them. >> [image: image.png] >> >> Actually, to achieve functions similar to Word : var height = >> >objrage.get_Information(WdInformation.wdVerticalPositionRelativeToPage); >> >> >> Best Regards >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Database back end?
I believe the first issue here is that I am not aware the method to use a base document as a back end and the same manner that you might contact say a different database using JDBC. So, I think you might need to use the API to manually manipulate the document which is very different than maybe writing macros inside the base document to connect to the actual database portion. I think I said that very poorly, but I don't think you could use something like JDBC to access. Base is the big issue here. And my opinion, if you are writing a web app and you intend to use Java, you might be better off with another database as your back end. But now some others more experienced than I can weigh in. I have however used base to access other backend databases then what is used internally to base. The back end database for internal based documents is HSQL I believe. Get BlueMail for Android On Feb 18, 2023, 7:11 PM, at 7:11 PM, Amn Ojee Uw wrote: >I was wondering if it would be possible to hookup a Java Web >Application >I am working on to LibreOffice's Base back-end. >If it is possible, where can I find the API and a stand alone LO-Base? > >Thanks! > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice parent company
Apache is not required to LibreOffice. I don't think I would classify LibreOffice as a company. Get BlueMail for Android On Feb 18, 2023, 7:37 AM, at 7:37 AM, Amn Ojee Uw wrote: >New comer here! >What is the parent company of LibreOffice? Apache? > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Basic Macros with Base
I think in my AndrewBase.odt document that I previously referenced, that I wrote a routine to put quotes around things so that they would appear inside the strings but I would have to go back and double check. But yes, I think you need to do that. Get BlueMail for Android On Jan 26, 2023, 3:21 AM, at 3:21 AM, Harvey Nimmo wrote: >Hi Robert, > >the thought occurs to me that the existing quotes within the SQL >statements may need their own treatment. The statements that work under >the LOBase Tools>SQL... function have different type of single >quotemarks for the column names (e.g. containing two separate words) or >the text to be set in the columns. I have assumed that the macro (SQL) >string variables just need to be enclosed in double quotemarks. Is this >right? > >Cheers >Harvey > > >On Wed, 2023-01-25 at 21:51 +0100, Robert Großkopf wrote: >> Hi Harvey, >> > >> > how would this work for me, where I only want to create a SQL >> > statement >> > as a string and execute it. >> >> Mcro works with SQL-code, which has been saved in a field of a table. >> Field in the table is called "SQL-Code". Table is datasource of a >> form. >> A button in this form will start the code. >> >> First needed object is executing a button in the form to start the >> procedure. >> >> If you will save all code directly in a macro you will need >> → a connection to the database >> → SQL code, which has been maskes with double doublequotes for >> fieldnames and tablenames >> → var for creating a statement >> → execute the sql-code in this created statement >> >> At which line of the macro the code stops for you? >> > > >> > > Here a code from German Base Handbuch: >> > > >> > > SUB ChangeData(oEvent AS OBJECT) >> > > DIM oConnection AS OBJECT >> > > DIM oForm AS OBJECT >> > > DIM stSql AS STRING >> > > DIM oSql_Statement AS OBJECT >> > > DIM inValue AS INTEGER >> > > oForm = oEvent.Source.Model.Parent >> > > oConnection = oForm.activeConnection() >> > > stSQL = oForm.getString(oForm.findColumn("SQL-Code")) >> > > inValue = MsgBox("Should SQL-Code" & CHR(13) & stSQL & CHR(13) >> > > & >> > > "be executed?", 20, "Execute SQL-Code") >> > > IF inValue = 6 THEN >> > > oSQL_Statement = oConnection.createStatement() >> > > oSQL_Statement.execute(stSql) >> > > END IF >> > > END SUB >> > > >> > > SQL-Code is part of a table. Field in the table is "SQL-Code". >> > > Table >> > > is >> > > datasource of a form. A button in this form will be enough to >> > > execute >> > > the macro. You coud update, insert or delete rows by command >> > > "execute". >> >> Regards >> >> Robert >> -- >> Homepage: https://www.familiegrosskopf.de/robert >> >> > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Basic Macros with Base
I have a guess since I was not previously aware of this method. There is precedence for LO adding support for Microsoft Office (MSO) compatibility. I am guessing that this method was added for MSO compatibility with MS Access (but that is just a guess). I would assume, therefore, that it should act similarly to how the method work in MS Access (again a guess). When I really want to know, I pull the code and then I go looking for the method in the code to see what it does. Also, if it immediately registers as an error, then you might need to turn on compatibility mode. Well, that is what I thought until I googled a bit This implies that the command is based on an extension rather than directly supported by LO. https://extensions.libreoffice.org/en/extensions/show/access2base https://extensions.openoffice.org/en/project/access2base-api-base-users https://ask.libreoffice.org/t/syntax-form-controls-base/45282 but then this seems to imply otherwise https://books.libreoffice.org/en/BG72/BG7209-Macros.html Sorry, not much help :-( On Tuesday, January 24, 2023 15:50 EST, Harvey Nimmo wrote: Thanks. Not sure I can understand how that should work...hmmm I based my syntax on the example here https://learn.microsoft.com/en-us/office/vba/api/access.docmd.runsql On Tue, 2023-01-24 at 20:39 +, Dave Howorth wrote: > On Tue, 24 Jan 2023 20:32:18 +0100 > Harvey Nimmo wrote: > > > Where can I find the syntax of the DoCmd.RunSQL command to be used > > with a LOBase Macro in Basic? > > I've never heard of the command, but google suggests > > https://docs.libreoffice.org/wizards/html/classaccess2base_1_1DoCmd.html#a3c1b223e5e4024f2a8b955b2df3b6f92 > > I've no idea whether it is correct/relevant. > > > My assumption was > > X = "SQL string" > > DoCmD.RunSQL X -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Basic Macros with Base
I am not familiar with "DoCmd.RunSQL", I will have to look it up (unless you have a few links). Is DoCmd a server? I have not used Base with Macros in a long time, but, last time I did, I was creating connections to a database and then running SQL commands using a connection object. I have examples in AndrewBase.odt if that is of any help to you. https://www.pitonyak.org/database/ https://www.pitonyak.org/database/AndrewBase.odt (called Random DB Ramblins, and yes that is spelled incorrectly). On Tuesday, January 24, 2023 14:32 EST, Harvey Nimmo wrote: Where can I find the syntax of the DoCmd.RunSQL command to be used with a LOBase Macro in Basic? My assumption was X = "SQL string" DoCmD.RunSQL X The SQL string runs correctly is correct when executed as SQL Command in the Base Tools/SQL window. The Basic Macro with the above statemsnt compiles without error when the SQL command text is enclosed in "" quotes. But at runtime it halts with the message that the variable X is not set. However, a Basic Print statement shows the correct value for X. (By the way, the Watch function displays no values for any variable. Not sure if it should) My conclusion is that I ma using the wrong syntax for DoCmd.RunSQL Any ideas? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Macros in spreadsheets
I am having trouble following what is happening (and I guess I missed the first reply. First, it looks like the cell D2 is calling a macro. If I understand, the cells are NOT recalculating so you are causing each one to run manually. What happens if you use Data > Calculate > Recalculate (or F9) to cause every cell to recalculate? If that works, you can also write a macro to cause it to recalculate. I do not remember off hand how to do that (and I don't want to take the time to look it up), but, I did record this macro that uses the dispatcher to do it. I feel like it is cheating but it should work just fine. sub recalculate document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") dispatcher.executeDispatch(document, ".uno:Calculate", "", 0, Array()) end sub On Monday, January 02, 2023 20:22 EST, Stephen Morris wrote: On 3/1/23 09:13, Michael Tiernan wrote: > On 12/23/22 11:02 AM, Andrew Pitonyak wrote: >> If you are looking to cause functions to recalculate, > > Thanks for the reply. > > Here's the thing. It's not that I want to force a recalculate, it's > that I have to in order to get the macros to respond. > > Here's an example: (What I expect when the spreadsheet finishes opening.) > > /*Cell*//* > */ /*Contents*//* > */ /*Display*//* > */ > D1 > 192.168.17.231/24 > 192.168.17.231/24 > D2 > =ipwithoutmask(D1) > 192.168.17.231 > D3 > =ipmask(D1) > 255.255.255.0 > D4 > =ipmasklken(D3) > 24 > > Now, when I actually do open the spreadsheet, it says: > > /*Cell*//* > */ /*Contents*//* > */ /*Display*//* > */ > D1 > 192.168.17.231/24 > 192.168.17.231/24 > D2 > =ipwithoutmask(D1) > #NAME? > D3 > =ipmask(D1) > #NAME? > D4 > =ipmasklken(D3) > #NAME? > > So, if I say it differently, it *seems* like the Macros aren't run > when the spreadsheet is opened. > > The macro library has a "Main" entry that is empty. If I choose > "Tools" -> "Macros" -> "Run macro" and then select "Main" and execute > it, there's no visible change. > > BUT, if I go into the contents of "D2" and add a space at the end of > the formula "=ipwithoutmask(D1)" to read "=ipwithoutmask(D1) " and hit > return and the macro executes and displays the proper value. > > HOWEVER, none of the other cells change so I have to go into each one > and do the same sort of thing, add a space at the end of the line or > between the macro and the parenthesis, each time, hit return and it > works properly. > > This is obviously not the correct way it should work. > > Hence my query about "starting" macros when the document is opened. > > So, that leads to, am *I* doing something wrong? > > Thanks for everyone's time. > Not being familiar with Calc's macro functionality, what you are showing as your macro references looks like a formula, so I would check two things, which you may have already checked as I also haven't been following this thread, check your macro security options as they may be preventing your macros from running as the default option is to prevent unsigned macros from running. Also check your formula "recalculate of load" options as they may be set to not recalculate. With your main entry being empty I would expect running that to actually do nothing. Looking at the existing macro definitions and the way they are shown when placing the cursor in them, I would assume your macros are within a module, so when you reference the macro in your formula, do you need to reference is as, for example, .ipwithoutmask(D1)? regards, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Macros in spreadsheets
No computer access Right now so everything I say is going to be a guess. If you are looking to cause functions to recalculate, I think that might be a setting not related to macros. Because you can turn off auto recalculation. Also, you can force a full update. I know it's on the menu. I don't remember the key strokes but I know it's there something like tools recalculator something or maybe it's update all I guess That said, you can associate events to macros. I do believe. I don't do it often, but I believe you can. So you can set a macro to run when a document opens and maybe that's what you want. I don't remember offhand how to get to events. You can associate a macro to run when an event occurs, but I have done it. I designed some macros for a company that wanted things to auto calculate when they opened a template. For me, learning macros was easier by simply looking at examples and then modifying them for my own uses. But you're asking how to cause macros to run based on certain conditions, not how do you accomplish a specific task. Best of luck. Get BlueMail for Android On Dec 23, 2022, 10:51 AM, at 10:51 AM, Michael Tiernan wrote: >I have a couple of BASIC macros in a spreadsheet. > >I keep thinking that there must be a "init" function that isn't being >called because each time I open the spreadsheet, the macros don't run. >I >have to mess about a bit and then force each cell to recalculate >manually. (I'm sure that there's a global 'recalculate' button/tool >somewhere but that's secondary to the problem.) > >I know there's a lot of documentation out there on macros (almost too >much) but I'm not sure where to start reading, does anyone have a >pointer that would address, not how to create a macro but how to >incorporate it to become automatic? > >Thanks. > >-- > << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan > Non Impediti Ratione Cogatationis > Women and cats will do as they please, and men and dogs >should relax and get used to the idea. -Robert A. Heinlein > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] File conversion issue
Is this only text? I assume there is embedded content of some sort or some kind of fancy break going on. Is there a frame? When I had a problem it was specifically with an ODT file, so I copied it to a zip file, unzipped it and then I was able to look at the content to what sort of funny things were going on in there. I think you can do the same with the doc x file, but I surely have not tried that but I thought I'd heard that that was possible. Get BlueMail for Android On Nov 30, 2022, 6:24 AM, at 6:24 AM, "Bathula, Shiva Prasad" wrote: >Hi Andrew pitonyak, >Thanks for replying to my email. I tried to break the file and verified >. Here I have observed that two paragraphs are causing problems(1 page) >and removed that page from the file and it worked fine. Again, by >keeping the problematic page only passed separately and it also worked >fine. But including both is not working. Any idea like why we are >facing this behaviours with file? > >Thanks >Shivaprasad > >From: Andrew Pitonyak >Date: Tuesday, 29 November 2022 at 7:10 PM >To: lo.harald.ber...@t-online.de >Cc: Bathula, Shiva Prasad , >users@global.libreoffice.org >Subject: Re: [libreoffice-users] File conversion issue >Do you see any problems / errors when you attempt a specific document >manually? > >You claim that you cannot provide the example file, but, how much can >you modify the example file and still demonstate the error? > >I once had a file that caused a crash and it was related to an image in >a frame with a specific anchor type. > >Are you able to remove parts of the document and still reproduce the >crash? > >Is the document long and perhaps there might be a timeout? > >Are you able to modify the text (like change every letter to an X)? > >Just a few thoughts. > >On Tuesday, November 29, 2022 07:02 EST, lo.harald.ber...@t-online.de >wrote: > >Please try an error description on Bugzilla. Thank you. >https://bugs.documentfoundation.org/ > >Am 29.11.2022 um 11:57 schrieb Bathula, Shiva Prasad: >> We have been using libreoffice software for the last one and half >years to convert files like .doc, .docx, .jpg, .PNG, .tiff … files to >.pdf. Recently, some .docx files are failing to convert to .pdf. Here >we are using Libreoffice in Java code and in AWS lambda (Node.js). We >are not getting any clue because only some files are failing to convert >with Java code and with Node.js code((Lambda is getting timeout and >throwing “Command failed”) also. We can’t share the failed file here >because it is a client file. So could you please provide possible >causes for failures. > > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy > > > >This e-mail, including attachments, may include confidential and/or >proprietary information, and may be used only by the person or entity >to which it is addressed. If the reader of this e-mail is not the >intended >recipient or intended recipient’s authorized agent, the reader is >hereby >notified that any dissemination, distribution or copying of this e-mail >is >prohibited. If you have received this e-mail in error, please notify >the >sender by replying to this message and delete this e-mail immediately. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] File conversion issue
Do you see any problems / errors when you attempt a specific document manually? You claim that you cannot provide the example file, but, how much can you modify the example file and still demonstate the error? I once had a file that caused a crash and it was related to an image in a frame with a specific anchor type. Are you able to remove parts of the document and still reproduce the crash? Is the document long and perhaps there might be a timeout? Are you able to modify the text (like change every letter to an X)? Just a few thoughts. On Tuesday, November 29, 2022 07:02 EST, lo.harald.ber...@t-online.de wrote: Please try an error description on Bugzilla. Thank you. https://bugs.documentfoundation.org/ Am 29.11.2022 um 11:57 schrieb Bathula, Shiva Prasad: > We have been using libreoffice software for the last one and half years to > convert files like .doc, .docx, .jpg, .PNG, .tiff … files to .pdf. Recently, > some .docx files are failing to convert to .pdf. Here we are using > Libreoffice in Java code and in AWS lambda (Node.js). We are not getting any > clue because only some files are failing to convert with Java code and with > Node.js code((Lambda is getting timeout and throwing “Command failed”) also. > We can’t share the failed file here because it is a client file. So could you > please provide possible causes for failures. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Writer doc not going back to where I exited
Are you asking where your macros are stored. I am far from a computer for a few days, but, unless you manually moved them, they should still be in the original location... Probably similar to /home/tim/.config/libre office/3.5//basic If you make if into .config you can probably search for basic using find. Get BlueMail for Android On Nov 24, 2022, 4:55 PM, at 4:55 PM, Tim Lloyd wrote: >Hi, > >Running Fedora 36 > >Currently LO version 7.3.7.2 > >Earlier this week I had huge problems due to power spikes. I had >problems accessing my LO documents and I thought it best to uninstall >and reinstall. This I did from the fedora repos. > >This is an old problem where I exit and save a writer doc on "this" >page >but it goes to "that" page when I reopen the document. From memory >setting up personal data is the key to getting this to work and I have >done that. > >Any ideas why I can't open up again where I left off? > >My config/libreoffice/ files are intact from before the uninstall. I >would delete these but I am not sure how to store my macros. > >Regards > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Searching for info gives nothing related to what I need?
I have examples of creating your own dialogues in OOME (book) on my website. I don't remember off hand if I have examples in andrewmacro, which is also available there for download. Sorry can't easily check I won't have access to my computer for another week. I never cared for the process of creating your own dialogues, but with that, you can pretty much do whatever you want in terms of input. Get BlueMail for Android On Jul 24, 2022, 3:22 AM, at 3:22 AM, "Michael D. Setzer II" wrote: >Have gotten this macro to do what I want, but the process requires two >inputbox commands. Was trying to find a way to have a single dialog >rather >than two. All the searches come up with thing not even closely related >to what I >am looking for. Many are linked to Calc or Base or have super complex >step. >Want a single form or whatever to enter the to: info and subject: info. >Have tried dozens of search terms but not finding an example. > >Sub Mailto >Dim oDoc As Object >Dim Path$, sendto$,subject$,cmd$ >oDoc = ThisComponent >Path$ = oDoc.getURL() >sendto$ = InputBox ("To:") >subject$ = InputBox("Subject:") >If oDoc.HasLocation() Then > subject$=replace(subject$," ","%20") > cmd$="/home/msetzerii/.wine/drive_c/PMAIL/Programs/WSENDTO.EXE " >&mid(Path$,8,100) &" "&" >mailto:"&sendto$&chr$(63)&"subject="&subject$&"&body=SENDING%20"& >mid(Path$,8,100) > shell(cmd$) >Else > Print "The document has not yet been stored" >End If >End Sub >++ > Michael D. Setzer II - Computer Science Instructor (Retired) > mailto:mi...@guam.net > mailto:msetze...@gmail.com > Guam - Where America's Day Begins > G4L Disk Imaging Project maintainer > http://sourceforge.net/projects/g4l/ >++ > > > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] ReDim Preserve (BASIC macro programming)
I said but you can I don't have access to any materials or any way to test this, but I suspect it's because the array is initialized using the array function. If you run a quick test and initialize your array by defining the size and then manually setting the values, how better will work. I am not saying it's not an error, but I suspect it has to do with how the array statement creates an array. I remember correctly I found a couple odd things about it. Get BlueMail for Android On Jul 10, 2022, 2:02 PM, at 2:02 PM, Johnny Rosenberg wrote: >Hi. > >Is this a bug or is my brain just not working? > > > > > >*Sub ResizeArrayTest Dim MyArray(5) As Long MyArray=Array(1, 2, >3, >4, 5, 6) ReDim Preserve MyArray(4)End Sub* > >Running this creates the array MyArray, but it's *empty*, so it seems >like ” >*Preserve*” doesn't work here. Or what am I doing wrong? I'm sure I >have >got Preserve to work many times before, but maybe my brain crashed this >time. > >Using LibreOffice 7.2.7.2 on Ubuntu Studio 20.04. > >Kind regards > >Johnny Rosenberg > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] ROUND function consistency
Sorry, this is NOT a bug. This is exactly the result I expect if I was using VBA in MSO. Read on to find out why. I say this without looking at the code, but, you specifically told LO to use the VBA version of rounding, which is NOT normal rounding. VBA rounding uses bankers rounding. https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/round-function With "Bankers Rounding", when numbers are equidistant from the two nearest integers, they are rounded to the nearest even integer; therefore, 0.5 rounds down to 0; 1.5 rounds up to 2. So, it looks like you are getting the correct answer because you turned on VBA support so the round function should act like the VBA round function. If you really were writing a macro using Microsoft Office (MSO), you would probably have used Math.Round() (I think that is what it is called) to use the rounding that you were expecting. On Saturday, June 04, 2022 22:44 EDT, Steve Edmonds wrote: I have just put a basic macro together so it will calculate income tax due from our local tax rates. I needed to round the tax to the nearest cent so taking the easy route I added Option VBASupport 1 to use the available VB round function. I then noticed that the VB round function with say round(12.125,2) rounds down to 12.12 and the LO inbuilt spread sheet function ROUND with ROUND(12.125,2) rounds up to 12.13. Is rounding in this situation arbitrary or is there some some convention for consistency. Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: Script to parse spreadsheet and send to own database as CSV or JSON
I cannot comment on things that are online, but I believe that you can automate LibreOffice using Python; even though I have never done it. Well I guess I don't remember if I've done it or not and done a lot of things I don't remember just a long time ago. Most of the automation I have done is been in basic. Get BlueMail for Android On Apr 20, 2022, 12:58 PM, at 12:58 PM, Albin wrote: >Hello, > >Just wondering if you've received this question? > >Respectfully, > >-albin >___ >Digital Wizard | NeuroLeap Corp | San Jose, CA, USA >*Special Power for Special Children!* >The content of this email is confidential and intended for the >recipient >specified in message only. It is strictly forbidden to share any part >of >this message with any third party, without a written consent of the >sender. >If you received this message by mistake, please reply to this message >and >follow with its deletion, so that we can ensure such a mistake does not >occur in the future. > > >On Fri, Apr 15, 2022 at 10:51 PM Albin wrote: > >> Hello, >> >> We have spreadsheets filled out by our psychologists and other >> specialists, which are periodically (in the background) parsed and >sent to >> a database on our servers. >> Currently, we are using Google Sheets and Google Cloud, however, we >need >> to migrate to another solution. Since we have no profits and no >budget to >> buy anything, I was wondering if we could accomplish the parsing via >> scripts (preferably using Python) using LibreOffice Calc Online? >> >> Thank you. >> >> Respectfully, >> >> -albin >> ___ >> Digital Wizard | NeuroLeap Corp | San Jose, CA, USA >> *Special Power for Special Children!* >> The content of this email is confidential and intended for the >recipient >> specified in message only. It is strictly forbidden to share any part >of >> this message with any third party, without a written consent of the >sender. >> If you received this message by mistake, please reply to this message >and >> follow with its deletion, so that we can ensure such a mistake does >not >> occur in the future. >> > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice 7.3 not working on Fedora 34??
On Monday, February 07, 2022 20:20 EST, "Michael D. Setzer II" wrote: =On 7 Feb 2022 at 17:17, Dave Barton wrote: Subject: Re: [libreoffice-users] LibreOffice 7.3 not working on Fedora 34?? To: users@global.libreoffice.org From:0; Dave Barton Date sent: Mon, 7 Feb 2022 17:17:07 + > On 06/02/2022 22:28, Jean-Baptiste Faure wrote: > > Hi, > > > > Le 03/02/2022 à 10:56, Michael D. Setzer II a écrit : > >> Yesterday, Downloaded and installed and it reports a > >> crash, but just gives option to submit it, but no details. > >> Come up in safe mode, but opening calc just drops to > >> command prompt. > >> Tried running with strace, and don't see anything that > >> looks like error. > >> Have the Fedora 34 regular latest version running fine, > >> and have the had 7.2.x versions up to 7.2.5 and both work > >> fine. > >> Thought perhaps having 7.2.5 and 7.3 caused issue, so > >> uninstalled both, and then reinstalled 7.3, but same > >> results.> >> Have uninstalled 7.3, and put the 7.2.5 back, and it is > >> working.> >> Only tested with Calc, so not sure if 7.3 had other items > >> working?> >> Don't know what it actual submitted with the error it > >> found, or if includes any way to contact me of issue? > >> Thanks.> >> > > > > Seems like this bugreport: > > https://bugs.documentfoundation.org/show_bug.cgi?id=146990 > > > > Best regards.> > JBF > > Now https://bugs.documentfoundation.org/show_bug.cgi?id=147135 > > This bug has been reported in the forums of a number Linux distros. The > issue is very random and appears to only arise in some hardware > environments. > > For example, I run PCLinuxOS with either Intel or AMD based hardware on > a number of machines and I cannot reproduce the crash. For others with > near equivalent hardware and software environments to mine, the crash is > 100% reproducible.> > This is going to be a difficult one for the devs to track down. > Did notice something in message log file. If run libreoffice7.3 but don't try calc there is nothing, but if try calc and it crashes the log has these lines?? Feb 8 11:04:04 setzconote audit[513755]: ANOM_ABEND auid=1000 uid=0 gid=0 ses=2 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 pid=513755 comm="soffice.bin" exe="/opt/libreoffice7.3/program/soffice.bin" sig=4 res=1 Feb 8 11:04:05 setzconote abrt-server[513792]: Package 'libreoffice7.3' isn't signed with proper key Unfortuantely, the lines on abrt at time don't seem to show anything to me. Feb 8 11:04:05 setzconote abrt-dump-journal-oops[2039]: abrt-dump-journal-oops: Found oopses: 1 Feb 8 11:04:05 setzconote abrt-dump-journal-oops[2039]: abrt-dump-journal-oops: Creating problem directories Feb 8 11:04:05 setzconote abrt-server[513792]: Package 'libreoffice7.3' isn't signed with proper keyFeb 8 11:04:05 setzconote abrt-server[513792]: 'post-create' on '/var/spool/abrt/ccpp-2022-02-08-11:04:05.227869-513755' exited with 1 Feb 8 11:04:05 setzconote abrt-server[513792]: Deleting problem directory '/var/spool/abrt/ccpp-2022-02-08-11:04:05.227869-513755' Feb 8 11:04:06 setzconote abrt-server[513791]: Can't find a meaningful backtrace for hashing in '.' Feb 8 11:04:06 setzconote abrt-server[513791]: Preserving oops '.' because DropNotReportableOopses is 'no' Feb 8 11:04:06 setzconote abrt-notification[513811]: System encountered a non-fatal error in ??() Feb 8 11:04:06 setzconote abrt-dump-journal-oops[2039]: Reported 1 kernel oopses to Abrt > Regards > Dave > What I am about to say has no bearing on anything related to reality, but, this is what I had to do to make VMWare work on Fedora after I built my own binaries. The likliehood that this will work for you is very small indeed. I think you will need to create a password for signing. I do not remember when, but, just think of a password and write it down or something. (1) Generate a key, but do NOT use CN=VMware, use something like CN=LibreOffice openssl req -new -x509 -newkey rsa:2048 -keyout MOK.priv -outform DER -out MOK.der -nodes -days 36500 -subj "/CN=VMware/" (2) Import said key mokutil --import MOK.der (3) Sign the file of importance. In my case it was vmmon and vmnet (I ran this twice) for oyu it is probably soffice.bin /usr/src/kernels/$(uname -r)/scripts/sign-file sha256 ./MOK.priv ./MOK.der $(modinfo -n vmmon) Will this work? Probably not. If you are using Fedora, why not just use the version in the repo? I only mention all this because if it were me I would try it, but I am on Fedora 35 now and I am using the version from the fedora repo. Andrew -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] My Question About Security
Sorry, my email software is insisting that I top post. I can write a macro that will cause all sorts of problems But by default you will be warned that a document or template had macros. And this is not limited to LO. I am not familiar with a mechanism that can push my files of the computer without running a macro. Would love to know what that is. Please share. On Jan 27, 2022, 6:37 PM, at 6:37 PM, toki wrote: > >On 27/01/2022 11:59, Gabriele Ponzo wrote: >> Your file is safe as long as it stays on your computer, but if you >use some >> Cloud storage such as OneDrive, DropBox or any other, we cannot grant >it's >> security. >> And anyway, LibreOffice (usually) does not encrypt files. But yes, it >does >> not send them anywhere either, unless you ask it to do that. > >I'm being picky here, but templates can be created, and extensions can >be written, to send documents somewhere without the knowledge, consent, > >or authorization of the document creator. > >AFAIK, none of the currently available extensions _or_ templates >available on the LibO website have that security flaw. > >If one wants to dig deep into LibO configuration files, you can adjust >settings so that even if a malicious extension, or template is used, it > >won't send anything to the outside world. >(Considering the current political climate, it probably would be a good > >idea to document that procedure, and put it on the LibO Documentation >page.) > >tldr: Don't install any extensions, create your own templates, and >you'll be secure. > >jonathon > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calc airithmetic snafu
Left will return a string so convert to a number using value... Something like this =Value(left()) Get BlueMail for Android On Nov 26, 2021, 9:12 AM, at 9:12 AM, "Hylton Conacher (ZR1HPC)" wrote: >Hi, > >Using LO 7.2.2.2 Calc on iMac 11.6.1(Big Sur). > >I have a data column that ends in alphabetic letters i.e. > > C | D >2| 2.4 km| 2.4 >3| 4.8 km| 4.8 > >As the ' km' can't be added in column C, I used the LEFT formula to >only >extract the first 3 digits, namely =LEFT(C2,3). This works wonderfully >in column D, BUT whilst not shown on the spreadsheet, the numbers are >shown in-between double quotes if one looks at the formula, in column >D, >with the Function Wizard, which again does not enable the number to be >added, averaged etc. > >Both C, D columns are formatted as Number with a single decimal point >and there will be no -ve number. > >What am I missing, and where to rectify it? > >Regards >Hylton > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question
I believe the default is no... Check your settings... Cannot check now (away from computer) Also, excel macros are not 100 percent supported. Get BlueMail for Android On Oct 6, 2021, 7:19 AM, at 7:19 AM, sleepy wrote: >Does LibreOffice Calc have macros turned on by default? I accidently >opened >a xlsx file using Calc and I'm a really paranoid and think the file is >infected I meant to download it but I accidently opened it > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Counting cells
Not near a computer to test but I think you want the countif function Get BlueMail for Android On Mar 25, 2021, 5:13 AM, at 5:13 AM, Joe Conner wrote: >I am confused about how to count a number of cells that have a number. >In Calc, if cells a1:a11 each may or may not have a number in it, what >formula may I use to count how many cells have a number? I do not want >the sum of the numbers, just how many cells contain a number. > >Thank you. > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Basic macro to insert a custom shape into a page ?
So my guess that you were using the gallery was wrong. On the bright side, I did figure out how to access the gallery :-) It looks like you were provided a solution with using a custom shape, another thing I have not done before! Good Luck! Andrew Pitonyak On Thursday, February 11, 2021 15:53 EST, Regina Henschel wrote: Andrew Pitonyak schrieb am 11.02.2021 um 20:06: > > This might seem obvious, but: > > 1. What document type? Calc > > 2. What is a "custom" shape? Do you mean com.sun.star.drawing.CustomShape Yes > > Not that I have never used Cutom Shapes in any way in LibreOffice, but i have > written a Macro at least once. :-) > > I have written code that adds things such as lines (and other shapes) into > documents. > > I might have looked at something in LO that allows me to have a bunch of > shapes. On my computer, I use > > View > Gallery > > Too open it. From there it looks like I can drag objects out of the "gallery" > and onto a document. That makes a kind of copy&paste. I need an object newly created with the mouse. When you click on a shape icon in the toolbar and then click and drag with the mouse to create the shape, then the created custom shape is on a wrong layer. You notice in the "Drawing object properties"-toolbar, that both "To Foreground" and "To Background" are enabled. "To Foreground" should not be enabled, because when you create a custom shape with the mouse, you are working already in the "Foreground". I have a patch for it, but struggle with the unit test. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Basic macro to insert a custom shape into a page ?
This might seem obvious, but: 1. What document type? 2. What is a "custom" shape? Do you mean com.sun.star.drawing.CustomShape, or do you mean a Custom Shape that you have added to a Library? Not that I have never used Cutom Shapes in any way in LibreOffice, but i have written a Macro at least once. :-) I have written code that adds things such as lines (and other shapes) into documents. I might have looked at something in LO that allows me to have a bunch of shapes. On my computer, I use View > Gallery Too open it. From there it looks like I can drag objects out of the "gallery" and onto a document. I had forgotten you can do that in LO. Is this the type of graphic that you want to insert? Not that I know how, but I am trying to clarify in case it is something that I do know how to do. On Thursday, February 11, 2021 13:08 EST, Regina Henschel wrote: Hi all, does someone has a basic macro snippet for to insert a custom shape (e.g. a smiley) into a page? Background: For a unit test I need to insert a custom shape via code similar to as it is done via mouse. But I have no idea how to code it. A macro might give me an initial stage for a solution. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Can you please associate my extension to me?
Although I could manage it, I could no longer find it except to manage it... Cannot check it again until Sunday when I am again near a computer Sent from BlueMail On Oct 2, 2020, 3:13 AM, at 3:13 AM, Heiko Tietze wrote: >On 01.10.20 22:11, Andrew Pitonyak wrote: >> I noticed it seemed to have just disappeared but I can see if to >maintain it but not navigate to it. my best guess is that it is because >I inadvertently changed the title but I don't really know. I tried to >put entitled back, but did not cause it to reappear. > >Your extension has the status MODIFIED (whatever than means); maybe >this causes >it not being shown on the page? Or do you talk about the "Manage your >extensions" section, which is empty for me for some reason. In any case >you are >welcome to file a ticket on >https://redmine.documentfoundation.org/projects/extensions/issues > >Cheers, >Heiko > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Can you please associate my extension to me?
I noticed it seemed to have just disappeared but I can see if to maintain it but not navigate to it. my best guess is that it is because I inadvertently changed the title but I don't really know. I tried to put entitled back, but did not cause it to reappear. Sent from BlueMail On Oct 1, 2020, 11:12 AM, at 11:12 AM, Dave Howorth wrote: >On Thu, 1 Oct 2020 15:59:01 +0200 >Heiko Tietze wrote: > >> Publishing is only possible for admins. We consider to make this >> available in future. I pushed the button now... > >Page not found > >> On 01.10.20 14:37, Andrew Pitonyak wrote: >> > >> > I think that I am missing something obvious. How do I change the >> > latest version from DRAFT to published so that people can download >> > it? >> > >> > On Thursday, October 01, 2020 02:12 EDT, Heiko Tietze >> > wrote: Done, you are now the >> > maintainer of this extension. >> > >> > Many thanks for your contribution, >> > Heiko >> > >> > On 30.09.20 21:16, Andrew Douglas Pitonyak wrote: >> >> >> >> Is anyone able to associate this extension to me: >> >> >> >> >https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter >> >> >> >> >> >> If you cannot associate the extension to "and...@pitonyak.org", >> >> can I email the latest version for upload. >> >> >> >> >> >> >> > >> > -- >> > Dr. Heiko Tietze, UX-Designer and UX-Mentor >> > Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org >> > The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE >> > Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts >> > Legal details: https://www.documentfoundation.org/imprint >> > >> > >> > -- >> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> > Problems? >> > >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> > Posting guidelines + more: >> > https://wiki.documentfoundation.org/Netiquette List archive: >> > https://listarchives.libreoffice.org/global/users/ Privacy Policy: >> > https://www.documentfoundation.org/privacy >> > >> > >> > >> > >> > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Can you please associate my extension to me?
Ahh... It all makes sense now... Sent from BlueMail On Oct 1, 2020, 10:00 AM, at 10:00 AM, Heiko Tietze wrote: >Publishing is only possible for admins. We consider to make this >available in >future. I pushed the button now... > >On 01.10.20 14:37, Andrew Pitonyak wrote: >> >> I think that I am missing something obvious. How do I change the >latest version from DRAFT to published so that people can download it? >> >> On Thursday, October 01, 2020 02:12 EDT, Heiko Tietze > wrote: >> Done, you are now the maintainer of this extension. >> >> Many thanks for your contribution, >> Heiko >> >> On 30.09.20 21:16, Andrew Douglas Pitonyak wrote: >>> >>> Is anyone able to associate this extension to me: >>> >>> >https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter >>> >>> >>> If you cannot associate the extension to "and...@pitonyak.org", can >I email the >>> latest version for upload. >>> >>> >>> >> >> -- >> Dr. Heiko Tietze, UX-Designer and UX-Mentor >> Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org >> The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE >> Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts >> Legal details: https://www.documentfoundation.org/imprint >> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> >> >> >> > >-- >Dr. Heiko Tietze, UX-Designer and UX-Mentor >Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org >The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE >Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts >Legal details: https://www.documentfoundation.org/imprint > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Can you please associate my extension to me?
I think that I am missing something obvious. How do I change the latest version from DRAFT to published so that people can download it? On Thursday, October 01, 2020 02:12 EDT, Heiko Tietze wrote: Done, you are now the maintainer of this extension. Many thanks for your contribution, Heiko On 30.09.20 21:16, Andrew Douglas Pitonyak wrote: > > Is anyone able to associate this extension to me: > > https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter > > > If you cannot associate the extension to "and...@pitonyak.org", can I email > the > latest version for upload. > > > -- Dr. Heiko Tietze, UX-Designer and UX-Mentor Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: https://www.documentfoundation.org/imprint -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Can you please associate my extension to me?
Thanks, I will push a new version today Sent from BlueMail On Oct 1, 2020, 2:14 AM, at 2:14 AM, Heiko Tietze wrote: >Done, you are now the maintainer of this extension. > >Many thanks for your contribution, >Heiko > >On 30.09.20 21:16, Andrew Douglas Pitonyak wrote: >> >> Is anyone able to associate this extension to me: >> >> >https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter >> >> >> If you cannot associate the extension to "and...@pitonyak.org", can I >email the >> latest version for upload. >> >> >> > >-- >Dr. Heiko Tietze, UX-Designer and UX-Mentor >Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org >The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE >Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts >Legal details: https://www.documentfoundation.org/imprint > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?
On Monday, July 13, 2020 16:26 EDT, Gilles wrote: steveedmonds wrote > Possibly first you need to make sure that there is no direct formatting > applied to the paragraphs as this will override the style setting. Note > that clearing direct formatting will clear any bolding/italics and > super/sub scripts. Good to know, thanks for the tip (that's Format > Clear Direct Formating, CTRL+M). Is there a way to turn all paragraphs from Default Style to Text Body in one go? Having to do this for all paragraphs over 200 pages doesn't sound like fun. You can do this with search and replace. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Confused with Macro results??
ot; Years "&MOD(DATEDIF( A2, A1,"m"),12)&" Months "&DATEDIF(A2 ,A1 ,"md")&" Days" Originally wanted to just copy the formula, and change the A2,A1 to the new values. Recording it worked just fine, and did everything correctly in the recording process, but the play back didn't include the last steps using the F2 key. I've just now done a new version that does seem to work, but it made the process a lot longer... Was a mess getting all the "s correct, but it seems to work the way I want, just required manually replacing each value versus using the search and replace substitute command?? sub Z3rem --rem define variablesdim document as objectdim dispatcher as objectrem --rem get access to the documentdocument = ThisComponent.CurrentController.Framedispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem --dim sText sText = InputBox ("Please enter Date Cells Example D2,D1:") rem --dim args1(0) as new com.sun.star.beans.PropertyValueargs1(0).Name = "StringName"args1(0).Value = "=IF(DATEDIF(" & sText & ",""y""),IF(DATEDIF(" & sText & ",""y"")=1,""1 Year "",DATEDIF(" & sText & " ,""y"")&"" Years ""),"""")&IF(MOD(DATEDIF(" & sText & ",""m""),12),IF(MOD(DATEDIF(" & sText & ",""m""),12)=1,""1 Month "",MOD(DATEDIF(" & sText & ",""m""),12)&"" Months ""),"""")&IF(DATEDIF(" & sText & ",""md""),IF(DATEDIF(" & sText & ",""md"")=1,""1 Day "",DATEDIF(" & sText & " ,""md"")&"" Days""),"""")" dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args1()) end sub On 4 Jul 2020 at 20:54, Andrew Pitonyak wrote: From: "Andrew Pitonyak" Date sent: Sat, 04 Jul 2020 20:54:34 -0400Copies to: users@global.libreoffice.orgTo: Michael D. Setzer II Subject: Re: [libreoffice-users] Confused with Macro results?? > > > Might I ask what you want the macro to do? Your macro confuses me a bit...> > That said, the actual API has a very harsh learning curve (in my opinion). If I rip apart what I see, > I would guess the following:> > The user enters some text, which represents a set of cells separated by a comma.> > Next, you do things with these cells based on a very complicated formula. I am not familiar with > the EnterString dispatch off hand, but I assume that it places whatever this string is into a cell.> > Next you call the dispatcher to Copy to the clipboard followed by Cutting to the clipboard. That > seems redundant.> > > Next you have InsertContents, again, a dispatch command with which I have no familiarity, but, > off hand it looks like it is probably doing something similar to "Paste", but I am just guessing.> > So, what do you really want to accomplish?> > > > On Saturday, July 04, 2020 18:30 EDT, "Michael D. Setzer II" wrote:> > Been doing a lot of googling, but finding lots of stuff, but nothing > that works?> Have done a lot of versions and this is the latest one.> The record process does not allow for the use of the F2 key, so as > is, it> results in the original args1(0).Value being in the cell?> After the macro ends, I've found that if I manually press F2 then a > space and> enter it puts the formula as I originally wanted? F2 and enter does > nothing??> I've also found that if I manually do F2 F9 Enter Enter, it will place > just the> final text result in cell.> > Seems there use to be a Keypress option, that would allow for > simulating> keys, but that has been deprecated?> Also, found pages that talk about API stuff to modify cells, but the > two I tried> did nothing?> > Am I missing something??> > Note: In string I replaced the original "s with _ because it kept > giving me > messages about unbalanced ()?? That
Re: [libreoffice-users] Confused with Macro results??
I think that the correct answer is that you simply write your own function. That way you do not need to copy the long messy function and replace some text. Based on what you just said, however, assume that the intent is that you will modify the active cell to refernece the values in question. That would look something like this: (now I go see if i can make it work). And much hinges on how fancy / smart you want to make the portion that figures out what cell is selected. Remember, it is possible that you select a range when you run the macro, but. I know this is wrong because on my machine it complains about the "md" parameter, but I will not try to figure that out, it is 11:00 PM and I have not had my dinner yet. I hope that this helps at least a little bit. But this places the formula where you need it, you just need to (1) figure out how to call it and (2) what that formula needs to be. Let me know what you figure out. Dim s As String Dim sNew As String Dim sNewDates As String sNewDates = "D1, D2" sNewDates = InputBox ("Please enter Date Cells Example D2,D1:") ' Assume for a moment that you do want to do a simple string substitution. ' This will ONLY work if you are consistent on how "A2, A1" is represented in the string. ' The code you sent, it was not consistent. It was "A2, A2", A2 ,A2", and others. ' This example is consistent. ' Two double quotes works as an embedded double quote, so: s = "=IF(DATEDIF( A2, A1,""y""),IF(DATEDIF( A2, A1,""y"")=1,""1 Year "",DATEDIF( A2, A1,""y"")&"" Years ""),)&IF(MOD(DATEDIF(A2, A1 ,""m""),12),IF(MOD(DATEDIF( A2, A1,""m""),12)=1,""1 Month "",MOD(DATEDIF(A2, A1 ,""m""),12)&"" Months ""),)&IF(DATEDIF(A2, A1 ,""md""),IF(DATEDIF( A2, A1,""md"")=1,""1 Day "",DATEDIF(A2, A1,""md"")&"" Days""),)" ' You want to make a substitution. ' This gives you the string of interest. sNew = Replace(s, "A2, A1", sNewDates) Print sNew ' That said, what if you just do the entire calculation without using fancy dispatches. ' Even easier, you could write a function that is called from Calc and pass in two dates. Dim sDateCells() sDateCells = Split(sNewDates, ",") If UBound(sDateCells) <> 1 Then Print "Expected two dates" Exit Sub End If ' Get the current active sheet Dim oSheet oSheet = ThisComponent.CurrentController.getActiveSheet() Dim oRanges 'A blank range created by the document Dim oActiveCell 'The current active cell REM Force a single cell selection and discard the existing multi-selection if there is one. REM Create an empty SheetCellRanges service and then select it. REM This leaves ONLY the active cell selected. oRanges = ThisComponent.createInstance("com.sun.star.sheet.SheetCellRanges") ThisComponent.CurrentController.Select(oRanges) REM Get the active cell! oActiveCell = ThisComponent.CurrentSelection oActiveCell.setFormula(sNew) On Saturday, July 04, 2020 20:27 EDT, "Michael D. Setzer II" wrote: Basically, I want the macro to be able to work completely on its own. Agree that having to do the steps with the F2 and other keys is a problem. Not sure why the recorder refuses to record those steps?? The original formula is =IF(DATEDIF(A2,A1,y),IF(DATEDIF(A2,A1,y)=1,1 Year,DATEDIF(A2,A1,y)Years),)IF(MOD(DATEDIF(A2,A1,m),12),IF(MOD(DATEDIF(A2,A1,m),12)=1,1 Month,MOD(DATEDIF(A2,A1,m),12)Months),)IF(DATEDIF(A2,A1,md),IF(DATEDIF(A2,A1,md)=1,1 Day,DATEDIF(A2,A1,md)Days),) But to use the formula in a different location or with dates in different relative locations would require one to manually edit the formula and change all the A2,A1 settings to the new settings. Doing it 9 times. Thus the macro prompts for the new addresses, and changes them all. Problem is it leaves the formula contents displayed rather than the result?? Requiring the use of the F2 key and other keys. Have found the copy paste isn't required, but it changes the manual key options require to get the results. sub Z2 rem -- rem define variables dim documentas object dim dispatcher as object rem -- rem get access to the document document= ThisComponent.CurrentController.Frame dispatcher = createUnoService(com.sun.star.frame.DispatchHelper) rem -- dim sText sText = InputBox (Please enter Date Cells Example D2,D1:) rem -- dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name =StringName args1(0).Value ==SUBSTITUTE(SUBSTITUTE(=IF(DATEDIF(A2,A1,_y_),IF(DATEDIF(A2,A1,_y_)=1,_1 Year _,DATEDIF(A2,A1,_y_)_ Years _),__)IF(MOD(DATEDIF(A2,A1,_m_),12),IF(MOD(DATEDIF(A2,A1,_m_),12)=1,_1 Month _,MOD(DATEDIF(A2,A1,_m_),12)_ Months _),__)IF(DATEDIF(A2,A1,_md_),IF(DATEDIF(A
Re: [libreoffice-users] Confused with Macro results??
Might I ask what you want the macro to do? Your macro confuses me a bit... That said, the actual API has a very harsh learning curve (in my opinion). If I rip apart what I see, I would guess the following: The user enters some text, which represents a set of cells separated by a comma. Next, you do things with these cells based on a very complicated formula. I am not familiar with the EnterString dispatch off hand, but I assume that it places whatever this string is into a cell. Next you call the dispatcher to Copy to the clipboard followed by Cutting to the clipboard. That seems redundant. Next you have InsertContents, again, a dispatch command with which I have no familiarity, but, off hand it looks like it is probably doing something similar to "Paste", but I am just guessing. So, what do you really want to accomplish? On Saturday, July 04, 2020 18:30 EDT, "Michael D. Setzer II" wrote: Been doing a lot of googling, but finding lots of stuff, but nothing that works? Have done a lot of versions and this is the latest one. The record process does not allow for the use of the F2 key, so as is, it results in the original args1(0).Value being in the cell? After the macro ends, I've found that if I manually press F2 then a space and enter it puts the formula as I originally wanted? F2 and enter does nothing?? I've also found that if I manually do F2 F9 Enter Enter, it will place just the final text result in cell. Seems there use to be a Keypress option, that would allow for simulating keys, but that has been deprecated? Also, found pages that talk about API stuff to modify cells, but the two I tried did nothing? Am I missing something?? Note: In string I replaced the original "s with _ because it kept giving me messages about unbalanced ()?? That got rid of the errors, and then just converted them back? Not and important macro, but was just hoping to find a way to make it work the way I originally planned. Just playing around with stuff. Thanks. Perhaps I am overlooking something very simple.. sub Z1 rem -- rem define variables dim document as object dim dispatcher as object rem -- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem -- dim sText sText = InputBox ("Please enter Date Cells Example D2,D1:") rem -- dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name = "StringName" args1(0).Value = "=SUBSTITUTE(SUBSTITUTE(""=IF(DATEDIF(A2,A1,_y_),IF(DATEDIF(A2, A1,_y_)=1,_1 Year _,DATEDIF(A2,A1,_y_)&_ Years _),__)&IF(MOD(DATEDIF(A2,A1,_m_),12),IF(MOD(DATEDIF(A2,A1,_m_),1 2)=1,_1 Month _,MOD(DATEDIF(A2,A1,_m_),12)&_ Months _),__)&IF(DATEDIF(A2,A1,_md_),IF(DATEDIF(A2,A1,_md_)=1,_1 Day _,DATEDIF(A2,A1,_md_)&_ Days_),__)"",""A2,A1""," & chr$(34) & sText & chr$(34) & "),""_"",CHAR(34))" dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args1()) rem -- dispatcher.executeDispatch(document, ".uno:Copy", "", 0, Array()) rem -- REM Cut contents of cell to avoid the overwrite message dispatcher.executeDispatch(document, ".uno:Cut", "", 0, Array()) rem -- dim args2(5) as new com.sun.star.beans.PropertyValue args2(0).Name = "Flags" args2(0).Value = "SVD" args2(1).Name = "FormulaCommand" args2(1).Value = 0 args2(2).Name = "SkipEmptyCells" args2(2).Value = false args2(3).Name = "Transpose" args2(3).Value = false args2(4).Name = "AsLink" args2(4).Value = false args2(5).Name = "MoveMode" args2(5).Value = 4 dispatcher.executeDispatch(document, ".uno:InsertContents", "", 0, args2()) msgbox ("To complete process,"+chr$(13)+" Formula Press F2 then Space then Enter" + chr$(13)+"For Text Result Press F2 then F9 then Enter then Enter") end sub ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.or
Re: [libreoffice-users] Bug selecting text using the API
Can you report this? If not I will do so Sent from BlueMail On Oct 21, 2019, 12:00 AM, at 12:00 AM, Mauricio Baeza wrote: >On Sun, 20 Oct 2019 23:41:50 -0400, Andrew Pitonyak > wrote: > >> Thanks for testing. We now have three instances where this fails. >> >> If you still want the document I can send it, but, I think that the >list strips attachments I would need to send it to you directly >> > > >It's ok... You or I report this? > >Best regards >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Bug selecting text using the API
Thanks for testing. We now have three instances where this fails. If you still want the document I can send it, but, I think that the list strips attachments I would need to send it to you directly Sent from BlueMail On Oct 20, 2019, 11:00 PM, at 11:00 PM, Mauricio Baeza wrote: >On Sun, 20 Oct 2019 21:07:26 -0400, Andrew Douglas Pitonyak > wrote: > >> >> Tested using LO 6.2.0.3 on Fedora Linux. >> >> I wanted to find all instances of Italic text using the API and >select >> that text. I created a simple document with four areas that were >Italic. >> I used the following macro and, although FindAll does return all >italic >> text, it only selects the last three instances and not the first one. >> >> >> My example had two instances in normal text and two instances in a >text >> table. >> >> If I have more than once instance, it ignores the first. If I have >ONLY >> one instance of Italic text, it will select the text. >> >> >> Sub FindItalic_all >> Dim oDescriptor 'The search descriptor >> Dim oFound 'The found range >> Dim SrchAttributes(0) as new com.sun.star.beans.PropertyValue >> >> SrchAttributes(0).Name = "CharPosture" >> SrchAttributes(0).Value = com.sun.star.awt.FontSlant.ITALIC >> ' SrchAttributes(0).Name = "CharFontName" >> ' SrchAttributes(0).Value = "Comic Sans MS" >> >> oDescriptor = ThisComponent.createSearchDescriptor() >> oDescriptor.SetSearchAttributes(SrchAttributes) >> >> oFound = ThisComponent.findAll(oDescriptor) >> >> ' Dim i As Integer >> ' for i = 0 To oFound.Count - 1 >> ' Print oFound.getByIndex(i).getString(i) >> ' Next >> Thiscomponent.getCurrentController.select(oFound) >> End Sub >> > > >I confirm the same bug, with Python: > >from com.sun.star.beans import PropertyValue >from com.sun.star.awt.FontSlant import ITALIC > >doc = XSCRIPTCONTEXT.getDocument() > >opt = (PropertyValue(Name='CharPosture', Value=ITALIC),) >descriptor = doc.createSearchDescriptor() >descriptor.setSearchAttributes(opt) > >found = doc.findAll(descriptor) >doc.CurrentController.select(found) > >Always select len(found) - 1 > >I search if bug is reported, but not found any. > > >Best regards >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Reveal code, old macros convert them to LO
Indeed... A single style may cause multiple changes. I don't remember how that is displayed in the macro. Sent from BlueMail On Jul 4, 2019, 10:33 PM, at 10:33 PM, jomali wrote: >I don't remember the details of the sxw format. Perhaps reveal codes >were >appropriate then. However, ODF files have a complex SGML or HTML or XML >type format, along with a form of CSS, unlike WordPerfect and similar >programs, which used embedded code to delineate format changes. That >is, >there are no format codes to reveal in ODF documents. Any program that >pretended to show some kind of "format code" would be hopelessly >misleading. > >On Thu, Jul 4, 2019 at 2:01 AM Uwe Brauer wrote: > >> Hi >> >> >From time to time the question pops up whether LO could support >> Wordperfects reveal code. The developer are not too keen, and >sometimes >> it is stated that this feature could be implemented by a >> macro/extension. >> >> Now I remember that long time ago such macros existed and using the >> wayback machine I found them. They were written around 2005 for OO >1.2, >> using the sxw format. >> >> I tried them out in LO 6.2 and they don't work. >> >> Is there somebody with enough knownledge in macros to translate those >> macros to LO 6.2? >> >> Thanks and regards >> >> Uwe Brauer >> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> >> > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Reveal code, old macros convert them to LO
I don't think it was that much code. I might even have a working copy from a few years back, but won't have computer access until next week. Might have deleted it. If you can't make it work, remind me next week and I can take a look. Sent from BlueMail On Jul 4, 2019, 11:04 AM, at 11:04 AM, Johnny Rosenberg wrote: >Den tors 4 juli 2019 kl 08:03 skrev Uwe Brauer : > >> Hi >> >> >From time to time the question pops up whether LO could support >> Wordperfects reveal code. The developer are not too keen, and >sometimes >> it is stated that this feature could be implemented by a >> macro/extension. >> >> Now I remember that long time ago such macros existed and using the >> wayback machine I found them. They were written around 2005 for OO >1.2, >> using the sxw format. >> >> I tried them out in LO 6.2 and they don't work. >> >> Is there somebody with enough knownledge in macros to translate those >> macros to LO 6.2? >> > >How much code are we talking about? > >Kind regards > >Johnny Rosenberg > >> >> Thanks and regards >> >> Uwe Brauer >> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> >> > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Reveal code, old macros convert them to LO
just so we're clear, the macro functionality was not even close to the functionality in word perfect. all the macro did, was displaying a dialogue all of the codes. There is certainly a lot of use for this, but nothing near what you do automatically in word perfect. Sent from BlueMail On Jul 4, 2019, 12:15 PM, at 12:15 PM, John wrote: >On Thu, 2019-07-04 at 07:45 +0200, Uwe Brauer wrote: >> Hi >> >> > From time to time the question pops up whether LO could support >> Wordperfects reveal code. The developer are not too keen, and >sometimes >> it is stated that this feature could be implemented by a >> macro/extension. >> >> Now I remember that long time ago such macros existed and using the >> wayback machine I found them. They were written around 2005 for OO >1.2, >> using the sxw format. >> >> I tried them out in LO 6.2 and they don't work. >> >> Is there somebody with enough knownledge in macros to translate those >> macros to LO 6.2? >> >> Thanks and regards >> >> Uwe Brauer >> >Just in case any further support for this change is desired, one of the >all-time >BEST features of Word Perfect was "reveal codes". You could actually >use it to >figure out why the page format was not as expected! > >I would love to see this feature added to Libre Office! > >John >> > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] automatic font selection in macro
I would have used a text cursor, but, the recorded Macro is trivially modified to remove the font name, you just need to know that you can do that :-) sub insertAlphaNoFont rem -- rem define variables dim document as object dim dispatcher as object rem -- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem -- dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name = "Symbols" args1(0).Value = "α" dispatcher.executeDispatch(document, ".uno:InsertSymbol", "", 0, args1()) end Sub Lot easier than another solution (if you really did need the font name), which would look at the text cursor and pull the current font and use that. Inserting text at a text cursor (view cursor) should also not have needed a font. On Wednesday, February 13, 2019 00:51 EST, Thomas Blasejewicz wrote: On 2019/02/13 13:26, Andrew Pitonyak wrote: > if I wrote a macro that inserts the letter 'X', I would not expect the > insertion to specify the font unless I went out of my way to do so. > > I am interested in seeing the macro that you are using. Well, I am not actually "writing" the macro - I have no idea how to do that. I use "Tools -> Macros -> Record macro" and open the "insert special characters dialog box". THIS is where the problem is. As far as I can tell, there is no way NOT to select a font in that dialog. On top you have the "Search / Font / Subset" fields. "Font" gives you a list of fonts, but not the choice of "none / automatic" etc. - or allows you to delete the currently selected font. I had been hoping to find that kind of choice. Mr. Pitonyak. Please don't worry. I am not in a hurry. I have been pondering this for years already ... Thank you. Thomas Blasejewicz > > > > Sent from BlueMail <http://www.bluemail.me/r?b=14470> > On Feb 12, 2019, at 9:55 PM, Thomas Blasejewicz <mailto:ny...@hb.tp1.jp>> wrote: > > Good morning > I have another strange question. > Work related I have to insert not infrequently symbols into texts. > To make work easier, I have already created a number of macros to insert > for example the symbol "micro" into a text using a keyboard shortcut. > > Problem: > Let's say, I created the macro in a document that happened to use > "Arial" as font and later want to use it in a document that uses "Times > Roman". The macro I created then inserts an "Arial font micro" into the > Times Roman text, which then looks out of place. > > Is there a trick to create macros, so that the inserted symbol matches > the surrounding font? > I have tried all sorts of things, but could not yet find a solution. > It is not really a "problem", but such an automatic font adjustment > would be nice/helpful. > > Thank you. > Thomas > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] automatic font selection in macro
if I wrote a macro that inserts the letter 'X', I would not expect the insertion to specify the font unless I went out of my way to do so. I am interested in seeing the macro that you are using. I'm not able right now to try to find a macro that would do what you want, but if you can't find one let me know, and I will see if I can provide one for you after I look at the macro you are using now. Understand, however, the next two days for me will be hit or miss on availability. Sent from BlueMail On Feb 12, 2019, 9:55 PM, at 9:55 PM, Thomas Blasejewicz wrote: >Good morning >I have another strange question. >Work related I have to insert not infrequently symbols into texts. >To make work easier, I have already created a number of macros to >insert >for example the symbol "micro" into a text using a keyboard shortcut. > >Problem: >Let's say, I created the macro in a document that happened to use >"Arial" as font and later want to use it in a document that uses "Times > >Roman". The macro I created then inserts an "Arial font micro" into the > >Times Roman text, which then looks out of place. > >Is there a trick to create macros, so that the inserted symbol matches >the surrounding font? >I have tried all sorts of things, but could not yet find a solution. >It is not really a "problem", but such an automatic font adjustment >would be nice/helpful. > >Thank you. >Thomas > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Libre Calc – Excel corrected?
In Word, you can toggle among small case – initial caps - all caps easily – but not in Excel. Er, we are not talking about Word, either! Can you toggle among case sizes in Libre Calc? Not that I know of. But you could easily copy material into a text (Writer) document, modify it there, and copy it back. If you use Paste Special... and paste it into the text document as HTML you should see a table. That way, you can handle arbitrary ranges in one go, not just individual cells. I created a Calc document. Step 1: Select all cells of interest: Step 2: Use (1) Format > UPPERCASE (2) Format > lowercase (3) Format > Capitalize Every Word (4) Format > Sentence Case (5) Format > Toggle case This directly changes the text of interest, but, I think that it will NOT affect text shown that is produced by an equation. For example, =UPPER(A1) will always show as upper case. In Write, special case is handled using the Character Style. I do not believe that you can use a character style in Calc. A character style dictates how characters are displayed. They have a property CharCaseMap Specify how characters should be displayed using the com.sun.star.style.CaseMap constant group. This does not change the actual text—only the way it is displayed. • NONE = 0 – No case mapping is performed; this is the most commonly used value. • UPPERCASE = 1 – All characters are displayed in uppercase. • LOWERCASE = 2 – All characters are displayed in lowercase. • TITLE = 3 – The first character of each word is displayed in uppercase. • SMALLCAPS = 4 – All characters are displayed in uppercase, but with a smaller font. If you edit a character style, click on the Font Effects tab and the "Effects" drop-down allows you to set this. In calc, if you Format a Cell, there is also a Font Effects tab, but, there is no "Effects" drop-down or any other way to change how the text is displayed with respect to case. Although a Calc cell contains a text object, I do not see the CharCaseMap property in the text object. Seems that CharCsaeMap is an optional property so it need not be supported https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1style_1_1CharacterProperties.html#ab8138e9a5d1a97f5fbbc2b431ca0cffa I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Error When Closing Document Using Automation
Sorry, I do not know what is going on, but DO you see anything different if you: 1. Pause for a few seconds before you call close? In the back of my mind I am wondering if for some silly reason, control returns to you before the save command finishes running. 2. out of curiousity, what value is in the isModified property? 3. I assume that you are calling terminate on the desktop object, is this correct? 4. Assuming you sleep a few seconds first, what happens if you call dispose on the document rather than close? I do not even know if the dispose method still exists, but, if it does. Note that you should not in general use dispose, but, that is what existed before close() was added to the API. On 2018-08-31 13:00, dCipher wrote: Hi I have been automating Calc for years from Visual FoxPro. It has worked flawlessly until this week. Now the document close method often produces an ole error 80010105. I was using verison 5.1 so I updated everything to the latest 6.1 version but the problem persists. If I remove the Close() method and just use Terminate() I get the same result that 30%-50% of the time it crashes. The spreadsheet is created correctly but Libre Office crashes on the Close() method. Does anyone have any ideas what might be the cause? I am running on Windows Server 2012 64bit. I am using the 32bit version of Libre Office. If I try opening the document in Calc and makes some changes then use "Close" from the File menu. I am prompted to save the document and everything closes as expected. It only seems to occur when automating the process. laArgs(1).Name="FilterName" laArgs(1).Value="MS Excel 97" laArgs(2).Name="Overwrite" laArgs(2).Value=.T. ComArray(toBizObj.oMergeDoc,10) toBizObj.oMergeDoc.storeAsURL(ConvertToURL(toParam.Destination),@laArgs) toBizObj.oMergeDoc.close(1) <== Produces and error 30% - 50% of the time toBizObj.oMerge.Terminate() Thanks, Simon -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: Calc macro: write korean characters in atext file
I just checked OOME 4, and I think that I have a glaring omission in that I do not test or document the behavior of using write or print with special characters. Sadly, I do not know the answer off hand, but, I expect that you are seeing that they are not properly supported. Can you try using Simple File Access instead and let me know if that works? There is an example her: http://www.pitonyak.org/oo.php http://www.pitonyak.org/OOME_4_0.odt I include the example here, but, you should be able to see what you need to do. Also note that the ODT documents contains the macros and you can run the test program while reading the document if you eneable macros when you load the document. This is the example macro: Sub ExampleSimpleFileAccess Dim oSFA' SimpleFileAccess service. Dim sFileName$ ' Name of file to open. Dim oStream ' Stream returned from SimpleFileAccess. Dim oTextStream ' TextStream service. Dim sStrings' Strings to test write / read. Dim sInput$ ' The string that is read. Dim s$ ' Accumulate result to print. Dim i% ' Index variable. sStrings = Array("One", "UTF:Āā", "1@3") ' File to use. sFileName = CurDir() & "/delme.out" ' Create the SimpleFileAccess service. oSFA = CreateUnoService("com.sun.star.ucb.SimpleFileAccess") 'Create the Specialized stream. oTextStream = CreateUnoService("com.sun.star.io.TextOutputStream") 'If the file already exists, delete it. If oSFA.exists(sFileName) Then oSFA.kill(sFileName) End If ' Open the file for writing. oStream = oSFA.openFileWrite(sFileName) ' Attach the simple stream to the text stream. ' The text stream will use the simple stream. oTextStream.setOutputStream(oStream) ' Write the strings. For i = LBound(sStrings) To UBound(sStrings) oTextStream.writeString(sStrings(i) & CHR$(10)) Next ' Close the stream. oTextStream.closeOutput() oTextStream = CreateUnoService("com.sun.star.io.TextInputStream") oStream = oSFA.openFileRead(sFileName) oTextStream.setInputStream(oStream) For i = LBound(sStrings) To UBound(sStrings) sInput = oTextStream.readLine() s = s & CStr(i) ' If the EOF is reached then the new line delimiters are ' not removed. I consider this a bug. If oTextStream.isEOF() Then If Right(sInput, 1) = CHR$(10) Then sInput = Left(sInput, Len(sInput) - 1) End If End If ' Verify that the read string is the same as the written string. If sInput <> sStrings(i) Then s = s & " : BAD " Else s = s & " : OK " End If s = s & "(" & sStrings(i) & ")" s = s & "(" & sInput & ")" & CHR$(10) Next oTextStream.closeInput() MsgBox s End Sub Let me know if this works, I believe that it will. I hope that it will. On 2018-08-30 6:06, Cédric Giraud wrote: With the macro, *open *and *print *commands. Le jeu. 30 août 2018 à 05:22, Andrew Pitonyak a écrit : How do you open the file and write the text? Sent from BlueMail <http://www.bluemail.me/r?b=13569> On Aug 29, 2018, at 5:35 PM, Cegir wrote: Hi, thanks for your help I'm on Windows 10, and my keyboard is AZERTY. As French, the system is probably not UTF-8 by default. I just copy/paste hangul from another .ods file. I tried with 2 text editors and the .json reader from Firefox. It seems the problem is the macro creates an ANSI file by default, and not a UTF-8 version. I have no idea how to change it. If I create an UTF-8 file before running the macro, the macro recreates it in ANSI. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Strange Macro folder behavior
Many features are not available without Java so it lives on every computer that I own. I am not sure what the security risk is, but, since everything has one Happy to hear that your solved the problem and figured out where it is hiding. This is probably related to "where did I store my macro". If you remember... 1. Notice what Macro Library container you use. You might store a macro inside a document (and that would be a macro library container). Your choices here are really (a) some document, or (b) LibreOffice application. 2. Notice Library you used. Every Macro Library Container may contain numerous libraries. If you use the library named "Standard", then that macro will always be available, but, you cannot easily move macros stored in the standard library. 3. Notice what module you stored your macro. Each library can contain multiple modules. I hope that I have not confused you too terribly much. On 2018-07-23 17:30, Peggy wrote: Yes, I always use the record macro feature since I don't know enough to do it any other way. Thank you for the old post, I will try it. I did fiind my macros, can't even remember how I got there. I first tried an option that said I needed Java, which I don't want because I read it's a security risk. But when I declinded to enable it, Something opened and showed me the Macros. The ones I tried are working today. Thank you for the reply! On Sun, Jul 22, 2018 at 5:59 PM, Drew Jensen wrote: Howdy, So, I see that on ask libreoffice this has come up twice and both times closed out (without an answer) or left unanswered. There is an old forum post on this that might help in your case. You can find it here: https://forum.openoffice.org/en/forum/viewtopic.php?f=5&t=42324 but that is back form 2012. By any chance had you been using the Record Macro feature also? Best wishes, Drew On Sun, Jul 22, 2018 at 5:49 PM Peggy <33mar...@gmail.com> wrote: > I selected some all capitalized text in a title, wanting to make a macro to > change it to initial caps. Ran the macro, stopped it and it worked. Went to > the macros under "My macros" in the library to assign a shortcut key. > > I couldn't find the macro but found a whole new Folder named with the Title > I'd selected. Worse yet was a folder with the title of another document I'd > started. I couldn't find any way to delete either of them. > > And even worse, when I looked at "My Macros" they were all gone. > > Searched online and there were a couple of questions from people who had > lost all their macros, but they weren't answered. One was closed by a > moderator because (something like) it was untimely. Don't quote me on that. > Whatever it didn't seem the reason for closing it was valid. > > I will uninstall and reinstall Libre Office, just losing one template I > made since my macros are gone. But can anyone tell me what I did to cause > those new folders? My macors were simple but convenient, and I can create > them again. > > Peggy > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/ Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Predefinied constants (Macro, Basic)
Been there, done that. I noticed just as I was hitting send, or I would have redirected back to the list so that others could see the conversation. On 2018-07-23 16:52, Johnny Rosenberg wrote: Thank you, I'll have a look at it. Also sorry for accidentally mailing you directly, instead of the list. Kind regards Johnny Rosenberg 2018-07-23 19:15 GMT+02:00 Andrew Pitonyak : You can enumerate those with: theTypeDescriptionManager There is a method EnumerateTypesTest. Notice that there is a typeArray. I have note tested this, but, I could likely use the following two types com.sun.star.uno.TypeClass.CONSTANT, _ com.sun.star.uno.TypeClass.CONSTANTS And enumerate the constant types and print them. If I were industrious, I would dump them into a Calc document. I can think of lots of things that I could do. I have a method in the UNO module called EnumerateEnumeratsions, which, given a name, will print the names and associated values. On 2018-07-23 11:14, Johnny Rosenberg wrote: Thanks. I downloaded your OOME_4_0 document and I found it there. I was kind of hoping LibreOffice/Apache OpenOffice had its own constants so compatibility mode hasn't to be used, but not much to do about that, I guess. I already use a couple of constants when working with spreadsheets, for instance com.sun.star.sheet.CellFlags.VALUE and the others, but I haven't seen a list of all of those. Thanks for replying. Kind regards Johnny Rosenberg 2018-07-23 16:17 GMT+02:00 Andrew Pitonyak : I have not looked at the predefined constants in a while, and I do not remember how I got my list, but it was probably by reading the code. WARNING: I am about to tell you to download a document containing macros. The document looks just fine if you tell it to disable macros, but, it is a document about macro programming and almost every one of those macros is contained in libraries in the document. So, feel free to not enable them, but you will not be able to click on the buttons in the document to test run the contained macros. Navigate here: http://www.pitonyak.org/oo.php Download OpenOffice.org Macros Explained V4 (or just click on this link) http://www.pitonyak.org/OOME_4_0.odt Open the document and search for the text "vbNewLine". This should land you in table 10 Visual Basic-compatible string constants. This table lists 9 of this type of constant, but, they are only available if you enable "compatibility mode" using "Option Compatible" in the module, or, by calling CompatibilityMode(True) in your code before you use these specific constants. And no, I do not have an exhaustive list of defined constants. The constants defined by the UNO object model, you can obtain using a macro, but I do not think that it is directly related to your question so I will not spend time finding the code that does that; but it is in the document linked above. And yes, Pi is a defined constant in LO Basic. Hope this helped at least a little. On 2018-07-22 16:26, Johnny Rosenberg wrote: Hi! I have done some searching and finally I found this at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants: ”OpenOffice.org Basic predefines several constants. Among the most useful are: - True and False, for Boolean assignment statements - PI as a type Double numeric value” I assume this is true for LibreOffice as well, but I can't find the rest of the ”several constants”. At work a use Excel (I don't really want to and it's full of bugs, but at least I get paid…) and I wrote some macros in VBA. VBA has a lot of predefined constants, for instance vbNewLine and a lot more, and I'm now trying to find out what constants are available in LibreOffice Basic, since LibreOffice is what I use exclusively at home, so I don't have to reinvent the wheel. So a link to a list of ALL predefined Basic constants would be very appreciated. Kind regards Johnny Rosenberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Predefinied constants (Macro, Basic)
I have not looked at the predefined constants in a while, and I do not remember how I got my list, but it was probably by reading the code. WARNING: I am about to tell you to download a document containing macros. The document looks just fine if you tell it to disable macros, but, it is a document about macro programming and almost every one of those macros is contained in libraries in the document. So, feel free to not enable them, but you will not be able to click on the buttons in the document to test run the contained macros. Navigate here: http://www.pitonyak.org/oo.php Download OpenOffice.org Macros Explained V4 (or just click on this link) http://www.pitonyak.org/OOME_4_0.odt Open the document and search for the text "vbNewLine". This should land you in table 10 Visual Basic-compatible string constants. This table lists 9 of this type of constant, but, they are only available if you enable "compatibility mode" using "Option Compatible" in the module, or, by calling CompatibilityMode(True) in your code before you use these specific constants. And no, I do not have an exhaustive list of defined constants. The constants defined by the UNO object model, you can obtain using a macro, but I do not think that it is directly related to your question so I will not spend time finding the code that does that; but it is in the document linked above. And yes, Pi is a defined constant in LO Basic. Hope this helped at least a little. On 2018-07-22 16:26, Johnny Rosenberg wrote: Hi! I have done some searching and finally I found this at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants: ”OpenOffice.org Basic predefines several constants. Among the most useful are: - True and False, for Boolean assignment statements - PI as a type Double numeric value” I assume this is true for LibreOffice as well, but I can't find the rest of the ”several constants”. At work a use Excel (I don't really want to and it's full of bugs, but at least I get paid…) and I wrote some macros in VBA. VBA has a lot of predefined constants, for instance vbNewLine and a lot more, and I'm now trying to find out what constants are available in LibreOffice Basic, since LibreOffice is what I use exclusively at home, so I don't have to reinvent the wheel. So a link to a list of ALL predefined Basic constants would be very appreciated. Kind regards Johnny Rosenberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] About pseudo objects with Basic code ...
On 2018-07-09 14:21, Mauricio Baeza Servin wrote: On Mon, 09 Jul 2018 18:01:37 + (UTC), Andrew Pitonyak wrote: On 2018-07-09 13:25, Mauricio Baeza Servin wrote: > You can make; macros, functions of Calc (full integrated in function > wizard), extensions and new UNO components. This last part is very important for more serious programs. For certain serious integration, Basic fails, but it sounds like Python would be suitable. Of course, if you are asking what language to learn, you are not likely to write something so difficult, but, the fact that you can do it makes it easier. ok, I will write the firs very simple new UNO component, and I will documented it... Please, be merciful to my English Awesome! Also, your English is very understandable. the most important thing! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] About pseudo objects with Basic code ...
On 2018-07-09 13:25, Mauricio Baeza Servin wrote: You can make; macros, functions of Calc (full integrated in function wizard), extensions and new UNO components. This last part is very important for more serious programs. For certain serious integration, Basic fails, but it sounds like Python would be suitable. Of course, if you are asking what language to learn, you are not likely to write something so difficult, but, the fact that you can do it makes it easier. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] About pseudo objects with Basic code ...
Disclaimer: I have only used Python once to to talk to LO. In fact, I work pretty hard to write all of my "macros" in Basic because support is very consistent across platforms. I cannot comment directly on Python, but, in Basic, I do not need to worry about which interface handles which calls, that level of detail is handled for free. If I decided to not use Basic, I would evaluate which other language has the best integration, and, I cannot comment on that since I rarely leave Basic. I looked at Python because there was an issue with the Python version for a macro that someone wrote and they were having trouble with integration. My Primary complaint about Python is that the block structure is directly related to the spacing and I have had that messed with as I moved between machines and operating system. I do not expect that to be a problem if you do not move between machines and if you have full control over the editor that use in terms of how it is configured... And if you are not pasting code that others have written or from web sites. All of those issues have caused me issues all related to how Python interprets blocks. When I write code in my Python specific editor and I stay on one machine, and I do not integrate code from other places, I have no problems with it. I should note that I work with some people who feel that they must solve every problem with Python. As for your first language, I do not see a problem with using Python, but I also do not see a problem using Basic. Much depends on your end goal. Especially if you limit external dependencies, Python should run unchanged on most machines with a few caveats. Why do you want to program? More specifically, what do you want to produce? What type of programs do you want to write? (GUI, command line, control LO, etc...) How portable must your code be? If you want to write a GUI and it will only run on Windows, I think that Visual Studio has a decent environment for development. I spend way more time writing Java and C++ these days, which means that I have not been using Visual Studio lately. On 2018-07-09 6:20, Tom Davies wrote: Hi :) @ Mauricio: Wow!!! That was very eloquent! :)) Thanks :) @ Gordon: Sorry! I had a go with Pascal but got distracted and didn't get very far. It looked a LOT more elegant but i was entrenched in using Basic at the time and couldn't handle the back to basics at that point in time. @ all: Do you think Python is easy as a 1st language? - or is it better to start with something else first to ease into it all? I'm kinda playing around with Scratch a bit and kinda learning Python but at a very relaxed pace. Both seem quite good fun now :) Regards from a Tom :) On 9 July 2018 at 06:19, gordon cooper wrote: GoTo. One of the curses of Basic, the GoTo. When used by newcomers (and a few some old hands too) a Basic program would soon become an unstructured mess of GoTo's and a hassle to debug. One of our Pascal lecturers was very anti-Basic and forbade us to use it, or to even talk about it in his presence. Thank you Tom and Jonathon for the memory, Gordon. On 09/07/18 15:55, toki wrote: On 08/07/18 09:04 PM, Tom Davies wrote: I remember learning one form of basic in the 80s and that was pretty easy There is a book from the early/mid eighties, that is simply lists the vocabulary of the various dialects of BASIC in use then. IIRC, it was called _The BASIC Book_. It was written specifically for programmers to port software between the various systems that were available. Back then, all variants of basic used line numbers, and allowed GoTo. Today, several variants of BASIC don't use line number, and some variants don't have GoTo. jonathon -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un subscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Problems creating a split database
Off hand, I think that you are moving in the right direction. I have not looked at this in a very long time, but, I do have some macro information for use with Base (Written against a much earlier version of Base) available here: http://www.pitonyak.org/database/ This is a direct link to the document http://www.pitonyak.org/database/AndrewBase.odt Note that my Macro documents contain the maros in the document, which makes it possible to copy any macros that you want to use simply by importing the libraries. On the other hand, the documents contain macros, which means that you will be warned that they do contain macros. I try to create my documents such that you can run the macros directly by clicking on buttons embedded in the documents to test them. I am a bit overwhelmed with overdue tasks, but, if you notice something that is obviously no longer correct, please let me know. On 2018-03-06 8:48, Anne Wilson wrote: On 06/03/2018 13:35, zahra a wrote: hello. i downloaded getting started from libreoffice.org for free in odt format. which version of libreoffice do you need to work on? whats the different between free version and paid version of getting started? i downloaded getting started for libreoffice 5.2 in odt format from its website. i realized that it explanes macro and if you need to use macro in libreoffice, the book can help you! hope that help, God bless! Thanks for the quick reply. My books are somewhat out of date, with Getting Started being 4.2 and Base Handbook being 4.0. I had, though, noticed that both have some help with macros. Oce I'm sure that's the way to go, I'll consult them - although perhaps I should download the updated versions first :-) AnneW On 3/6/18, Anne Wilson wrote: Hello. Since this is my first post, I'll write some background first. I am deeply interested in machine embroidery, as well as general sewing. I therefore have accumulated a library of magazines with some excellent articles. The problem is finding the right article when I want to re-read it. I bought the Getting Started Guide and Base Handbook, and by constantly referring back to them, managed to get an embedded database, in which details of the article were accompanied by an image. You know what comes next. All was well until I had just over 200 entries - at which time it crashed and I lost all entries. Fortunately I had a backup up to the previous day's work, as well as an almost complete spreadsheet which had been the basis for my efforts, but there was no point in trying to do more, as all reading pointed to the problem of images causing the size to over-expand. I have now tried to create a split database, following the instructions I found online. However, I'm finding it difficult to source information on using it. Picked from the bits and pieces I've accumulated, instead of adding the image directly, I have created a text field containing a URL relative to the data folder, e.g. ../Images/OnionsAndRust.jpg. What I would like to achieve is that URL to be read in, the image displayed, then dropped when the record changes. Is this a reasonable approach? Can you point me to documentation that will help? I suspect that I need to learn to write macros for this to work, but again, providing I can find help to get started I am ready to learn. AnneW -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macros : For Each Cell in LibreOffice Basic ?
I remember writing code to go through cells... I don't remember if it was in AndrewMacro.odt or OOME.odt... Can't look it up now... Much depends on things like sizes and what you want to compare Coming off a long shift, need to sleep, if you can't find it, let me know. Sent from BlueMail On Jan 23, 2018, 6:45 AM, at 6:45 AM, stgmdn wrote: >Hello, > >I have to create a macro that read through a defined cell range, and >for >each cell, will assign it to a variable (to compare it to another >cell), >then it goes on the next cell. > >In my researches, I found that we can do this with a For Each Cell in >VBA >for Excel, but i can't seem to find the code that would do the same >thing in >LibreOffice Basic. > >Hope I've been clear enough, and thanks for your help. > > > >-- >Sent from: http://nabble.documentfoundation.org/Users-f1639498.html > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be >deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Importing a csv (tab delimited) to existing non-empty sheet (overwrite)
http://www.pitonyak.org/database/ Look at my random DB ramblings I don't remember if I have better coverage they're pretty in my primary macro book http://www.pitonyak.org/oo.php But I do explain them, but I cannot check the documents from my phone... Sent from BlueMail On Nov 20, 2017, 4:47 PM, at 4:47 PM, Johnny Rosenberg wrote: >Hi! > >I have some problems to find information about this. All I found after >hours of searching are few examples that probably work in some >situations >but certainly not what I'm looking for, > >The problem is that those examples contains a lot of anonymous numbers >and >stuff but no explanation what so ever what those numbers mean or where >I >can find the details. > >Here's the closest thing I came up with so far: >Sub Main >Dim HOME As String >Dim DirName As String >Dim FileName As String >Dim Args(1) As new com.sun.star.beans.PropertyValue > >HOME="/home/" >DirName = HOME & "/Some/Path/" >FileName = ConvertToURL(DirName & "/MyFile.csv") >' Get the latest results. >Shell(HOME & "/bin/ScriptThatCreatesMyFile.sh", True) >Args(0).Name = "FilterName" >Args(0).Value = "Text - txt - csv (StarCalc)" >Args(1).Name = "FilterOptions" >Args(1).Value = "44,34,76,1,,0,False,True,True,False" >StarDesktop.loadComponentFromURL(FileName, "_default", 2, Args()) >End Sub > >Questions: >Exactly what does ”44,34,76,1,,0,False,True,True,False” mean? Where can >I >find information about this? What is True? What is False? Why is >something >missing between two commas? Many questions come to my mind… > >Problems at the moment: > >1. The code above seems to treat my file as comma separated. I need TAB > only as separator. > 2. The CSV file is imported to a new window. I want it to overwrite >existing (old and outdated) information in columns A:D (without messing > with my conditional and unconditional formatting) on Sheet 0. > >After som further experimenting I seem to have solved problem 1. It >seems >lik means Chr(44), which is a comma, and Chr(34) os a double quote. The >following line gave me separate columns for every TAB: >Args(1).Value = "9,,76,1,,0,False,True,True,False" >But what does the rest mean? Chr(76)="L", which seems weird, so I guess >the >”76” means something else. > >I wonder why this kind of information is so hard to find. For easy >stuff, >when no manual is needed, you can find tons of information, but when >things >are a bit more cryptic, when a manual is really, really needed, you can >search for hours and find nothing, as it seems. Maybe I'm wrong, I >actually >hope I am, even if I would look stupid… :P > > > >Kind regards > >Johnny Rosenberg > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be >deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: Fwd: [libreoffice-users] Macro Dim Dialog and Control
Sorry, using my phone for this... And off the top of my head... Each object usually supports multiple interfaces... In basic, the actual type does not matter. Names starting with an x refer to an interface. I need to look it up, but I think that the preference was a variant rather than object, but... It may no longer matter The developer who told me this could not remember why it when it mattered And I only had a problem because of it once, and that was years ago. Other languages, like Java, it matters. I'd we had a smarter IDE it might be useful to declare the actual type. Sent from BlueMail On Nov 19, 2017, 5:31 PM, at 5:31 PM, Johnny Rosenberg wrote: >Oops, sorry. I did it again, I accidentally replied privately rather >than >to the list. I'm sorry for that, Robert. > >-- Forwarded message -- >From: Johnny Rosenberg >Date: 2017-11-19 23:19 GMT+01:00 >Subject: Re: [libreoffice-users] Macro Dim Dialog and Control >To: Robert Großkopf > > >2017-11-19 20:00 GMT+01:00 Robert Großkopf >: > >> Hi Jonny, >> > >> > This works, but what about oDlg and oCtl? Are there special data >types >> for >> > them too? The documentation I've found so far doesn't give any >hints at >> > all. I tried this: >> > Dim Dlg As com.sun.star.awt.XDialog ' No error here, >> > ' but next line throws an error: >> > oDlg = CreateUnoDialog(DialogLibraries.Standard.MyDialogue) >> > ' Error: No access to object. >> > 'Invalid usage of the object. >> > ' Well, something like that, it's actually in Swedish. >> >> What is the name of the dialog? Is ist called "MyDialogue"?. > > >No, I actually faked it for this mailing list. The real name is in >Swedish, >so I figured it would be easier for you guys if I picked an English >name >instead, just for this example. But the name isn't the problem anyway. >My >question is if there is an ”extended data type” for dialogs and >controls, >just like there is for sheets (com.sun.star.sheet.XSpreadsheet) and >cells ( >com.sun.star.table.XCell). I searched for and while and thought that >com.sun.star.awt.XDialog could be it for dialogs, but as I said, I got >that >error message. When I used Object, like you do below, everything worked >for >me too, but my question wasn't about getting it working, it was if >there is >such a data type. I'm not doing anything particular, I'm just trying to >learn this new stuff about those ”new data types”, that I enable by >selecting Tools → Options… → LibreOffice → Advanced → Activate >experimental >features, then restart LibreOffice, then Tools → Options… → LibreOffice >→ >Basic IDE options → ☒ Use extended data types (give or take some words >or >phrases, since this is a translation from Swedish). > >When trying to get information I found this page: >https://help.libreoffice.org/Common/Basic_IDE_Options#Use_extended_types > >However, they only provided two examples of those new data types (the >two I >mention above), and there's no link or anything that points to the rest >of >them, so it's pretty useless, unfortunately. > > >> It should >> appear at the left (catalog of objects - don't konwo if this is the >> right name ..) and at the bottom (like the standard "Module1") >> >> Declare the dialog first, out of a sub: >> DIM oDialog0 AS OBJECT >> >> Start the dialog: >> >> SUB Dialog0Start >> DialogLibraries.LoadLibrary("Standard") >> oDialog0 = createUnoDialog(DialogLibraries.Standard.Dialog0) >> oDialog0.Execute() >> END SUB >> >> Name of the dialog is "Dialog0" >> >> End the dialog: >> >> SUB Dialog0Ende >> oDialog0.EndExecute() >> END SUB >> >> >Yes, that's how I used to do it, and it usually work for me too, but >this >wasn't what I asked about. My question is about those new data types, >mentioned on the page I referred to above. > >I'm sorry for my confusing English, which obviously isn't my native >language. >Thanks for replying, though! :) > > >Kind regards > >Johnny Rosenberg > > > >> Regards >> >> Robert >> -- >> Homepage: http://robert.familiegrosskopf.de >> LibreOffice Community: http://robert.familiegrosskopf.de/map_3 >> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-un >> subscribe/ >> Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived and cannot >be >> deleted >> > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be >deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-
Re: [libreoffice-users] [macros] How to create a timer ?
On 2017-07-21 11:30, Jean-Francois Nifenecker wrote: All, I'm looking for a way to create a timer in LibO Basic as a reminder to accomplish some task. The timer would be started when the document is opened, then would send a message to the user if he has not accomplished a particular task (eg validating a particular dialog) when a delay expires (eg 2 hrs). In fact I'm in need of several timers for the same document to handle as many different delays/tasks. Can anyone point me to some direction as I'm currently in the dark? Thanks in advance. Best regards, -- Jean-Francois Nifenecker, Bordeaux My gut reaction is that this is not directly supported in Basic. That said, read these posts: https://forum.openoffice.org/en/forum/viewtopic.php?f=44&t=59369 https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=33935 Sadly, this post references something implemented in BeanShell that would have helped, but it references a now defunct forum with the solution (so when they say that MS777 developed a solution and provides a link, that link is no longer valid). http://ooo-forums.apache.org/en/forum/viewtopic.php?t=65864&p=292463 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc macro tutorial
For most users, the recorder is a decent solution. As for support, do not expect that from MS unless you have a credit card. I found some bugs in their C++ compiler about 15 years ago. 5 to 10 years later I thought for sure they would have fixed them. Nope, I had to work around them yet again. It had to do with their streaming classes. There was a failure when the boundary was split by a buffer read for some built-in text reading routines. Not like I could just call MS and get support. For sure they have a better object layer for manipulating documents. Not even close. I have never looked at their Macro programming resources, but, if possible, be certain to use the .NET classes since VBA is still littered with bugs. Last time I wrote a VBA application, half my code was related to working around bugs in their language implementation. These bugs initially existed in OpenOffice.org, but were fixed years ago; for example, bugs related to determining an arrays size in certain circumstances. I had to write special routines to deal with these issues. Moving to the .NET versions made things really nice, however, with full access to the .NET container classes. If you have no particular need to run where MSO is not supported, not a bad move. Good luck on your project. On 11.05.2016 08:42, dave boland wrote: > Andrew, > > Thanks for the note. I actually do software development (Java right now) and enjoy reading documentation (no, not crazy - I've been tested). But when I read a document called "Getting Started With Macros", I reasonably expect it to cover the basics of how to create a macro from scratch - like I would with a VB program (did that for 6 years). I was disappointed to see that it was about using the macro recorder, which will not work for me. > > I get that the authors are volunteers, and that generally the do a fantastic job. However, in this area, not so much. > > I've decided that in the short term Calc (and Base) will not fit my needs (documentation, support concerns) and will move the data to Excel/Access. Not what I wan to do, and not what LO community should like, but it seems like the best course of action for this project. > > Dave, > > On Tue, May 10, 2016, at 02:19 PM, Andrew Pitonyak wrote: > >> Dave, I am copying you directly since I do not know if the email client I am currently using will copy to the list; sorry about that, but I thought you might like my response faster than several hours from now when I am using my standard email client. >> >> On 10.05.2016 13:52, dave boland wrote: >> >>> I want to automate a Calc spreadsheet to do some data analysis. I need some help finding a complete tutorial on Calc macros. Looking for something like the books published for Excell. >> >> Not familiar with them >> >>> I read the documentation, but it says user created macros are beyond the scope of the documentation. REALLY! What the heck is the documentation for then? >> >> Done by volunteers and the documentation at which you looked was beyond their scope. >> >> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1 [1] >> >> Chapter 12 specifically says "Macros" http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view [2] >> >> Chapter 13 contains numerous macro tutorials and examples (well, it did when I wrote the first draft some years back) http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view [3] >> >> Or, try here: http://www.pitonyak.org/oo.php [4] This site contains numerous documents. You might want to look at these two documents. The first is a book and the second is more of a list of macros that accomplish certain tasks. It is kind of a roughly sorted brain dump. >> >> http://www.pitonyak.org/OOME_3_0.odt [5] http://www.pitonyak.org/AndrewMacro.odt [6] >> >> Tri >> >>> ote type="cite" style="padding-left:5px; border-left:#1010ff 2px solid; margi >> idth:100%"> >> >> Tried the web version of this mail group, but it would not accept the catcha code. >> >> Hate those! > > -- > dave boland > dbola...@fastmail.fm > > -- > http://www.fastmail.com - Access all of your messages and folders > wherever you are Links: -- [1] http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1 [2] http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view [3] http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view [4] http://www.pitonyak.org/oo.php [5] http://www.pitonyak.org/OOME_3_0.odt [6] http://www.pitonyak
Re: [libreoffice-users] Calc macro tutorial
Dave, I am copying you directly since I do not know if the email client I am currently using will copy to the list; sorry about that, but I thought you might like my response faster than several hours from now when I am using my standard email client. On 10.05.2016 13:52, dave boland wrote: I want to automate a Calc spreadsheet to do some data analysis. I need some help finding a complete tutorial on Calc macros. Looking for something like the books published for Excell. Not familiar with them I read the documentation, but it says user created macros are beyond the scope of the documentation. REALLY! What the heck is the documentation for then? Done by volunteers and the documentation at which you looked was beyond their scope. http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1 Chapter 12 specifically says "Macros" http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view Chapter 13 contains numerous macro tutorials and examples (well, it did when I wrote the first draft some years back) http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view Or, try here: http://www.pitonyak.org/oo.php This site contains numerous documents. You might want to look at these two documents. The first is a book and the second is more of a list of macros that accomplish certain tasks. It is kind of a roughly sorted brain dump. http://www.pitonyak.org/OOME_3_0.odt http://www.pitonyak.org/AndrewMacro.odt Tried the chat, wants to know what channel. What the heck is that? No idea. Tried the web version of this mail group, but it would not accept the catcha code. Hate those! I'm growing frustrated and very angry. Wait until you try to write macros. I mean, ummm, sorry you are frustrated and angry. LO Macros are very powerful in that they directly use the internal object structure and it is easy to add support for other languages. The disadvantage is that it has a steep learning curve, especially if you do not already understand software development. I usually recommend that people begin with an example that is close to what they need. The general language structure is essentially identical, but, for the most part, document manipulation methods is very different. This is supposed to be user support? It is community support. You did not pay for the product and the people who will now try to help you are all volunteers; they do it because they like to help people as part of a community. If you do not care for email type support, be sure to check out this forum https://forum.openoffice.org/en They have some very competent Macro people hanging out in the macro forums. Best of luck! Dave, -- dave boland dbola...@fastmail.fm Andrew Pitonyak -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macro help
Steve, I know a little bit about macros and I am willing to take a look, but, I am trying to avoid having to create a sample document to test what you are trying to do and I have very little time. can you send a sample Calc document to "and...@pitonyak.org" If possible: 1. Add your macro to the document. 2. make sure the document contains the named range with appropriate data. 3. Indicate exactly what parameters should be used to call the function and what you expected the result to be. I know, it is a lot to ask, but otherwise I need to set all that up myself and I think it would be much faster for you (since you probably already have this). On 06.01.2016 15:19, Steve Edmonds wrote: Hi. I am hoping someone on this list is a lot better with accessing Calc functions in a macro than I am, I have have struggled with this for a day and resorted to a cheat in frustration. I had an equation 300 characters long in a group of cells and decided to replace it with a function as it is something I use on a regular basis. The macro (below) looks up the first column of named range RngName to find the position of value and interpolates between the tabulated data before and after value to determine an interpolated number cdgv at value. I have yet to add any validity checking. The cheat I added was to pass the first column of RngName as its own named range for use in the MATCH function. In a sheet I can use =MATCH(472,INDEX(CdG1data,,1)) where 472 would be value, CdG1data would be RngName but I just can't get this to work in my macro. Function VLinterp(value, RngName, offset, firstcol) REM firstcol is named range first column of RngName fc=createUnoService("com.sun.star.sheet.FunctionAccess") rowBefore = fc.callFunction("Match", Array(value, ThisComponent.NamedRanges.getByName(firstcol).ReferredCells)) v1 = fc.callFunction("Index", Array(ThisComponent.NamedRanges.getByName(RngName).ReferredCells,rowBefore,1) v2 = fc.callFunction("Index", Array(ThisComponent.NamedRanges.getByName(RngName).ReferredCells,rowBefore+1,1) cdg1 = fc.callFunction("Index", Array(ThisComponent.NamedRanges.getByName(RngName).ReferredCells,rowBefore,offset) cdg2 = fc.callFunction("Index", Array(ThisComponent.NamedRanges.getByName(RngName).ReferredCells,rowBefore+1,offset) cdgv = cdg1+(cdg2-cdg1)*(value-v1)/(v2-v1) VLinterp = cdgv End Function Any help appreciated, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Numbering formulas in Writer
I always did this using a numerical sequence field; the same field type used for numbering tables. On May 5, 2015 12:08 PM, =?ISO-8859-1?Q?Kolbj=F8rn_Stuest=F8l?= wrote: > > Many places I am told that inserting formula numbering is quite simple. > Write "fn" in a new line and press the F3 key. > In my copy of LibreOffice 4.4.2.2 (Windows) I am not able to do this. > Instead I get a message that LibreOffice did not find autotext for the > short cut "fn" or something like that. (It works in my copy of > OpenOffice 3.2). > I think it has to do with some settings somewhere but am not able to > find out where. > Some suggestions? > > Kolbjoern > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Installing LO using yum localinstall
I use Fedora and I generally use "yum localinstall" to install my RPMs. I also add an exclude=libreoffice* in yum.conf so that yum does not try to update libreoffice when a new copy is pushed to the Fedora repositories. This then causes yum to ignore the RPMs that match the wild-card, so dependencies fail, and it refuses to install until I remove the exclude from yum.conf. So, is setting the exclude no longer needed in yum.conf as long as I keep up with the latest releases? should I just use rpm to install this? did I do something wrong? Just looking for thoughts. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Repository with LibreOffice 4.4 for Fedora 21+?
As root, edit /etc/yum.conf In the [main] section append a line like exclude=libreoffice* On Feb 5, 2015 9:37 AM, avamk wrote: > > OK, I followed everyone's tips and was able to replace the Fedora > repository-installed LibreOffice 4.3 with 4.4 installed from the RPMs > downloaded from the LibreOffice site!! > > Sorry I've never tinkered with YUM configuration before, how to I > modify it to ignore LibreOffice updates? > > Another strange thing is that when (and only when) I enable "Use > OpenGL for all rendering" in options, (1) all vertical scroll bars > become upside down (i.e. the bar moves up from the bottom when I > scroll down), (2) all checks in checkboxes are upside down, and (3) > when I resize a window the expanded area is all dark! Has this > happened to anyone else?? > > Thanks for your replies! > > On 05/02/2015, Andrew Douglas Pitonyak [via Document Foundation Mail > Archive] wrote: > > > > > > Side note... You probably need to modify one of your yum configuration > > files > > to tell yum to ignore LO updates. > > > > On Feb 5, 2015 9:08 AM, Andrew Douglas Pitonyak > > wrote: > >> > >> > >> On 02/05/2015 07:07 AM, Tom Davies wrote: > >> > Hi :) > >> > I think you can usually just install over the top to wipe the previous > >> > version. > >> > > >> > However on an extremely rare occasion that might not work in which > >> > case you might need to remove/uninstall everything and then reinstall > >> > the newer version. however when you do so you can keep the User > >> > Profile so that all your settings, configs, galleries, > >> > Extensions/add-ons/plugins, templates and all the rest remain intact. > >> > It's quite a good idea to create a copy of your User Profile every so > >> > often so that it's easier to get back to a configuration you liked if > >> > anything crazy ever happens. > >> > > >> > It's the price of getting a much newer and more updated version. > >> > Windows users always have to install any programs this way so it's a > >> > bit like going back to Windows for a little moment. > >> > > >> > Regards from > >> > Tom :) > >> > > >> > > >> > > >> > On 5 February 2015 at 11:58, avamk wrote: > >> >> I see. If I install LibreOffice 4.4 manually (via the RPM I'm > >> >> guessing?) can I just install a newer version over it once it's > >> >> released, or do I have to remove the whole thing before installing an > >> >> update? Thanks! > >> >> > >> >> On 05/02/2015, timllloyd [via Document Foundation Mail Archive] > >> >> wrote: > >> >>> > >> >>> Hi, the best suggestion is to grab the latest from the LO site (you > >> >>> will > >> >>> have to monitor the site for updates): > >> >>> > >> >>> http://www.libreoffice.org/ > >> >>> > >> >>> As well as monitoring for updates you also have to install & remove > >> >>> manually. As you are using Fedora I assume you are familiar with that > >> >>> > >> >>> process but any problems pls sing out. > >> >>> > >> >>> Cheers > >> >>> > >> >>> On 05/02/15 11:59, avamk wrote: > >> >>>> Hello, > >> >>>> > >> >>>> LibreOffice in the Fedora 21 repositories are currently in the 4.3 > >> >>>> series. > >> >>>> Is there an updated LibreOffice repository for Fedora 21 (and also > >> >>>> future > >> >>>> versions) that have LibreOffice 4.4? I like to use the newest version > >> >>>> of > >> >>>> LibreOffice on Fedora if possible. Thanks! > >> >>>> > >> with Fedora 21 I have been using the standard Fedora release, but, if > >> you do not, I think that you can remove the existing using yum... > >> > >> Is it installed? > >> > >> yum list installed | grep "libreoffice" > >> > >> I expect that you can remove it using > >> > >> yum remove libreoffice* > >> > >> I have always used "yum localinstall *.rpm" to
Re: [libreoffice-users] Re: Repository with LibreOffice 4.4 for Fedora 21+?
Side note... You probably need to modify one of your yum configuration files to tell yum to ignore LO updates. On Feb 5, 2015 9:08 AM, Andrew Douglas Pitonyak wrote: > > > On 02/05/2015 07:07 AM, Tom Davies wrote: > > Hi :) > > I think you can usually just install over the top to wipe the previous > > version. > > > > However on an extremely rare occasion that might not work in which > > case you might need to remove/uninstall everything and then reinstall > > the newer version. however when you do so you can keep the User > > Profile so that all your settings, configs, galleries, > > Extensions/add-ons/plugins, templates and all the rest remain intact. > > It's quite a good idea to create a copy of your User Profile every so > > often so that it's easier to get back to a configuration you liked if > > anything crazy ever happens. > > > > It's the price of getting a much newer and more updated version. > > Windows users always have to install any programs this way so it's a > > bit like going back to Windows for a little moment. > > > > Regards from > > Tom :) > > > > > > > > On 5 February 2015 at 11:58, avamk wrote: > >> I see. If I install LibreOffice 4.4 manually (via the RPM I'm > >> guessing?) can I just install a newer version over it once it's > >> released, or do I have to remove the whole thing before installing an > >> update? Thanks! > >> > >> On 05/02/2015, timllloyd [via Document Foundation Mail Archive] > >> wrote: > >>> > >>> Hi, the best suggestion is to grab the latest from the LO site (you will > >>> have to monitor the site for updates): > >>> > >>> http://www.libreoffice.org/ > >>> > >>> As well as monitoring for updates you also have to install & remove > >>> manually. As you are using Fedora I assume you are familiar with that > >>> process but any problems pls sing out. > >>> > >>> Cheers > >>> > >>> On 05/02/15 11:59, avamk wrote: > >>>> Hello, > >>>> > >>>> LibreOffice in the Fedora 21 repositories are currently in the 4.3 > >>>> series. > >>>> Is there an updated LibreOffice repository for Fedora 21 (and also > >>>> future > >>>> versions) that have LibreOffice 4.4? I like to use the newest version of > >>>> LibreOffice on Fedora if possible. Thanks! > >>>> > with Fedora 21 I have been using the standard Fedora release, but, if > you do not, I think that you can remove the existing using yum... > > Is it installed? > > yum list installed | grep "libreoffice" > > I expect that you can remove it using > > yum remove libreoffice* > > I have always used "yum localinstall *.rpm" to install the RPMs after I > extract the code. > > Last time I did this, there was a GUI integration driectory under the > standard RPM directory. I changed to that directory and installed the > RPM meant for UI integration for gnome. I don't remember what that is > called off hand, or even if it is still required. I don't have time now > to download and check the RPMs, but, if you send a list of RPMs, I can > tell you which one it is. > > -- > Andrew Pitonyak > My Macro Document: http://www.pitonyak.org/AndrewMacro.odt > Info: http://www.pitonyak.org/oo.php > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [Calc] how to compare not exactly equal values?
Subtract the numbers and check the absolute value On Feb 4, 2015 8:40 AM, gordom wrote: > > Hallo everyone. > I do realize my post title is not very descriptive. Sorry for that. > I have 2 (or sometimes more) values (numbers) and want to compare them > and check if they are more-less equal. Let say the condition is > fulfilled if the numbers are exactly equal or the difference is not > higher than (+/-) 1. > Here is the example: > > 3,1 3 TRUE > 5,9 6 TRUE > 7 -5 FALSE > 10 9 TRUE > -6 -6 TRUE > > Any clues how I can do this? > Regards, > gordom > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fields always marked as spelling errors
This time I will reply using a computer so that I can more easily respond to the list rather than directly... On 30.12.2014 09:59, CVAlkan wrote: This is a trivial issue, but every field in my Writer documents is displayed with a blue squiggly line beneath it just as if it were a spelling error. I've looked around in vain for a way to disable spell checking of fields (if that is indeed what is causing the annoyance). Grammar checker By "field" I mean things like page numbers, cross-references and such. Cross-references to "reference" rather than "page number" seem to be a special case, though, as sometimes they only have the squiggly line in footnotes, but sometimes it appears in both body text as well as footnotes. I did a quick check on a computer using the latest version of LO and the grammar checker did not seem to complain about things that I created as a test and did not flag numbers The Tools|Options sections of Writer only seem to permit changing (or eliminating) the normal background color used to mark the fields, and I was unable to locate anything in the spell check stuff to ignore fields. This is obviously a pretty trivial thing, but if anyone knows why this happens or if there is anything I can do to "clean up the display" I would appreciate it. I am clueless about this (sadly). try making some changes at Tools | Options | Language Settings and from there you can look at "Writing Aids" and "English sentence checking". The version I just installed on a Windows box included "Lightproof grammar checker". Thanks, and have a great New Year. Happy new year to you as well. Andrew Pitonyak -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Macro from command line: ThisComponent.CurrentController not found
Hopefully this will make it back top the list, Good call responding to the list I believe that you cannot have a view cursor unless you have a display. Some work was done to improve things like maybe it will work if you load the document and then hide it But that is a long shot. Off hand I don't think that you can understand much related to position such add page number without a view. All of the other cursors so not provide this information. After saying that... I expect that PDF export needs a way to understand page numbers and it sounds like you can do that without a view... So perhaps I am mistaken. My best guess is that it only matters of page numbers are displayed in the document and that uses field which should have a display value stored but not updated without the view. Not sure is this helps... greyspammer wrote: >A user who could not post directly to the list because he was using his phone >with a non-matching e-mail address asked me why I was using >CurrentController. I think I better write the answer to the list so everyone >can participate. > >The macro is rather complex. The documents are invoices containing text >table with a list of items and their prices. They are created by a >third-party program. I supply a template and the program fills in the data >from its database. > >Now, it can happen that the table with the items is longer than one page >(even longer than two or three) pages. The macro will detect this and split >the table at those places, adding a subtotal to the foot of each page and a >carry over on the start of the next page. I plan to add this macro to the >template so that it automatically executes when a PDF is generated. > >Example: The document I get looks like this (I hope the layout survives ;)): > ><- snip -> > ><- snap -> > >After the macro is done, the document looks like this: > ><- snip -> > ><- snap -> > >As you can see, it's pretty complex and due to the lack of documentation, >the only way to achieve this result was to replicate the steps I would >otherwise do manually. That means getting a view cursor (which is a part of >the current controller). Then I use my view cursor to do the stuff. I put it >in the last column of the first row. Then I go down cell by cell, summing up >values on way. Until the page changes. Then I go back up, insert subtotal >and carry over and finally split the table between them. > >If there is another way to do it without CurrentController, I have not found >it. > >If it helps, I can post the macro but it's a bit lengthy... > > > >-- >View this message in context: >http://nabble.documentfoundation.org/Macro-from-command-line-ThisComponent-CurrentController-not-found-tp4074374p4074502.html >Sent from the Users mailing list archive at Nabble.com. > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >List archive: http://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: off-list Re: [libreoffice-users] Date changes to a 5 digit number
No computer access, but my guess its that the problem its that the format is set to an integer constant. The correct method is to lookup the format index and create the format if it does not exist. I would explain more, but my phone is slow to use for this. Will have better access in a few days if needed. There is an example in andrewmacro.odt I believe. Hth Sent from my Samsung Epic™ 4G Tom Davies wrote: Hi :) Looks like the code didn't get to the list so here it is " REM * BASIC * Sub Main End Sub sub Insert_Line_and_Date rem -- rem define variables dim document as object dim dispatcher as object rem -- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem -- dim args1(1) as new com.sun.star.beans.PropertyValue args1(0).Name = "GraphicName" args1(0).Value = "" args1(1).Name = "IsSimpleLine" args1(1).Value = true dispatcher.executeDispatch(document, ".uno:InsertGraphicRuler", "", 0, args1()) rem -- dim args2(5) as new com.sun.star.beans.PropertyValue args2(0).Name = "Type" args2(0).Value = 0 args2(1).Name = "SubType" args2(1).Value = 0 args2(2).Name = "Name" args2(2).Value = "" args2(3).Name = "Content" args2(3).Value = "0" args2(4).Name = "Format" args2(4).Value = 5122 args2(5).Name = "Separator" args2(5).Value = " " dispatcher.executeDispatch(document, ".uno:InsertField", "", 0, args2()) rem -- dim args3(0) as new com.sun.star.beans.PropertyValue args3(0).Name = "Text" args3(0).Value = ", " dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args3()) rem -- dim args4(1) as new com.sun.star.beans.PropertyValue args4(0).Name = "Template" args4(0).Value = "Heading 1" args4(1).Name = "Family" args4(1).Value = 2 dispatcher.executeDispatch(document, ".uno:StyleApply", "", 0, args4()) end sub " Regards from Tom :) > > From: . >To: Tom Davies >Sent: Saturday, 27 October 2012, 18:37 >Subject: Re: off-list Re: [libreoffice-users] Date changes to a 5 digit number > > >Tom, > >Did my code message get to the list? I know you replied with it but it seems there's no option for me to reply to the list. > >Thanks, > >Carl > > > >On 10/27/2012 01:33 PM, Tom Davies wrote: > > >> >> >> >> >>> >>> From: . >>>To: Tom Davies >>>Sent: Saturday, 27 October 2012, 18:29 >>>Subject: Re: [libreoffice-users] Date changes to a 5 digit number >>> >>>On 10/27/2012 01:06 PM, Tom Davies wrote: Hi :) Can you copy&paste the macro's code into a reply as text? If we could see the code then some people here might be able to spot the error. Good luck and regards from Tom :) >>> >>>Here's the code- >>> >>>REM * BASIC * >>> >>>Sub Main >>> >>>End Sub >>> >>> >>> >>> >>> >>> >>>sub Insert_Line_and_Date >>>rem -- >>>rem define variables >>>dim document as object >>>dim dispatcher as object >>>rem -- >>>rem get access to the document >>>document = ThisComponent.CurrentController.Frame >>>dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") >>> >>>rem -- >>>dim args1(1) as new com.sun.star.beans.PropertyValue >>>args1(0).Name = "GraphicName" >>>args1(0).Value = "" >>>args1(1).Name = "IsSimpleLine" >>>args1(1).Value = true >>> >>>dispatcher.executeDispatch(document, ".uno:InsertGraphicRuler", "", 0, >>>args1()) >>> >>>rem -- >>>dim args2(5) as new com.sun.star.beans.PropertyValue >>>args2(0).Name = "Type" >>>args2(0).Value = 0 >>>args2(1).Name = "SubType" >>>args2(1).Value = 0 >>>args2(2).Name = "Name" >>>args2(2).Value = "" >>>args2(3).Name = "Content" >>>args2(3).Value = "0" >>>args2(4).Name = "Format" >>>args2(4).Value = 5122 >>>args2(5).Name = "Separator" >>>args2(5).Value = " " >>> >>>dispatcher.executeDispatch(document, ".uno:InsertField", "", 0, args2()) >>> >>>rem -- >>>dim args3(0) a
Re: [libreoffice-users] Macros
Spotty access to email and short on time The included help does not include API level documentation since most people have no need for it. Sadly, I have no ability at the moment to generate an example, but, you can find numerous examples in AndrewMacro.odt for this. I believe that there will be a better explanation in OOME as available on my web site. If you download that and it does not yet contain Calc examples, shoot me a private email and I will push a copy that (although incomplete) will contain an example of how this is done. In brief, the idea is that you: 1. Obtain a reference to the document. If it is the current document, then you can use the variable "ThisComponent". 2. Get a reference to the sheet containing the cell. In most cases, you can do something like the following: ThisComponent.sheets.getByIndex(0) ' Get the first sheet ThisComponent.sheets.getByName("Investments") ' Get a sheet by name Sometimes you simply want to get the currently active sheet, which is a bit more difficult. It probably looks something like the follow (from memory so I am probably wrong). ThisComponent.CurrentController.ActiveSheet After you have the sheet, then you can get the cell. Again, this is all from memory, so I am likely totally wrong, but it probably looks something like: oSheet.getCellByPosition(1,2) 'Cell B3 oSheet.getCellRangeByName("B3") A cell range with a single cell returns that cell I believe. Next, you must decide how to get the contents of the cell. Do you want the contained formula, a numeric value, or a string representation? Oh, and David, I copied you with a BCC because I do not know if my post to the list will go through based on the credentials used to send this email. Andrew Pitonyak On Sun, 30 Oct 2011 11:13:40 + (GMT), Tom Davies wrote: > Hi :) > There are various books and guides about Macros. I've been told by > various people that Andrew Pitonyak's is excellent. Hopefully the link is > on this page > http://wiki.documentfoundation.org/Documentation/Publications > > I'm not sure if that will help with the specific problem as we might need > to collect links to more external resources onto that page. > Regards from > Tom :) > > > --- On Sat, 29/10/11, David S. Crampton wrote: > >> From: David S. Crampton >> Subject: [libreoffice-users] How may I read the value of a cell into a >> macro variable? >> To: users@global.libreoffice.org >> Date: Saturday, 29 October, 2011, 0:44 >> This question has two parts: simple >> and more complex: >> >> simple: I wish to read the value of the currently selected >> cell (in Calc, of course) into a variable in the macro >> language (Libre Basic). Script example please. and >> thank you! >> >> more complex: AFAIK the LibreHelp does not document the >> stuff like: >> >> dispatcher.executeDispatch(document, ".uno:GoToCell", "", >> 0, args2()) >> >> I used to be pretty skilled at recording macros and then >> modifying them. Where do I go to find things related to >> "uno:GoToCell"? Universal Network Objects? Can't >> find the "starting point". >> >> Thank you for an orientation, >> --David S. Crampton >> >> --For unsubscribe instructions e-mail to: >> users+h...@global.libreoffice.org >> Problems? >> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >> List archive: http://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived >> and cannot be deleted >> >> -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted