http://blog.gmane.org/gmane.comp.documentfoundation.libreoffice.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30491 <pre>Hi, I have a writer odt document with a form and 2 option buttons (Option1: "yes/no") as well as other form elements. Clicking one option button enables it and immediately disables the other if the component names are identical (eg "optionButtons1"). I run a macro whenever I detect the "Mouse pressed" event for these option buttons. This macro searches through all form components and grabs their values. My goal is to get the "Option1" value (eg. 1 if YES was selected and 0 if NO was selected). The macro function snippet below returns something like "&amp;optionButtons1=0&amp;optionButtons1=1" when the YES option button isn't clicked and the NO option button is. Instead, how can I get something like "Option1=1" when the YES option button is clicked and the NO button isn't? Likewise, get "Option1=0" when YES isn't clicked and NO is. Doc = ThisComponent Forms = Doc.Drawpage.Forms For I = 0 To Forms.Count - 1 Form = Forms.GetbyIndex(I) For J = 0 To Form.Count - 1 Ctl = Form.GetbyIndex(J) If Ctl.supportsServ</pre> Vieri 2013-05-21T11:35:13 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30489 <pre>When trying to install Libre, I keep getting the error message 2502 or 2503,and am unable to install. Please Advise. Mr L Armstrong..... </pre> lesarmstrong< at >talktalk.net 2013-05-21T01:03:23 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30485 <pre>Hi. There is a command to insert date/time in a LibreOffice Writer text? Thank you in advance. André Ricardo Silva Engenheiro Eletricista - CREA 107695-9 Tel: (49) 8852-2847 Rua Cezenando R. Ferreira S/N - Centro - Correia Pinto - SC </pre> André Ricardo Silva 2013-05-20T17:27:33 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30484 <pre>Hi. There is a way to type data/field in a LibreOffice Writer text? Obrigado. André Ricardo Silva Engenheiro Eletricista - CREA 107695-9 Tel: (49) 8852-2847 Rua Cezenando R. Ferreira S/N - Centro - Correia Pinto - SC </pre> André Ricardo Silva 2013-05-20T17:00:31 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30477 <pre>I installed LibreOffice Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3) direct from http://www.libreoffice.org/download/ on Lubuntu 13.04. While I have no issues with it [I]per se[/I], I think it has installed some svg files in /usr/share/icons/gnome/scalable/apps that are really horrible. These svg files are several hundred kB in size and one, libreoffice4.0-calc.svg, is 1.3 MB. Opening that particular svg file in Firefox 22 or an image viewer takes a while. This is on a Core2Duo laptop with 4GB RAM. I really don't see the need for such bloated svg files. When I inspected it with a text editor and with svg-edit.html (https://code.google.com/p/svg-edit/), it's clear to see that there's just so much garbage in there. Grrr... Do these svg files have any purpose at all? I don't think it's fair to include such large svg files as part of the installation. -- View this message in context: http://nabble.documentfoundation.org/Why-such-large-svg-files-in-LibreOffice-Linux-tp4056944.html Sen</pre> chimak111 2013-05-20T06:49:16 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30471 <pre>I'm a tad confused by the following situation : when LO 4.0.3.3 was released, I thought to upgrade by clicking on the Help tab in LO 4.0.2.2 and choosing «Check for updates» in the menu that then appears. To my disappointment no such alternative appeared in the menu. Neither did I get any updates from the LO PPA, neither the more general LibreOffice version nor the more specific version for updates to LO 4.0.x. OK, I downloaded the three packages (main package, Swedish-language langpack, plus the help package) directly from the LibreOffice website and installed them from the respective DEBS folders. Doing so installed the package under /opt/libreoffice4.0, as distinct from usr/lib/libreoffice, on which the 4.0.2.2 package is installed. I now have two distinct LibreOffice installations available on my Cinnamon panel, which gives me a choice - always nice ! - but, for example, documents that I receive as attachments to email messages are opened by default in LO 4.0.2.2 and I have to jump through several hoop</pre> M Henri Day 2013-05-19T14:42:58 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30469 <pre>I have LibreOffice 4.0.3.3 on a Windows 7 computer. I have an older database created originally with OpenOffice. The database is a household inventory including item description, brand name, serial number, date an item was purchased and its exact cost (among other fields). I have just noticed that in LibreOffice Base the program is rounding all costs to $.00). I cannot find a setting that is causing this unwanted rounding. When I look at the format of any cell that is involved, one item says that it will accept two digits past the decimal marker (but nothing mentions rounding off). I did not change any settings between when I used OpenOffice Base (where it displayed costs correctly) and when I changed over to LibreOffice Base. #1 - is this the right forum to ask this question? #2 - is anybody else having a similar problem? #3 - is there a setting that I have overlooked that will solve this unwanted rounding of costs? Thanks for any answers. jnrigg -- View this message in context: http://nabble.d</pre> jnrigg 2013-05-18T07:38:19 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30468 <pre></pre> Anish Pandey 2013-05-18T17:17:25 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30450 <pre>Hi,   Just installed LibreOffice 3.6.6   All links to help / submit feedback etc from the app and attempts to access help via links on the LibreOffice website eg to https://help.libreoffice.org/Writer/Welcome_to_the_Writer_Help   yield a warning page indicating an issue with the site's security certificate.   I'm using XP and IE 8.     Bob. </pre> Bob Power 2013-05-17T12:13:43 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30437 <pre>Hi: I uninstalled my 3.6 LibreOffice a few weeks ago when I discovered that the Ubuntu Software Center had an "official" version of the new 4.0.2. I'm using a 64 bit version of Ubuntu 12.04 LTS by the way. I've had a slew of problems with that release and don't have the time to fool with it, so I uninstalled all of the LibreOffice stuff - again using the Ubuntu Software Center - in order to try the separately downloaded 4.0.3 version from the Libre Office site. Everything went well for the first part (the stuff in LibreOffice_4.0.3_Linux_x86-64_deb.tar.gz). When I attempted the second part (in the desktop-integration), I got the following message: ~/Downloads/LibreOffice_4/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration$ sudo dpkg -i *.deb dpkg: regarding libreoffice4.0-debian-menus_4.0.3-3_all.deb containing libreoffice-debian-menus: libreoffice-core conflicts with libreoffice-unbundled libreoffice-debian-menus provides libreoffice-unbundled and is to be installed. dpkg: error processin</pre> CVAlkan 2013-05-16T22:29:26 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30428 <pre>Kérem, mondják meg, hogy lehet beállitani a 12-es alapállapotu betüméretet 14es alapállapotra? l want to know how can l set up the base letter size 12 to base letter size 14 so that l should not set up the letter size whenver l start a new document! Thanks. </pre> marta333< at >deck.hu 2013-05-16T11:55:44 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30423 <pre>Hi all, My collegues asked me to draw a network &amp; server topology. They would like more "sexy" pictucres than rectangles and circles: Would you have a Drawing template to have nice "computer &amp; network pictures"? Example: http://www.fr3d.org/blog/wp-content/uploads/2006/10/network-current.png </pre> Mihamina Rakotomandimby 2013-05-16T07:11:03 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30404 <pre>Anyone know if there is an equivalent to the Filemaker Pro "Case" function? It's kinda like the "IF" function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do that, etc. Here's what I need to do. Take 4 columns and concatenate with a semi-colon between the values, but not string together two semi-colons consecutively. Like: Phone Email Mail -&gt; Phone;Email;Mail Phone Mail -&gt; Phone;Mail Mail -&gt; Mail Email Mail -&gt; Email;Mail So semi-colons only occur if there's a value present and not at all if there's only one value present. I hope that makes sense and displays correctly. Carl </pre> Carl Paulsen 2013-05-15T20:16:40 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30402 <pre>I'm having trouble with LibreOffice 3.6. A file I was given contains regions that are readonly, and I can't figure out how to unprotect them in order to edit them. The usual advice in the archives is to use the Format -&gt; Sections menu option. That doesn't work here; the Sections line in the Format menu is grayed out. Other advice is to save the file in .odt format and then open the result. That doesn't work either. Attached to this email is a very short document (in .odt format) exhibiting the problem. It's just one line of text saying: Normal (9) Normal again. The "(9)" region shows up in gray and can't be edited. Can anybody help? Thanks, Alan Stern </pre> Alan Stern 2013-05-15T19:52:43 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30398 <pre>hi, I have create a style for paragraph: English font is Times New Roman, font size is 12 pt. And it appears that the current style is my custom style, but when I type some English words, it change to font cajcd-fntaa, font size 13.6 pt. What wrong? I'm using LibreOffice Portable 4.0.3.3 on Windows 7. </pre> 胡小柯 2013-05-15T17:03:37 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30385 <pre>I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API. Is this the right place? To save a little time, let me explain my question. I have a Base Form that uses a ListBox based on a SQL query. When a record is updated, I want the ListBox to requery. In Microsoft Access, I just said Requery and I didn't even need to specify the control. How do I get a Form to requery in LibreOffice? </pre> Steven Friedrich 2013-05-15T12:24:14 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30372 <pre>Hi, I'd like to deploy a compiled Java macro with an ODT document. According to http://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Writing_Macros: " If you want to deploy the macro to a document you need to place it in a Scripts/java directory within the document zip file. " What does that mean exactly? I tried the following: I saved the ODT file within a subdir and placed my Java macro (and descriptor file) within subdir/Scripts/java/MYJAVAMACRO. If I load the document and go to Tools-&gt;Macros-&gt;Run macros, I can't see my Java macro under the "document" tree. What am I doing wrong? Eventually I'd like to store my odt + java macros within a webdav directory so that the dir structure would be something like this: https://server.com/webdav/docs/doc1.odt https://server.com/webdav/docs/Scripts/java/MYJAVAMACRO/parcel-descriptor.xml https://server.com/webdav/docs/Scripts/java/MYJAVAMACRO/MYJAVAMACRO.jar Clients would open the ODT files like this: soffice -o https://server.com/webdav/docs/doc1.</pre> Vieri 2013-05-15T09:25:08 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30369 <pre>All the report tutorials I've seen seem somewhat primitive, in terms of what kinds of structures can be printed. If I have a main entity, and I have two one-to-many relationships to other tables (FK links from the other tables to the main table), is there any way to generate a report with the main table data, and the data for the other relationships also included (indented and formatted properly)? </pre> David Karr 2013-05-15T03:42:28 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30366 <pre>Hi list In LibO v. 4.0.3.3 Writer when I open existing documents via the File/ Recent Documents menu, the requested document opens at the beginning of the document, and not at the end/ last saved point as expected. This is on GNU/ Linux Mint 14, with LibO 4.0.3.3. Any thoughts about how to test/ correct this or to open at the last saved position? Cheers </pre> sun shine 2013-05-15T00:45:46 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30359 <pre>Hello Is it possible for a document to be converted to PDF format? </pre> D.R. 2013-05-14T13:19:51 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/30350 <pre>LO 4.0.3.3 I've had some problems with sorting that may have cost me 6 hours of work. Wondering what's going on. Biggest problem is that when sorting and choosing to "expand selection" it sometimes only expands to some of the columns of data. Why would this happen? I noticed this after a while of working on a large data file, and earlier sorts may have only sorted a portion of the sheet, meaning I have to check and possibly re-create all of my work. Much less problematic, recently I'm sorting a sheet and it sorts not only the column of data but also the columns themselves. Since I'm using vlookup a bunch, with static references (to work properly in my case), this re-sorting will screw up the entire file. I can't afford the time to recreate the vlookups each time I sort. I didn't have latter this problem under 3.x.x Carl </pre> Carl Paulsen 2013-05-14T17:47:04 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.documentfoundation.libreoffice.user