[libreoffice-users] Calc function
I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once a number appears in B4:G11 4 times, it changes color to Red...got that part. Then I want to manually enter that number somewhere into J4:N21. once entered into J4:N21, i want that number to erase from B4:G11. ideally at that point i would also like all remaining numbers in B4:G11 to shift up, leaving no empty cells above cells with values in them (keeping them in the order entered within columns). -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Browser plugin gives blank page
Hi Tim, Le 2012-04-17 15:10, webmaster-Kracked_P_P a écrit : Marc, I have not kept up with this thread. If you mean opening a .odt file from an online source in Firefox, [instead of saving to the disk] like it use to do a few months back, I remember the last 2 or 3 times with Firefox 10 and 11, I got a blank page myself. This was Ubuntu 10.04's FF repository versions. I do remember it use to work fine, but not since the repository went from 3 or 4 straight to 10 and then 11 a week later. I also was running 3.4.5 then, but now 3.4.6. I wonder if there is a browser issue and not the LO issue. Then, if this is the case, it should be reviewed by the LibreOffice devs to see if they could make it work again with the newer versions of FF as this is an integrated plugin in LibreOffice and not an add-on. I have to say this is a useful plugin and I hope it is made to work again. It was reported as a bug in Dec 2011 here: https://bugs.freedesktop.org/show_bug.cgi?id=44232 Marc -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc function
Am 17.04.2012 19:35, Mike Phelan wrote: I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once a number appears in B4:G11 4 times, it changes color to Red...got that part. Then I want to manually enter that number somewhere into J4:N21. once entered into J4:N21, i want that number to erase from B4:G11. ideally at that point i would also like all remaining numbers in B4:G11 to shift up, leaving no empty cells above cells with values in them (keeping them in the order entered within columns). Only a small set of features adds data to your spreadsheet and nothing in Calc will ever remove any data automatically. You have to do that by hand or by means of a macro program. It seems to be another inventory task which should be done in a database program of your choice. Later you may connect your database to this office suite (this is what the Base component does) and use Calc or Writer as output medium for pretty printing and further calculations. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 17/04/12 18:14, Andreas Säger a écrit : Hi all, The easiest improvements in my honest opinion: - Wipe out the .odb container all together and get back to the configuration of database access in OOo 1. Back to external databases with configuration data in configuration files, forms and reports in stand-alone office documents. More speed more safety, security, accessibility and transparency. People who do not understand how to connect separated software tools do not understand the .odb container neither (as we can read in all the mail merge topics). - Remove all the half done wizards. Do not improve them. Remove! No database developer nor interface designer needs all this stinky rubbish. There are graphical tools to compose forms and reports within office documents. There is SQL for all the rest, including all the things we can not do in the current graphical interface. There are plenty of SQL editors to produce valid SQL for various databases. SQL text can be pasted into any database configuration. - Add native database queries, so the current direct SQL mode returns editable row sets and the (useless or even harmful) graphical query designer can be removed as well. - Having removed all the wizards (they are Java components) without losing any functionality at all, extensions could substitute .odb packages. When you open the extension, the database gets installed _permanently_ (rather than _temporarily_ like the .odb) into the configuration tree together with the forms and reports documents. The database will be registered and all the tables, queries, forms and reports are accessible form the data source window, hyperlinks and desktop links just like it used to be in OOo 1. Ah, nostalgia those were halcyon days ;-) +1 (not that that means anything in our user land. Unfortunately, as I was told quite a while ago either on the dev-list or IRC dev channel, or bugzilla, no-one wants to go back to 10 year old technology, i.e. the LO devs are not interested in undoing what Sun it its infinite wisdom thought would be a good idea when it re-invented OOo-Base, so we are stuck with what we have until someone steps up and decides to either unravel it all or improve it - a mammoth task by anyone's standards. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 17/04/12 20:13, ptoye a écrit : Is there any point in suggesting that LibO and OO should continue to diverge? I'd have thought convergence would be more productive, both in terms of the development which seems too thinly spread, and for users who might even see a serious contender emerging. To my knowledge (which granted, may be limited), there is not a single Base developer on the AOOo team. The integration of hsqldb2 had already been prepared during Oracle's tenure, it was thereafter a matter of integrating the child workspace of the relevant code. Moreover, AOOo have dropped future bundling of the Oracle ReportBuilder extension because of licensing problems with some of the Pentaho libraries, as with the mysql native connector. In other words, the Base module in AOOo is effectively at best stalled, at worst crippled with regard to OOo 3.3.x Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Problems importing an OO database into LO
Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work rather well on the whole, albeit with tweaking, and are multi-OS compatible. LONG story short I have now moved my (re-built) Database on to Kexi - and what a difference It's like getting out of an old broken-down VW (or other make) of car and getting into a brand new Jaguar and driving down the highway at 100mph!! And I know what that feels like as I did just that last year in the UK!! Yes there is a lot to learn and work out but the overall effect is like Chalk and Cheese!! For anyone interested I can recommend this DB - some of the more fancy options are only due out in future releases but for a basic DB job it just works!! Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a Windows, Mac or Solaris user and then have that work ? If not, then it is no better than Access, or Lotus Approach. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) I think Kexi and the rest of Calligra/KOffice has a Windows version just as LibreOffice does. Calligra/KOffice uses ODF natively and presumably can use MS formats although i'm not sure quite how well. Regards from Tom :) --- On Wed, 18/4/12, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:17 Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work rather well on the whole, albeit with tweaking, and are multi-OS compatible. LONG story short I have now moved my (re-built) Database on to Kexi - and what a difference It's like getting out of an old broken-down VW (or other make) of car and getting into a brand new Jaguar and driving down the highway at 100mph!! And I know what that feels like as I did just that last year in the UK!! Yes there is a lot to learn and work out but the overall effect is like Chalk and Cheese!! For anyone interested I can recommend this DB - some of the more fancy options are only due out in future releases but for a basic DB job it just works!! Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a Windows, Mac or Solaris user and then have that work ? If not, then it is no better than Access, or Lotus Approach. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Legacy Base reports won't open in LibreOffice 3.5
Le 17/04/12 06:26, frofa a écrit : Hi, In LO 3.5 when I click on a particular legacy report to run it, the expected window saying Connecting to data source Importing data opens for a brief instant, then disappears, leaving just the window with the report template layout showing...but no report is ever generated. Note: All the queries my reports are based on run perfectly (in LO 3.5) so it doesn't seem to be a database connection problem. This sounds like an import problem of the hidden field, and should be reported as a bug against the Writer component. Or better still, check to see whether there isn't already a bug report about failed opening of Writer documents containing hidden fields. Please also add the workaround you mention in your post. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
On 18/04/2012 11:17, Alexander Thurgood wrote: Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work rather well on the whole, albeit with tweaking, and are multi-OS compatible. Hi Alex - Yes I wanted to try this and everybody said it was easy but NOBODY gave me any instructions!! I did mess about with it a few times but got nowhere - so I never was able to try this out!! Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a Windows, Mac or Solaris user and then have that work ? If not, then it is no better than Access, or Lotus Approach. Kexi is a standard SQLlight format so the files should be movable between OpSys-es. I also see that Calligra 2.4 has just been released that includes the latest Kexi and this is available on Window$ and they are asking for Mac OS Devs also!! But non of this was a major concern of mine. I run my own DB and used it EVERY day. I don't have to pass it on to others so as long as it works for me (well) in Linux - that's what I need!!! And so far Kexi is delivering, (for me anyway!!). All the best Ian W Pretoria -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) The divergence has resulted in at least a doubling of the numbers of people working on the project(s). The projects do have a lot of overlap and share a lot. People that were colleagues working alongside each other may find themselves split into different projects but still chatting and helping each other. Taking just LibreOffice alone, it has famously already had a vast amount of devs join in. The Easy hacks initiative has made it far easier to get devs that are familiar with other projects familiarised with programming for LibreOffice. It's helped draw in students and other people that have never really done any programming before or left programming years ago and Google's Summer of Code has helped draw people into programming for LO too. Under Sun the infrastructure had all grown quite tangled so it was good to get a fresh start under TDF maximising the usefulness of modern technology that simply wasn't around when Sun's infrastructure was originally planned. The Apache Foundation is quite large and IBM can support their developments but would fidn it difficult to support a truly and fully OpenSource project such as LibreOffice. Apparently Apache Licensing allows a mix of some fairly proprietary chunks of code alongside OpenSource ones. If OOo had just carried on under Sun then it wouldn't have had the resources of either Apache nor TDF let alone both!! Plus about half the community would have been unhappy about not being fully OpenSource and therefore never gaining the backing of the Free Software Foundation which has led to a greater range of distros being comfortable using LO. The other half might have wanted to pull us more in the direction of corporate secrecy such as IBM seem to want. This way both sides are happier and growing faster. Regards from Tom :) --- On Wed, 18/4/12, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:17 Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work rather well on the whole, albeit with tweaking, and are multi-OS compatible. LONG story short I have now moved my (re-built) Database on to Kexi - and what a difference It's like getting out of an old broken-down VW (or other make) of car and getting into a brand new Jaguar and driving down the highway at 100mph!! And I know what that feels like as I did just that last year in the UK!! Yes there is a lot to learn and work out but the overall effect is like Chalk and Cheese!! For anyone interested I can recommend this DB - some of the more fancy options are only due out in future releases but for a basic DB job it just works!! Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a Windows, Mac or Solaris user and then have that work ? If not, then it is no better than Access, or Lotus Approach. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters
Tom wrote: How do you do that if your system (openSuSE 12.1) only allows two (2) key composition? I didn’t think there was such a restriction. I have a custom compose list (on Ubuntu), and I just created a three-key combination, and it works. Is this something unique to SUSE (which seems unlikely), or is there something else wrong? Do your two-key combinations work? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) That sounds much easier for data-input and normal look-up use for normal users that are barely familiar with Word/Writer and Calc/Excel. Most normal office workers seem scared of using databases for even low level tasks. This style of use takes away the scary front-end and gives them something more familiar. It sounds like a slightly tougher challenge for the designers in some ways but saves them endless time fiddling around lining up boxes on Forms and Reports. If normal office workers can be allowed to do the fiddling then i think that suits everyone much better. Regards from Tom :) --- On Wed, 18/4/12, Fernand Vanrie s...@pmgroup.be wrote: From: Fernand Vanrie s...@pmgroup.be Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:55 On 17/04/2012 23:58, Andreas Säger wrote: Am 17.04.2012 19:23, Tom Davies wrote: Hi :) It looks like most of this can be done without touching Base itself? Is LO able to use databases in this way already? Is it something that could be passed to the devs list an/or the BoD discussion list? Something like this could be phrased to capture the imagination, Saying it's the old way might put them off. Regards from Tom :) I use to use Base like this. I connect a Base document to HSQL 2.8 databases with forms and reports on the desktop (spreadsheet reports are sufficient for us). The Base container is nothing but a configuration file storing the connection URL, SQL query strings and the default log-in (and I left some rarely used admin forms in it). My users do not know anything about the database document. The content of the database document could be some XML and query strings in the configuration tree (just like it used to be in OOo 1). We are using OO-LO as a front end to connect to MySQL, we no longer use the LO-forms etc , but we usesDialogs and their controls (also Drids and the DataSourceBrowser)who are fed with the MySQL-data. Reporting is done by feeding WriterDocs with the data, or Calc-spreadsheets for data oriented reports. Exporting to a spreadsheet is very slow when feeding the sheet cell by cell. But using the doimport on a cell range is lightning fast. For Connecting, we use the NativeConnector. We try to avoid using a OO-LO dbase doc(for safety reasons) and connect directly using the DriverManager. This method has a important drawback, The DataSourceBrowser is not working without connecting with dbaseDoc. when low volume selections (100 lines)using the GridControls is very use full but becomes to slow for big selections, here is the DataSource browser a possible workaround. GridControls however have the advantage that we can color every line, that makes it far more user friendly. This system is used by 100 users , who can do all their tasks with only using OO-LO Greetz Fernand -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Problems importing an OO database into LO
Hi :) That is exactly why i wondered if Andreas' points could be worked on while leaving the existing package, Base, as it stands. That way the database functionality could be moved forwards while leaving the kludgy mess (ok, it might not be a kludge from a coders pov) to get sorted 'later'. The trees outside my window have been severely pruned back but i know that by the summer the leaves will be out in full force. The trees look a lot healthier already as they are not groaning under their own weight. Regards from Tom :) --- On Wed, 18/4/12, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:05 Le 17/04/12 18:14, Andreas Säger a écrit : Hi all, The easiest improvements in my honest opinion: - Wipe out the .odb container all together and get back to the configuration of database access in OOo 1. Back to external databases with configuration data in configuration files, forms and reports in stand-alone office documents. More speed more safety, security, accessibility and transparency. People who do not understand how to connect separated software tools do not understand the .odb container neither (as we can read in all the mail merge topics). - Remove all the half done wizards. Do not improve them. Remove! No database developer nor interface designer needs all this stinky rubbish. There are graphical tools to compose forms and reports within office documents. There is SQL for all the rest, including all the things we can not do in the current graphical interface. There are plenty of SQL editors to produce valid SQL for various databases. SQL text can be pasted into any database configuration. - Add native database queries, so the current direct SQL mode returns editable row sets and the (useless or even harmful) graphical query designer can be removed as well. - Having removed all the wizards (they are Java components) without losing any functionality at all, extensions could substitute .odb packages. When you open the extension, the database gets installed _permanently_ (rather than _temporarily_ like the .odb) into the configuration tree together with the forms and reports documents. The database will be registered and all the tables, queries, forms and reports are accessible form the data source window, hyperlinks and desktop links just like it used to be in OOo 1. Ah, nostalgia those were halcyon days ;-) +1 (not that that means anything in our user land. Unfortunately, as I was told quite a while ago either on the dev-list or IRC dev channel, or bugzilla, no-one wants to go back to 10 year old technology, i.e. the LO devs are not interested in undoing what Sun it its infinite wisdom thought would be a good idea when it re-invented OOo-Base, so we are stuck with what we have until someone steps up and decides to either unravel it all or improve it - a mammoth task by anyone's standards. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] More crashes
Hi :) For bug-reporting these 2 guides end-up with roughly the same result. Noobs to OpenSource might prefer the 2nd link but i suspect you might prefer the 1st one http://wiki.documentfoundation.org/BugReport https://www.libreoffice.org/get-help/bug/ I'm glad to hear most of your crashing is fixed by going back to the 3.4.6! Which version of java are you using now? Tools - Options - Java Regards from Tom :) --- On Wed, 18/4/12, Jonathan Schultz jonat...@imatix.com wrote: From: Jonathan Schultz jonat...@imatix.com Subject: [libreoffice-users] More crashes To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 1:37 Although reverting to version 3.4.6 stopped some of the crashes I was experiencing, I find that I still get regular crashing on certain files. One particular problem is that trying to copy-and-paste from a master document containing 8 sub-documents into a new document causes instant crashing. And some other spurious files seem to provoke regular crashes. So my questions are: 1. Any suggested work-arounds for the master document problem? 2. Is it worth my while getting a debug output for these other crashes? And where should I report it if I do? Thanks, Jonathan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Rendering issue on Windows and Draw product
Hi people, First of all thanks a lot for the hard work you are carrying out. Few weeks ago I found and issue using LibreOffice Draw product, basically the issue is i don't see anything in the main window... looks like the rendering is not working well on my computer. Details as follow: Product version: 3.5.2 (it is also happening with 3.5.X) SO: Windows 7 Professional - SP1 Java version: 1.6.0_26 http://nabble.documentfoundation.org/file/n3919611/LibreOffice_3_5_2_rendering_issue.png Is someone experiencing same behaviour? Thanks in advance, Hector -- View this message in context: http://nabble.documentfoundation.org/Rendering-issue-on-Windows-and-Draw-product-tp3919611p3919611.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] beware of the m$ subsidiary
Hi :) The question is a moving target and seems to be moving in our favour. More people are using LO/OOo now even if it's often alongside MSO. Also it's about how much power and control you have. There are many circumstances where you are totally at the mercy of other people and have to accept what they use. A single job-seeker signing up with agencies, an office worker that has to comply with company policy, a company reliant on customers who could easily go elsewhere. However there are many places where you can grab power and demand that people treat you with some consideration. So grab when you can and just gently push the rest of the time and gracefully give-in but have another go a while later. Just my tuppence Regards from Tom :) --- On Wed, 18/4/12, Jay Lozier jsloz...@gmail.com wrote: From: Jay Lozier jsloz...@gmail.com Subject: Re: [libreoffice-users] beware of the m$ subsidiary To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 1:20 On 04/17/2012 06:56 PM, e-letter wrote: On 17/04/2012, webmaster-Kracked_P_Pwebmas...@krackedpress.com wrote: Well, it is always good to promote ODF, but if you work in a business environment, you cannot get away from MSO's file formats. I create the documents in LO and save my copy in ODF, but I still have to send editable files to some people who's business or agency has not or cannot switch to LO. So for these people/businesses/agencies, I need to send them MSO file formatted documents. You could send in odf, which m$ is supposed to support. Growth in the quantity of odf documents, together with people complaining to m$ (instead of complaining to LO!), the long term effect is to force m$ to improve compatibility with odf, _not_ vice versa! The analogy is one of the worse technologies: flash. Thankfully, successful marketing of apple products increased the quantity of non-flash devices and therefore the demand for other technologies, e.g. html5. Promote LO and ODF, but you still have to deal with those who have not switched over to LO and/or ODF. Most government agencies [USA] at all levels are not allowed to use any other office package but MSO AND are forbidden to install software on their computers, including screen-savers and such. I know of one that will not allow the use of USB devices as well. So, until everyone switches to ODF, we must continue to save some of our documents to MSO formates and send them off to others. I wonder if someone in the USA could sue and win because the MSO format is a proprietary format thus requiring users to buy a proprietary product for best results. If an agency used only odf formats that are readable by any number of free and proprietary products then users are not forced to purchase specific product for best results. Such organisations were often forced to use m$ie6, whilst the world moved forward to using safari, opera, firefox, etc.. The world did not wait for m$ to improve their web browser! Therefore, the claim that everyone must simultaneously change to odf is a fallacy. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Browser plugin gives blank page
Hi :) My GnuLinux repos give me a mozilla-OpenOffice plugin but the repos are set-up so that i would have to install OOo to be able to use it. I think it should be grabbed, modified for LO and put on LO's Extensions website Regards from Tom :) --- On Tue, 17/4/12, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: From: webmaster-Kracked_P_P webmas...@krackedpress.com Subject: Re: [libreoffice-users] Re: Browser plugin gives blank page To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 20:10 On 04/17/2012 02:46 PM, Marc Paré wrote: Hi Jay Le 2012-04-15 23:47, Jay Lozier a écrit : Same results here too; I get a blank page. I am running LO 3.5.2.2 under Mageia Linux and Java 1.7.0_03 on FF 9.0.1. Marc Is the problem with the plugin? I think we would need more people to confirm, but, yes, I would say it's with the plugin seeing as everything else on my browser works without any problems. Marc Marc, I have not kept up with this thread. If you mean opening a .odt file from an online source in Firefox, [instead of saving to the disk] like it use to do a few months back, I remember the last 2 or 3 times with Firefox 10 and 11, I got a blank page myself. This was Ubuntu 10.04's FF repository versions. I do remember it use to work fine, but not since the repository went from 3 or 4 straight to 10 and then 11 a week later. I also was running 3.4.5 then, but now 3.4.6. I wonder if there is a browser issue and not the LO issue. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: beware of the m$ subsidiary
On 4/17/12 6:01 AM, webmaster-Kracked_P_P wrote: Most government agencies [USA] at all levels are not allowed to use any other office package but MSO AND are forbidden to install software on their computers, including screen-savers and such. It can be misleading to say something like this (yes, it's true) without also saying *why* these policies are in place. To keep the explanation simple, it's the ability to support the hardware and software out there, and ensure security of the system as a whole, and do so with diminishing resources. Been there, done that. :-) -- Ken Mac OS X 10.6.8 Firefox 11.0 Thunderbird 11.0.1 LibreOffice 3.5.1.2 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problems importing an OO database into LO
I think Andreas' approach for end users is a very good idea. I think, furthermore, that it starts to redefine how databases can be used. that's a good thing and going dowm that track will, I'm sure, lead to further developments. As such, yes, I think it would be a great idea to push that approach. I think that as an additional and separate approach, what is thought of as Base now *should* be made more accessible and useful so that the general populace *can* start to do things with data themselves. Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problems importing an OO database into LO
I'm almost thinking of installing something like MySQL and writing my own front-end in Java. I'm sorry if I'm being slow, or not following the conversation properly (lots going on here at the moment), but, if you're thinking like that, what's wrong with Base? The things you'd need to do, Base does. The things that approach won't get you, something to present your data, you'd use Writer/Calc for. The two problems I've registered (which have a multitude of subsidiaries, I know, I'm not trying to say Base is great yet, it's clearly not), is that the whole thing crashes, the answer is use a back end not the embedded system, and the wizards are cr*p, building your own front end to (eg) MySQL won't help you there. Andreas' approach of writing queries and setting up Writer documents to use them does what you want, doesn't it? Writing documentation for this approach would be a good idea to broadcase these ideas. Mark Stanton One teeny-tiny step for mankind, apparently... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] beware of the m$ subsidiary
On 2012-04-17 8:01 AM, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: Well, it is always good to promote ODF, but if you work in a business environment, you cannot get away from MSO's file formats. I create the documents in LO and save my copy in ODF, but I still have to send editable files to some people who's business or agency has not or cannot switch to LO. So for these people/businesses/agencies, I need to send them MSO file formatted documents. Sadly, we will soon be rolling out Microsoft Office to most of our employees due to the poor support for the new MS xml file formats (we get a ton of these from external clients/vendors, and complaining to them and begging for them to send the older file formats is simply not an option). I am hoping that Microsofts licensing will allow me to set up a Terminal Server and provide 'shared' access to Office (ie, once the max number of sessions is in use, other users will get some kind of 'sorry, all instances of MSO are in use, please try again later), so we don't have to buy a license for everyone... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] beware of the m$ subsidiary
On 2012-04-17 6:56 PM, e-letter inp...@gmail.com wrote: You could send in odf, which m$ is supposed to support. Growth in the quantity of odf documents, together with people complaining to m$ (instead of complaining to LO!), the long term effect is to force m$ to improve compatibility with odf, No, the long term effect, for those doing business, is anyone doing this becomes a laughing stock to the clients/vendors they work with... it is the ODF format that will be deemed broken, NOT Microsofts poor support of it. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: beware of the m$ subsidiary
Am 17.04.2012 13:50, e-letter wrote: Readers, M$ is allegedly seeking to invest in interoperability and open source: http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790. Perhaps more for 'Groklaw', but isn't this a potential trojan horse to pollute GPLv3? We will see true interoperability only when odf and openformula become the defaults within m$o. Until then, please avoid creation of m$ formats using LO and continue to promote odf. If MS publishes announcements like this one, this is the best indicator that nothing will actually happen. It's the usual appeasement blah blah towards the public sector. They just have to wait for their users (and LibO) to spread more OOXML documents. Then they have pushed their new de-facto standard. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Lorem Ipsum is 'sticks' in full screen mode (LO v 3.5.2)
Hello, I just installed the LO version 3.5.2, and Magenta's Lorem Ipsum extension 'sticks' in full screen mode. (Windows 7 64-Bit) I tried reinstalling the extension but it did not resolve the problem. http://imagebin.org/208618 (installed) http://imagebin.org/208619 (uninstalled) -- GnuPG is Free Software (meaning that it respects your freedom). Extensible, customizable text editor---GNU Emacs; Where's yours? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Spell checker breaks in Windows XP LO 3.5.2
Hi Manfred, Thanks a lot for your quick response!! So I've tried as best as I can to replicate what you've suggested. Unfortunately, I can't seem to make the fat check mark appear anywhere. For example, post-restart, I see under Tools Options Language Settings Languages: http://nabble.documentfoundation.org/file/n3920136/picture_00.png Under Tools Options Language Settings Writing Aids I see: http://nabble.documentfoundation.org/file/n3920136/picture_01.png and http://nabble.documentfoundation.org/file/n3920136/picture_02.png In no case can I make this fat check mark appear. Again, it's as though the extension is broken. If you have the time to forward some more ideas, I would be grateful!! Thanks, Christian -- View this message in context: http://nabble.documentfoundation.org/Spell-checker-breaks-in-Windows-XP-LO-3-5-2-tp3919812p3920136.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] beware of the m$ subsidiary
On Tue, 2012-04-17 at 12:50 +0100, e-letter wrote: Readers, M$ is allegedly seeking to invest in interoperability and open source: http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790. Oh, whatever. And this sent from a gmail account. Yea. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Spell checker breaks in Windows XP LO 3.5.2
Hi Christian, On Wed, Apr 18, 2012 at 4:24 PM, cbkschroeder [via Document Foundation Mail Archive] ml-node+s969070n3920136...@n3.nabble.com wrote: Hi Manfred, Thanks a lot for your quick response!! So I've tried as best as I can to replicate what you've suggested. Unfortunately, I can't seem to make the fat check mark appear anywhere. For example, post-restart, I see under Tools Options Language Settings Languages: [image: picture 00] Under Tools Options Language Settings Writing Aids I see: [image: picture 01] and [image: picture 02] In no case can I make this fat check mark appear. Again, it's as though the extension is broken. If you have the time to forward some more ideas, I would be grateful!! I'm pretty sure that something is broken in your LibreOffice user profile. [1] You might try to re-synchronize the 'bundled dictionaries': - Close LibreOffice (+ Quickstarter, if enabled) - Go to '...\Documents and Settings\user name\Application Data\LibreOffice\3\user\extensions\bundled' - Rename the folder 'bundled' to (e.g.) 'bundled_old' - Restart LibO. A new folder 'bundled' will be created in the user profile. All bundled dictionaries should be available. Hope this helps... Addendum: (1) Checking the program folder 'extensions' [Path: ...\Program_Files\LibreOffice 3.5\share\extensions] - Folder 'dict-en' is available (with the file 'en_US.dic' [among others])? (2) Your LibreOffice 3.5.2 installation: default or customized installation? (3) Does the problem occur--right from start--with - a renamed LibreOffice user profile - another / a new user (OS level)? mjk [1] https://wiki.documentfoundation.org/Documentation/UserProfile -- View this message in context: http://nabble.documentfoundation.org/Spell-checker-breaks-in-Windows-XP-LO-3-5-2-tp3919812p3920385.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] beware of the m$ subsidiary
Intermediate free software required. It appears to be time for an intermediate translation software be made available. Similar to those that change image types between png, jpg and tiff. The idea is a free translation software that sits in between the file and the program calling for the file. When the file is called, the intermediate delivers to the program in the file type requested. The intermediate software filter should be freely available for all operating systems. The consumer installs once and is never bothered again with this issue. Updates are backgrounded. This also isolates issues of files not correctly importing/exporting and removes it as an issue from the program the user wants. Those who claim proprietary cannot claim foul, can remain isolated and cannot claim foul when not forthcoming with assistance. Whaddayathink? On 4/17/2012 7:50 AM, e-letter wrote: Readers, M$ is allegedly seeking to invest in interoperability and open source: http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790. Perhaps more for 'Groklaw', but isn't this a potential trojan horse to pollute GPLv3? We will see true interoperability only when odf and openformula become the defaults within m$o. Until then, please avoid creation of m$ formats using LO and continue to promote odf. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] beware of the m$ subsidiary
Hi :) +1 but if we keep gently pushing, where we can, things will keep making progress. It does help to have louder campaigners such as FSF and Richard Stallman. It would be great if e-letter could join FSF if he/she hasn't already. Regards from Tom :) --- On Wed, 18/4/12, Tanstaafl tansta...@libertytrek.org wrote: From: Tanstaafl tansta...@libertytrek.org Subject: Re: [libreoffice-users] beware of the m$ subsidiary To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 13:48 On 2012-04-17 6:56 PM, e-letter inp...@gmail.com wrote: You could send in odf, which m$ is supposed to support. Growth in the quantity of odf documents, together with people complaining to m$ (instead of complaining to LO!), the long term effect is to force m$ to improve compatibility with odf, No, the long term effect, for those doing business, is anyone doing this becomes a laughing stock to the clients/vendors they work with... it is the ODF format that will be deemed broken, NOT Microsofts poor support of it. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc function
Den 18 april 2012 09:47 skrev Andreas Säger ville...@t-online.de: Am 17.04.2012 19:35, Mike Phelan wrote: I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once a number appears in B4:G11 4 times, it changes color to Red...got that part. Then I want to manually enter that number somewhere into J4:N21. once entered into J4:N21, i want that number to erase from B4:G11. ideally at that point i would also like all remaining numbers in B4:G11 to shift up, leaving no empty cells above cells with values in them (keeping them in the order entered within columns). Only a small set of features adds data to your spreadsheet and nothing in Calc will ever remove any data automatically. You have to do that by hand or by means of a macro program. It seems to be another inventory task which should be done in a database program of your choice. Later you may connect your database to this office suite (this is what the Base component does) and use Calc or Writer as output medium for pretty printing and further calculations. I actually think it's possible with cell functions only, but I think it would be quite complicated. Too complicated for me, anyway. I did something else that I also thought was impossible first, but I solved it eventually. It was not easy (for me) though… My task was to create a list of things that is sorted automatically. The formulas were quite long and hard to read… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: beware of the m$ subsidiary
Hi :) Interestingly apparently many US government agencies and departments use GnuLinux for most of their server-side and infra-structure but had to cave into users demands for MS on their desktops. An interesting quiet little press release appeared on the DistroWatch website a few days ago. http://distrowatch.com/ Scroll down to the note written 2012-04-13 A new version of Lightweight Portable Security (LPS), a Linux live CD with strong privacy protection features created by the United States Department of Defence, is out. Version 1.3.3 is a maintenance release, updating Firefox, Flash, Adobe Reader and OpenSSL, and adding Thunderbird and Pidgin to the deluxe edition. From the changelog: Changes in version 1.3.3: updated Firefox to 10.0.3 ESR; updated Flash to 11.2.202.228; updated OpenSSL to 0.9.8u; updated Adobe Reader to 9.5.1; updated Encryption Wizard application to 3.3.2; added Thunderbird 3.1.20 and DAVmail to LPS-Public Deluxe for S/MIME email support with MS Exchange OWA; added Pidgin 2.10.2 (with SameTime support); added VMware View 1.4; added option for OpenDNS DNSCrypt; added Firefox extension HTTPS Everywhere 2.0.1; added Firefox extension NoScript 2.3.7 (disabled by default). Download (SHA256) the live CD images from the project's download server: LPS-1.3.3_public.iso (176MB), LPS-1.3.3_public_deluxe.iso (377MB). Shamelessly copypasted from the DW site. See the original here http://distrowatch.com/?newsid=07201 if it has scrolled off the bottom of the DW front page. Err, i bcc'd one of the main people, probably the top person at DW just to keep him in the loop Regards from Tom :) --- On Wed, 18/4/12, Ken Springer snowsh...@q.com wrote: From: Ken Springer snowsh...@q.com Subject: [libreoffice-users] Re: beware of the m$ subsidiary To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 12:14 On 4/17/12 6:01 AM, webmaster-Kracked_P_P wrote: Most government agencies [USA] at all levels are not allowed to use any other office package but MSO AND are forbidden to install software on their computers, including screen-savers and such. It can be misleading to say something like this (yes, it's true) without also saying *why* these policies are in place. To keep the explanation simple, it's the ability to support the hardware and software out there, and ensure security of the system as a whole, and do so with diminishing resources. Been there, done that. :-) -- Ken Mac OS X 10.6.8 Firefox 11.0 Thunderbird 11.0.1 LibreOffice 3.5.1.2 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Spell checker breaks in Windows XP LO 3.5.2
Do me a favor, try using this Canadian English dictionary. [en-CA] http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/kpp-canadian-english-dictionary-638K-word-list.oxt See if it over-writes some of the default files for you enough for it to work for your needs. There may be some part of the locked, default, dictionary that is causing you the issues. I wonder if a different English dictionary would solve the problems, since with several dictionaries installed, I see the last one is checked first. That is what happens when I look at the Thesaurus part of the dictionaries. I seen my Thesaurus listing show up before the default installed version's listings. So I hope the the English spelling part will be used first, or over write the previous versions in the file[s] that contain the used dictionary information. It might help, or it may not. I deal with en-US as my default language. I tend to make sure a US version is installed instead of a generic all English version. I think the default one includes many non-North American English localizations, like South African English. This is the en-US version of the dictionary. http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/kpp-american-english-dictionary-638k-word-list.oxt Try the dictionary extensions. See if that helps your issue. Also, my versions have more words in its word lists than the default installed one and any other version I can find. 638,000+ words for the largest en-CA version, with 217K words in the smallest en-CA version. On 04/18/2012 08:38 AM, cbkschroeder wrote: Hi, The spell checker in LibreOffice 3.5.2 seems to spontaneously break. This happened to me on previous versions, too. I have spent too much time going through various channels to try to solve the problem; lots of workarounds -- installing other dictionaries, for example -- can be found. These workarounds don't, of course, solve the problem. I'm using US English, and I'm in Canada. Before I waste somebody's time by submitting a bug report, I thought I'd try here for input. It seems that one day I will happily be using writer with the spell check running 100%. Then, next day, the spell checker doesn't seem to work anymore. Poof. I've got XP SP3. It seems as though the English dictionary extension somehow breaks despite my doing nothing in regard to configuring the software beyond default. I had entertained that running OS updates might be breaking the software, so I tried the following, though I couldn't replicate the issue. I know, this may seem like a lot to post for a negative result, but I feel it might be useful to know what DOESN'T seem to cause the problem. - Reverted to 120401 OS backup image made via True Image; LibreOffice 3.5.1 was installed; spell check didn't work. Most recent round of XP updates had not been applied. - Uninstalled Libreoffice 3.5.1 - Deleted LibreOffice folder in Program Files - Deleted LibreOffice folder in C:\Documents and Settings\Administrator\Application Data - Deleted LibreOffice shortcuts in Start menu - Ran CCleaner - Rebooted - Installed LibreOffice 3.5.2 and helppack. - Rebooted. - Ran LibreOffice Writer. Touched nothing, just started typing gobbledegook. US English spell check was active and lots of little red squiggly error underlines indicated the spell check was working. - Went to tools, options, language settings, languages, and under Default Languages for Documents there was a nice fat check mark with ABC written over top of it beside the Default - English (USA) setting. Several other languages present here also had that thick check mark. - User interface setting was Default - English (USA), Locale setting was Default - English (USA). I took a snapshot of the window: http://nabble.documentfoundation.org/file/n3919812/picture_00.png - When I went to the extension manager, scrolled down to English Spelling Dictionaries and left-clicked to highlight it, I saw that an Options button appeared: http://nabble.documentfoundation.org/file/n3919812/picture_01.png Clicking it opened yet another window which said English Sentence Checking: http://nabble.documentfoundation.org/file/n3919812/picture_02.png - Ran CCleaner 3.17.1689, ran the cleaner function, ran the registry Scan for Issues function, fixed all issues, and rebooted. - Started writer again, discovered the state of the program was unchanged from the above description. Everything worked fine. The last CCleaner execution clearly did not adversely effect LO. - Proceeded to run the windows updates one by one. - Cumulative Security Update for Internet Explorer 8 for Windows XP (KB2675157). Rebooted. LO OK. Ran CCleaner. Rebooted. LO OK. - Security Update for Windows XP (KB2653956). Rebooted. LO OK. Ran CCleaner. Rebooted. LO OK. - Windows Malicious Software Removal Tool - April 2012 (KB890830). Rebooted. LO OK. Ran CCleaner. Rebooted. LO OK. - Security Update for
Re: [libreoffice-users] select en-dash and em-dash characters
Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net: On Tue, 17 Apr 2012 18:09:31 +0200 Johnny Rosenberg gurus.knu...@gmail.com wrote: Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie: Regina wrote: They are usually written via AutoCorrect. The simple hyphen is replaced with the en-dash or em-dash when the following word is finished . . . That is _not_ a good idea. The hyphen, en rule and em rule (dash) are distinct characters with distinct uses in conventional typography and typesetting. Their correct use cannot be predicted by context, nor are they interchangeable. You need to find out where these characters are in the character set you are using. This depends on your operating system, your language, and your keyboard layout. As Johnny pointed out, they can be entered with the compose key. If you use them so often that even this is too cumbersome you can customise your keyboard layout, That's actually what I did (called ”Sweden Johnny Rosenberg”, available on my computers only…), but I didn't mention it because I thought it could be a bit tricky… I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also did a lot of other modification, like removed all my numbers from the first row (I already have them on the num pad to the right – why have them at more than one place?) and moved some Shift+number combinations so I don't need Shift for characters like ”!#%/” and so on. I even made labels to put on my keys, but most of them was worn out after a couple of weeks of typing… To change the layout (or rather add a new one in this case), you need to fiddle with three files (at least in Ubuntu): /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml and /usr/share/X11/xkb/symbols/the file representing your language, more on that another time… Ok, this was a bit off topic… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ so that (for example) compose-hyphen gets you the en rule and shift-compose-hyphen gets you the dash (em rule). If you want to do this I will help you (but only if you use GNU/Linux!). You could, as Johnny suggests, create your own auto-correct sequences, but personally I would avoid all such contrivances. Auto-correct is _not_ your friend. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Hi Johnny; Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the keyboard but which key is Gr? My keyboard (an old IBM windows model) doesn't have such a key. Thanks, Tom I saw that someone already answered, but I'll reply anyway. The ”+” does only mean that the key is hold. So Alt+Shift+x means that Alt, Shift and x is pressed simultaneously, or at least that no key is released before the other keys is pressed. The compose key doesn't work that way, therefore no ”+” sign: ”Compose --.” means ”hit the Compose key, release it, then type --.”. About the AltGr key, I don't think it exists on standard US keyboards, for example. Many other languages though, use some characters that are not on a regular US keyboard, like in my case, Swedish. We have three extra letters in our alphabet: A-Z, then ÅÄÖ and the same for lower case (a-z, åäö). That means that there are not enough keys for everything, so characters like ”{[]}\|” are omitted, or at least replaced by our Swedish characters. We need them sometimes anyway though, so they are placed on other keys and we can type them by using the AltGr key, for example AltGr+8 for ”[” and AltGr+9 for ”]”. On the other hand, at least with Swedish keyboards, they have no right Alt key, only one to the left, so I guess AltGr is simply the right Alt key. It's placed immediately to the right of the space key, at least on my keyboard. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters
Den 18 april 2012 02:12 skrev Thomas Taylor li...@comcast.net: On Tue, 17 Apr 2012 10:48:22 +0100 Séamas Ó Brógáin s...@iol.ie wrote: Doug: Using the compose key, the default settings are: dash (em rule) --- en rule: --. How do you do that if your system (openSuSE 12.1) only allows two (2) key composition? Thanks, Tom I have had OpenSUSE some years back (I think it was 11.3 or something), but unfortunately I didn't test this… However, this page doesn't say anything about that the compose key behaviour is depending on your GNU/Linux-distribution, so I thought this was true for all of them. Maybe it's a Gnome thing and you have the KDE version of OpenSUSE? Well, I don't think so, but I use Gnome only, so I don't know. Best regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters
Den 18 april 2012 18:19 skrev Johnny Rosenberg gurus.knu...@gmail.com: Den 18 april 2012 02:12 skrev Thomas Taylor li...@comcast.net: On Tue, 17 Apr 2012 10:48:22 +0100 Séamas Ó Brógáin s...@iol.ie wrote: Doug: Using the compose key, the default settings are: dash (em rule) --- en rule: --. How do you do that if your system (openSuSE 12.1) only allows two (2) key composition? Thanks, Tom I have had OpenSUSE some years back (I think it was 11.3 or something), but unfortunately I didn't test this… However, this page doesn't say anything about that the compose key behaviour is depending on your GNU/Linux-distribution, so I thought this was true for all of them. Forgot to include the link to ”this page”… sorry… :D Here it is: http://www.hermit.org/Linux/ComposeKeys.html Maybe it's a Gnome thing and you have the KDE version of OpenSUSE? Well, I don't think so, but I use Gnome only, so I don't know. Best regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters
Even Micro$oft Windoze has keyboards using the AltGr. For a list of available keyboard layouts in Windoze: http://msdn.microsoft.com/en-us/goglobal/bb964651 An example of a U.S. English (US-International) keyboard layout which uses the AltGr: http://www.microsoft.com/resources/msdn/goglobal/keyboards/kbdusx.html On my main PC (Linux), I use the English-International keyboard as my default layout because a lot of my typing uses words in French, German, and other languages. It is way easier than having to open Character Map, find the desired character, copy it, and paste. AFAIK, all Linux flavours and all Windoze versions have the ability to switch between keyboard layouts. -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters
On Wed, 18 Apr 2012 18:10:18 +0200 Johnny Rosenberg gurus.knu...@gmail.com wrote: Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net: On Tue, 17 Apr 2012 18:09:31 +0200 Johnny Rosenberg gurus.knu...@gmail.com wrote: Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie: Regina wrote: They are usually written via AutoCorrect. The simple hyphen is replaced with the en-dash or em-dash when the following word is finished . . . That is _not_ a good idea. The hyphen, en rule and em rule (dash) are distinct characters with distinct uses in conventional typography and typesetting. Their correct use cannot be predicted by context, nor are they interchangeable. You need to find out where these characters are in the character set you are using. This depends on your operating system, your language, and your keyboard layout. As Johnny pointed out, they can be entered with the compose key. If you use them so often that even this is too cumbersome you can customise your keyboard layout, That's actually what I did (called ”Sweden Johnny Rosenberg”, available on my computers only…), but I didn't mention it because I thought it could be a bit tricky… I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also did a lot of other modification, like removed all my numbers from the first row (I already have them on the num pad to the right – why have them at more than one place?) and moved some Shift+number combinations so I don't need Shift for characters like ”!#%/” and so on. I even made labels to put on my keys, but most of them was worn out after a couple of weeks of typing… To change the layout (or rather add a new one in this case), you need to fiddle with three files (at least in Ubuntu): /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml and /usr/share/X11/xkb/symbols/the file representing your language, more on that another time… Ok, this was a bit off topic… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ so that (for example) compose-hyphen gets you the en rule and shift-compose-hyphen gets you the dash (em rule). If you want to do this I will help you (but only if you use GNU/Linux!). You could, as Johnny suggests, create your own auto-correct sequences, but personally I would avoid all such contrivances. Auto-correct is _not_ your friend. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Hi Johnny; Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the keyboard but which key is Gr? My keyboard (an old IBM windows model) doesn't have such a key. Thanks, Tom I saw that someone already answered, but I'll reply anyway. The ”+” does only mean that the key is hold. So Alt+Shift+x means that Alt, Shift and x is pressed simultaneously, or at least that no key is released before the other keys is pressed. The compose key doesn't work that way, therefore no ”+” sign: ”Compose --.” means ”hit the Compose key, release it, then type --.”. snip Hi Johnny ;) The problem with the above is that in openSuSE the compose key only allows two (2) keystroke combinations, not three (3). Compose -./-- do not insert anything. To me, this is just a point of education as I don't use dash m/n in my writing. Just trying to learn a bit. Thanks for any further explanation. Tom -- Tom Taylor - retired penguin openSUSE 12.1x86_64 openSUSE 12.2x86_64 KDE 4.6.00, FF 7.0 KDE 4.7.2, FF 11.0 claws-mail 3.8.0 registered linux user 263467 linxt-At-comcast-DoT-net -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters (added)
On Wed, 18 Apr 2012 18:10:18 +0200 Johnny Rosenberg gurus.knu...@gmail.com wrote: Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net: On Tue, 17 Apr 2012 18:09:31 +0200 Johnny Rosenberg gurus.knu...@gmail.com wrote: Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie: Regina wrote: They are usually written via AutoCorrect. The simple hyphen is replaced with the en-dash or em-dash when the following word is finished . . . That is _not_ a good idea. The hyphen, en rule and em rule (dash) are distinct characters with distinct uses in conventional typography and typesetting. Their correct use cannot be predicted by context, nor are they interchangeable. You need to find out where these characters are in the character set you are using. This depends on your operating system, your language, and your keyboard layout. As Johnny pointed out, they can be entered with the compose key. If you use them so often that even this is too cumbersome you can customise your keyboard layout, That's actually what I did (called ”Sweden Johnny Rosenberg”, available on my computers only…), but I didn't mention it because I thought it could be a bit tricky… I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also did a lot of other modification, like removed all my numbers from the first row (I already have them on the num pad to the right – why have them at more than one place?) and moved some Shift+number combinations so I don't need Shift for characters like ”!#%/” and so on. I even made labels to put on my keys, but most of them was worn out after a couple of weeks of typing… To change the layout (or rather add a new one in this case), you need to fiddle with three files (at least in Ubuntu): /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml and /usr/share/X11/xkb/symbols/the file representing your language, more on that another time… Ok, this was a bit off topic… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ so that (for example) compose-hyphen gets you the en rule and shift-compose-hyphen gets you the dash (em rule). If you want to do this I will help you (but only if you use GNU/Linux!). You could, as Johnny suggests, create your own auto-correct sequences, but personally I would avoid all such contrivances. Auto-correct is _not_ your friend. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Hi Johnny; Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the keyboard but which key is Gr? My keyboard (an old IBM windows model) doesn't have such a key. Thanks, Tom I saw that someone already answered, but I'll reply anyway. The ”+” does only mean that the key is hold. So Alt+Shift+x means that Alt, Shift and x is pressed simultaneously, or at least that no key is released before the other keys is pressed. The compose key doesn't work that way, therefore no ”+” sign: ”Compose --.” means ”hit the Compose key, release it, then type --.”. snip Hi Johnny ;) The problem with the above is that in openSuSE the compose key only allows two (2) keystroke combinations, not three (3). Compose -./-- do not insert anything. To me, this is just a point of education as I don't use dash m/n in my writing. Just trying to learn a bit. Thanks for any further explanation. Tom After some trial and error I find that three key combinations work in some applications but not in others. They do work in LO but not when immediately adjacent. Thanks for your help. Tom -- Tom Taylor - retired penguin openSUSE 12.1x86_64 openSUSE 12.2x86_64 KDE 4.6.00, FF 7.0 KDE 4.7.2, FF 11.0 claws-mail 3.8.0 registered linux user 263467 linxt-At-comcast-DoT-net -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc function
Am 18.04.2012 17:56, Johnny Rosenberg wrote: Den 18 april 2012 09:47 skrev Andreas Sägerville...@t-online.de: Am 17.04.2012 19:35, Mike Phelan wrote: I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once a number appears in B4:G11 4 times, it changes color to Red...got that part. Then I want to manually enter that number somewhere into J4:N21. once entered into J4:N21, i want that number to erase from B4:G11. =IF(COUNTIF(B4;$J$4:$N$21);;B4) copy down 7 rows and 5 columns to the right. Copy the resulting range and paste over B4:G11 ideally at that point i would also like all remaining numbers in B4:G11 to shift up, leaving no empty cells above cells with values in them (keeping them in the order entered within columns). Sort each of the 6 columns manually. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: beware of the m$ subsidiary
Hi :) Before Linux most of those servers would probably have been using Unix. A fair percentage moved from Unix to Bsd too. There are apparently other unix-based OSes out there and a few other odd ones that form almost all the remaining percentage. Regards from Tom :) --- On Wed, 18/4/12, Ken Springer snowsh...@q.com wrote: From: Ken Springer snowsh...@q.com Subject: [libreoffice-users] Re: beware of the m$ subsidiary To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 18:48 On 4/18/12 10:05 AM, Tom Davies wrote: Interestingly apparently many US government agencies and departments use GnuLinux for most of their server-side and infra-structure but had to cave into users demands for MS on their desktops. MS has always been the choice for the OS in almost all cases, AFAIK, but the actual programs used varied widely years ago. My agency generally preferred Word Perfect as the word processor, but when (I think) a government wide survey was taken as to an across the board single word processing program to aid document sharing, WP lost out to Word. Lots of unhappy people in my agency who had to redo all their macros, templates, etc. That surprises me not as far as the servers go. It seems the general impression of US Fed employees is they are, in general, not terribly bright in a lot of areas, where my experience is just the opposite. Especially the tech guys. They are well aware of the advantages of Linux. The agency I worked for didn't use Linux on any servers, AFAIK. Not because they may not have wanted to, but the support load the tech people had to provide so far exceeded their abilities to do a good job, they were always making decisions in a direction of having everything the same, to at least try to give everyone the help they needed. The problem, despite the big government hoopla, is there's just not enough human beings to do the job well for the tasks assigned. (Not going into the question of efficient operations, etc, as much of that is caused by people outside individual agencies, not the average employee.) The average employee is prevented, intentionally, from having anything more to do with the servers other than using them to store their data on. I was a supervisor, and I was at my last unit for 5 years before I even knew I could do that. No one bothered to tell me I actually had access to the server's hard drives for file storage. Our unit didn't even have a dedicated IT position, it fell to the administrative officer (total department personnel size of 1) as one of many collaborative duties, and when he passed away, it was given to me as a similar collaborative duty. I was Chief of Maintenance (total dept. size of 3), as well as Environmental officer, Safety Officer, Fleet Manager, and I don't remember what else. -- Ken Mac OS X 10.6.8 Firefox 11.0 Thunderbird 11.0.1 LibreOffice 3.5.1.2 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters
On 04/18/2012 12:19 PM, Johnny Rosenberg wrote: Den 18 april 2012 02:12 skrev Thomas Taylorli...@comcast.net: On Tue, 17 Apr 2012 10:48:22 +0100 Séamas Ó Brógáins...@iol.ie wrote: Doug: Using the compose key, the default settings are: dash (em rule) --- en rule:--. How do you do that if your system (openSuSE 12.1) only allows two (2) key composition? Thanks, Tom I have had OpenSUSE some years back (I think it was 11.3 or something), but unfortunately I didn't test this… However, this page doesn't say anything about that the compose key behaviour is depending on your GNU/Linux-distribution, so I thought this was true for all of them. Maybe it's a Gnome thing and you have the KDE version of OpenSUSE? Well, I don't think so, but I use Gnome only, so I don't know. Best regards Johnny Rosenberg ジョニー・ローゼンバーグ Using PCLinuxOS with KDE and the 3-key thing works fine here. If you're testing it, you may need to go to a program that uses a variable width font, like Times-Roman. (I tired it in LO.) --doug -- Blessed are the peacekeepers...for they shall be shot at from both sides. --A.M. Greeley -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: beware of the m$ subsidiary
On 4/18/12 12:20 PM, Tom Davies wrote: Before Linux most of those servers would probably have been using Unix. A fair percentage moved from Unix to Bsd too. There are apparently other unix-based OSes out there and a few other odd ones that form almost all the remaining percentage. That could be, that timeframe was long before I was that knowledgeable about computers. The fed gov department I worked for used MS's server program. This department had mostly small units scattered across the country, and a few overseas. It would be plausible, that when the IT guys in Timbuktu needed onsite help with a local server, the familiar desktop interface simply made it easier to get the job done. Or, it was part of an overarching negotiating agreement on the purchase price of X number of copies of Windows. Or, a bit of both! LOL -- Ken Mac OS X 10.6.8 Firefox 11.0 Thunderbird 11.0.1 LibreOffice 3.5.1.2 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters
On 04/18/2012 01:30 PM, Thomas Taylor wrote: On Wed, 18 Apr 2012 18:10:18 +0200 Johnny Rosenberggurus.knu...@gmail.com wrote: Den 17 april 2012 22:32 skrev Thomas Taylorli...@comcast.net: On Tue, 17 Apr 2012 18:09:31 +0200 Johnny Rosenberggurus.knu...@gmail.com wrote: Den 16 april 2012 22:36 skrev Séamas Ó Brógáins...@iol.ie: Regina wrote: They are usually written via AutoCorrect. The simple hyphen is replaced with the en-dash or em-dash when the following word is finished . . . That is _not_ a good idea. The hyphen, en rule and em rule (dash) are distinct characters with distinct uses in conventional typography and typesetting. Their correct use cannot be predicted by context, nor are they interchangeable. You need to find out where these characters are in the character set you are using. This depends on your operating system, your language, and your keyboard layout. As Johnny pointed out, they can be entered with the compose key. If you use them so often that even this is too cumbersome you can customise your keyboard layout, That's actually what I did (called ”Sweden Johnny Rosenberg”, available on my computers only…), but I didn't mention it because I thought it could be a bit tricky… I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also did a lot of other modification, like removed all my numbers from the first row (I already have them on the num pad to the right – why have them at more than one place?) and moved some Shift+number combinations so I don't need Shift for characters like ”!#%/” and so on. I even made labels to put on my keys, but most of them was worn out after a couple of weeks of typing… To change the layout (or rather add a new one in this case), you need to fiddle with three files (at least in Ubuntu): /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml and /usr/share/X11/xkb/symbols/the file representing your language, more on that another time… Ok, this was a bit off topic… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ so that (for example) compose-hyphen gets you the en rule and shift-compose-hyphen gets you the dash (em rule). If you want to do this I will help you (but only if you use GNU/Linux!). You could, as Johnny suggests, create your own auto-correct sequences, but personally I would avoid all such contrivances. Auto-correct is _not_ your friend. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Hi Johnny; Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the keyboard but which key is Gr? My keyboard (an old IBM windows model) doesn't have such a key. Thanks, Tom I saw that someone already answered, but I'll reply anyway. The ”+” does only mean that the key is hold. So Alt+Shift+x means that Alt, Shift and x is pressed simultaneously, or at least that no key is released before the other keys is pressed. The compose key doesn't work that way, therefore no ”+” sign: ”Compose --.” means ”hit the Compose key, release it, then type --.”. snip Hi Johnny ;) The problem with the above is that in openSuSE the compose key only allows two (2) keystroke combinations, not three (3). Compose -./-- do not insert anything. To me, this is just a point of education as I don't use dash m/n in my writing. Just trying to learn a bit. Thanks for any further explanation. Tom I should think that a bug report to OpenSuse is in order! --doug -- Blessed are the peacekeepers...for they shall be shot at from both sides. --A.M. Greeley -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] select en-dash and em-dash characters
Hi :) It is quite possible that openSuSE don't allow 3 character sequences. They are one of the longest running distros that are still active and they tend to go their own way. I get the impression they aim slightly more at corporate users and offer better traditional forms of tech-support which Canonical are also trying to add on as options in their support. Apparently openSuSE contribute something like 25% of LO coding work! A fantastic and much appreciated organisation :))) Regards from Tom :) --- On Wed, 18/4/12, Doug dmcgarr...@optonline.net wrote: From: Doug dmcgarr...@optonline.net Subject: Re: [libreoffice-users] select en-dash and em-dash characters To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 19:38 On 04/18/2012 01:30 PM, Thomas Taylor wrote: On Wed, 18 Apr 2012 18:10:18 +0200 Johnny Rosenberggurus.knu...@gmail.com wrote: Den 17 april 2012 22:32 skrev Thomas Taylorli...@comcast.net: On Tue, 17 Apr 2012 18:09:31 +0200 Johnny Rosenberggurus.knu...@gmail.com wrote: Den 16 april 2012 22:36 skrev Séamas Ó Brógáins...@iol.ie: Regina wrote: They are usually written via AutoCorrect. The simple hyphen is replaced with the en-dash or em-dash when the following word is finished . . . That is _not_ a good idea. The hyphen, en rule and em rule (dash) are distinct characters with distinct uses in conventional typography and typesetting. Their correct use cannot be predicted by context, nor are they interchangeable. You need to find out where these characters are in the character set you are using. This depends on your operating system, your language, and your keyboard layout. As Johnny pointed out, they can be entered with the compose key. If you use them so often that even this is too cumbersome you can customise your keyboard layout, That's actually what I did (called ”Sweden Johnny Rosenberg”, available on my computers only…), but I didn't mention it because I thought it could be a bit tricky… I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also did a lot of other modification, like removed all my numbers from the first row (I already have them on the num pad to the right – why have them at more than one place?) and moved some Shift+number combinations so I don't need Shift for characters like ”!#%/” and so on. I even made labels to put on my keys, but most of them was worn out after a couple of weeks of typing… To change the layout (or rather add a new one in this case), you need to fiddle with three files (at least in Ubuntu): /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml and /usr/share/X11/xkb/symbols/the file representing your language, more on that another time… Ok, this was a bit off topic… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ so that (for example) compose-hyphen gets you the en rule and shift-compose-hyphen gets you the dash (em rule). If you want to do this I will help you (but only if you use GNU/Linux!). You could, as Johnny suggests, create your own auto-correct sequences, but personally I would avoid all such contrivances. Auto-correct is _not_ your friend. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Hi Johnny; Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the keyboard but which key is Gr? My keyboard (an old IBM windows model) doesn't have such a key. Thanks, Tom I saw that someone already answered, but I'll reply anyway. The ”+” does only mean that the key is hold. So Alt+Shift+x means that Alt, Shift and x is pressed simultaneously, or at least that no key is released before the other keys is pressed. The compose key doesn't work that way, therefore no ”+” sign: ”Compose --.” means ”hit the Compose key, release it, then type --.”. snip Hi Johnny ;) The problem with the above is that in openSuSE the compose key only allows two (2) keystroke combinations, not three (3). Compose -./-- do not insert anything. To me, this is just a point of education as I don't use dash m/n in my writing. Just trying to learn a bit. Thanks for any further explanation. Tom I should think that a bug report to OpenSuse is in order! --doug -- Blessed are the peacekeepers...for they shall be shot at from both sides. --A.M. Greeley -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and
[libreoffice-users] Trouble opening ODS file in LibreOffice
Hi, I have an ODS file that I am not able to open. It is a spreadsheet file that I have been using daily since the first of the year. I have opened it and updated it every day since the first of January. Yesterday when I tried to open it, Libreoffice opened properly; then I got a Filter Selection dialog box. Whatever filter I select, the file will not open. I am able to open other ODS files. Any ideas why this file fails to open? Dick -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Sum across sheets
Hi. Is it possible to SUM across sheets without having to name each sheet. i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4) My sheets are named Bill, Bob, Tom Dick and Harry. Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work. SUM(Bill.E4:Harry.E4) doesn't work. SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work. Thanks, Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Sum across sheets
Hi Steve, Steve Edmonds schrieb: Hi. Is it possible to SUM across sheets without having to name each sheet. i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4) My sheets are named Bill, Bob, Tom Dick and Harry. Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work. SUM(Bill.E4:Harry.E4) doesn't work. SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work. It should be possible and works for me with LO 3.5.2.2 on WinXP. What is your version and OS? Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Sum across sheets
On 18 April 2012 16:57, Steve Edmonds steve.edmo...@ptglobal.com wrote: Is it possible to SUM across sheets without having to name each sheet. i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4) Example: =SUM(Sheet1.A1:Sheet2.C6) -- will total everything in Sheet1 and Sheet2 in cells A1 through C6. It will not include a value in, e.g., Sheet1.D1. My sheets are named Bill, Bob, Tom Dick and Harry. Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work. SUM(Bill.E4:Harry.E4) doesn't work. SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work. Once you rename a sheet, you have to use the sheet's name. If you create the formula before renaming a sheet, the formula will be changed. If the first sheet is Bill and the last sheet is Harry and you want to add values in cell E4 of each sheet: =SUM(Bill.E4:Harry.E4) -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Trouble opening ODS file in LibreOffice
Hi :) Can you upload the ods to Nabble so that we can have a look? Note that this is a public access list so don't upload it if it's confidential. Just follow the links to Nabble and reply to one of the posts in the right thread and then click on the More button. Upload is the 1st option and puts a link into the body of the message. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Trouble-opening-ODS-file-in-LibreOffice-tp3921408p3921571.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Sum across sheets
On 2012-04-19 10:09, T. R. Valentine wrote: On 18 April 2012 16:57, Steve Edmondssteve.edmo...@ptglobal.com wrote: Is it possible to SUM across sheets without having to name each sheet. i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4) Example: =SUM(Sheet1.A1:Sheet2.C6) -- will total everything in Sheet1 and Sheet2 in cells A1 through C6. It will not include a value in, e.g., Sheet1.D1. My sheets are named Bill, Bob, Tom Dick and Harry. Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work. SUM(Bill.E4:Harry.E4) doesn't work. SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work. Once you rename a sheet, you have to use the sheet's name. If you create the formula before renaming a sheet, the formula will be changed. If the first sheet is Bill and the last sheet is Harry and you want to add values in cell E4 of each sheet: =SUM(Bill.E4:Harry.E4) Thanks TR and to Regina. I could not get this to work this morning at home (#Ref errors), but it does here at work (I just fetched the sheet off my home PC). The sheet is a few years old so probably originated in OOO but the OS and LO versions at work and home should be the same. I will check, it is working now so that is what is important. Cheers, Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Trouble opening ODS file in LibreOffice
unable to open this file http://nabble.documentfoundation.org/file/n3921824/2012_taxes.ods 2012_taxes.ods -- View this message in context: http://nabble.documentfoundation.org/Trouble-opening-ODS-file-in-LibreOffice-tp3921408p3921824.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Trouble opening ODS file in LibreOffice
I get 1.5 kB and empty. steve On 2012-04-19 12:46, trickydicky wrote: unable to open this file http://nabble.documentfoundation.org/file/n3921824/2012_taxes.ods 2012_taxes.ods -- View this message in context: http://nabble.documentfoundation.org/Trouble-opening-ODS-file-in-LibreOffice-tp3921408p3921824.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted