[libreoffice-users] Re: MySQL Native Connector for Linux 4.2 and 4.3
Le 04/01/2015 14:01, Heinrich Stöllinger a écrit : Hi Heinrich, the possibility to specify such a parameter. Under the given situation LO 4.3.5.2 crashes when the server goes away and one acknowledges the respective error message. Is there a chance to get an autoconnect-feature included in a future version of the connector? File a new bug request for enhancement, if one hasn't been filed already. Your description of the crash when the connection is dropped at least confirms a bug I reported here : https://bugs.freedesktop.org/show_bug.cgi?id=83995 Alex -- 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] MySQL Native Connector for Linux 4.2 and 4.3
Hello, As I have already mentioned before... I would love to use the native connector for a number of reasons (eg. performance...). My provider has a timeout-value of 1 minute set for a MySQL-connections and is not willing to increase this value. Using the JDBC-Connector one can specify an automatic reconnect parameter. This is by no means ideal, because sometimes one does not access the database for more than one minute. However, it is kind of o.k. because LO-DB reconnects to the server-DB by just pressing o.k. -- one gets used to this (at least in MY case!). To my knowledge the native connector does NOT have the possibility to specify such a parameter. Under the given situation LO 4.3.5.2 crashes when the server goes away and one acknowledges the respective error message. Is there a chance to get an autoconnect-feature included in a future version of the connector? Regards from snowy Salzburg H. Stoellinger -- 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] Program Abort - Service Manager not available
Dr. Jim Ishler wrote: When I try to start LibrOffice I get an error that the program cannot be started. It says the service manager is not available. Premature end of file:///C:/Users/jishler/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/common.rdb I have tried reinstalling LibreOffice, repairing it, and unistalling and then reinstalling, but I always get the same error. How can I fix this? I am running Windows 7 It looks like one of the files in your profile is corrupt. Uninstalling and reinstalling keeps your existing profile, so that any user configuration is carried over to a new version, so won't fix that. First thing I'd try is to close LibreOffice, rename just that one file, then start LibreOffice. It might create a default and start OK, or it might not. If that works, you can either try to copy anything from the original (renamed) file which you need, or just delete it. If that doesn't work, close LibreOffice and rename the folder C:/Users/jishler/AppData/Roaming/LibreOffice/ (for example, to LibreOffice-2015-01-04). Then start LibreOffice; it should create a new LibreOffice folder with a default profile. Depending how much you've customised, you might want to try to copy some parts of the old profile across to the new (e.g. custom spell check dictionaries), but if you haven't customised much it's probably easier just to re-do any configuration you need via the options within LibreOffice. Renaming rather than deleting these files/folders means you've still got a copy of the broken profile in case you need to recover anything from it. You can delete them if you're confident you don't need anything from them. Mark. -- 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] How do I move a formula without changing it?
I have some rate-of-change triangles I need to change. These show the annual rate of change for different numbers of years and look like this: 2010X X X X X 2011X X X X 2012X X X 2013X X 2014X Basically, I want to reverse the lines, moving the top to bottom and vice versa. I want to do this so the multiple years go out from the ending date instead of the starting date. Like this: 2010X 2011X X 2012X X X 2013X X X X 2014X X X X X If I just copy and paste and the cells aren't protected by '$' the cells change accordingly. I don't want that to happen. I want the formulae to reference the same cells. I just want to move them to another location. Is there any way to do this? -- 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] How do I move a formula without changing it?
On 04/01/15 15:39, Robert Peirce wrote: I have some rate-of-change triangles I need to change. These show the annual rate of change for different numbers of years and look like this: 2010XXXXX 2011XXXX 2012XXX 2013XX 2014X Basically, I want to reverse the lines, moving the top to bottom and vice versa. I want to do this so the multiple years go out from the ending date instead of the starting date. Like this: 2010X 2011XX 2012XXX 2013XXXX 2014XXXXX If I just copy and paste and the cells aren't protected by '$' the cells change accordingly. I don't want that to happen. I want the formulae to reference the same cells. I just want to move them to another location. Is there any way to do this? Yes - add $ to the cell references in the formula - e.g., A2 becomes $A$2. That means you can move the formula anywhere you want but it will still reference A2... -- 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: How do I move a formula without changing it?
On 1/4/15 10:43 AM, Gordon Burgess-Parker wrote: Yes - add $ to the cell references in the formula - e.g., A2 becomes $A$2. That means you can move the formula anywhere you want but it will still reference A2... I know that but that is what I am trying to avoid. I would have to change it to copy and then change it back after I move it so I can drag the next year. I am looking for a way to copy and paste the existing formulae without changing them. This may not be possible but I thought I would check. If I can't do that I will have to investigate to see what the fewest number of cells I actually must change are and take it from there. -- 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] Conditional formatting in Calc
In a spreadsheet I needed to set the background color in the three cells A1, B1, and C1, depending on the value of B1. Example: If the cell B1 contains A all the 3 cells will be colored. At all other values in B1 nothing happens. In a couple of hours I found a solution, but not in the Help section of LibreOffice. Perhaps I just didn't recognize it? Some hidden help :-). I think there should be something in Help about how to format cells ranges depending on the content of one cell. I guess I am not the only one who needs this function sometimes. Curious about the Solution? Here it is: Select the actual cells range. Open the Conditional Formatting Dialog and select condition type Formula is. As a formula enter (in this example) $B1=A. (The $ sign *must* be added). Choose or create a style that suits you and press the OK button (or press Enter). 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
[libreoffice-users] Using PriorToReset event in Base form
Please correct me if I'm wrong, and if there's a better place to ask, let me know. It is my understanding (experimentally verified) that the PriorToReset event will fire when a new database row is produced for data entry. Inside this event, I can use the passed in event object to get the Form and from the form get at the elements of the form. I named my sub the same as the event it relates to. Sub PriorToReset(event) dim Form dim DateField Form=event.source DateField = Form.getByName(Date) Now I can drop a date into the Date field via : DateField.setPropertyValue(Text, 01/04/2015 ) That date shows up on the screen as though I had keyed it in by hand. Great so far. Once I fill out the remaining fields manually, and an attempt is made to send the data to the database, an error shows up asking to fill in the mandatory Date field. I'm looking at it filled in exactly as I want it, but somehow the system thinks it's not filled in. If I focus the date field and backspace over the last digit (5) and then re enter 5 and hit enter, and then attempt to save the record, it works. Why? Why can I see the date field filled in exactly as I want it, but somehow the system thinks the field is empty or somehow invalid until I touch the field and tinker with its last digit. If I set the last digit to 9, for example, a database row is stored with 01/04/2019 in it as expected. -- Bill Gradwohl -- 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] How do I move a formula without changing it?
You might have the answer in your own question, even I am not quite ready in my thinking about this. If you move the formula (e.g. via the sequence ctrl+X and ctrl+V at the new position, well you can do it via the edit menu instead) the references do not change, the formula still points at the same cells as in the first position. It is when you copy the formula the references change, as they are relative. However to really get them absolute, you have to anchor them with the $ sign. Den 2015-01-04 16:39, skrev Robert Peirce: I have some rate-of-change triangles I need to change. These show the annual rate of change for different numbers of years and look like this: 2010XXXXX 2011XXXX 2012XXX 2013XX 2014X Basically, I want to reverse the lines, moving the top to bottom and vice versa. I want to do this so the multiple years go out from the ending date instead of the starting date. Like this: 2010X 2011XX 2012XXX 2013XXXX 2014XXXXX If I just copy and paste and the cells aren't protected by '$' the cells change accordingly. I don't want that to happen. I want the formulae to reference the same cells. I just want to move them to another location. Is there any way to do this? -- 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] How to change the start application event in 4.2.8.2
Hi :) Which Operating System are you using, or at least which platform? Windows (such as Xp, Vista, Win7), Mac or a Linux (such as Ubuntu, Mageia, openSuSE)? Sorry for the delay in response! Regards from Tom :) On 2 January 2015 at 14:51, MrKingdom 74cutl...@comcast.net wrote: When I start 4.2.8.2, I get a blank spreadsheet. I didn't get this the in the last version and I don't need it. How do I change this? -- View this message in context: http://nabble.documentfoundation.org/How-to-change-the-start-application-event-in-4-2-8-2-tp4134847.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
[libreoffice-users] captions and headings
Hi I'm working on a document that has chapters+sections 00-01, 00-02, ... 01-01, 01-02, ... etc. I'd like the figures to be numbered just using the first part, ie figure 00:01, figure 00:02, etc. With numbering running consecutively through all the 00-xx sections; but i can't figure (excuse the pun) out how to do it. A major difficulty is that the caption category doesn't appear to accept spaces or punctuation. Is there a way around this to achieve what i'd like, or am i perhaps asking a bit too much here? Thanks /Gary -- 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: How do I move a formula without changing it?
On 1/4/15 3:11 PM, Kaj Persson wrote: You might have the answer in your own question, even I am not quite ready in my thinking about this. If you move the formula (e.g. via the sequence ctrl+X and ctrl+V at the new position, well you can do it via the edit menu instead) the references do not change, the formula still points at the same cells as in the first position. It is when you copy the formula the references change, as they are relative. However to really get them absolute, you have to anchor them with the $ sign. That is very cool. I tried it and it works. I didn't realize there was a difference between copying and cutting. -- 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: How to change the start application event in 4.2.8.2
I'm using Windows 7. -- View this message in context: http://nabble.documentfoundation.org/How-to-change-the-start-application-event-in-4-2-8-2-tp4134847p4135101.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
Re: [libreoffice-users] Program Abort - Service Manager not available
Does the problem go away if you completely exist LO and then rename your LO user profile? On 01/04/2015 01:03 AM, Dr. Jim Ishler wrote: When I try to start LibrOffice I get an error that the program cannot be started. It says the service manager is not available. Premature end of file:///C:/Users/jishler/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/common.rdb I have tried reinstalling LibreOffice, repairing it, and unistalling and then reinstalling, but I always get the same error. How can I fix this? I am running Windows 7 -- 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
Re: [libreoffice-users] Using PriorToReset event in Base form
Hi Bill, I also encountered this problem. It turns out that you need to update the Control's bound field. Below is a modified version of a Macro I use. To update most Controls is fairly straightforward, but a Date Control is a bit more complicated. As you can see, you pass the Control Name, the new Value and the Form object to the Macro. In your case I think if you called - libUpdateControlValue(Date, 2015-01-04, DateField) you will get the result you want. Sub libUpdateControlValue(sControlName AS String, sNewValue AS String, oControl AS Object) Dim DateStructAS new com.sun.star.util.Date Dim sDateValue AS String Dim sControlTypeAS String sControlType = oControl.DataFieldProperty if Instr(1,Text,EffectiveValue,SelectedItems,sControlType) 0 then oControl.boundfield.updateString(sNewValue)' Sets the new value in the boundfield Object End if if sControlType = Date then sDateValue = sNewValue' to prevent sNewValue being changed! if len(sDateValue) = 10 then ' = -mm-dd sDateValue = left(sDateValue,4) + mid(sDateValue,6,2) + right(sDateValue,2)' = mmdd End if DateStruct.year = left(sDateValue,4) DateStruct.month = mid(sDateValue,5,2) DateStruct.day = mid(sDateValue,7,2) oControl.boundfield.updateDate(DateStruct)' Sets the new value in the boundfield Object End if End Sub Let me know if you have any problems. Noel -- Noel Lodge lodg...@gmail.com On 5 January 2015 at 06:39, Bill Gradwohl b...@ycc.com wrote: Please correct me if I'm wrong, and if there's a better place to ask, let me know. It is my understanding (experimentally verified) that the PriorToReset event will fire when a new database row is produced for data entry. Inside this event, I can use the passed in event object to get the Form and from the form get at the elements of the form. I named my sub the same as the event it relates to. Sub PriorToReset(event) dim Form dim DateField Form=event.source DateField = Form.getByName(Date) Now I can drop a date into the Date field via : DateField.setPropertyValue(Text, 01/04/2015 ) That date shows up on the screen as though I had keyed it in by hand. Great so far. Once I fill out the remaining fields manually, and an attempt is made to send the data to the database, an error shows up asking to fill in the mandatory Date field. I'm looking at it filled in exactly as I want it, but somehow the system thinks it's not filled in. If I focus the date field and backspace over the last digit (5) and then re enter 5 and hit enter, and then attempt to save the record, it works. Why? Why can I see the date field filled in exactly as I want it, but somehow the system thinks the field is empty or somehow invalid until I touch the field and tinker with its last digit. If I set the last digit to 9, for example, a database row is stored with 01/04/2019 in it as expected. -- Bill Gradwohl -- 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