Re: [libreoffice-users] ver. 4.2 copy/past bug
Hi :) If something worked and suddenly stopped working as if by magic then the first thing to try is to rename your User Profile https://wiki.documentfoundation.org/UserProfile Renaming is better than deleting because you might have tons of stuff in your profile (templates, galleries, Extensions, file-backups etc) that you don't want to lose. If renaming or deleting the User Profile DOES work then you might be able to copy chunks of your old one back and that can be a good way of trouble-shooting down to pin-point the problem. If you have deleted the User Profile then that is, of course, impossible. If you just renamed the User Profile then you can leave the trouble-shooting to a day when you do find time (or never but at least it's possible). If renaming DOES NOT help then you could rename the old one back without suffering any losses. On the other hand it is quite possible that you don't have anything exciting in your User Profile or that it might be a good time to start afresh with reconfiguring LO's settings and with installing fresh Extensions that you need now rather than trying to keep using ancient ones or ancient versions of ones you don't really use any more. If the problems happened straight after upgrading to a newer version then reverting to an older version makes a LOT of sense. Preferably an x.x.4 or higher. It's that 3rd digit that shows greater stability. The 4.1.4 should be about as solid as they get but some people are on 4.0.6 to get the extra stability of that although they miss out a lot on features and compatibility with MS formats. Although i have some machines still on 3.5.(something) without really missing anything but then my needs are modest for those machines. Anyway, 4.1.4 is a good release and it's worth carrying on following the 4.1.x branch as it gets developed further and stability increases further. However 30+ worksheets in a single file and 1Mb means it's quite a huge file! If you can't break it up easily (or even if you can but don't want to) then it is well worth considering using a specialist spreadsheeting program instead of Calc/Excel. Both the later are designed to integrate well with other modules/programs within an office suite but means you are carrying extra baggage and your computer is using resources to make it easy to switch into Presentations, Drawing programs, and all sorts of stuff that you probably don't need while using the spreadsheet. A specialist tool focussing resources on, and designed purely for handling, spreadsheets might be better. Gnumeric uses the same formats as Calc natively and can also handle the relevant MS formats and is often found to out-perform Excel and even Calc especially on low spec. machines. http://projects.gnome.org/gnumeric From their News section the quick link to directly download their latest Windows version is http://people.gnome.org/~mortenw/gnumeric/gnumeric-1.12.9-20131128.exe NOTE this directly downloads an Exe file!!! I NEVER usually give links like that because you don't know me and have no reason to trust me so you really should try the first link and have a look around for yourself before attempting any downloading! The only reason i give it this time is because i found it difficult to find on their site so i just wanted to make it easier for you. Regards from Tom :) On 17 February 2014 23:24, Tim Lloyd tim.ll...@gmx.com wrote: Tom, my thoughts FWIW. I would suggest restoring the latest version, deleting your user profile and trying again. This has been known to work in the past. What operating system are you using? is this an old file which has seen a number of different LO versions? Cheers On 18/02/14 03:33, Tom Cloyd wrote: I'm reverting to ver. 4.1.4.2, after spending almost 40 min. this morning trying to isolate a problem. I could reliable crash the problem by trying to copy two cells in Calc to another location in the same sheet. I got this error message: /vector::_M_range_check /I'm working and have no time to go beyond posting the problem here. That's just the reality of my life this Monday morning. I'd attempt a bug report, but every time I've tried that I've gotten lost in the sheer strangeness of the process. No time for that either. I can offer to share the spreadsheet in which the crash occurs, for what that's worth. It has maybe 30 sheets and is about a meg. in size. I did find that removing about 15 of the sheets appeared to stop the problem, for unknown reasons. t. // -- 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?
Re: [libreoffice-users] Crash Calc
Hi :) I don't know if it would help at all but have you read the section on Macros in the Published Guides? Chapter 13 in the Getting Started guide https://wiki.documentfoundation.org/Documentation/Publications There is also an excellent guide written by Andrew Pitonyak https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers If it costs money it is apparently well worth it. If not then grab it quick as it really should cost something to buy! Regards from Tom :) On 16 February 2014 09:58, informatichien informatich...@ymail.com wrote: Hello with these 2 macros called alternatively, I crash Calc after 10-50 calls. I feel like a memory leak, because before the crash there are abnormal signs: display another sheet, significant delay ... I call the macro NouvelleFacture with a list where I chose the name, then the macro Imprimer, it creates me a pdf and saves the current document (Odoc.Store) anyone have an idea? Thanks! Bonjour avec ces 2 macros appelées alternativement , je plante Calc au bout de 10 à 50 appels. j'ai l'impression d'une fuite mémoire, car avant le plantage il y a des signes anormaux : affichage d'une autre feuille, delay important... j'appelle la macro Nouvelle Facture avec une liste déroulante ou je choisi le nom, puis la macro Imprimer, celle-ci me crée un pdf et enregistre le document en cours (Odoc.Store) quelqu'un aurait une idée? bonne journée!! Sub NouvelleFacture (Evt) dim oDoc as object dim Feuille as object Dim oRange As Object Dim oCellLire as object, oCellEcrire as object Dim i as Integer Dim l as Long, ll as Long Dim itemNum as Integer Dim Nom as string, Adr1 as string, Adr2 as string, Ville as string, Chambre as string oDoc=thiscomponent Feuille=oDoc.Sheets.getByName(Formules) itemNum = Evt.Source.SelectedItemPos + 1 oCellLire = Feuille.getCellByPosition(3,9)'timer l= oCellLire.GetValue ll = Timer() l=ll-l oCellLire = Feuille.getCellByPosition(2,9)'drp impression, est vérifié à l'ouverture d'une nouvelle facture if oCellLire.GetValue = 0 AND l10 then i= MsgBox (La facture n'a pas été enregistrée, continuer?, 4 + 32 + 256, Attention) if i = 7 then exit sub End If if i = 6 then oCellEcrire = Feuille.getCellByPosition(3,9)'timer l = Timer() oCellEcrire.SetValue(l) End If else oCellLire.SetValue(0) End If oCellLire = Feuille.getCellByPosition(2,10) 'num facture i=oCellLire.Value Feuille=oDoc.Sheets.getByName(Clients) oCellLire = Feuille.getCellByPosition(0,itemNum) 'civi Nom = oCellLire.string oCellLire = Feuille.getCellByPosition(1,itemNum) 'nom Nom = Nom oCellLire.string oCellLire = Feuille.getCellByPosition(2,itemNum) 'prénom Nom = Nom oCellLire.string oCellLire = Feuille.getCellByPosition(3,itemNum) 'Adr1 Adr1 = oCellLire.string oCellLire = Feuille.getCellByPosition(4,itemNum) 'Adr2 Adr2 = oCellLire.string oCellLire = Feuille.getCellByPosition(5,itemNum) 'CP Ville = oCellLire.string oCellLire = Feuille.getCellByPosition(6,itemNum) 'Ville Ville = Ville oCellLire.string oCellLire = Feuille.getCellByPosition(7,itemNum) 'Chambre Chambre = Chambre oCellLire.string Feuille=oDoc.Sheets.getByName(FactureIndividuelle) oCellEcrire = Feuille.getCellByPosition(0,14) oCellEcrire.SetString(Facture N° i) oCellEcrire = Feuille.getCellByPosition(5,6) oCellEcrire.SetString(Nom) oCellEcrire = Feuille.getCellByPosition(5,7) oCellEcrire.SetString(Adr1) oCellEcrire = Feuille.getCellByPosition(5,8) oCellEcrire.SetString(Adr2) oCellEcrire = Feuille.getCellByPosition(5,9) oCellEcrire.SetString(Ville) oCellEcrire = Feuille.getCellByPosition(5,10) oCellEcrire.SetString(Chambre) oRange = Feuille.getCellRangeByPosition(0,18,0,29)'(A19:A30) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(0,32,0,42)'(A33:E42) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(5,18,5,29)'(F18:F30) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(5,32,5,42)'(F33:F43) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(6,18,6,29)'(G19:G30) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(6,32,6,42)'(G33:G43) oRange.clearContents(31) oCellLire = Feuille.getCellByPosition(1,20) 'acte oCellEcrire = Feuille.getCellByPosition(1,20) oCellEcrire.Setstring(oCellLire.getstring) End Sub Sub Imprimer Dim oDoc As Object Dim FeuilleDep As Object, FeuilleArr As Object Dim oCellLire as object, oCellEcrire as object Dim Args1(2) as new com.sun.star.beans.PropertyValue Dim Args2(2) as new com.sun.star.beans.PropertyValue Dim Chemin As String, maDate As String Dim i as Integer, ExoLig As Integer, numCli As Integer, numFact As Integer Dim Client as String Dim DrpModif as integer oDoc = ThisComponent FeuilleDep = oDoc.Sheets.getByName(Formules) oCellLire = FeuilleDep.getCellByPosition(2,8)' DrpModif DrpModif = oCellLire.getvalue if DrpModif = 0 then oCellLire =
Re: [libreoffice-users] plantage Calc
Hi :) Sorry i didn't know the address of the French team so i just forwarded this to here. please pass it on! I odn't know if informatichien is on this or the French mailing lists so please make sure he/she is included in replies! :) The question was translated into English and posted on the English mailing list but didn't receive any good responses. Regards from Tom :) 2014-02-16 9:50 GMT+00:00 informatichien informatich...@ymail.com: Bonjour avec ces 2 macros appelées alternativement , je plante Calc au bout de 10 à 50 appels. j'ai l'impression d'une fuite mémoire, car avant le plantage il y a des signes anormaux : affichage d'une autre feuille, delay important... j'appelle la macro Nouvelle Facture avec une liste déroulante ou je choisi le nom, puis la macro Imprimer, celle-ci me crée un pdf et enregistre le document en cours (Odoc.Store) quelqu'un aurait une idée? bonne journée!! Sub NouvelleFacture (Evt) dim oDoc as object dim Feuille as object Dim oRange As Object Dim oCellLire as object, oCellEcrire as object Dim i as Integer Dim l as Long, ll as Long Dim itemNum as Integer Dim Nom as string, Adr1 as string, Adr2 as string, Ville as string, Chambre as string oDoc=thiscomponent Feuille=oDoc.Sheets.getByName(Formules) itemNum = Evt.Source.SelectedItemPos + 1 oCellLire = Feuille.getCellByPosition(3,9)'timer l= oCellLire.GetValue ll = Timer() l=ll-l oCellLire = Feuille.getCellByPosition(2,9)'drp impression, est vérifié à l'ouverture d'une nouvelle facture if oCellLire.GetValue = 0 AND l10 then i= MsgBox (La facture n'a pas été enregistrée, continuer?, 4 + 32 + 256, Attention) if i = 7 then exit sub End If if i = 6 then oCellEcrire = Feuille.getCellByPosition(3,9)'timer l = Timer() oCellEcrire.SetValue(l) End If else oCellLire.SetValue(0) End If oCellLire = Feuille.getCellByPosition(2,10) 'num facture i=oCellLire.Value Feuille=oDoc.Sheets.getByName(Clients) oCellLire = Feuille.getCellByPosition(0,itemNum) 'civi Nom = oCellLire.string oCellLire = Feuille.getCellByPosition(1,itemNum) 'nom Nom = Nom oCellLire.string oCellLire = Feuille.getCellByPosition(2,itemNum) 'prénom Nom = Nom oCellLire.string oCellLire = Feuille.getCellByPosition(3,itemNum) 'Adr1 Adr1 = oCellLire.string oCellLire = Feuille.getCellByPosition(4,itemNum) 'Adr2 Adr2 = oCellLire.string oCellLire = Feuille.getCellByPosition(5,itemNum) 'CP Ville = oCellLire.string oCellLire = Feuille.getCellByPosition(6,itemNum) 'Ville Ville = Ville oCellLire.string oCellLire = Feuille.getCellByPosition(7,itemNum) 'Chambre Chambre = Chambre oCellLire.string Feuille=oDoc.Sheets.getByName(FactureIndividuelle) oCellEcrire = Feuille.getCellByPosition(0,14) oCellEcrire.SetString(Facture N° i) oCellEcrire = Feuille.getCellByPosition(5,6) oCellEcrire.SetString(Nom) oCellEcrire = Feuille.getCellByPosition(5,7) oCellEcrire.SetString(Adr1) oCellEcrire = Feuille.getCellByPosition(5,8) oCellEcrire.SetString(Adr2) oCellEcrire = Feuille.getCellByPosition(5,9) oCellEcrire.SetString(Ville) oCellEcrire = Feuille.getCellByPosition(5,10) oCellEcrire.SetString(Chambre) oRange = Feuille.getCellRangeByPosition(0,18,0,29)'(A19:A30) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(0,32,0,42)'(A33:E42) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(5,18,5,29)'(F18:F30) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(5,32,5,42)'(F33:F43) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(6,18,6,29)'(G19:G30) oRange.clearContents(31) oRange = Feuille.getCellRangeByPosition(6,32,6,42)'(G33:G43) oRange.clearContents(31) oCellLire = Feuille.getCellByPosition(1,20) 'acte oCellEcrire = Feuille.getCellByPosition(1,20) oCellEcrire.Setstring(oCellLire.getstring) End Sub Sub Imprimer Dim oDoc As Object Dim FeuilleDep As Object, FeuilleArr As Object Dim oCellLire as object, oCellEcrire as object Dim Args1(2) as new com.sun.star.beans.PropertyValue Dim Args2(2) as new com.sun.star.beans.PropertyValue Dim Chemin As String, maDate As String Dim i as Integer, ExoLig As Integer, numCli As Integer, numFact As Integer Dim Client as String Dim DrpModif as integer oDoc = ThisComponent FeuilleDep = oDoc.Sheets.getByName(Formules) oCellLire = FeuilleDep.getCellByPosition(2,8)' DrpModif DrpModif = oCellLire.getvalue if DrpModif = 0 then oCellLire = FeuilleDep.getCellByPosition(2,10) 'NumFacture numFact = oCellLire.getvalue oCellLire.setValue(numFact+1) else numFact = DrpModif End If oCellLire = FeuilleDep.getCellByPosition(2,8)' DrpModif oCellLire.SetValue(0) oCellLire = FeuilleDep.getCellByPosition (2,1) 'chemin Chemin = oCellLire.getString if Right(Chemin,1) / then Chemin = Chemin / End If oCellLire = FeuilleDep.getCellByPosition (5,5)'année i = oCellLire.getValue Chemin = Chemin i / oCellLire = FeuilleDep.getCellByPosition (4,5)'mois i = oCellLire.getValue oCellLire =
Re: [libreoffice-users] Dropdown box in calc, mutliple columns
Hi :) I don't know but it sounds like it might be better to use a database program for this sort of thing. Base is good when used with an external back-end. Please let us know what Operating System you are using (Xp, Win7, Ubuntu, Mac something or whatever). Also might be good to know which version of LibreOffice you are using! :) Regards from Tom :) On 12 February 2014 13:36, Pat Brown mistyha...@gmail.com wrote: I have two columns in calc. Column A has a list of items while column B has an associated cost. I want to be able to select from column A and have the item entered into a form (say column X) but I also want to automatically select the associated cost and have this entered into column Y, alongside its associated item. Is this possible in Calc, and how would I then set this up? Thanks, Paddy -- 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] LibreOffice Logo function
Thank you, Tom. Yes, I reported it yesterday using https://www.libreoffice.org/get-help/bug/. (Bug 75109). Kolbjoern Den 18.02.2014 10:35, skreiv Tom Davies: Hi Kolbjoern :) Report it!! https://wiki.documentfoundation.org/BugReport Hopefully you have reported it already since no-one responded sooner! The QA/bug-squad team do 'triage' to confirm that it's a bug and if it's not then they can close it easily. It is good to report here first except that in your case you are already heavily involved in the project and likely to be wiser about the difference between user-error and actual bug. Plus you've been involved in a local language documentation team so you have extra wisdom. So while it's good for most people to ask us jic we can solve the problem easily it;s better if you personally just go ahead and post bugs without asking us on this mailing list. Your email looks just about perfect to copypaste to the bug-report people although you might need to use their drop-downs to restate the info you have already given in that email! 4.2.1 is not unstable. It is just that it might possibly suffer from unknown issues on some real-world machines. However it's fairly rare to actually find any problems with it at all. Consider that this mailing list is one of the first places that people come to grumble when they find a problems and that about 2 years ago there were an estimated 60 million users on LibreOffice. We have under a dozen grumbles per day. AskLO and other places also have similarly low numbers of grumbles to deal with. On the other hand you are right that many of those can probably be fixed easily by going back to the 4.1.4 or by waiting for the 4.2.4. Regards from Tom :) On 16 February 2014 13:59, Kolbjørn Stuestøl kolbjo...@stuestoel.no wrote: I am not able to define my own functions in LibreOffice Logo 4.2.1.1. TO test FORWARD 20 ; or whatever command END test does not works. Nothing happens, not even an error message. Some others having the same problem? I think it is a bug, but before reporting it as such I would like to verify that it really is a bug. Using Windows 7 LibreOffice downloaded from http://no.libreoffice.org/last-ned-libreoffice/ Defining my own functions works in 4.1. (Yes, I know that 4.2 is unstable and all that, but I am using it because I am translating LO to Norwegian nynorsk). 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] paste to the edit box?
Is it possible to copy text, then paste it into the edit box in calc 4,x under ubuntu 13.10? Now I have to put the cursor in the edit box, then click on edit- paste. 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] LibreOffice Logo function
Hi Kolbjoern :) Report it!! https://wiki.documentfoundation.org/BugReport Hopefully you have reported it already since no-one responded sooner! The QA/bug-squad team do 'triage' to confirm that it's a bug and if it's not then they can close it easily. It is good to report here first except that in your case you are already heavily involved in the project and likely to be wiser about the difference between user-error and actual bug. Plus you've been involved in a local language documentation team so you have extra wisdom. So while it's good for most people to ask us jic we can solve the problem easily it;s better if you personally just go ahead and post bugs without asking us on this mailing list. Your email looks just about perfect to copypaste to the bug-report people although you might need to use their drop-downs to restate the info you have already given in that email! 4.2.1 is not unstable. It is just that it might possibly suffer from unknown issues on some real-world machines. However it's fairly rare to actually find any problems with it at all. Consider that this mailing list is one of the first places that people come to grumble when they find a problems and that about 2 years ago there were an estimated 60 million users on LibreOffice. We have under a dozen grumbles per day. AskLO and other places also have similarly low numbers of grumbles to deal with. On the other hand you are right that many of those can probably be fixed easily by going back to the 4.1.4 or by waiting for the 4.2.4. Regards from Tom :) On 16 February 2014 13:59, Kolbjørn Stuestøl kolbjo...@stuestoel.no wrote: I am not able to define my own functions in LibreOffice Logo 4.2.1.1. TO test FORWARD 20 ; or whatever command END test does not works. Nothing happens, not even an error message. Some others having the same problem? I think it is a bug, but before reporting it as such I would like to verify that it really is a bug. Using Windows 7 LibreOffice downloaded from http://no.libreoffice.org/last-ned-libreoffice/ Defining my own functions works in 4.1. (Yes, I know that 4.2 is unstable and all that, but I am using it because I am translating LO to Norwegian nynorsk). 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
Re: [libreoffice-users] Mail Merge Wizard fails in 4.2.0
Hi :) Sorry for the lack of responses! If it worked fine in 4.1.4 and stopped working in 4.2.0 then it's worth reporting as a bug-report. https://wiki.documentfoundation.org/BugReport Obviously it would be good to try 4.2.1 jic it has been fixed already but bug-squad/QA can quickly close the ticket if it has been fixed but you haven't had time to check it yourself. The main reason it's good to ask this mailing list is if you are a new user, perhaps more familiar with other office suites, and have not yet read up much of the documentation nor gained years of experience using LO/OOo/AOO. Regards from Tom :) On 15 February 2014 12:58, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: Has anyone else had a problem with the MailMerge Wizard in 4.2.0? In release 4.1.4 and all previous releases it produced the merged data. In release 4.2.0 it gives every indication that it is doing the business by stepping, the correct number of times, through the records in the selected address list. It produces the correct number of pages. Each page has the address block in it. However, each address block is empty. I've tested this on Slackware 14.1 and Windows XP. Has anyone else seen this. If so do you know if a bug has been created for this. I've searched bugzilla and not found anything. 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 -- 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] Other teams and so-called bug-reports
Hi :) Many bugs for many projects are from noobs who simply don't know their way around the programs yet. Many so-called 'bugs' could be easily closed by people who normally only consider working in direct User Support (such as this mailing list) and by just giving people links to documentation or giving a direct answer to the question. Also many people are not yet familiar with posting bug-reports and that IS something this mailing list can help with, a bit. So, again, for most people it IS better to post on this mailing list but if you have been involved for a couple of years or have read through several books of the Published Guides then feel free to go ahead and post bug-reports without asking permission! :D Also if you are on this mailing list to answer question or have unexpectedly found that you knew answers or if you are interested in helping people solve issues then it might be a good time to join the QA team to help close bug-reports that are really just a case of someone new not knowing how to use LO. This is also a good time to look into joining one of the low traffic teams such as marketing, design (UI, icons, leaflets and more), documentation, localisation/translation. This mailing list saw a sharp drop-off and also a steady decrease in traffic over the last year so now is a good time to start migrating to other teams, such as those, where your skills and knowledge will be an asset. Also there are other places where questions get asked. AskLO is one obvious one but it would also be good to troll through the vast amount of articles about LO out there and help people who write into the comments section and clearly don't know their way to good places to ask questions. Please try to give them links to here, AskLO or the official help page so they can get those links themselves and also give them links to documentation such as here http://www.libreoffice.org/get-help/documentation/ because the wiki-link we usually give on this mailing list might be confusing to such people. I am NOT saying to leave this list!! Just that if you have been here a while then you are probably used to dealing with an exceptionally high volume of traffic and might be finding yourself looking around for other ways to keep busy and there is tons of great stuff out there within the LO community. Regards from Tom :) -- 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
[Solved] Re: [libreoffice-users] Dropdown box in calc, mutliple columns
Hi :) I've been told off-list that Brian Barker did give the right answer to this. Something to do with VLook-up apparently. So, this q is completely solved Regards from Tom :) On 18 February 2014 09:19, Tom Davies tomc...@gmail.com wrote: Hi :) I don't know but it sounds like it might be better to use a database program for this sort of thing. Base is good when used with an external back-end. Please let us know what Operating System you are using (Xp, Win7, Ubuntu, Mac something or whatever). Also might be good to know which version of LibreOffice you are using! :) Regards from Tom :) On 12 February 2014 13:36, Pat Brown mistyha...@gmail.com wrote: I have two columns in calc. Column A has a list of items while column B has an associated cost. I want to be able to select from column A and have the item entered into a form (say column X) but I also want to automatically select the associated cost and have this entered into column Y, alongside its associated item. Is this possible in Calc, and how would I then set this up? Thanks, Paddy -- 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] Re: [libreoffice-accessibility] Changes in the LO 4.3-dev start screen, intentilnal or bug?
Hi Tom, yeah, my posting to the accessibility list was totally intentional, since this was a question specifically related to the interaction of LibreOffice with screen readers for the blind. There may not be a visual difference between the 4.2 and 4.3.0 dev builds of this initial LibreOffice screen at all, but the info exposed to assistive technologies may indeed vary as the result of an unintentional change, or an intentional one. :) Marco On 2/18/2014 11:48 AM, Tom Davies wrote: Hi :) I am not even sure how to check on this but has anyone else tried running the 4.3.0 pre-beta-test release and able to see if there is a dialogue in the right place? Errr, Marco posted this to the Accessibility list so please make sure he is cc'd (or in the To field) into all replies! Thanks and regards from tom :) On 18 February 2014 09:06, Marco Zehe marco.z...@googlemail.com wrote: Hi there! While testing the latest 4.3-dev build for a change related to bug 74284, I noticed that the following Option pane from LibreOffice 4.2.0 is no longer present in LibreOffice 4.3.0-dev, even from before the mentioned commit: Developer info for navigator object: name: u'' role: ROLE_OPTIONPANE states: isFocusable: False hasFocus: False Python object: NVDAObjects.IAccessible.IAccessible object at 0x057C8410 Python class mro: (class 'NVDAObjects.IAccessible.IAccessible', class 'NVDAObjects.window.Window', class 'NVDAObjects.NVDAObject', class 'baseObject.ScriptableObject', class 'baseObject.AutoPropertyObject', type 'object') description: u'Click an icon to open a new document or a file dialog.' location: (122, 186, 1418, 758) value: None appModule: 'soffice' (appName u'soffice', process ID 4320) at address 56b1cb0 appModule.productName: u'LibreOffice' appModule.productVersion: u'4.2.0.4' TextInfo: class 'NVDAObjects.NVDAObjectTextInfo' windowHandle: 524558L windowClassName: u'SALFRAME' windowControlID: 0 windowStyle: 349110272 windowThreadID: 4328 windowText: u'LibreOffice' displayText: u'' IAccessibleObject: POINTER(IAccessible2) ptr=0xe74b964 at 57ec8a0 IAccessibleChildID: 0 IAccessible event parameters: windowHandle=524558L, objectID=-4, childID=-62 IAccessible accName: u'' IAccessible accRole: ROLE_SYSTEM_CLIENT IAccessible accState: (0) IAccessible accDescription: u'Click an icon to open a new document or a file dialog.' IAccessible accValue: None IAccessible2 windowHandle: 524558 IAccessible2 uniqueID: -62 IAccessible2 role: IA2_ROLE_OPTION_PANE IAccessible2 states: (0) IAccessible2 attributes: exception: (-2147467259, 'Unspecified error', (None, None, None, 0, None)) Has this option pane really been removed from 4.3-dev visually, or is it just no longer accessible via a bug that was introduced? Regards, Marco -- To unsubscribe e-mail to: accessibility+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/accessibility/ 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] svg image format import bug
Readers, A bug has been reported about the failure of LO to display text created with an svg image: https://bugs.freedesktop.org/show_bug.cgi?id=32248 Can anyone please confirm this occurs in the latest stable version of LO writer? -- 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: svg image format import bug
Confirmed on 4.1 and 4.2 branch. Apparently this doesn't happen with all svg files. And inserting an svg with text within a document isn't a problem either. According to Comment #13 from Dec 2013 this problem no longer occurs in Apache OpenOffice so it is probably an easy task to migrate to LO the code that fixes it... It just requires finding someone with the knowledge and the interest in doing that... -- View this message in context: http://nabble.documentfoundation.org/svg-image-format-import-bug-tp4097740p4097743.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] How to setup LO
Using LO on PCLOS-64-KDE. LO version 4.1 Writer. I need to have two setups--I think you guys call them styles--one of which I will use to edit imported documents, which will then be sent to a publisher, and the other of which I will use for new originations from me. 1. The _imported_ file should be printed in Times New Roman, at whatever pitch it comes in at--10, 12, 14, etc. It should have any quotation marks or apostrophes that are straight lines converted to curly quotes. It should remove any paragraph indents. It should double space lines. It should convert double word-spaces to single. It should never sub- or super- script anything automatically. When some other function is applied, such as converting a portion of the text to fully justified, or changing type size, _nothing else should change_! 2. The _original_ document should be printed in Times New Roman, 12 point, using smart quotes, single line spacing, no automatic super- or sub- scripts, no paragraph indents, and when some other function is specified at work time, such as changing justification or centering, or type size, _nothing else should change_! Everything should be saved in /home/doug/Documents in Microsoft 1997--2003 .doc format, regardless of what format it came in at. Always! There should be some extremely easy way of selecting version 1 or version 2 above. (I am not interested in any other features. I don't write books or college papers, or anything else, and I don't like surprises, such as the whole format or layout changing when some simple change is applied.) I would really appreciate if someone out there reading this could set this up for me. (I think number 1 is the difficult one--number 2 is almost the default, I think (hope!). I have a great deal of trouble with number 1--like when I try to set up curly quotes, the only way I know how is to use the auto-format thing, and then all sorts of other things change. Thanx--doug -- 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] plantage Calc
Bonjour Le 16/02/2014 10:50, informatichien a écrit : Bonjour avec ces 2 macros appelées alternativement , je plante Calc au bout de 10 à 50 appels. j'ai l'impression d'une fuite mémoire, car avant le plantage il y a des signes anormaux : affichage d'une autre feuille, delay important... j'appelle la macro Nouvelle Facture avec une liste déroulante ou je choisi le nom, puis la macro Imprimer, celle-ci me crée un pdf et enregistre le document en cours (Odoc.Store) quelqu'un aurait une idée? Vous recevrez plus de réponses sur la liste francophone dont vous trouverez les modalités d'inscription ici : http://fr.libreoffice.org/forums/ La présente liste est en langue anglaise. Translation: You will get more answers on the French speaking list for which you will find the subscription instructions here: http://fr.libreoffice.org/forums/ The list here is an English speaking list. Merci par avance Cordialement Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org Tel:+33683901545 Membership Certification Committee Member - Co-founder The Document Foundation -- 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] Has anyone seem this 4.0 article, yet?
I just received an e-newsletter that referred to this article. nice looking small article with a slide show. It seems to be listed in the Enterprise Apps section of eWeek's online articles. It is nice to see LibreOffice and Enterprise go together. LibreOffice 4.2 Office Suite Boasts New Features, Performance Boost By Sean Michael Kerner | Posted 2014-02-03 http://www.eweek.com/enterprise-apps/slideshows/libreoffice-4.2-office-suite-boasts-new-features-performance-boost.html -- 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] Has anyone seem this 4.0 article, yet?
Kracked_P_P---webmaster wrote: I just received an e-newsletter that referred to this article. I just read that article. We must get the same newsletter. :-) -- 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: [libreoffice-marketing] Has anyone seem this 4.0 article, yet?
I think Italo keeps track of this. And yes very nice article it is encouraging to do even better :-) Best, Charles. Kracked_P_P---webmaster webmas...@krackedpress.com a écrit : I just received an e-newsletter that referred to this article. nice looking small article with a slide show. It seems to be listed in the Enterprise Apps section of eWeek's online articles. It is nice to see LibreOffice and Enterprise go together. LibreOffice 4.2 Office Suite Boasts New Features, Performance Boost By Sean Michael Kerner | Posted 2014-02-03 http://www.eweek.com/enterprise-apps/slideshows/libreoffice-4.2-office-suite-boasts-new-features-performance-boost.html -- To unsubscribe e-mail to: marketing+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/marketing/ All messages sent to this list will be publicly archived and cannot be deleted -- Envoyé de mon téléphone avec Kaiten Mail. Excusez la brièveté. -- 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] Other teams and so-called bug-reports
Le 18/02/2014 11:07, Tom Davies a écrit : Hi :) Many bugs for many projects are from noobs who simply don't know their way around the programs yet. Many so-called 'bugs' could be easily closed by people who normally only consider working in direct User Support (such as this mailing list) and by just giving people links to documentation or giving a direct answer to the question. Also many people are not yet familiar with posting bug-reports and that IS something this mailing list can help with, a bit. So, again, for most people it IS better to post on this mailing list but if you have been involved for a couple of years or have read through several books of the Published Guides then feel free to go ahead and post bug-reports without asking permission! :D Also if you are on this mailing list to answer question or have unexpectedly found that you knew answers or if you are interested in helping people solve issues then it might be a good time to join the QA team to help close bug-reports that are really just a case of someone new not knowing how to use LO. This is also a good time to look into joining one of the low traffic teams such as marketing, design (UI, icons, leaflets and more), documentation, localisation/translation. This mailing list saw a sharp drop-off and also a steady decrease in traffic over the last year so now is a good time to start migrating to other teams, such as those, where your skills and knowledge will be an asset. Also there are other places where questions get asked. AskLO is one obvious one but it would also be good to troll through the vast amount of articles about LO out there and help people who write into the comments section and clearly don't know their way to good places to ask questions. Please try to give them links to here, AskLO or the official help page so they can get those links themselves and also give them links to documentation such as here http://www.libreoffice.org/get-help/documentation/ because the wiki-link we usually give on this mailing list might be confusing to such people. I am NOT saying to leave this list!! Just that if you have been here a while then you are probably used to dealing with an exceptionally high volume of traffic and might be finding yourself looking around for other ways to keep busy and there is tons of great stuff out there within the LO community. Thanks Tom! Kind regards Sophie -- 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: svg image format import bug
Hi :) I've had trouble in other programs with words in Svgs i've made in Inkscape but haven't really explored it in LibreOffice for ages. Regards from Tom :) On 18 February 2014 12:50, Pedro pedl...@gmail.com wrote: Confirmed on 4.1 and 4.2 branch. Apparently this doesn't happen with all svg files. And inserting an svg with text within a document isn't a problem either. According to Comment #13 from Dec 2013 this problem no longer occurs in Apache OpenOffice so it is probably an easy task to migrate to LO the code that fixes it... It just requires finding someone with the knowledge and the interest in doing that... -- View this message in context: http://nabble.documentfoundation.org/svg-image-format-import-bug-tp4097740p4097743.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: [libreoffice-users] ver. 4.2 copy/past bug
Hi :) No worries! It's what we are here for! :) The thing in my answer was to try Gnumeric http://projects.gnome.org/gnumeric instead of Calc/Excel for that 1 spreadsheet (or for all of them to make it easier). Renaming (or deleting) the User Profile seems to fix something like 90% of weird problems that suddenly start but didn't occur before. It's a magic cure all worth knowing. I prefer renaming so i can go back (some day (if i ever get around to it)) to get details of why it happened. I keep meaning to back-up my User Profile when i get it just right but keep forgetting. Regards from Tom :) On 18 February 2014 15:56, Tom Cloyd tomcloydm...@gmail.com wrote: Hey, thanks, guys. That's a ton of help. I've a bit more time today, and will pursue the problem. There's also some great stuff in your email, Tom, for my carefully kept notes on LO, and especially on Calc., which I use a great deal every day. You took real time to give me that much info. I seriously appreciate this effort! Thank you both for the quick and thoughtful response. Tom On 02/18/2014 01:51 AM, Tom Davies wrote: Hi :) If something worked and suddenly stopped working as if by magic then the first thing to try is to rename your User Profile https://wiki.documentfoundation.org/UserProfile Renaming is better than deleting because you might have tons of stuff in your profile (templates, galleries, Extensions, file-backups etc) that you don't want to lose. If renaming or deleting the User Profile DOES work then you might be able to copy chunks of your old one back and that can be a good way of trouble-shooting down to pin-point the problem. If you have deleted the User Profile then that is, of course, impossible. If you just renamed the User Profile then you can leave the trouble-shooting to a day when you do find time (or never but at least it's possible). If renaming DOES NOT help then you could rename the old one back without suffering any losses. On the other hand it is quite possible that you don't have anything exciting in your User Profile or that it might be a good time to start afresh with reconfiguring LO's settings and with installing fresh Extensions that you need now rather than trying to keep using ancient ones or ancient versions of ones you don't really use any more. If the problems happened straight after upgrading to a newer version then reverting to an older version makes a LOT of sense. Preferably an x.x.4 or higher. It's that 3rd digit that shows greater stability. The 4.1.4 should be about as solid as they get but some people are on 4.0.6 to get the extra stability of that although they miss out a lot on features and compatibility with MS formats. Although i have some machines still on 3.5.(something) without really missing anything but then my needs are modest for those machines. Anyway, 4.1.4 is a good release and it's worth carrying on following the 4.1.x branch as it gets developed further and stability increases further. However 30+ worksheets in a single file and 1Mb means it's quite a huge file! If you can't break it up easily (or even if you can but don't want to) then it is well worth considering using a specialist spreadsheeting program instead of Calc/Excel. Both the later are designed to integrate well with other modules/programs within an office suite but means you are carrying extra baggage and your computer is using resources to make it easy to switch into Presentations, Drawing programs, and all sorts of stuff that you probably don't need while using the spreadsheet. A specialist tool focussing resources on, and designed purely for handling, spreadsheets might be better. Gnumeric uses the same formats as Calc natively and can also handle the relevant MS formats and is often found to out-perform Excel and even Calc especially on low spec. machines. http://projects.gnome.org/gnumeric From their News section the quick link to directly download their latest Windows version is http://people.gnome.org/~mortenw/gnumeric/gnumeric-1.12.9-20131128.exe NOTE this directly downloads an Exe file!!! I NEVER usually give links like that because you don't know me and have no reason to trust me so you really should try the first link and have a look around for yourself before attempting any downloading! The only reason i give it this time is because i found it difficult to find on their site so i just wanted to make it easier for you. Regards from Tom :) On 17 February 2014 23:24, Tim Lloyd tim.ll...@gmx.com wrote: Tom, my thoughts FWIW. I would suggest restoring the latest version, deleting your user profile and trying again. This has been known to work in the past. What operating system are you using? is this an old file which has seen a number of different LO versions? Cheers On 18/02/14 03:33, Tom Cloyd wrote: I'm reverting to ver. 4.1.4.2, after spending almost 40 min. this morning trying to isolate a
Re: [libreoffice-users] ver. 4.2 copy/past bug
Hey, thanks, guys. That's a ton of help. I've a bit more time today, and will pursue the problem. There's also some great stuff in your email, Tom, for my carefully kept notes on LO, and especially on Calc., which I use a great deal every day. You took real time to give me that much info. I seriously appreciate this effort! Thank you both for the quick and thoughtful response. Tom On 02/18/2014 01:51 AM, Tom Davies wrote: Hi :) If something worked and suddenly stopped working as if by magic then the first thing to try is to rename your User Profile https://wiki.documentfoundation.org/UserProfile Renaming is better than deleting because you might have tons of stuff in your profile (templates, galleries, Extensions, file-backups etc) that you don't want to lose. If renaming or deleting the User Profile DOES work then you might be able to copy chunks of your old one back and that can be a good way of trouble-shooting down to pin-point the problem. If you have deleted the User Profile then that is, of course, impossible. If you just renamed the User Profile then you can leave the trouble-shooting to a day when you do find time (or never but at least it's possible). If renaming DOES NOT help then you could rename the old one back without suffering any losses. On the other hand it is quite possible that you don't have anything exciting in your User Profile or that it might be a good time to start afresh with reconfiguring LO's settings and with installing fresh Extensions that you need now rather than trying to keep using ancient ones or ancient versions of ones you don't really use any more. If the problems happened straight after upgrading to a newer version then reverting to an older version makes a LOT of sense. Preferably an x.x.4 or higher. It's that 3rd digit that shows greater stability. The 4.1.4 should be about as solid as they get but some people are on 4.0.6 to get the extra stability of that although they miss out a lot on features and compatibility with MS formats. Although i have some machines still on 3.5.(something) without really missing anything but then my needs are modest for those machines. Anyway, 4.1.4 is a good release and it's worth carrying on following the 4.1.x branch as it gets developed further and stability increases further. However 30+ worksheets in a single file and 1Mb means it's quite a huge file! If you can't break it up easily (or even if you can but don't want to) then it is well worth considering using a specialist spreadsheeting program instead of Calc/Excel. Both the later are designed to integrate well with other modules/programs within an office suite but means you are carrying extra baggage and your computer is using resources to make it easy to switch into Presentations, Drawing programs, and all sorts of stuff that you probably don't need while using the spreadsheet. A specialist tool focussing resources on, and designed purely for handling, spreadsheets might be better. Gnumeric uses the same formats as Calc natively and can also handle the relevant MS formats and is often found to out-perform Excel and even Calc especially on low spec. machines. http://projects.gnome.org/gnumeric From their News section the quick link to directly download their latest Windows version is http://people.gnome.org/~mortenw/gnumeric/gnumeric-1.12.9-20131128.exe NOTE this directly downloads an Exe file!!! I NEVER usually give links like that because you don't know me and have no reason to trust me so you really should try the first link and have a look around for yourself before attempting any downloading! The only reason i give it this time is because i found it difficult to find on their site so i just wanted to make it easier for you. Regards from Tom :) On 17 February 2014 23:24, Tim Lloyd tim.ll...@gmx.com wrote: Tom, my thoughts FWIW. I would suggest restoring the latest version, deleting your user profile and trying again. This has been known to work in the past. What operating system are you using? is this an old file which has seen a number of different LO versions? Cheers On 18/02/14 03:33, Tom Cloyd wrote: I'm reverting to ver. 4.1.4.2, after spending almost 40 min. this morning trying to isolate a problem. I could reliable crash the problem by trying to copy two cells in Calc to another location in the same sheet. I got this error message: /vector::_M_range_check /I'm working and have no time to go beyond posting the problem here. That's just the reality of my life this Monday morning. I'd attempt a bug report, but every time I've tried that I've gotten lost in the sheer strangeness of the process. No time for that either. I can offer to share the spreadsheet in which the crash occurs, for what that's worth. It has maybe 30 sheets and is about a meg. in size. I did find that removing about 15 of the sheets appeared to stop the problem, for unknown reasons. t. // -- To unsubscribe e-mail to:
[libreoffice-users] Re: [libreoffice-accessibility] Cross-platform(?) spell-check bug
Hi :) Another one from the Accessibility mailing list. Regards from Tom :) On 18 February 2014 14:42, Joanmarie Diggs jdi...@igalia.com wrote: Hey all. Any Windows screen-readers users able to use the LibreOffice spell checker? https://bugs.freedesktop.org/show_bug.cgi?id=74242 If you're seeing the same problem I am in Linux and on the Mac, confirmation would be appreciated. Thanks! --joanie -- To unsubscribe e-mail to: accessibility+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/accessibility/ 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] Re: [libreoffice-accessibility] Changes in the LO 4.3-dev start screen, intentilnal or bug?
Hi :) I am not even sure how to check on this but has anyone else tried running the 4.3.0 pre-beta-test release and able to see if there is a dialogue in the right place? Errr, Marco posted this to the Accessibility list so please make sure he is cc'd (or in the To field) into all replies! Thanks and regards from tom :) On 18 February 2014 09:06, Marco Zehe marco.z...@googlemail.com wrote: Hi there! While testing the latest 4.3-dev build for a change related to bug 74284, I noticed that the following Option pane from LibreOffice 4.2.0 is no longer present in LibreOffice 4.3.0-dev, even from before the mentioned commit: Developer info for navigator object: name: u'' role: ROLE_OPTIONPANE states: isFocusable: False hasFocus: False Python object: NVDAObjects.IAccessible.IAccessible object at 0x057C8410 Python class mro: (class 'NVDAObjects.IAccessible.IAccessible', class 'NVDAObjects.window.Window', class 'NVDAObjects.NVDAObject', class 'baseObject.ScriptableObject', class 'baseObject.AutoPropertyObject', type 'object') description: u'Click an icon to open a new document or a file dialog.' location: (122, 186, 1418, 758) value: None appModule: 'soffice' (appName u'soffice', process ID 4320) at address 56b1cb0 appModule.productName: u'LibreOffice' appModule.productVersion: u'4.2.0.4' TextInfo: class 'NVDAObjects.NVDAObjectTextInfo' windowHandle: 524558L windowClassName: u'SALFRAME' windowControlID: 0 windowStyle: 349110272 windowThreadID: 4328 windowText: u'LibreOffice' displayText: u'' IAccessibleObject: POINTER(IAccessible2) ptr=0xe74b964 at 57ec8a0 IAccessibleChildID: 0 IAccessible event parameters: windowHandle=524558L, objectID=-4, childID=-62 IAccessible accName: u'' IAccessible accRole: ROLE_SYSTEM_CLIENT IAccessible accState: (0) IAccessible accDescription: u'Click an icon to open a new document or a file dialog.' IAccessible accValue: None IAccessible2 windowHandle: 524558 IAccessible2 uniqueID: -62 IAccessible2 role: IA2_ROLE_OPTION_PANE IAccessible2 states: (0) IAccessible2 attributes: exception: (-2147467259, 'Unspecified error', (None, None, None, 0, None)) Has this option pane really been removed from 4.3-dev visually, or is it just no longer accessible via a bug that was introduced? Regards, Marco -- To unsubscribe e-mail to: accessibility+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/accessibility/ 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] Keyboard shortcuts
I may have missed it, but I don't think anyone responded to this. On 8 February 2014 18:40, John Jason Jordan joh...@comcast.net wrote: The problem is that some keyboard shortcuts are not working, specifically Ctrl-F12 (opens insert table dialog box) and Ctrl-Shift-End / Ctrl-Shift-Home (selects to end / beginning of document). However, Ctrl-Shift-Right / Left Arrow select to the end / beginning of the current word, as they are supposed to, as does Ctrl-a (select all). My Ubuntu/LO 4.0.2.2 settings for Writer under Tools/Customise: Ctrl+F12 — Table Ctrl+Shift+End — Select to End of Document Ctrl+Shift+Home — Select to Beginning of Document Ctrl+Shift+Right — Select to Word Right Ctrl+Shift+Left — Select to Beginning of Word Ctrl+A — (nothing assigned in Writer; Select All assigned in LibreOffice) I have checked in the settings editor for Xubuntu and Ctrl-F12 is set to Workspace 12, although I have only two workspaces enabled, and I can't tell if Workspace 12 is just part of a preconfigured list where it is not actually enabled, or whether anything in the list is automatically enabled. I also can't figure out what the keyboard shortcut list in the settings editor actually does - e.g., if a document window is open do the settings editor preferences override the application keyboard shortcuts, or the other way around? In my experience, making keyboard assignments under Tools/Customise overrides other settings, for better or worse. As a test, in Tools/Customise (Customise dialogue box), in the Functions Category window, I selected 'Format' and in the Functions Function windows, I selected Italic. In the Keys window was Ctrl+I — I went to the Shortcut keys window, clicked on Ctrl+U (which showed Underline as the assignment) and then the Modify button. It added that shortcut to the Keys window. I then opened a Writer document, highlighted a paragraph, and used Ctrl+U. It italicised the paragraph. So making the change there overrode the normal underline function. Before switching back, I tested it in Calc and found it had also changed it for Calc **even though the choice in the Customise dialogue box had been set to Writer** and not set to LibreOffice! As for Ctrl-Shift-End and Ctrl-Shift-Home, neither is listed in the Xubuntu settings editor, so they should be completely free for applications. More importantly, these two shortcuts do not work in Gedit or my mail client's compose window either, although I can't check the Ctrl-F12 in them because these applications have no table function. And all of these shortcuts are enabled in the LO customization dialog box. If I'm understanding correctly, the assignments are correct in LibreOffice according to the Customise dialogue box? Do the keyboard assignments appear in the menu (iow, Table/Insert/Table shows Ctrl+F12)? I'm tired of having to use the mouse/menus to select to the beginning / end of a document or open the insert table dialog window. I understand. I would be also. Does anyone have any suggestions for places to poke around in? Can anyone with LO on a 'buntu duplicate the problem? In the Customise dialogue box, are any assigned actions associated with events (Events tab)? In Ubuntu, the Keyboard Settings allow keyboard assignments in eight different categories (Launchers, Navigation, Screenshots, Sound and Media, System, Universal Access, Windows, and Custom Shortcuts). I presume you checked all categories? -- T. R. Valentine A rich heart may be under a poor coat. -- 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] Mail Merge Wizard fails in 4.2.0
Hi Thanks Tom. I've raised bug - 75166 MAILMERGE: wizard produces empty address block Alex On Tuesday 18 Feb 2014 09:59:36 Tom Davies wrote: Hi :) Sorry for the lack of responses! If it worked fine in 4.1.4 and stopped working in 4.2.0 then it's worth reporting as a bug-report. https://wiki.documentfoundation.org/BugReport Obviously it would be good to try 4.2.1 jic it has been fixed already but bug-squad/QA can quickly close the ticket if it has been fixed but you haven't had time to check it yourself. The main reason it's good to ask this mailing list is if you are a new user, perhaps more familiar with other office suites, and have not yet read up much of the documentation nor gained years of experience using LO/OOo/AOO. Regards from Tom :) On 15 February 2014 12:58, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: Has anyone else had a problem with the MailMerge Wizard in 4.2.0? In release 4.1.4 and all previous releases it produced the merged data. In release 4.2.0 it gives every indication that it is doing the business by stepping, the correct number of times, through the records in the selected address list. It produces the correct number of pages. Each page has the address block in it. However, each address block is empty. I've tested this on Slackware 14.1 and Windows XP. Has anyone else seen this. If so do you know if a bug has been created for this. I've searched bugzilla and not found anything. 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 -- 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] Realtime Calc in Impress
How can I get my spreadsheets pasted into impress to update in real time during the presentation? Best Regards, Justin Barker Contractor TEMA - Production Engineering +1.859.372.2582 -- 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] Has anyone seem this 4.0 article, yet?
Hi :) Thanks! :) I added a comment about the AndrOO working fine with LO files and added a paragraph about how files in ODF seem more consistent between different versions and even between different programs in the wider OpenSource eco-system. Also had a bit of a dig at MSO :))) Regards from Tom :) On 18 February 2014 17:11, Kracked_P_P---webmaster webmas...@krackedpress.com wrote: I just received an e-newsletter that referred to this article. nice looking small article with a slide show. It seems to be listed in the Enterprise Apps section of eWeek's online articles. It is nice to see LibreOffice and Enterprise go together. LibreOffice 4.2 Office Suite Boasts New Features, Performance Boost By Sean Michael Kerner | Posted 2014-02-03 http://www.eweek.com/enterprise-apps/slideshows/libreoffice-4.2-office-suite-boasts-new-features-performance-boost.html -- 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] Re: svg image format import bug
On 18/02/2014, Pedro pedl...@gmail.com wrote: Confirmed on 4.1 and 4.2 branch. Apparently this doesn't happen with all svg files. And inserting an svg with text within a document isn't a problem either. To clarify, the scenario is creating an svg image and adding a text node _within_ that image file; the vector lines are successfully visible when imported in Writer, but the text within the image is invisible. Any existing text in the Writer document remains unchanged after image import. -- 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] Keyboard shortcuts
2014-02-18 18:59 GMT+01:00 T. R. Valentine trvalent...@gmail.com: I may have missed it, but I don't think anyone responded to this. On 8 February 2014 18:40, John Jason Jordan joh...@comcast.net wrote: The problem is that some keyboard shortcuts are not working, specifically Ctrl-F12 (opens insert table dialog box) and Ctrl-Shift-End / Ctrl-Shift-Home (selects to end / beginning of document). However, Ctrl-Shift-Right / Left Arrow select to the end / beginning of the current word, as they are supposed to, as does Ctrl-a (select all). My Ubuntu/LO 4.0.2.2 settings for Writer under Tools/Customise: Ctrl+F12 — Table Ctrl+Shift+End — Select to End of Document Ctrl+Shift+Home — Select to Beginning of Document Ctrl+Shift+Right — Select to Word Right Ctrl+Shift+Left — Select to Beginning of Word Ctrl+A — (nothing assigned in Writer; Select All assigned in LibreOffice) I have checked in the settings editor for Xubuntu and Ctrl-F12 is set to Workspace 12, although I have only two workspaces enabled, and I can't tell if Workspace 12 is just part of a preconfigured list where it is not actually enabled, or whether anything in the list is automatically enabled. I also can't figure out what the keyboard shortcut list in the settings editor actually does - e.g., if a document window is open do the settings editor preferences override the application keyboard shortcuts, or the other way around? In my experience, making keyboard assignments under Tools/Customise overrides other settings, for better or worse. As a test, in Tools/Customise (Customise dialogue box), in the Functions Category window, I selected 'Format' and in the Functions Function windows, I selected Italic. In the Keys window was Ctrl+I — I went to the Shortcut keys window, clicked on Ctrl+U (which showed Underline as the assignment) and then the Modify button. It added that shortcut to the Keys window. I then opened a Writer document, highlighted a paragraph, and used Ctrl+U. It italicised the paragraph. So making the change there overrode the normal underline function. The ”normal underline function”? As I understand it, the ”normal underline function” is defined exactly there, so you didn't override it, you changed it. Or do you mean that the LibreOffice Customise dialogue box changed the underline functions in other programs too, such as gnote or whatever? Johnny Rosenberg Before switching back, I tested it in Calc and found it had also changed it for Calc **even though the choice in the Customise dialogue box had been set to Writer** and not set to LibreOffice! As for Ctrl-Shift-End and Ctrl-Shift-Home, neither is listed in the Xubuntu settings editor, so they should be completely free for applications. More importantly, these two shortcuts do not work in Gedit or my mail client's compose window either, although I can't check the Ctrl-F12 in them because these applications have no table function. And all of these shortcuts are enabled in the LO customization dialog box. If I'm understanding correctly, the assignments are correct in LibreOffice according to the Customise dialogue box? Do the keyboard assignments appear in the menu (iow, Table/Insert/Table shows Ctrl+F12)? I'm tired of having to use the mouse/menus to select to the beginning / end of a document or open the insert table dialog window. I understand. I would be also. Does anyone have any suggestions for places to poke around in? Can anyone with LO on a 'buntu duplicate the problem? In the Customise dialogue box, are any assigned actions associated with events (Events tab)? In Ubuntu, the Keyboard Settings allow keyboard assignments in eight different categories (Launchers, Navigation, Screenshots, Sound and Media, System, Universal Access, Windows, and Custom Shortcuts). I presume you checked all categories? -- T. R. Valentine A rich heart may be under a poor coat. -- 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] ver. 4.2 copy/past bug
Tom, Well, I'm back on ver. 4.2. I have a lot of files in Calc with links - to various sheets, and to other files. THEY ARE ALL BROKEN NOW. This is a disaster, and reverting LO isn't, I think going to fix it. Sigh. Re: faster load/save of files - xml is a text format, and will necessarily be slower than a binary equivalent - that's my understanding, anyway. I noticed quite some time ago, when converting from Excel to Calc that the save took about 3 times as along. t. On 02/18/2014 10:12 AM, Tom Davies wrote: Hi :) Thanks! :) Xml is the way all the office formats are going. It does have 3 main advantages afaik; 1. When things go wrong it's easier to poke around inside and maybe even fix corrupted files 2. It's easy to compress further into Zip or other compression formats 3. errr, oh i thought it was faster and easier to load/save but i've never seen anyone produce stats about it. Now you mention it i've no idea whether it feels faster or slower to open files. As for your User Profile, it might be a really good idea to occasionally create a back-up copy in the same way and then keep the one with the settings you like best to put on any machine just before installing LibreOffice or OpenOffice so that you get all your fav. settings but with all the relevant updated bits added by the installer. Regards from Tom :) On 18 February 2014 16:41, Tom Cloyd tomcloydm...@gmail.com wrote: Tom, I have to say that nothing makes me smile quite like a quick, detailed response to a problem reported to a user discussion list! For years, the absolute best list in this regard I've experienced has been that for the Lilypond music engraving software, but LO's list is surely a close second. As for gnumeric - that's totally new to me. I like calc, but do NOT like the fact that it save files in xml and thus they are large and slow to save and retrieve. There's just no need for that. Xml should be an option, with binary the default, in my opinion. Will definitely give gnumeric a try. Thanks for the profile-renaming tip. I followed your advice, and thus saved my dictionaries - probably the single most valuable thing in my user profile. Thanks again for all the help! Tom On 02/18/2014 09:32 AM, Tom Davies wrote: Hi :) No worries! It's what we are here for! :) The thing in my answer was to try Gnumeric http://projects.gnome.org/gnumeric instead of Calc/Excel for that 1 spreadsheet (or for all of them to make it easier). Renaming (or deleting) the User Profile seems to fix something like 90% of weird problems that suddenly start but didn't occur before. It's a magic cure all worth knowing. I prefer renaming so i can go back (some day (if i ever get around to it)) to get details of why it happened. I keep meaning to back-up my User Profile when i get it just right but keep forgetting. Regards from Tom :) On 18 February 2014 15:56, Tom Cloyd tomcloydm...@gmail.com wrote: Hey, thanks, guys. That's a ton of help. I've a bit more time today, and will pursue the problem. There's also some great stuff in your email, Tom, for my carefully kept notes on LO, and especially on Calc., which I use a great deal every day. You took real time to give me that much info. I seriously appreciate this effort! Thank you both for the quick and thoughtful response. Tom On 02/18/2014 01:51 AM, Tom Davies wrote: Hi :) If something worked and suddenly stopped working as if by magic then the first thing to try is to rename your User Profile https://wiki.documentfoundation.org/UserProfile Renaming is better than deleting because you might have tons of stuff in your profile (templates, galleries, Extensions, file-backups etc) that you don't want to lose. If renaming or deleting the User Profile DOES work then you might be able to copy chunks of your old one back and that can be a good way of trouble-shooting down to pin-point the problem. If you have deleted the User Profile then that is, of course, impossible. If you just renamed the User Profile then you can leave the trouble-shooting to a day when you do find time (or never but at least it's possible). If renaming DOES NOT help then you could rename the old one back without suffering any losses. On the other hand it is quite possible that you don't have anything exciting in your User Profile or that it might be a good time to start afresh with reconfiguring LO's settings and with installing fresh Extensions that you need now rather than trying to keep using ancient ones or ancient versions of ones you don't really use any more. If the problems happened straight after upgrading to a newer version then reverting to an older version makes a LOT of sense. Preferably an x.x.4 or higher. It's that 3rd digit that shows greater stability. The 4.1.4 should be about as solid as they get but some people are on 4.0.6 to get the extra stability of that although they miss out a lot on features and compatibility with MS formats. Although i have some machines
[libreoffice-users] Document Recovery window appears
The Document Recovery window comes up every time I open LO. When I Start Recovery Recovery failed comes up. Closing out window I can continue with LO. I have uninstalled and reinstalled LO, but it is still happening. Thanks for help. Muriel Parker -- 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] Document Recovery window appears
On Tue, Feb 18, 2014 at 4:46 PM, Muriel Parker rspn...@gmail.com wrote: The Document Recovery window comes up every time I open LO. When I Start Recovery Recovery failed comes up. Closing out window I can continue with LO. I have uninstalled and reinstalled LO, but it is still happening. Sounds like the problem I've had. Next time the Document Recovery window appear press Esc instead of the things you name above. Saw this tip while lurking on this list and it worked for me. -Alan -- 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] ver. 4.2 copy/past bug
UPDATE re: the below problem: This is very odd. Here's an example of what I'm seeing: I have a hyperlink from a cell in sheet C to a cell in sheet A. I click/double-click the link. Nothing happens. I inspect the link, and where the link target URL should be I see !!br0ken!! But the tool-tip over the link advises me to try Ctrl-click and that actually works. Is this the default? Could be, for all I know. And why does the link indicate it's broken, yet it still works? I can make NO sense of this, I'll admit. t. = Tom, Well, I'm back on ver. 4.2. I have a lot of files in Calc with links - to various sheets, and to other files. THEY ARE ALL BROKEN NOW. This is a disaster, and reverting LO isn't, I think going to fix it. Sigh. Re: faster load/save of files - xml is a text format, and will necessarily be slower than a binary equivalent - that's my understanding, anyway. I noticed quite some time ago, when converting from Excel to Calc that the save took about 3 times as along. t. On 02/18/2014 10:12 AM, Tom Davies wrote: Hi :) Thanks! :) Xml is the way all the office formats are going. It does have 3 main advantages afaik; 1. When things go wrong it's easier to poke around inside and maybe even fix corrupted files 2. It's easy to compress further into Zip or other compression formats 3. errr, oh i thought it was faster and easier to load/save but i've never seen anyone produce stats about it. Now you mention it i've no idea whether it feels faster or slower to open files. As for your User Profile, it might be a really good idea to occasionally create a back-up copy in the same way and then keep the one with the settings you like best to put on any machine just before installing LibreOffice or OpenOffice so that you get all your fav. settings but with all the relevant updated bits added by the installer. Regards from Tom :) On 18 February 2014 16:41, Tom Cloyd tomcloydm...@gmail.com wrote: Tom, I have to say that nothing makes me smile quite like a quick, detailed response to a problem reported to a user discussion list! For years, the absolute best list in this regard I've experienced has been that for the Lilypond music engraving software, but LO's list is surely a close second. As for gnumeric - that's totally new to me. I like calc, but do NOT like the fact that it save files in xml and thus they are large and slow to save and retrieve. There's just no need for that. Xml should be an option, with binary the default, in my opinion. Will definitely give gnumeric a try. Thanks for the profile-renaming tip. I followed your advice, and thus saved my dictionaries - probably the single most valuable thing in my user profile. Thanks again for all the help! Tom On 02/18/2014 09:32 AM, Tom Davies wrote: Hi :) No worries! It's what we are here for! :) The thing in my answer was to try Gnumeric http://projects.gnome.org/gnumeric instead of Calc/Excel for that 1 spreadsheet (or for all of them to make it easier). Renaming (or deleting) the User Profile seems to fix something like 90% of weird problems that suddenly start but didn't occur before. It's a magic cure all worth knowing. I prefer renaming so i can go back (some day (if i ever get around to it)) to get details of why it happened. I keep meaning to back-up my User Profile when i get it just right but keep forgetting. Regards from Tom :) On 18 February 2014 15:56, Tom Cloyd tomcloydm...@gmail.com wrote: Hey, thanks, guys. That's a ton of help. I've a bit more time today, and will pursue the problem. There's also some great stuff in your email, Tom, for my carefully kept notes on LO, and especially on Calc., which I use a great deal every day. You took real time to give me that much info. I seriously appreciate this effort! Thank you both for the quick and thoughtful response. Tom On 02/18/2014 01:51 AM, Tom Davies wrote: Hi :) If something worked and suddenly stopped working as if by magic then the first thing to try is to rename your User Profile https://wiki.documentfoundation.org/UserProfile Renaming is better than deleting because you might have tons of stuff in your profile (templates, galleries, Extensions, file-backups etc) that you don't want to lose. If renaming or deleting the User Profile DOES work then you might be able to copy chunks of your old one back and that can be a good way of trouble-shooting down to pin-point the problem. If you have deleted the User Profile then that is, of course, impossible. If you just renamed the User Profile then you can leave the trouble-shooting to a day when you do find time (or never but at least it's possible). If renaming DOES NOT help then you could rename the old one back without suffering any losses. On the other hand it is quite possible that you don't have anything exciting in your User Profile or that it might be a good time to start afresh with reconfiguring LO's settings and with installing fresh Extensions that you need
Re: [libreoffice-users] Document Recovery window appears
Hi :) Cancel the recovery instead of trying to recover. That should clear it and usually opens the document more correctly too. Regards from Tom :) On 18 February 2014 21:46, Muriel Parker rspn...@gmail.com wrote: The Document Recovery window comes up every time I open LO. When I Start Recovery Recovery failed comes up. Closing out window I can continue with LO. I have uninstalled and reinstalled LO, but it is still happening. Thanks for help. Muriel Parker -- 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