Re: [libreoffice-users] LO suddenly very slow
I tried that. That computer has LO Version 4.2.8.2. Same problem, started at about line 225. Took over a minute to bring up the help menu after clicking help. It took another 30 or so seconds to close the window with the version number, so either something in my sheet is causing a cpu slow down, memory hog, etc. or ...? John On 01/15/2016 12:28 PM, Virgil Arrington wrote: This is a pure stab in the dark, but can you run it on LO 4.x? I had loaded LO 5.0.x a few weeks ago and found it crashing often. So, I uninstalled it and reinstalled L.O. 4. Perhaps there's something in v. 5 that isn't ready for spreadsheet prime time. Virgil On 01/15/2016 02:20 PM, John R. Sowden wrote: I have a SS with about 6 pages, lots of calcs, lookups, etc. about 175K in size. I am running LO ver 5.0.3.2 under Ubuntu ver 14.04 with 4 GB ram.. The other year's sheets of the same size run fine (several a little larger). All of a sudden at about line 250 I hit a brick wall. I enter text, it takes about 5 seconds, sometimes more, to put the data on the screen and give me the cursor back. When loading, the progress bar moves to the center immediately and then stays there for about 25 seconds before it moves on and then displays the SS. I don't know if I need to "compact" it, although there is nothing in the menu tree that discusses that. I have recopied the formulas that are used in this area from above areas, no change. Thoughts? John -- 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] LO suddenly very slow
This is a pure stab in the dark, but can you run it on LO 4.x? I had loaded LO 5.0.x a few weeks ago and found it crashing often. So, I uninstalled it and reinstalled L.O. 4. Perhaps there's something in v. 5 that isn't ready for spreadsheet prime time. Virgil On 01/15/2016 02:20 PM, John R. Sowden wrote: I have a SS with about 6 pages, lots of calcs, lookups, etc. about 175K in size. I am running LO ver 5.0.3.2 under Ubuntu ver 14.04 with 4 GB ram.. The other year's sheets of the same size run fine (several a little larger). All of a sudden at about line 250 I hit a brick wall. I enter text, it takes about 5 seconds, sometimes more, to put the data on the screen and give me the cursor back. When loading, the progress bar moves to the center immediately and then stays there for about 25 seconds before it moves on and then displays the SS. I don't know if I need to "compact" it, although there is nothing in the menu tree that discusses that. I have recopied the formulas that are used in this area from above areas, no change. Thoughts? John -- 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] Bulleted and Numbered List graphic not normal
When copying and pasting an article into Write (latest version), the bulleted list or numbered lists show a ball with a 10 on it instead of the plain black dot graphic. Even Numbered Lists are the 10 ball. How do I change the default graphic for the list 'dot'? The first graphic for the lists is that little black ball with a 10 on it.. it looks like a 10 ball for pool. If I can't change the default graphic, how can I delete that graphic.. just get rid of it? Where is the graphics for the lists? Thanks, E.W. -- 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] LO suddenly very slow
I have a SS with about 6 pages, lots of calcs, lookups, etc. about 175K in size. I am running LO ver 5.0.3.2 under Ubuntu ver 14.04 with 4 GB ram.. The other year's sheets of the same size run fine (several a little larger). All of a sudden at about line 250 I hit a brick wall. I enter text, it takes about 5 seconds, sometimes more, to put the data on the screen and give me the cursor back. When loading, the progress bar moves to the center immediately and then stays there for about 25 seconds before it moves on and then displays the SS. I don't know if I need to "compact" it, although there is nothing in the menu tree that discusses that. I have recopied the formulas that are used in this area from above areas, no change. Thoughts? John -- 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] Problem
This list doesn't allow attachments. So we couldn't see anything. From what you write it sounds like a virus… but I have really little to no clues. --- Gabriele Ponzo 2016-01-15 16:58 GMT+01:00 Doreen Howes : > I am not sure whether this is the correct address to use but, if not, > perhaps you could forward it on to somebody who can help me sort out my > problem. I attach a screenshot of an error message I am getting when > trying to open a number of my documents with various endings, e.g. odt, > htm, eml. C directory is of course the one normally used so I cannot > understand what is going wrong. Any advice would be much appreciated. > > Doreen Howes > > -- > 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] Problem
I am not sure whether this is the correct address to use but, if not, perhaps you could forward it on to somebody who can help me sort out my problem. I attach a screenshot of an error message I am getting when trying to open a number of my documents with various endings, e.g. odt, htm, eml. C directory is of course the one normally used so I cannot understand what is going wrong. Any advice would be much appreciated. Doreen Howes -- 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: Transferrig a parameter to a sub form
Am 15.01.2016 um 04:23 schrieb Egbert Eissing:
> I have a form with atable control which lists all the employees, and a
> sub-form with atable control that lists the payroll data of each employee.
> If an employee isselected in the first table, the employeeID should be passed
> to thesub form to filter the data for the selected employee. The code
> couldlook something like this:
> oDoc=ThisComponent.DrawPage.Forms
> oFormACemplData=oDoc.getByName("ACemplData”) ' main form
> oFormPayrollData=oDoc.getByName("FormPayrollData”) ' sub form
> oEmployeeID =oForm.getByName("employeeID") ' employeeID is theparameter for
> TablePayrollData. sEmployeeID =oEmployeeID.text oFormPayrollData.Parameter=
> setINT(sEmployeeID) oFormPayrollData.refresh()
> It is this second tolast line, the syntax of which I do not know, and have
> not been ableto find in any of the examples I have read and re-read.
> Alternatively, if itis not possible to just pass a parameter to the table,
> may be it ispossible to pass a complete prepared statement instead.
> Could anybodyprovide some clue on how to do it?Thanks for helping. Egbert
>
Apply master and slave fields to the subform. No macro required. For
more than A=B AND X=Y bindings, you can bind the subform to a parameter
query and link paramA=X AND paramB=Y while paramA and paramB can be used
with all kinds of functions and operators.
--
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] Linking a Form to another table
OK - I have found the answer to this problem myself here... http://stackoverflow.com/questions/27102600/solved-libreoffice-com-mysql-jdbc-driver-cannot-be-loaded On 01/14/2016 06:23 PM, Ian "Witty" Whitfield wrote: Hi All Am still trying to connect my existing 'Input Form' to a different Table. Been busy so got round to trying it again today!! Now when I try to link to an existing Database I get the error "The JBDC Driver could not be loaded". The Class is "com.mysql.jdbc.Driver" which worked before. Any idea what is wrong or what I can check - I'm lost!! Thanks Ianw Pretoria RSA -- 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
