[libreoffice-users] Suggestion for macro
Hi all, this is my first post so I want to congratulate for the project and the efforts given to it. I'm writing a merge script for impress slide, based on some Basic code found on various forums. It works but I find difficulties in handling the prompt asking to adapt the slides to the presentation where they are merged. I want to macro-click Yes I try handling it by an event from TopWindow but I can't get useful debug information (using MRI loops triggering window open and log to file is not useful either) so I'm stuck. Can someone kindly suggest me a way to handle the click Yes or references to docs? Thanks in advance. Best Regards, Luca ps: some code follow Sub doMerge() '... oList = createUnoListener(TopW_, com.sun.star.awt.XTopWindowListener) oToolkit = srcDoc.getCurrentController().getFrame().getContainerWindow().getToolkit() oToolkit.addTopWindowListener(oList) '... End Sub Sub TopW_windowOpened(e as Object) On Error Goto ErrorHandler oACWin = e.source.AccessibleContext 'mriLog(oACWin) '# this loop, I think 'wLog( oACWin.getAccessibleChild(0) ) oAC_Yes = oACWin.getAccessibleChild(0).AccessibleContext oAC_No = oAC.getAccessibleChild(1).AccessibleContext oAC_Yes.doAccessibleAction(0) ErrorHandler: Exit Sub 'On Error GoTo 0 End Sub -- 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] My story
A while back Tom asked people to tell their stories so this is mine. I started with a project to create an application using a DBMS to manage our local currency. This would be used by relatively basic users who would almost certainly want to use Windows. I already had a working knowledge of MySQL and I knew how to use that to do all the admin tasks but I needed a GUI to do data entry and report writing. So I started by trying to connect LO to MySQL with the ODBC connector. After a lot of reading I installed the MyODBC connector, created a driver and a DSN amd LO said Can't find driver or something like that. I thought I'd try it in Linux to get the hang of it before settling down to work in Windows and this gave me Can't find library or something like that. Then I found that LO will connect to MySQL directly without the need for a connector so I tried that and it worked. But this facility is not available in Windows. OOo does have the facility to connect directly to MySQL in Windows so at last I can get on with the project. OOo does what I want and OOo Base is pretty much like LO Base so I'm afraid it is goodbye LO. Been good to know you Tony -- 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: blog with great comparison table between LO and AOO
Hi :) I think one of the key things missing in the history section is that between the LO's 3.3.0 release and Oracle's 3.4.0 release there had been tons of LO releases and LO merged with a large and significant OOo fork known as Go-oo, which was the 'OpenOffice' used in many distros. While LO had already had many releases the 3.4.0 (beta) was Oracles first. The history makes it look like noting much happened in either project until the 3.4.0 got released. A by-product of that is that it makes it look as tho Oracle won the race to get a first release out after Buying-up Sun. Perhaps it's just that the author was shy of claiming too much credit for LO. Afaik he has been a significant driving force in the devs' community and the wider LO community. Regards from Tom :) --- On Wed, 9/5/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: blog with great comparison table between LO and AOO To: users@global.libreoffice.org Date: Wednesday, 9 May, 2012, 1:14 krackedpress wrote In his blog, Michael Weeks has as a great table comparison between LO and Apache's OO. I would love to see something like this between LO and MSO. http://people.gnome.org/~michael/blog/2012-04-26-ooo-comparison.html lt;http://people.gnome.org/%7Emichael/blog/2012-04-26-ooo-comparison.html Well, most of the points that look good for LibO do not matter, are a matter of taste, may be even counter productive. The OOXML output filters are a desaster. Many people complain about all the bundled stuff (dysfunctional report builder, too many languages). Most of the Calc differences can be seen as draw backs (I prefer OOo Calc actually). There are plenty of comparisons between LO/OOo and MSO. The result depends on the tester. If you compare LO with MSO the same way as Micheal compares AOO with LO then MSO wins. -- View this message in context: http://nabble.documentfoundation.org/blog-with-great-comparison-table-between-LO-and-AOO-tp3972755p3972842.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 -- 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] My story
Hi :) It's good to hear about people experiences especially when kept neat and short but i doubt i told or instructed or tried to 'force' anyone to do anything. I might have suggested using newspapers or magazines to promote your project by inviting reporters to an event or to invite them to interview you about some aspect of your project. People generally think that to advertise their product they have to pay for advertisement space but the chances are that if you have a good news story then the press might be interested in writing a story about it. It's cheaper and more likely to be readremembered. Regards from Tom :) --- On Wed, 9/5/12, Tony Sumner t...@whittycat.me.uk wrote: From: Tony Sumner t...@whittycat.me.uk Subject: [libreoffice-users] My story To: users@global.libreoffice.org Date: Wednesday, 9 May, 2012, 9:09 A while back Tom asked people to tell their stories so this is mine. I started with a project to create an application using a DBMS to manage our local currency. This would be used by relatively basic users who would almost certainly want to use Windows. I already had a working knowledge of MySQL and I knew how to use that to do all the admin tasks but I needed a GUI to do data entry and report writing. So I started by trying to connect LO to MySQL with the ODBC connector. After a lot of reading I installed the MyODBC connector, created a driver and a DSN amd LO said Can't find driver or something like that. I thought I'd try it in Linux to get the hang of it before settling down to work in Windows and this gave me Can't find library or something like that. Then I found that LO will connect to MySQL directly without the need for a connector so I tried that and it worked. But this facility is not available in Windows. OOo does have the facility to connect directly to MySQL in Windows so at last I can get on with the project. OOo does what I want and OOo Base is pretty much like LO Base so I'm afraid it is goodbye LO. Been good to know you Tony -- 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] Anchoring the images to page inside section.
Hi Vit On 09/05/2012 at 05:47, Vit vitr...@gmail.com wrote: 1. Fix position relative to the text, moving with the text. Text should be on the right or on the left of the picture. I can't achieve this using anchoring now. Example: http://dug.im/6ee14 2. I want two different pictures positioned after the text in parallel at right and at left and moving with it. Example: http://dug.im/6ee14 3. I want the image on the separate page and moving with the text, which is before the image. Example: http://dug.im/6ee14 Your example images are all the same. You may want to repost your message with corrected links. -- Best regards Mirosław Zalewski -- 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] My story
Hello Tony, Funny - I find exactly the opposite: the native MySQL-connector works perfectly well under Windows/Vista with me, but I cannot get it to work under either Debian-Wheezy or Linux/Mint-Lisa. Even though there is a lot of discouragement regarding the usage of JDBC under LO (them obviously wanting to diminish the dependency on Java!), I am actually using the JDBC-connector on my Linux systems. It seems somewhat less buggy than ODBC. In any case, I am trying out the native MySQL connector under Linux EVERY new version of LO - so far with no success. If I had the time to do so, I would compile the connector myself. I have been using Base under both OO and LO for years (after using Lotus/Approach before). What I REALLY want to do is build an application system for the administration of a wind band (musicians, literature, uniforms, concerts, supporting members and outside business contacts, etc., etc.) based on one of the available frameworks (eg. Symphony). So far I have built my homepage (www.rainermusik.at) using the PHP-Framework Seagull. Unfortunately there doesn't seem to be much going on within that framework anymore. Regards from Salzburg Heinrich On Wed, 09 May 2012 10:09:32 +0200, Tony Sumner t...@whittycat.me.uk wrote: A while back Tom asked people to tell their stories so this is mine. I started with a project to create an application using a DBMS to manage our local currency. This would be used by relatively basic users who would almost certainly want to use Windows. I already had a working knowledge of MySQL and I knew how to use that to do all the admin tasks but I needed a GUI to do data entry and report writing. So I started by trying to connect LO to MySQL with the ODBC connector. After a lot of reading I installed the MyODBC connector, created a driver and a DSN amd LO said Can't find driver or something like that. I thought I'd try it in Linux to get the hang of it before settling down to work in Windows and this gave me Can't find library or something like that. Then I found that LO will connect to MySQL directly without the need for a connector so I tried that and it worked. But this facility is not available in Windows. OOo does have the facility to connect directly to MySQL in Windows so at last I can get on with the project. OOo does what I want and OOo Base is pretty much like LO Base so I'm afraid it is goodbye LO. Been good to know you Tony -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] My story
On 09/05/2012 10:09, Tony Sumner wrote: A while back Tom asked people to tell their stories so this is mine. I started with a project to create an application using a DBMS to manage our local currency. This would be used by relatively basic users who would almost certainly want to use Windows. I already had a working knowledge of MySQL and I knew how to use that to do all the admin tasks but I needed a GUI to do data entry and report writing. So I started by trying to connect LO to MySQL with the ODBC connector. After a lot of reading I installed the MyODBC connector, created a driver and a DSN amd LO said Can't find driver or something like that. I thought I'd try it in Linux to get the hang of it before settling down to work in Windows and this gave me Can't find library or something like that. Then I found that LO will connect to MySQL directly without the need for a connector so I tried that and it worked. But this facility is not available in Windows. Sorry, wrong: the Native MySQL connector works fine for at least Windows XP OOo does have the facility to connect directly to MySQL in Windows so at last I can get on with the project. OOo does what I want and OOo Base is pretty much like LO Base so I'm afraid it is goodbye LO. Been good to know you Tony -- 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] My story
What could be the reason for this? One person can use the native MySQL connector to connect in Windows but can not in Linux. Another person use it to connect Linux but can not in Linux. Likely, the first person has the version that should be used in a Windows OS, and the second person has the version that should be used in a Linux OS. This connector is OS specific. Perhaps these two people should send each other the version they have. On the LO website, the native MySQL connector has been pulled for all OS's until more work is done on it. But the sad thing is that there is not enough people that can do the amount of work required for keeping this extension updated as newer versions of LO are developed. --Dan On Wed, 2012-05-09 at 11:47 +0200, Heinrich Stoellinger wrote: Hello Tony, Funny - I find exactly the opposite: the native MySQL-connector works perfectly well under Windows/Vista with me, but I cannot get it to work under either Debian-Wheezy or Linux/Mint-Lisa. Even though there is a lot of discouragement regarding the usage of JDBC under LO (them obviously wanting to diminish the dependency on Java!), I am actually using the JDBC-connector on my Linux systems. It seems somewhat less buggy than ODBC. In any case, I am trying out the native MySQL connector under Linux EVERY new version of LO - so far with no success. If I had the time to do so, I would compile the connector myself. I have been using Base under both OO and LO for years (after using Lotus/Approach before). What I REALLY want to do is build an application system for the administration of a wind band (musicians, literature, uniforms, concerts, supporting members and outside business contacts, etc., etc.) based on one of the available frameworks (eg. Symphony). So far I have built my homepage (www.rainermusik.at) using the PHP-Framework Seagull. Unfortunately there doesn't seem to be much going on within that framework anymore. Regards from Salzburg Heinrich On Wed, 09 May 2012 10:09:32 +0200, Tony Sumner t...@whittycat.me.uk wrote: A while back Tom asked people to tell their stories so this is mine. I started with a project to create an application using a DBMS to manage our local currency. This would be used by relatively basic users who would almost certainly want to use Windows. I already had a working knowledge of MySQL and I knew how to use that to do all the admin tasks but I needed a GUI to do data entry and report writing. So I started by trying to connect LO to MySQL with the ODBC connector. After a lot of reading I installed the MyODBC connector, created a driver and a DSN amd LO said Can't find driver or something like that. I thought I'd try it in Linux to get the hang of it before settling down to work in Windows and this gave me Can't find library or something like that. Then I found that LO will connect to MySQL directly without the need for a connector so I tried that and it worked. But this facility is not available in Windows. OOo does have the facility to connect directly to MySQL in Windows so at last I can get on with the project. OOo does what I want and OOo Base is pretty much like LO Base so I'm afraid it is goodbye LO. Been good to know you Tony -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] My story
Hi :) Good point! Swapping the ones that do work and dropping the ones that don't sounds good. Ideally the Extensions site would have a table with LO version down the side and platform/OS along the top. There would be a few holes but at least people would know which need to be updated or which version of LO to stick with. I don't see the point in removing stuff that does work under the right conditions. From what i gather it 'only' needs someone using the relevant platform and relevant version of LO to compile the connector from source and the source is easily available. The problem is that only. I compiled something once but i didn't have a clue what i was doing and just followed instructions very closely. Luckily the instructions were good and it worked. Regards from Tom :) --- On Wed, 9/5/12, Dan Lewis elderdanle...@gmail.com wrote: From: Dan Lewis elderdanle...@gmail.com Subject: Re: [libreoffice-users] My story To: users@global.libreoffice.org Date: Wednesday, 9 May, 2012, 11:29 What could be the reason for this? One person can use the native MySQL connector to connect in Windows but can not in Linux. Another person use it to connect Linux but can not in Windows. Likely, the first person has the version that should be used in a Windows OS, and the second person has the version that should be used in a Linux OS. This connector is OS specific. Perhaps these two people should send each other the version they have. On the LO website, the native MySQL connector has been pulled for all OS's until more work is done on it. But the sad thing is that there is not enough people that can do the amount of work required for keeping this extension updated as newer versions of LO are developed. --Dan On Wed, 2012-05-09 at 11:47 +0200, Heinrich Stoellinger wrote: Hello Tony, Funny - I find exactly the opposite: the native MySQL-connector works perfectly well under Windows/Vista with me, but I cannot get it to work under either Debian-Wheezy or Linux/Mint-Lisa. Even though there is a lot of discouragement regarding the usage of JDBC under LO (them obviously wanting to diminish the dependency on Java!), I am actually using the JDBC-connector on my Linux systems. It seems somewhat less buggy than ODBC. In any case, I am trying out the native MySQL connector under Linux EVERY new version of LO - so far with no success. If I had the time to do so, I would compile the connector myself. I have been using Base under both OO and LO for years (after using Lotus/Approach before). What I REALLY want to do is build an application system for the administration of a wind band (musicians, literature, uniforms, concerts, supporting members and outside business contacts, etc., etc.) based on one of the available frameworks (eg. Symphony). So far I have built my homepage (www.rainermusik.at) using the PHP-Framework Seagull. Unfortunately there doesn't seem to be much going on within that framework anymore. Regards from Salzburg Heinrich On Wed, 09 May 2012 10:09:32 +0200, Tony Sumner t...@whittycat.me.uk wrote: A while back Tom asked people to tell their stories so this is mine. I started with a project to create an application using a DBMS to manage our local currency. This would be used by relatively basic users who would almost certainly want to use Windows. I already had a working knowledge of MySQL and I knew how to use that to do all the admin tasks but I needed a GUI to do data entry and report writing. So I started by trying to connect LO to MySQL with the ODBC connector. After a lot of reading I installed the MyODBC connector, created a driver and a DSN amd LO said Can't find driver or something like that. I thought I'd try it in Linux to get the hang of it before settling down to work in Windows and this gave me Can't find library or something like that. Then I found that LO will connect to MySQL directly without the need for a connector so I tried that and it worked. But this facility is not available in Windows. OOo does have the facility to connect directly to MySQL in Windows so at last I can get on with the project. OOo does what I want and OOo Base is pretty much like LO Base so I'm afraid it is goodbye LO. Been good to know you Tony -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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:
[libreoffice-users] Re: My story
Le 09/05/12 12:29, Dan Lewis a écrit : Hi all, On the LO website, the native MySQL connector has been pulled for all OS's until more work is done on it. But the sad thing is that there is not enough people that can do the amount of work required for keeping this extension updated as newer versions of LO are developed. Yup, I pulled the plug - too much effort to maintain, too long to build (at least on my workhorse Linux box), and too diverse a OS/bit architecture scope, plus the fact that I had no hope of ever building it for Windows. The work to maintain is immense, and there are not enough people willing, or simply able, to build the connector against the stable branch of LO, i.e. currently LO 3.5.x, and the future LO 3.6, in order to test for incompatibilities that some of the new development features might throw up. Just building LO for Mac takes 4 hours on my OSX server when everything goes smoothly. If for some reason the build fails, which it often does when building from master, then it takes more than 12 hours. On my Linux box, it systematically takes 2 days to complete the build. I'm not prepared to mobilise my machine for that amount of time anymore, because it essentially means I can't do anything else with it, and I have other projects to engage in. The situation will be even worse with the newly released AOOo 3.4, unless someone starts building the connector, then it will start to no longer work either. Apache can not build it within the confines of its project for licensing reasons, and so it will have to rely on third party volunteers doing those builds and providing the connector separately. If the actual OOo mysql extension continues to work at all, then it is sheer luck. 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] math issues
Hi Marc, Marc Grober schrieb: It is exact as described in the link: First Insert Object Formula. Now you are in the formula editor. And then Tools Import Formula. Only if yo don't exit the equation editor before selecting Tools-Import, which one might do in as much as the documentation does not include those few precious words while the equation editor is open, lol. Now, as far as importing xml files, I have never been successful at importing mathml and must assume that this is accomplished through some secret handshake as well ;-) for example, an attempt to import test.xml which consisted of the following: ?xml version=1.0 encoding=UTF-8? !DOCTYPE math PUBLIC -//W3C//DTD MathML 2.0//EN http://www.w3.org/Math/DTD/mathml2/mathml2.dtd; math xmlns=http://www.w3.org/1998/Math/MathML; mrow mia/mi mo#x2062;!--InvisibleTimes; --/mo msup mix/mi mn2/mn /msup mo+/mo mib/mi mo#x2062;!--InvisibleTimes; --/mo mix/mi mo+/mo mic/mi /mrow /math was unsuccessful. I had tested that very same example before I had answered. Besides the fact, that the character #x2062; is rendered wrong, the import is without problems. So there must be some difference between my and your way. So next try with a step by step description: Precondition: The MathML is saved as file on disk, for example mymath.xml. 1. Open a Writer document or use a new one. Set the cursor where the formula should be. 2. Insert Object Formula. Now the equation editor is open. The top menu has changed, a part of the writer document is shown, with a rectangle where the formula will be, and a command window with a blinking cursor exists. 4. Tools Import Formula. You get a file picker. Choose your MathMl-file, here mymath.xml. Click on button 'Insert'. 5. Now you have the proper command in the command window. If something is wrong (for example the character #x2062; mentioned above), you can correct it. 6. Klick outside the formula into your Writer document. Finished. An attempt to export similar code as writer xml was similarly ineffective on import. If you only want to convert a single formula to MathML and your formula is inside a Writer document, then right-click the formula. The context menu opens and the last item is Save as Use this and select MathML from the list of available file formats. You will get a single MathML file. It does not matter whether you use the file extension .mml or .xml. Reimporting this file as described above, gives the same formula as exported, because the original LO formula is written to an annotation element and read when imported. You should use grouping brackets to generate a well structured formula in LO, although LO does not need them to render the formula. It will give better results in export. If you want to export the whole Writer document with an easy access to the MathML without unzipping, you can use File Export type XHTML, or File Save as type Flat XML. Do you understand German? Than the German Handbuch für Math on http://de.libreoffice.org/hilfe-kontakt/handbuecher/ might give you some ideas. 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] My story
On May 09, 2012, Dan Lewis wrote: Likely, the first person has the version that should be used in a Windows OS, and the second person has the version that should be used in a Linux OS. Oh, come on. It is obvious which version is which and I had the Windows one. The instructions for creating the driver are very simple and clear and I followed them. When it said driver not found it meant diving into the depts of Windows which I am reluctant to do. Fernand says that the native driver does work for Windows XP. So I must have looked at some out of date documentation that said otherwise. In that connection, Heinrich, I am sure I saw something to the effect that if you are using Linux you should use JDBC and not ODBC. Can't find it now though. Thanks to everyone for the suggestions as to what I can do now to get it working but I don't need to do anything do I, just learn how to get the best out of OOo Base. Like importing data from a CSV file which is much more complicated than it need be. Tony -- 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] My story
I have to put my hand up to the breakdown here too. I was (am) hoping to build this connector but pressure of other work has got in the way for the moment. I'll be back... Mark Stanton One small step for mankind... -- 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] My story
Hi Tony, I have just installed LO 3.5.3 and the native connector worked immediately out of the box on Windows/Vista. Regarding ODBC: yes, my experience tells me -- don't use it under Linux. There are bugs such as not SHOWING default values for columns (even though they are actually stored correctly). Reluctantly I am now using JDBC, but it at least seems to work correctly (even if it is a bit slow!). One thing that has also bothered me with Linux/LO/Base: every couple of minutes performance becomes dreadful. The systems monitor shows high CPU-usage of my 4-CPU, 2.4 GH PC then. Only when I then save the Base-file (*.odb) does everything return to normal. I have set the automatic save interval to 60 minutes, but it seems to me that some action triggers the degradation. I haven't got to the bottom of that as yet. Regards, H On Wed, 09 May 2012 15:12:51 +0200, Tony Sumner t...@whittycat.me.uk wrote: On May 09, 2012, Dan Lewis wrote: Likely, the first person has the version that should be used in a Windows OS, and the second person has the version that should be used in a Linux OS. Oh, come on. It is obvious which version is which and I had the Windows one. The instructions for creating the driver are very simple and clear and I followed them. When it said driver not found it meant diving into the depts of Windows which I am reluctant to do. Fernand says that the native driver does work for Windows XP. So I must have looked at some out of date documentation that said otherwise. In that connection, Heinrich, I am sure I saw something to the effect that if you are using Linux you should use JDBC and not ODBC. Can't find it now though. Thanks to everyone for the suggestions as to what I can do now to get it working but I don't need to do anything do I, just learn how to get the best out of OOo Base. Like importing data from a CSV file which is much more complicated than it need be. Tony -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] My story
Hi :) If OOo works then sticking with it makes a lot of sense. We are not really competing with them except in a reasonably friendly way. There was a time when Oracle tried competing with us but that was just before they gave up and handed it off to a community organisation. Now it's co-operative competition. Some people still work in both projects. Regards from Tom :) --- On Wed, 9/5/12, Tony Sumner t...@whittycat.me.uk wrote: From: Tony Sumner t...@whittycat.me.uk Subject: Re: [libreoffice-users] My story To: users@global.libreoffice.org Date: Wednesday, 9 May, 2012, 14:12 On May 09, 2012, Dan Lewis wrote: Likely, the first person has the version that should be used in a Windows OS, and the second person has the version that should be used in a Linux OS. Oh, come on. It is obvious which version is which and I had the Windows one. The instructions for creating the driver are very simple and clear and I followed them. When it said driver not found it meant diving into the depts of Windows which I am reluctant to do. Fernand says that the native driver does work for Windows XP. So I must have looked at some out of date documentation that said otherwise. In that connection, Heinrich, I am sure I saw something to the effect that if you are using Linux you should use JDBC and not ODBC. Can't find it now though. Thanks to everyone for the suggestions as to what I can do now to get it working but I don't need to do anything do I, just learn how to get the best out of OOo Base. Like importing data from a CSV file which is much more complicated than it need be. Tony -- 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] math issues
Hi :) It probably doesn't get quite so far into it but the official Math Guide is ready http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Math_Guide The docs team have done an amazing amount in the last couple of weeks. Regards from Tom :) --- On Wed, 9/5/12, Regina Henschel rb.hensc...@t-online.de wrote: From: Regina Henschel rb.hensc...@t-online.de Subject: Re: [libreoffice-users] math issues To: users@global.libreoffice.org Date: Wednesday, 9 May, 2012, 13:17 Hi Marc, Marc Grober schrieb: It is exact as described in the link: First Insert Object Formula. Now you are in the formula editor. And then Tools Import Formula. Only if yo don't exit the equation editor before selecting Tools-Import, which one might do in as much as the documentation does not include those few precious words while the equation editor is open, lol. Now, as far as importing xml files, I have never been successful at importing mathml and must assume that this is accomplished through some secret handshake as well ;-) for example, an attempt to import test.xml which consisted of the following: ?xml version=1.0 encoding=UTF-8? !DOCTYPE math PUBLIC -//W3C//DTD MathML 2.0//EN http://www.w3.org/Math/DTD/mathml2/mathml2.dtd; math xmlns=http://www.w3.org/1998/Math/MathML; mrow mia/mi mo#x2062;!--InvisibleTimes; --/mo msup mix/mi mn2/mn /msup mo+/mo mib/mi mo#x2062;!--InvisibleTimes; --/mo mix/mi mo+/mo mic/mi /mrow /math was unsuccessful. I had tested that very same example before I had answered. Besides the fact, that the character #x2062; is rendered wrong, the import is without problems. So there must be some difference between my and your way. So next try with a step by step description: Precondition: The MathML is saved as file on disk, for example mymath.xml. 1. Open a Writer document or use a new one. Set the cursor where the formula should be. 2. Insert Object Formula. Now the equation editor is open. The top menu has changed, a part of the writer document is shown, with a rectangle where the formula will be, and a command window with a blinking cursor exists. 4. Tools Import Formula. You get a file picker. Choose your MathMl-file, here mymath.xml. Click on button 'Insert'. 5. Now you have the proper command in the command window. If something is wrong (for example the character #x2062; mentioned above), you can correct it. 6. Klick outside the formula into your Writer document. Finished. An attempt to export similar code as writer xml was similarly ineffective on import. If you only want to convert a single formula to MathML and your formula is inside a Writer document, then right-click the formula. The context menu opens and the last item is Save as Use this and select MathML from the list of available file formats. You will get a single MathML file. It does not matter whether you use the file extension .mml or .xml. Reimporting this file as described above, gives the same formula as exported, because the original LO formula is written to an annotation element and read when imported. You should use grouping brackets to generate a well structured formula in LO, although LO does not need them to render the formula. It will give better results in export. If you want to export the whole Writer document with an easy access to the MathML without unzipping, you can use File Export type XHTML, or File Save as type Flat XML. Do you understand German? Than the German Handbuch für Math on http://de.libreoffice.org/hilfe-kontakt/handbuecher/ might give you some ideas. 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 -- 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: Queries wizard in Base
On 03/03/2012 10:20 AM, Dan Lewis wrote: On Sat, 2012-03-03 at 16:23 +0100, Andreas Säger wrote: Am 03.03.2012 16:09, Sylvain Bromberber wrote: I do have Java installed. By the way, it worked fine while I was still using Open Office. It works with all versions of OpenOffice.org, LibreOffice 3.3.x and it broke unnoticed somewhere in the development process of LibreOffice 3.4. The other 2 methods to create a query still work fine. The wizard did not add anything that could not be done in the designer. It works for LO 3.4.5 downloaded from the LO website. Looks like someone managed to fix it for one version before breaking it again for 3.5.0. And I would not say that the query wizard is worthless, just limited in what it can accomplish. Uses: for a simple query, and as a teacher of what is needed when creating a query. Before someone disagrees with me, I have long used the table design dialog, and the query design dialog in place of the table and query wizards, resp. ... Works in: LibreOffice 3.5.1.1 Build ID: 45a2874-aa8c38d-dff3b9c-def3dbd-62463c8 Hello, I recently installed LibreOffice 3 and updated to version 3.5.3.2, Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80, yesterday. I created a new database yesterday before the update, so I don't know if this issue was there beforehand, but when I tried to use the Queries Wizard or Forms Wizard, nothing happens. This is the Mac version, and I'm on Mac OS X 10.5. Is this an issue for Mac? I'm not sure if I've done anything wrong. I did have a portable version of LibreOffice prior to just installing it to the drive. Could the old data associated with the portable version corrupt the new version? -- Alexandria lexi.c...@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
[libreoffice-users] Keyboard shortcuts for changing text size
I tried setting keyboard shortcuts for increasing and decreasing text size. I set Control++ as Increase Font. I did not see a corresponding Decrease Font option to set for Control+-. However, pressing Control++ does not increase the size of the text, neither if text is selected nor if it is not. The Text Size selector does not change. LibreOffice 3.5.3.2, Kubuntu Linux 11.10. Thanks. -- Dotan Cohen http://gibberish.co.il http://what-is-what.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] math issues
Hi Tom, Tom Davies schrieb: Hi :) It probably doesn't get quite so far into it but the official Math Guide is ready http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Math_Guide The docs team have done an amazing amount in the last couple of weeks. Regards from Tom :) We (German group) too. The English Guide has no section on Import and Export. That section is new in the German Guide (and some other parts). For LO 3.5 or 3.6 it is worth to look at the German Guide and if you find it useful, translate it to English. 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] Re: My story
Hi :) Oh! I thought once you had built one connector for one set of circumstances then it would keep working. So a connector built for LO 3.4.5 on Xp would keep working for anyone that used XP and stuck to LO 3.4.5, and with luck it might work for LO 3.4.6 too although it would be unlikely to work for any other branch. If it's likely to stop working or probably wont work on a similar system then it sounds like a nightmare. Regards from Tom :) --- On Wed, 9/5/12, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: My story To: users@global.libreoffice.org Date: Wednesday, 9 May, 2012, 12:32 Le 09/05/12 12:29, Dan Lewis a écrit : Hi all, On the LO website, the native MySQL connector has been pulled for all OS's until more work is done on it. But the sad thing is that there is not enough people that can do the amount of work required for keeping this extension updated as newer versions of LO are developed. Yup, I pulled the plug - too much effort to maintain, too long to build (at least on my workhorse Linux box), and too diverse a OS/bit architecture scope, plus the fact that I had no hope of ever building it for Windows. The work to maintain is immense, and there are not enough people willing, or simply able, to build the connector against the stable branch of LO, i.e. currently LO 3.5.x, and the future LO 3.6, in order to test for incompatibilities that some of the new development features might throw up. Just building LO for Mac takes 4 hours on my OSX server when everything goes smoothly. If for some reason the build fails, which it often does when building from master, then it takes more than 12 hours. On my Linux box, it systematically takes 2 days to complete the build. I'm not prepared to mobilise my machine for that amount of time anymore, because it essentially means I can't do anything else with it, and I have other projects to engage in. The situation will be even worse with the newly released AOOo 3.4, unless someone starts building the connector, then it will start to no longer work either. Apache can not build it within the confines of its project for licensing reasons, and so it will have to rely on third party volunteers doing those builds and providing the connector separately. If the actual OOo mysql extension continues to work at all, then it is sheer luck. 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] My story
Hi :) If it's going to take hours to build it and if it's likely to need to be re-done often then i think it would be better to focus your efforts elsewhere, like making the instructions easier to understand? They probably are good already with nice coding brackets so people can just copypaste command-line stuff without ever understanding what they are doing. Regards from Tom :) --- On Wed, 9/5/12, Mark Stanton m...@vowleyfarm.co.uk wrote: From: Mark Stanton m...@vowleyfarm.co.uk Subject: Re: [libreoffice-users] My story To: users@global.libreoffice.org Date: Wednesday, 9 May, 2012, 15:17 I have to put my hand up to the breakdown here too. I was (am) hoping to build this connector but pressure of other work has got in the way for the moment. I'll be back... Mark Stanton One small step for mankind... -- 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] math issues
This was one reason I wanted to assist in working on docs, but the curve one needed to address in order to do that proved just too much. A far cry from experience working on wiki based documentation. What often is a problem in such areas is that those used to doing something in a particular manner don't really understand where another user may be coming from. When I talk of Math being universal and transparent I mean that a user should not have to be bothered with issues of entering and displaying Math. Another issue is context - the cause for the start of this thread is one example. A second is Regina's e-mail suggesting that I do a Save As - Flat XML though I have no such option in my save as dialog. As far as exporting as xhtml, I have 4 different export to xhtml options (it took me a while to figure out which one to use to obtain.) But, if I do export as xhtml the LO default gives me an html doc that appears to be an mathml xml document, which if I then try to import as a formula will not work (though it appears to be identical to the file that does work), even if I change the extension to mml or xml. I have tried checking format to make sure it is plain text etc. SO, if a tool can't be used simply and effectively, it won't be used. And, of course, it works for me doesn't help. Typically the key to goo documentation is identifying where users go off the rails I started playing with this some 5 years ago because a fellow teacher wanted to be able to mock up his math assignments in OOo and then convey them to the web, without the math getting turned into images that had to be separately maintained. I don't know that things would be any easier now for him... On 5/9/12 8:02 AM, Regina Henschel wrote: Hi Tom, Tom Davies schrieb: Hi :) It probably doesn't get quite so far into it but the official Math Guide is ready http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Math_Guide The docs team have done an amazing amount in the last couple of weeks. Regards from Tom :) We (German group) too. The English Guide has no section on Import and Export. That section is new in the German Guide (and some other parts). For LO 3.5 or 3.6 it is worth to look at the German Guide and if you find it useful, translate it to English. 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
[libreoffice-users] Change help font
Hi all, the fonts in the help screen are looking really awful for me. I know that you can adjust their size changing the html documents zoom level. But I would like to change the font itself. I've been playing a bit with font substitutions to no avail. Is it possible? Thanks a lot -- Carlos -- 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] Formulas...
It is so long since I used the Formula I'm looking for that I have forgotten what it is. Here is my problem I have a column, say, D4 in which I have a constant figure, say, 100 Another column E10 , let's call it Production, contains a figure of, say, 79 I can establish that 79 is 79% of actual production by entering the formula =E10/D4 and then Formatting the expression to Percentage. But I cannot remember the formula to copy E10 down so that D4 is the constant. I have tried E/10/D4, E10/$D4, $E10/D4, $E10/$D4 and then Filled Down without obtaining the correct answer. If anyone on the list is able to help me, I'd be most gratefu, Zed Desk - A very large wastebasket with drawers. -- 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] Formulas...
D4 and E10 are cells not columns as a result it is unclear what you mean by copy E10 down so that D4 is the constant. What exactly are yo trying to accomplish? On 5/9/12 3:03 PM, Zed wrote: It is so long since I used the Formula I'm looking for that I have forgotten what it is. Here is my problem I have a column, say, D4 in which I have a constant figure, say, 100 Another column E10 , let's call it Production, contains a figure of, say, 79 I can establish that 79 is 79% of actual production by entering the formula =E10/D4 and then Formatting the expression to Percentage. But I cannot remember the formula to copy E10 down so that D4 is the constant. I have tried E/10/D4, E10/$D4, $E10/D4, $E10/$D4 and then Filled Down without obtaining the correct answer. If anyone on the list is able to help me, I'd be most gratefu, Zed Desk - A very large wastebasket with drawers. -- 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] Formulas...
Hi :) Do you need both parts of D$ to stay fixed? $D keeps the D part fixed and then $4 keeps the 4 part fixed so you need =E10/$D$4 (I think) Regards from Tom :) --- On Thu, 10/5/12, Zed z...@zed.net.nz wrote: From: Zed z...@zed.net.nz Subject: [libreoffice-users] Formulas... To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 0:03 It is so long since I used the Formula I'm looking for that I have forgotten what it is. Here is my problem I have a column, say, D4 in which I have a constant figure, say, 100 Another column E10 , let's call it Production, contains a figure of, say, 79 I can establish that 79 is 79% of actual production by entering the formula =E10/D4 and then Formatting the expression to Percentage. But I cannot remember the formula to copy E10 down so that D4 is the constant. I have tried E/10/D4, E10/$D4, $E10/D4, $E10/$D4 and then Filled Down without obtaining the correct answer. If anyone on the list is able to help me, I'd be most gratefu, Zed Desk - A very large wastebasket with drawers. -- 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] Formulas...
Hi Zed I believe you are looking for =E10/$D$10 -- Best regards Mirosław Zalewski -- 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: IPad?
.docx is rapidly becoming my new most annoying default. Though it will likely never trump hide file extensions by default or even Hide My Computer/My Documents from desktop by default -- Wolfkin http://about.me/wolfkin On Sun, May 6, 2012 at 1:47 PM, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: I also tend to tell them to send out .doc instead of .docx files, since there are still a large percentage of people/agencies that never bought any newer version of MSO than 2003. Also I tell them that MSO 2010 .docx files can have issues if you open them in MSO 2007. So they should stick with .doc files instead. MSO just keep on messing with their file formats and those new version are not completely compatible with their older MSO versions that could read those formats [by mime name]. -- 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] Freezing a cell in Calc permanently
When you freeze a row or column in Calc http://help.libreoffice.org/Calc/Freezing_Rows_or_Columns_as_Headers is there a way to save that as a permanent state? I've tried freezing and after a few minutes I managed to get it to work but when I save and close the file it opens again unfrozen. -- Wolfkin http://about.me/wolfkin -- 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] Cal default print settings (and general default settings)
another quick one. by default Calc doesn't print the grid or column/row headers. For everyone for whom I suggest LibreOffice this is a huge problem. Is there a way to change settings by default? Speaking of default settings.. on a slightly more off topic. Is there a way, for instance write a small script, to save a series of settings? When I install LibreOffice on someone's computer I got thru a the same series of steps to ensure the smoothest transition. This includes things like changing the default file saving format. Perhaps turning the autocorrect off (oddly most of the people I know would be grateful to remove the squiggle they've just never known it was an option before), and stuff like that. -- Wolfkin http://about.me/wolfkin -- 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] Freezing a cell in Calc permanently
On Wed, 2012-05-09 at 20:47 -0400, The Wolfkin wrote: When you freeze a row or column in Calc http://help.libreoffice.org/Calc/Freezing_Rows_or_Columns_as_Headers is there a way to save that as a permanent state? I've tried freezing and after a few minutes I managed to get it to work but when I save and close the file it opens again unfrozen. -- Wolfkin http://about.me/wolfkin Then we need more information about your set up: operating system? version of LO? 32 bit or 64 bit? Is the spreadsheet an Excel workbook? How many sheets do you have in the file? How many of these sheets have the rows or columns frozen? Something is different about your setup that is causing this because you are not getting the standard results. For the last 8 years or perhaps more, a Calc (originally .sxc; now .ods) spreadsheet would preserve the Window Freeze when the file was saved. --Dan -- 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] Freezing a cell in Calc permanently
Well my mom just sent me a spreadsheet she's doing. Created on her MacBook 10.5 i think. Should be the latest version of LO. I was working on my Win7 64bit Dell computer here. Ver 3.4.4. These were .ods files. Simple simple stuff here.. Only using one (of three default) sheet. Less than 100 rows, trying to freeze the top row. -- Wolfkin http://about.me/wolfkin On Wed, May 9, 2012 at 9:25 PM, Dan Lewis elderdanle...@gmail.com wrote: Then we need more information about your set up: operating system? version of LO? 32 bit or 64 bit? Is the spreadsheet an Excel workbook? How many sheets do you have in the file? How many of these sheets have the rows or columns frozen? Something is different about your setup that is causing this because you are not getting the standard results. For the last 8 years or perhaps more, a Calc (originally .sxc; now .ods) spreadsheet would preserve the Window Freeze when the file was saved. --Dan -- 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] Templates Disappeared
On 04/05/12 17:09, Keith Bates wrote: Thanks Dan. I'm away from home for a few days, but I'll give it a go when I return Keith On 03/05/12 05:12, Dan Lewis wrote: On Wed, 2012-05-02 at 11:16 +1000, Keith Bates wrote: With the new release of Ubuntu last week I received a new release of LO 3.5.2.2 For some reason, my templates are no longer accessible. The files are present in a folder that is referenced in the Tools-Options-Paths - all unchanged since the previous version of 3.4. When I try to access the templates through the organise templates feature, there are no templates. I also get an error message templates already exists- presumably a reference to the folder templates rather than really bad English. This error message also comes up when I open an existing document. When I try to start a new document using a template I get this message: Error creating a new document; templates already exists. I've checked paths and permissions and I can't see what is wrong. The problem arises from a change in where the templates are located: LO 3.5 stores them in a different location (.config/libreoffice/3/user/template) than 3.4 (.libreoffice/3/user/template). Suggestion: use the organise templates feature again. If you use My Templates as the folders for your templates, highlight it. The click the Command button and select Update. Perhaps this will cause your templates to appear. If this does not work, copy your templates contained in .libreoffice/3/user/template to .config/libreoffice/3/user/template. Then organise your templates, highlight the My Template folder, click the Command button, and select Update from the drop down menu. The templates should appear. I used this process to add multiple templates to My Templates, and it saves time compared to importing one template at a time. --Dan I tried what Dan suggested but it doesn't work :( I don't even have a My Templates folder in the template organiser wizard thing. I know it was there in 3.4 but it's no longer there. I copied the template files to .config/libreoffice/3/user/template then clicked the Commands button and Update but then got several templates already exists messages and one Update could not be completed error. I've removed all folders from the templates path except the default (/usr/lib/ something) and then added.config/libreoffice/3/user/template and set it as the default for adding new templates. I'm wondering if there is a glitch in the Ubuntu update. -- God bless you Keith Bates Narrabri NSW Jesus is the Way the Truth and the Life -- 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] Paragraph styles for list styles
Hi all, I find this description in the documentation very misleading: Each of the list styles predefined in Writer has four associated paragraph styles. For example, the Numbering 1 list style is associated with four paragraph styles: Numbering 1 Numbering 1 Cont. Numbering 1 End Numbering 1 Start In what sense list style Numbering 1 is related to paragraph styles Numbering 1 *? What one can see is that the N in paragraph styles Numbering N * is related to indentation level and not intended for working in tandem with the list style Numbering N. One can use paragraph style Numbering 1 with any of the list styles, because concerns seem to be completely orthogonal. Can you clarify the relationship between paragraph styles Numbering N * and list style Numbering N? What scenarios are paragraph styles Numbering N * and List N * intended for? Thank you a lot -- Carlos -- 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] Formulas...
2012/5/10 Mirosław Zalewski mini...@poczta.onet.pl: Hi Zed I believe you are looking for =E10/$D$10 Or rather =E10/$D$4… -- Best regards Mirosław Zalewski -- 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] Anchoring the images to page inside section.
I'm very sorry for the images. Here are the examples. 1. Fix position relative to the text, moving with the text. Text should be on the right or on the left of the picture. I can't achieve this using anchoring now. Example: http://dug.im/d7682 2. I want two different pictures positioned after the text in parallel at right and at left and moving with it. Example: http://dug.im/87bb8 3. I want the image on the separate page and moving with the text before it, which is before the image. Example: http://dug.im/6c379 I don't know an easy way to realise any of this situations. The most complicated and topmost wanted by me is positioning the image on the top-right (bottom-right, bottom-left) corner of the page and moving with the text it is anchored to (but no overlapping with other images positioned to that corner, which are anchored to another text and accidentally are located at the same page). This will look like 1, but the images should be always in the corner regadrless of exact position the text they are anchored to, and if there are images on the same position on the page they mustn't overlap. With best regards, Vit -- 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