[libreoffice-users] Re: Local data in writer pulldown list
Gary Dale wrote > It's actually a little more complicated. In order to create the list > box, you need to select a data source. No, using LO 5.2.2 I simply open Writer and 1. selected the listbox icon from the Form Controls toolbar then 2. clicked and dragged the outline of a listbox on the page 3. (as mentioned previously) Are you perhaps using the wizard instead? - Manjaro 0915 OpenRC 64bit LibreOffice 5.0.3.2 | Ubuntu 14.04 64bit : LibreOffice: 4.1 4.2.7.1, 4.4.5, 5.1 beta2 & dailys -- View this message in context: http://nabble.documentfoundation.org/Local-data-in-writer-pulldown-list-tp4197940p4198145.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
[libreoffice-users] Re: Local data in writer pulldown list
1. Right mouse click on the list box, choose control 2. On the 'General' Tab, choose List entries. 3. type your first entry BUT press Shift+Enter to make non-breaking space for the 2nd entry 4. repeat as necessary. 5. Choose File>Export as PDF. 6. Select the 'Create PDF Form' option. I left the Submit format as 'FDF', & it worked in qpdfview, prompting me to save when I exited. I'm afraid you'll need to research the other options. - Manjaro 0915 OpenRC 64bit LibreOffice 5.0.3.2 | Ubuntu 14.04 64bit : LibreOffice: 4.1 4.2.7.1, 4.4.5, 5.1 beta2 & dailys -- View this message in context: http://nabble.documentfoundation.org/Local-data-in-writer-pulldown-list-tp4197940p4197947.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
[libreoffice-users] Re: updating a bookmark using a basic macro
I half-remember coming across something like this before: From section 14.11.1 Bookmarks in Andrew Pitonyaks OpenOffice Macros Explained (http://www.pitonyak.org/OOME_3_0.pdf): /A bookmark is text content that is accessible based on its name. A bookmark may encompass a text range or a single point. Listing 371 inserts text content at the point where a bookmark is anchored. Use the getString() object method to obtain the string contained in the bookmark. Use setString() to set the string contained in the bookmark. If the bookmark is merely a point, the text is merely inserted before the bookmark. When a created bookmark is inserted into the text, the insertion point determines the bookmarkâs anchor position./ - Manjaro 8.13 64bit Ubuntu 14.04 64bit : LibreOffice: 4.1 4.2.7.1, 4.4.5, 5.0 -- View this message in context: http://nabble.documentfoundation.org/updating-a-bookmark-using-a-basic-macro-tp4168303p4168643.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
[libreoffice-users] BASIC, Writer Table Cell Selection: Numbering/Bullets interfere with TextTableCursor
Hello, I'm trying to return a cell range for some cells selected in a Writer text table. From what I've read in Andrew Pitonyak's documentation, the method getRangeName() from a TextTableCursor seems to be the way to do it. However oSels.supportsService(com.sun.star.text.TextTableCursor) returns FALSE if the cells selected contain numbering or bullets. If I switch the numbering off the same selected cells return TRUE I can use getRangeName(). Is this behaviour inconsistent (i.e a bug) or am I missing something? I've repeated this in LO4.1, 4.4.5, 5.0, 5.0.1RC1 Linux x86_64 example document containing macro and steps to reproduce: http://www.mediafire.com/view/0q0sdy9kdtyncky/Selected.Table.Cells.odt here is the pertinent code from the document above: Dim i As Integer : Dim sTextTableCursor$ sTextTableCursor$ = com.sun.star.text.TextTableCursor oSels = ThisComponent.getCurrentController().getSelection() If Not oSels.supportsService(sTextTableCursor) Then Msgbox Please make a selection of cells!, MB_OK + MB_ICONSTOP ElseIf oSels.supportsService(sTextTableCursor) Then REM At least one entire cell is selected If validSelection(oSels.getRangeName()) Then tempStr = Good, the selection is more than 1 cell! Else tempStr = The selection needs to be more than 1 cell! End If Msgbox We've got a selection in a table! CHR$(10) The selected range is: oSels.getRangeName() CHR$(10) tempStr 'xray oSels End If Thanks. Selected.odt http://nabble.documentfoundation.org/file/n4157169/Selected.odt - Ubuntu 14.04 64bit : LibreOffice: 4.2.7.1, 4.3.2.2 -- View this message in context: http://nabble.documentfoundation.org/BASIC-Writer-Table-Cell-Selection-Numbering-Bullets-interfere-with-TextTableCursor-tp4157169.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
[libreoffice-users] Daily Master 64bit deb Install Failure
Hello, I'm using debs from http://dev-builds.libreoffice.org/daily/master/Linux-rpm_deb-x86_64@46-TDF/current/ on Ubuntu 14.04 64bit LO 4.2.6, 4.3.2 and the installs have been failing regularly (every weekend or so) for the past two-three months. Package lodevbasis4.4-core05 is always missing. ( see dpkg -i *.deb excerpt below) /dpkg: error processing package lodevbasis4.4-extension-pdf-import (--install): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of lodevbasis4.4-extension-report-builder: lodevbasis4.4-extension-report-builder depends on lodevbasis4.4-core05 (= 4.4.0.0.alpha0); however: Package lodevbasis4.4-core05 is not installed. lodevbasis4.4-extension-report-builder depends on lodevbasis4.4-core05 (= 4.4.0.0.alpha0-1); however: Package lodevbasis4.4-core05 is not installed./ Debs */lodevbasis4.4-core01_4.4.0.0.alpha0-1_amd64.deb/* to */lodevbasis4.4-core07_4.4.0.0.alpha0-1_amd64.deb/* are present in the archive, but */lodevbasis4.4-core05_4.4.0.0.alpha0-1_amd64.deb/* is not. 4.2 and 4.3 releases have installed fine. Any suggestions? TIA - Ubuntu 14.04 64bit : LibreOffice: 4.2.6.2, 4.3.1.1 -- View this message in context: http://nabble.documentfoundation.org/Daily-Master-64bit-deb-Install-Failure-tp4124903.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
[libreoffice-users] Re: Feature Request for Calc - input forms and reports
For input forms, you could try this: http://extensions.openoffice.org/en/project/dataform http://extensions.openoffice.org/en/project/dataform - Ubuntu 14.04 64bit : LibreOffice: 4.2.6.2, 4.3.1.1 -- View this message in context: http://nabble.documentfoundation.org/Feature-Request-for-Calc-input-forms-and-reports-tp4119629p4119709.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
[libreoffice-users] Re: v3.5 vs RC3
Is LO3.5 the same as release candidate 3, or should I download 3.5??? Thank you. Joe Conner, Poulsbo, WA USA From http://www.libreoffice.org/download/release-notes/ : /This release is bit-for-bit identical to the 3.5.0 Release Candidate 3, so you don't need to download or reinstall if you have that version already. Note that therefore, the about box states LibreOffice 3.5.0 RC3./ - Ubuntu 10.10 64bit : LibreOffice 3.4.3 OOO340m1 (Build:302) JRE: jre-6u21-linux-x64.bin -- View this message in context: http://nabble.documentfoundation.org/v3-5-vs-RC3-tp3749229p3749309.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Copy calc data to writer table
Steve Edmonds wrote: Hi. I am just copying some data from a calc sheet into a table in writer without wanting to embed it as a calc8 item. snip Is this logical or am I missing something, would a feature request to add another paste special item Paste to table be useful or a more sensible approach (i.e. on paste specialunformatted text to have a prompt Paste to separate rows if pasting into a table. steve I use the PasteAsValue extension: http://extensions.services.openoffice.org/en/project/pasteasvalue The only drawback being that the top row of the table is automatically bolded centred. It installs a button ( a Capital 'T' ) in the toolbar. - Ubuntu 10.10 64bit : LibreOffice 3.4.3 OOO340m1 (Build:301) JRE: jre-6u21-linux-x64.bin -- View this message in context: http://nabble.documentfoundation.org/Copy-calc-data-to-writer-table-tp3263380p3265856.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Base / Postgresql support
No luck with the sdbc driver. I disabled the driver then removed it. I even went so far as to rename my /.libreoffice dir, re-install it start afresh. Looking at https://bugs.freedesktop.org/show_bug.cgi?id=35784 the driver is currently broken. JDBC works, but it might be slower. - Ubuntu 10.10 64bit : LibreOffice 3.4.2 OOO340m1 (Build:203) JRE: jre-6u21-linux-x64.bin -- View this message in context: http://nabble.documentfoundation.org/Base-Postgresql-support-tp3226192p3230789.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Base / Postgresql support
Walt wrote: Hi Anyone know how to get native pgsql support on base - it seems missing from the connect to an exsitng database options. I've checked under both Linux and Windows. There was a special driver in a zip file available from the old openoffice.org site. It was an extension installed through the (Tools-)Extension Manager I've uploaded it to multiupload here: http://www.multiupload.com/LLL32191L0 (postgresql-sdbc-0.7.6b.zip) I'm afraid I have no idea if it will still work though. Let me check get back to you. Walt wrote: Also is it possble to mix and match datasources on one base database (some local tables + some odbc tables etc) AFAIK there's only one connection string (ODBC, SDBC, JDBC) that can be specified via the (database properties -connection settings:) Datasource URL field. - Ubuntu 10.10 64bit : LibreOffice 3.4.2 OOO340m1 (Build:203) JRE: jre-6u21-linux-x64.bin -- View this message in context: http://nabble.documentfoundation.org/Base-Postgresql-support-tp3226192p3227883.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Base record access unacceptably slow
. tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here is a relatively painless way to install an older JRE along side the default Ubuntu one. ( I'm using Ubuntu 10.10 64bit ) It definitely sped up my Base table browsing, but then I don't have any binaries embedded in my tables. It has the bonus of not messing with the existing JRE Overview: 1. Download the JRE archive (approx. 20 mb) 2. Extract in /tmp 3. as root, copy the extracted directory to /usr/lib/jvm 4. set this JRE as the JRE of choice in LO (ToolsOptionsJava) 5. Exit LO restart Instructions: 1.Download jdk-6u21-linux-i586.bin (for i386) or jdk-6u21-linux-x64.bin for x86_64 from http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR JRE archive at ORACLE . Save to /tmp 2.run it using: sh jdk-6u21-linux-i586.bin . The JRE is now extracted to /tmp/jre1.6.0_21/ 3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm 4. Exit restart office. In ToolsOptionsJava, choose 1.6.0_21. Exit restart office 5. Load you Base file compare the speed. If you want to remove it simply set the JRE back to the old one in ToolsOptionsJava sudo rm -rf /usr/lib/jvm/jre1.6.0_21/ -- View this message in context: http://nabble.documentfoundation.org/Base-record-access-unacceptably-slow-tp3202820p3211034.html Sent from the Users mailing list archive at Nabble.com. -- 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