Re: [libreoffice-users] Something strange : settings in Tools - Options - Impress - Print
Hi Hirono, You are right, on reopening saved versions it seems to reset the value back to default. At least now it does. If I open LO then change, save and reenter Impress Print Setting in LO the setting is retained. If I open LO save a file after previously setting the Impress Print Setting, the value return to default. If I reset the value and exit the reenter LO and -- open new file, the adjusted setting is retained -- open an existing file, the adjusted setting is retained If I save the file -- setting is retained while changed file is open -- setting is now reset to default on reopening the file and continues to reset the value despite me changing the value. If I create a new file and start again the value update is sticky until I reopen a saved document. *My take on what is happening* The 'Page options' is being saved to file (or at least attempted to be saved to file. When you open an existing document it overwrites the saved data into the configuration file for Impress. The problem appears to be that the value selected for 'Page options' is not being set, despite being updated when an existing file is reopened, or is being stored incorrectly. You will need to post a bug on the system and get one of the developers to change this behaviour, to me it does appear to be a BUG. On 05/08/11 15:34, Hirono Moi wrote: Hi Simon, Thank you very much your reproducing and advice. I take it from my test that the configuration file is not updated in this instance until LO is restarted. Yes, I know you're right, but, After I restarted LO, and then I opend FileNameA.odp or FileNameB.odp, the value was 'default'. How about in your case? Regards, (2011/08/05 11:10), Simon Cropper (The foss Workflow Guides) wrote: Hi Hirono, I use LO on Ubuntu 10.04. I also get the described behaviour but only when I have not restarted LO. The first time I opened LO and reproduced your steps it worked exactly as you stated. I closed LO and opened it again and the 'default' was then Fit to Page I take it from my test that the configuration file is not updated in this instance until LO is restarted. Try changing the value of Tools - Options - Impress - Print - Page to Fit to Page then restart LO. What is the value when you restart LO Default or Fit to Page? -- Cheers Simon Simon Cropper Website Administrator http://www.fossworkflowguides.com The fossWorkflow Guides (c) Simon Cropper CC-BY-SA 3.0 Australia http://creativecommons.org/licenses/by-sa/3.0/au/deed.en -- 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] LibreOffice base - cannot make a convenient form to add data
I'm trying to make a small base with a couple of forms to view and add data. For instance, I have a table Objects and it has two fields location and assigned to of type INTEGER, because they are linked to ID fields of tables locations and people respectively. It is inconvenient to enter digits in table editor, so I wanted to make a form which will show linked values instead. Normal thing, just like in MS Access. I created a from, modified columns location and assigned to to be comboboxes, and that's it. 1. Can't find where to select which column to use from a linked table. Good to me is that I have only one column in each of these linked tables. But there should be an option somewhere, maybe I just can't find it? 2. Now I have location combo showing proper content, while assigned to does not show anyting. The only reason I can think of is that in linked table locations the needed field is called location, the same as in main table. And in second linked table the needed field is called person and not assigned to. I'll try to rename it to have equal names but that is somewhat inconvenient. Again this leads to Q1 - how do I select a column, from which I take linked data? 3. Even though location shows linked data correctly in combobox, when I select anything I just get a 0 in the field. I really want to keep seeing linked data and not ID or whatever integer there is. And I don't understand why it puts 0 whatever I choose in the box. Pls hlp. =) Thank you! -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-base-cannot-make-a-convenient-form-to-add-data-tp3227878p3227878.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
[libreoffice-users] Re: Base / Postgresql support
Walt wrote: Hi Anyone know how to get native pgsql support on base - it seems missing from the connect to an exsitng database options. I've checked under both Linux and Windows. There was a special driver in a zip file available from the old openoffice.org site. It was an extension installed through the (Tools-)Extension Manager I've uploaded it to multiupload here: http://www.multiupload.com/LLL32191L0 (postgresql-sdbc-0.7.6b.zip) I'm afraid I have no idea if it will still work though. Let me check get back to you. Walt wrote: Also is it possble to mix and match datasources on one base database (some local tables + some odbc tables etc) AFAIK there's only one connection string (ODBC, SDBC, JDBC) that can be specified via the (database properties -connection settings:) Datasource URL field. - Ubuntu 10.10 64bit : LibreOffice 3.4.2 OOO340m1 (Build:203) JRE: jre-6u21-linux-x64.bin -- View this message in context: http://nabble.documentfoundation.org/Base-Postgresql-support-tp3226192p3227883.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] Something strange : settings in Tools - Options - Impress - Print
Hi Simon, Thank you very much your repeated tests and advice. I entirely agree with your view. I would like to know a workaround ofsome kind, if you have any idea. Regards, (2011/08/05 15:11), Simon Cropper (The foss Workflow Guides) wrote: Hi Hirono, You are right, on reopening saved versions it seems to reset the value back to default. At least now it does. If I open LO then change, save and reenter Impress Print Setting in LO the setting is retained. If I open LO save a file after previously setting the Impress Print Setting, the value return to default. If I reset the value and exit the reenter LO and -- open new file, the adjusted setting is retained -- open an existing file, the adjusted setting is retained If I save the file -- setting is retained while changed file is open -- setting is now reset to default on reopening the file and continues to reset the value despite me changing the value. If I create a new file and start again the value update is sticky until I reopen a saved document. *My take on what is happening* The 'Page options' is being saved to file (or at least attempted to be saved to file. When you open an existing document it overwrites the saved data into the configuration file for Impress. The problem appears to be that the value selected for 'Page options' is not being set, despite being updated when an existing file is reopened, or is being stored incorrectly. You will need to post a bug on the system and get one of the developers to change this behaviour, to me it does appear to be a BUG. -- 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] LO 3.4.2 Calc - charts don't automatically refresh
(This happened with the previous release of 3.4 as well) I add data to the sheet but the chart based on that data doesn't automatically reflect the additional data - I have to double-click on the data lines in order to refresh the chart. Am I missing something here? (The data ranges in the chart cover the whole amount of data to be entered, so it's not a case of the range not covering the data...) -- 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] LO 3.4.2 Calc - charts don't automatically refresh
Hello Gordon, On Fri, 05 Aug 2011 08:37:32 +0100 Gordon Burgess-Parker gbpli...@gmail.com wrote: (This happened with the previous release of 3.4 as well) I add data to the sheet but the chart based on that data doesn't automatically reflect the additional data - I have to double-click on the data lines in order to refresh the chart. Am I missing something here? (The data ranges in the chart cover the whole amount of data to be entered, so it's not a case of the range not covering the data...) I'm no Calc expert, but have you by any chance disabled the auto calculate feature in Calc? If you can update the chart by pressing F9, this would indicate that you might have. So try enabling this feature and see how it goes then. Sigrid -- 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: looking for help on Base
Il giorno gio, 04/08/2011 alle 09.45 -0700, NoOp ha scritto: On 08/04/2011 01:19 AM, Roberto Scotti wrote: the site http://www.libreoffice.org/features/base/ states ... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access... When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: JDBC JDBC Oracle Adabas D Foglio elettronico dBASE Testo MySQL ODBC How do you activate the MS Access native-support driver? Is a SQLite native-support driver available? Many thanks, Roberto Scotti Maybe this will help: http://packages.ubuntu.com/natty/i386/database/libreoffice-base quote You can extend the functionality of LibreOffice Base by installing these packages: * unixodbc: ODBC database support * libmyodbc | odbc-postgresql | libsqliteodbc | tdsodbc | mdbtools: ODBC drivers for: - MySQL - PostgreSQL - SQLite - MS SQL / Sybase SQL - *.mdb (JET / MS Access) * libmysql-java | libpg-java | libjtds-java: JDBC Drivers for: - MySQL - PostgreSQL - MS SQL Server and Sybase Check to see if you have those installed. Yes, at least I tried to install mdbtools, the stand-alone viewer is working: gmdb2 0.6pre1 GNOME MDB Viewer is a grapical interface to MDB Tools. It lets you view and export data and schema from MDB files produced by MS Access 97/2000/XP/2003. What is needed next to have it available in LbreOffice-Base? Many thanks, rs -- 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] LO 3.4.2 Calc - charts don't automatically refresh
On 05/08/2011 08:57, Sigrid Carrera wrote: Hello Gordon, On Fri, 05 Aug 2011 08:37:32 +0100 Gordon Burgess-Parkergbpli...@gmail.com wrote: (This happened with the previous release of 3.4 as well) I add data to the sheet but the chart based on that data doesn't automatically reflect the additional data - I have to double-click on the data lines in order to refresh the chart. Am I missing something here? (The data ranges in the chart cover the whole amount of data to be entered, so it's not a case of the range not covering the data...) I'm no Calc expert, but have you by any chance disabled the auto calculate feature in Calc? If you can update the chart by pressing F9, this would indicate that you might have. So try enabling this feature and see how it goes then. Sigrid Interesting. Autocalculate is ON, and if I enter data AFTER clicking on the charts, then the charts automatically update. It only seems to happen on first opening...(the charts are in different sheets to the data - would that have a bearing?) -- 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] libreoffice 3.4.2.3 without sane?
Hello. I am a Gentoo user and I just subscribed to this list. Today libreoffice 3.4.2.3 was added to portage and sane-backends appeared as a new dependency. From my research I guessed that this is controlled via the --with-system-sane configure flag, but I tried adding --without-system-sane to the ebuild, and the configure script still fails telling me that sane.h wasn't found. checking for sane/sane.h... no configure: error: sane not found. install sane So, is it possible to build libreoffice 3.4.2.3 without installing sane? Thanks beforehand. -- Jesús Guerrero Botella -- 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] libreoffice 3.4.2.3 without sane?
Hi Jesús, This is a good question for the dev-list: http://lists.freedesktop.org/mailman/listinfo/libreoffice Regards, Cor Jesús J. Guerrero Botella wrote (05-08-11 11:52) Hello. I am a Gentoo user and I just subscribed to this list. Today libreoffice 3.4.2.3 was added to portage and sane-backends appeared as a new dependency. From my research I guessed that this is controlled via the --with-system-sane configure flag, but I tried adding --without-system-sane to the ebuild, and the configure script still fails telling me that sane.h wasn't found. checking for sane/sane.h... no configure: error: sane not found. install sane So, is it possible to build libreoffice 3.4.2.3 without installing sane? Thanks beforehand. -- - Cor - http://nl.libreoffice.org -- 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] libreoffice 3.4.2.3 without sane?
Thank you. I just posted this same question to that list. -- Jesús Guerrero Botella -- 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] There goes Open-Source in the White House
The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. -- 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] There goes Open-Source in the White House
Is this for real? This is terrible news - from twohot@device.mobile :) -Original Message- From: webmaster for Kracked Press Productions webmas...@krackedpress.com Date: Fri, 05 Aug 2011 07:39:47 To: LibreO - Users Globalusers@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] There goes Open-Source in the White House The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. -- 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: QUESTION: Libreoffice documents constantly need recovery
I have not been following this thread, but the original question is something that happened to me once. What I did was: uninstall LibreOffice. delete the hidden folder .libreoffice [for Ubuntu] or delete LibreOffice's Program Files folder [for Windows]. reinstall LibreOffice That fixed the constant recovery [and failed recovery every time] on my system. I want to ask what GUI are you using for Ubuntu 11.04? Unity [default], KDE, or the optional GNOME? I do not think I would use the Unity GUI though. I like having GNOME as my GUI with a lot of added KDE system packages installed. That way I have GNOME GUI with many of the KDE packages that GNOME seems either not have or are not fitting my needs. - I cannot install 11.04 on mine due to an unsupported monitor error. 1368 by 768 is the largest and default resolution. It should be able to use the 1024 by 768 resolution or lower, but 11.04 just will not. I think since the motherboard's Nvidia chipset, it sees that the chipset supports 1920 by 1080 and 1440 by 900 so it defaults its startup resolution to one of those unsupported resolutions for my monitor. Once day I will fix that issue and install 11.04 instead of having 10.04 LTS. On 08/04/2011 06:13 PM, Tom Davies wrote: Hi :) A clean install of Ubuntu 11.04 should do the trick. Going for a dual-boot or multi-boot is a lot easier than it sounds. The standard install process usually gives you the option in the Partitioning Section. Possibly the 2nd or 3rd standard option out of about 4 options on that page. The 4th option gets a bit technical but you can always click on the Back button if it's too complicated and then change to one of the standard 2 or 3 options. I think you could handle it tho. Regards from Tom :) From: Juan Carlosjuanzeppe...@hotmail.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 19:48:30 Subject: [libreoffice-users] Re: QUESTION: Libreoffice documents constantly need recovery Well, after read all the possible solutions, finally I decided to install Ubuntu 11.04 (a clean installation) and reinstall LO. I hope this fix the problem. Thanks to all who shared their opinions. -- View this message in context: http://nabble.documentfoundation.org/QUESTION-Libreoffice-documents-constantly-need-recovery-tp2515584p3226318.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] There goes Open-Source in the White House
Hi :) There are other countries in the world and not all of them follow the US slavishly. It's not the government, it's just a government. Many other countries push OpenSource or at least non-MS, sometimes just because they don't see any need to make a foreign company richer, sometimes to support local languages and culture better. Brasil is not small and has a huge and specifically LibreOffice community. Germany and Italy are also strongly supportive of LibreOffice apparently along with France. Most of Europe has 20% of the market using OpenOffice or LibreOffice. Spanish governments (4/5 of them) put resources into developing their own variants of Ubuntu/Debain i think the other went with Arch. The Scientific Technological Research Council of Turkey develop Pardus which was one of the first distros to have LibreOffice by default. Vietnam and many other countries are supporting a strong push towards OpenSource. The One Laptop Per Child programme has helped children get a better education and is based on OpenSource. There is a lot of positive OpenSource action going on around the world which might leave corporate America lagging behind! Regards from Tom :) From: webmaster for Kracked Press Productions webmas...@krackedpress.com To: LibreO - Users Global users@global.libreoffice.org Sent: Fri, 5 August, 2011 12:39:47 Subject: [libreoffice-users] There goes Open-Source in the White House The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. -- 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] width of com.sun.star.awt.grid.GridColumn
hello friends, com.sun.star.awt.grid.GridColumn has a width field, but setting it doesn't seem to have a benefic effect. what unit does this field have? how can i convert map appfont (ma) units to this unit? thanks in advance, 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: Activex control in LibreOffice 3.4.2?
On 08/04/2011 11:34 PM, NoOp wrote: On 08/04/2011 01:49 AM, Tom Davies wrote: Hi :) There is an extension or add-on for FireFox but i doubt there is an ActiveX for Internet Explorer. ActiveX is fairly often used to infect or compromise systems so it's good to avoid it. ... Do you *ever* test before or after you make comments like this on this list? The nasties that can come with ActiveX is a big reason that many people moved to Firefox as their default browser over IE. There are ways to help use IE and not have those nasties mess with your system, but it is just easier to use Firefox, Chrome, Opera, Sahara, or some other non-IE browser on Windows. I have to check if I have installed that Firefox add-on since my drive replacement. Do not remember installing it, but I installed in the early days of LO 3.3.0. -- 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] There goes Open-Source in the White House
On 08/05/2011 02:39 PM, webmaster for Kracked Press Productions wrote: The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. The problem is not with the Chief Information Officer, buy with the Chief Community Organizer that appointed him knowing that the CIO is a MS shill, and with those who elected a know-it-all know-nothing to move into the White House. -- Stan Goodman Qiryat Tiv'on Israel -- 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: QUESTION: Libreoffice documents constantly need recovery
Hi :)
Renaming the .libreoffice or even better, one of it's sub-folders (such as
the
user/3), has the same effect as deleting it except that you are able to have a
look at your old stuff even tho LibreOffice can't see it. It effectively
quarantines your old set-up.
I have tried installing 11.04 a couple of times and each time it has
automatically given me the Gnome DE rather than Unity because it couldn't
handle
my monitor/graphics-card. I think your particular issue is that you connect
your flat-screen using a Vga cable rather than Hdmi, Dvi or whatever. In my
case it's because my monitor is a horribly ancient and dying Crt. (My 2nd Crt
is still quite nice).
Hopefully the 11.10 due to be released at the end of October ('obviously',
(hence the .10)) will have beaten Unity into better shape. The 3rd alpha
release has just been released but i'm not keen to test things that early,
maybe
wait for beta 2.
The 10.04 and 10.10 are great but i am about to try out a few other distros
again as LiveCds and then perhaps dual/multi-boots if i like the look. I might
even try contacting a few distro hoppers. I'm not keen to move away from
Ubuntu but there are a lot of ubuntu clones worth trying. I might try the
new
Zorin. Obviously i am going to try the more obvious ones such as Mint, Mageia,
openSUSE but i have already had a quick go with most. Mint and Mageia are the
most interesting and worth trying imo.
http://distrowatch.com/
Regards from
Tom :)
From: webmaster for Kracked Press Productions webmas...@krackedpress.com
To: users@global.libreoffice.org
Sent: Fri, 5 August, 2011 13:02:46
Subject: Re: [libreoffice-users] Re: QUESTION: Libreoffice documents constantly
need recovery
I have not been following this thread, but the original question is something
that happened to me once.
What I did was:
uninstall LibreOffice.
delete the hidden folder .libreoffice [for Ubuntu] or delete LibreOffice's
Program Files folder [for Windows].
reinstall LibreOffice
That fixed the constant recovery [and failed recovery every time] on my system.
I want to ask what GUI are you using for Ubuntu 11.04? Unity [default], KDE,
or
the optional GNOME?
I do not think I would use the Unity GUI though. I like having GNOME as my GUI
with a lot of added KDE system packages installed. That way I have GNOME GUI
with many of the KDE packages that GNOME seems either not have or are not
fitting my needs.
-
I cannot install 11.04 on mine due to an unsupported monitor error. 1368 by
768 is the largest and default resolution. It should be able to use the 1024
by
768 resolution or lower, but 11.04 just will not. I think since the
motherboard's Nvidia chipset, it sees that the chipset supports 1920 by 1080
and
1440 by 900 so it defaults its startup resolution to one of those unsupported
resolutions for my monitor. Once day I will fix that issue and install 11.04
instead of having 10.04 LTS.
On 08/04/2011 06:13 PM, Tom Davies wrote:
Hi :)
A clean install of Ubuntu 11.04 should do the trick. Going for a dual-boot or
multi-boot is a lot easier than it sounds. The standard install process
usually
gives you the option in the Partitioning Section. Possibly the 2nd or 3rd
standard option out of about 4 options on that page. The 4th option gets a
bit
technical but you can always click on the Back button if it's too
complicated
and then change to one of the standard 2 or 3 options. I think you could
handle
it tho.
Regards from
Tom :)
From: Juan Carlosjuanzeppe...@hotmail.com
To: users@global.libreoffice.org
Sent: Thu, 4 August, 2011 19:48:30
Subject: [libreoffice-users] Re: QUESTION: Libreoffice documents constantly
need
recovery
Well, after read all the possible solutions, finally I decided to install
Ubuntu 11.04 (a clean installation) and reinstall LO. I hope this fix the
problem.
Thanks to all who shared their opinions.
--
View this message in context:
http://nabble.documentfoundation.org/QUESTION-Libreoffice-documents-constantly-need-recovery-tp2515584p3226318.html
l
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
Re: [libreoffice-users] Re: how to select extension dictionary for spellchecking
On 08/05/2011 12:22 AM, planas wrote: Hi On Thu, 2011-08-04 at 23:49 -0400, webmaster for Kracked Press Productions wrote: So, would it be better to use the Oxford English or the British English form of spelling? Here in the USA, if we do not use proper American spelling our papers are rejected for sloppiness. I wrote colour once instead of color and the professor was upset with me. My 20 pound [weight] dictionary had the English spelling first, so I used it. I did not know better in those days before computer were smaller than a normal car or truck. So do we use en_GB or en_GB-oed as the default one for Queen and Country? I think use Americans sometimes spell our words differently so we can be different after we broke away from British rule. LibreOffice's ToolsLanguage SettingsLanguagesLocalized --- has 14 different listing for English. More languages than there are versions I can find to install or are in the install .deb files. http://libreoffice-na.us/English/add-on-dictionaries-large-list/US_English_April-19-2011-dic-file.oxt is the link to one that has the most up-to-date .dic file I could find. I found the file and updated the original .oxt file with it. Maybe someone could do that for en_GB-oed to my it better and more up-to-date than from a 2005 .dic file [which the one linked to before from OOo's site has]. Actually 500 years ago, most people could not read. So knowing how to spell was not important. Actually look at the number of different France/French language versions - 4 of them - plus a few localized ones that no longer are called French since they are so different. 20+ Spanish dictionaries are in the list I have at: http://libreoffice-na.us/English/extensions.html#dict . All localized to a country which uses it. On 08/04/2011 05:55 PM, Tom Davies wrote: Hi :) I think 500 years ago there wasn't even an agreed standard way of spelling any word. Shakespeare wrote his own name with many different spellings during his life. I did think that ise had been THE English way for a LOT longer tho! lol. Languages have to evolve and adapt to changing requirements. Regards from Tom :) From: webmaster for Kracked Press Productionswebmas...@krackedpress.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 20:55:36 Subject: Re: [libreoffice-users] Re: how to select extension dictionary for spellchecking So you are saying that the British English use of -ise instead of -ize is a new thing that is just a new way of spelling words that have been around, a new localized [or is it localised] way? I use American English which spells colour as color. But this is the first time I have heard of the -ise/-ize issue. Well they always say language involves. Take English in Britain about 500 years ago. The same words, but different spellings. So should I dump en_GB in favor en_GB-oed version? Should I not include en_CA or en_GB[oed] in my dictionary list in the USA? I know that one .oxt dictionary add-on that includes many different English files. Should people not use that type? en_GB-oed .dic file has 46,113 words in its word list. The Wiki page shows analyse in en_GB-oed and analyze in en_US. Well in the oed .dic file I cannot find analyse. Below is the word list where that word should be located, but it is not. ample/PT amplification/M anarchy/3Ww1SM anastigmatic Andaman/M aneroid Anglican/MS I found the word analyse in the en_GB .dic file dated 2010-02-15 analyze in the en_CA .dic file dated 2010-02-15 but neither spelling in the en_GB-eod version dated 2005-06-13. So the eod version has not kept up with what the Wiki page link shows for Oxford English. Of course, you could always edit a word list and keep only the spellings that Oxford English excepts. As I understand, the complete Oxford dictionary contains 20 volumes/books to hold all the words and definitions. I have a word list of over 200,000 words, but would you want to have a word processor spell checker dictionary with all those words, or only the ones you really want to use? The more words in the list, the more chances that your misspelled words are correct spelling for a different unwanted word. There is not good way around it, except edit your word list to remove the words that are not spelled correctly for your localized version of the language. On 08/04/2011 10:18 AM, ron.vandenbranden wrote: Hi, Thanks for your thoughts. On Thursday 4 August 2011 15:12:21, krackedpress [via Document Foundation Mail Archive] wrote: Could someone tell me what it the difference between the standard en_GB and the OED [Oxford English] version? Maybe I should clarify my problem: I regularly have to edit articles for publication in a journal that conforms to Oxford Spelling (http://en.wikipedia.org/wiki/Oxford_spelling), which differs on some points from regular BE spelling, e.g.: only forms in -ize are allowed. In
Re: [libreoffice-users] There goes Open-Source in the White House
Hi :) +1 But to be fair on them they do need to push US companies into becoming more profitable and MS has not grown as fast as they hoped in certain areas such as tablets, netbooks (and even notebooks), mobile devices, smart-phones, servers, Cloud, search engine and have lost ground in areas such as web-browsers. Can almost imagine them - Oh no! What to do?? Quick get an MS person into the White House. Oddly they don't seem to realise that they could make other US companies even more profitable by promoting OpenSource and forcing MS to compete more fairly on grounds of functionality rather than sheer might. All just my own opinion of course. If i get thrown off the list then at least it was fun! Good luck and regards from Tom :) From: Stan Goodman stan.good...@hashkedim.com To: users@global.libreoffice.org Sent: Fri, 5 August, 2011 13:26:54 Subject: Re: [libreoffice-users] There goes Open-Source in the White House On 08/05/2011 02:39 PM, webmaster for Kracked Press Productions wrote: The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. The problem is not with the Chief Information Officer, buy with the Chief Community Organizer that appointed him knowing that the CIO is a MS shill, and with those who elected a know-it-all know-nothing to move into the White House. -- Stan Goodman Qiryat Tiv'on Israel -- 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] There goes Open-Source in the White House
How real it is and going to become depends on the new Chief of Technology. Here is the article about the naming of the new Chief. http://www.nytimes.com/2011/08/04/technology/white-house-picks-new-information-chief.html?_r=3ref=technology http://www.nytimes.com/2011/08/04/technology/white-house-picks-new-information-chief.html?_r=3ref=technology On 08/05/2011 07:50 AM, Onyeibo Oku wrote: Is this for real? This is terrible news - from twohot@device.mobile :) -Original Message- From: webmaster for Kracked Press Productionswebmas...@krackedpress.com Date: Fri, 05 Aug 2011 07:39:47 To: LibreO - Users Globalusers@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] There goes Open-Source in the White House The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. -- 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: how to select extension dictionary for spellchecking
Hi :) +1 Ok, so i object to having to type out the whole of though and shorten it to tho. Oddly i like the extra unnecessary u in colour and things tho (oops). Shakespeare was only about 400 years ago btw. 21st C - 17th C = 400. My maths was wonky yday. regards from Tom :) From: webmaster for Kracked Press Productions webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Fri, 5 August, 2011 13:32:38 Subject: Re: [libreoffice-users] Re: how to select extension dictionary for spellchecking On 08/05/2011 12:22 AM, planas wrote: Hi On Thu, 2011-08-04 at 23:49 -0400, webmaster for Kracked Press Productions wrote: So, would it be better to use the Oxford English or the British English form of spelling? Here in the USA, if we do not use proper American spelling our papers are rejected for sloppiness. I wrote colour once instead of color and the professor was upset with me. My 20 pound [weight] dictionary had the English spelling first, so I used it. I did not know better in those days before computer were smaller than a normal car or truck. So do we use en_GB or en_GB-oed as the default one for Queen and Country? I think use Americans sometimes spell our words differently so we can be different after we broke away from British rule. LibreOffice's ToolsLanguage SettingsLanguagesLocalized --- has 14 different listing for English. More languages than there are versions I can find to install or are in the install .deb files. http://libreoffice-na.us/English/add-on-dictionaries-large-list/US_English_April-19-2011-dic-file.oxt t is the link to one that has the most up-to-date .dic file I could find. I found the file and updated the original .oxt file with it. Maybe someone could do that for en_GB-oed to my it better and more up-to-date than from a 2005 .dic file [which the one linked to before from OOo's site has]. Actually 500 years ago, most people could not read. So knowing how to spell was not important. Actually look at the number of different France/French language versions - 4 of them - plus a few localized ones that no longer are called French since they are so different. 20+ Spanish dictionaries are in the list I have at: http://libreoffice-na.us/English/extensions.html#dict . All localized to a country which uses it. On 08/04/2011 05:55 PM, Tom Davies wrote: Hi :) I think 500 years ago there wasn't even an agreed standard way of spelling any word. Shakespeare wrote his own name with many different spellings during his life. I did think that ise had been THE English way for a LOT longer tho! lol. Languages have to evolve and adapt to changing requirements. Regards from Tom :) From: webmaster for Kracked Press Productionswebmas...@krackedpress.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 20:55:36 Subject: Re: [libreoffice-users] Re: how to select extension dictionary for spellchecking So you are saying that the British English use of -ise instead of -ize is a new thing that is just a new way of spelling words that have been around, a new localized [or is it localised] way? I use American English which spells colour as color. But this is the first time I have heard of the -ise/-ize issue. Well they always say language involves. Take English in Britain about 500 years ago. The same words, but different spellings. So should I dump en_GB in favor en_GB-oed version? Should I not include en_CA or en_GB[oed] in my dictionary list in the USA? I know that one .oxt dictionary add-on that includes many different English files. Should people not use that type? en_GB-oed .dic file has 46,113 words in its word list. The Wiki page shows analyse in en_GB-oed and analyze in en_US. Well in the oed .dic file I cannot find analyse. Below is the word list where that word should be located, but it is not. ample/PT amplification/M anarchy/3Ww1SM anastigmatic Andaman/M aneroid Anglican/MS I found the word analyse in the en_GB .dic file dated 2010-02-15 analyze in the en_CA .dic file dated 2010-02-15 but neither spelling in the en_GB-eod version dated 2005-06-13. So the eod version has not kept up with what the Wiki page link shows for Oxford English. Of course, you could always edit a word list and keep only the spellings that Oxford English excepts. As I understand, the complete Oxford dictionary contains 20 volumes/books to hold all the words and definitions. I have a word list of over 200,000 words, but would you want to have a word processor spell checker dictionary with all those words, or only the ones you really want to use? The more words in the list, the more chances that your misspelled words are correct spelling for a different unwanted word. There is not good way around it, except edit your word list to remove the
[libreoffice-users] new book
new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- 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: QUESTION: Libreoffice documents constantly need recovery
Sorry, but the only monitor connection that I have is the standard VGA
cable which is attached to the motherboard. Plus the Acer monitor uses
VGA cable as well. Now my 19 inch flat scree TV can use VGA or HDMI
cables. I have a VGA cable plugged into it for working with showing
stuff from a laptop to the TV for a larger display.
As for CRT, I have two massively have 17 inch ones in the bottom shelf
dead storage cabinet. I was thinking about installing 11.04 with one
of those installed instead of the 18 inch flat screen.
The Unity issue: well all I have read about 11.04 was that Unity was
the default GUI, but you could choose to use GNOME after the initial
install. It would be nice to have to choose Unity instead of it being
the default.
On 08/05/2011 08:28 AM, Tom Davies wrote:
Hi :)
Renaming the .libreoffice or even better, one of it's sub-folders (such as the
user/3), has the same effect as deleting it except that you are able to have a
look at your old stuff even tho LibreOffice can't see it. It effectively
quarantines your old set-up.
I have tried installing 11.04 a couple of times and each time it has
automatically given me the Gnome DE rather than Unity because it couldn't handle
my monitor/graphics-card. I think your particular issue is that you connect
your flat-screen using a Vga cable rather than Hdmi, Dvi or whatever. In my
case it's because my monitor is a horribly ancient and dying Crt. (My 2nd Crt
is still quite nice).
Hopefully the 11.10 due to be released at the end of October ('obviously',
(hence the .10)) will have beaten Unity into better shape. The 3rd alpha
release has just been released but i'm not keen to test things that early, maybe
wait for beta 2.
The 10.04 and 10.10 are great but i am about to try out a few other distros
again as LiveCds and then perhaps dual/multi-boots if i like the look. I might
even try contacting a few distro hoppers. I'm not keen to move away from
Ubuntu but there are a lot of ubuntu clones worth trying. I might try the new
Zorin. Obviously i am going to try the more obvious ones such as Mint, Mageia,
openSUSE but i have already had a quick go with most. Mint and Mageia are the
most interesting and worth trying imo.
http://distrowatch.com/
Regards from
Tom :)
From: webmaster for Kracked Press Productionswebmas...@krackedpress.com
To: users@global.libreoffice.org
Sent: Fri, 5 August, 2011 13:02:46
Subject: Re: [libreoffice-users] Re: QUESTION: Libreoffice documents constantly
need recovery
I have not been following this thread, but the original question is something
that happened to me once.
What I did was:
uninstall LibreOffice.
delete the hidden folder .libreoffice [for Ubuntu] or delete LibreOffice's
Program Files folder [for Windows].
reinstall LibreOffice
That fixed the constant recovery [and failed recovery every time] on my system.
I want to ask what GUI are you using for Ubuntu 11.04? Unity [default], KDE, or
the optional GNOME?
I do not think I would use the Unity GUI though. I like having GNOME as my GUI
with a lot of added KDE system packages installed. That way I have GNOME GUI
with many of the KDE packages that GNOME seems either not have or are not
fitting my needs.
-
I cannot install 11.04 on mine due to an unsupported monitor error. 1368 by
768 is the largest and default resolution. It should be able to use the 1024 by
768 resolution or lower, but 11.04 just will not. I think since the
motherboard's Nvidia chipset, it sees that the chipset supports 1920 by 1080 and
1440 by 900 so it defaults its startup resolution to one of those unsupported
resolutions for my monitor. Once day I will fix that issue and install 11.04
instead of having 10.04 LTS.
On 08/04/2011 06:13 PM, Tom Davies wrote:
Hi :)
A clean install of Ubuntu 11.04 should do the trick. Going for a dual-boot or
multi-boot is a lot easier than it sounds. The standard install process
usually
gives you the option in the Partitioning Section. Possibly the 2nd or 3rd
standard option out of about 4 options on that page. The 4th option gets a
bit
technical but you can always click on the Back button if it's too
complicated
and then change to one of the standard 2 or 3 options. I think you could
handle
it tho.
Regards from
Tom :)
From: Juan Carlosjuanzeppe...@hotmail.com
To: users@global.libreoffice.org
Sent: Thu, 4 August, 2011 19:48:30
Subject: [libreoffice-users] Re: QUESTION: Libreoffice documents constantly
need
recovery
Well, after read all the possible solutions, finally I decided to install
Ubuntu 11.04 (a clean installation) and reinstall LO. I hope this fix the
problem.
Thanks to all who shared their opinions.
--
View this message in context:
http://nabble.documentfoundation.org/QUESTION-Libreoffice-documents-constantly-need-recovery-tp2515584p3226318.html
l
Sent from the Users mailing list archive at Nabble.com.
-- For
Re: [libreoffice-users] Re: Activex control in LibreOffice 3.4.2?
Hi :) On linux systems it might be easier to install mozilla-libreoffice I'm not sure what to do for Windows or Mac but it was interesting to see that there is an ActiveX thing for LibreOffice :) It's probably safer than most ActiveX controls as i would guess that it's written with the usual OpenSource regard for safety as higher priority than functionality. Regards from Tom :) From: webmaster for Kracked Press Productions webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Fri, 5 August, 2011 13:10:23 Subject: Re: [libreoffice-users] Re: Activex control in LibreOffice 3.4.2? On 08/04/2011 11:34 PM, NoOp wrote: On 08/04/2011 01:49 AM, Tom Davies wrote: Hi :) There is an extension or add-on for FireFox but i doubt there is an ActiveX for Internet Explorer. ActiveX is fairly often used to infect or compromise systems so it's good to avoid it. ... Do you *ever* test before or after you make comments like this on this list? The nasties that can come with ActiveX is a big reason that many people moved to Firefox as their default browser over IE. There are ways to help use IE and not have those nasties mess with your system, but it is just easier to use Firefox, Chrome, Opera, Sahara, or some other non-IE browser on Windows. I have to check if I have installed that Firefox add-on since my drive replacement. Do not remember installing it, but I installed in the early days of LO 3.3.0. -- 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] new book
On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil 498 pages worth of Macros Explained could help a lot of people on these lists. Have downloaded it and exported it as a PDF file. -- 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: QUESTION: Libreoffice documents constantly need recovery
Hi :)
Tada! :) Vga strikes again. It was such a fantastic thing for so many decades
that they had to create a problem for it with the new-fangled flat-screen tech.
I don't remember being given a choice of DE for 11.04 but switching is so easy
for me that i might not have noticed.
Regards from
Tom :)
From: webmaster for Kracked Press Productions webmas...@krackedpress.com
To: users@global.libreoffice.org
Sent: Fri, 5 August, 2011 13:55:32
Subject: Re: [libreoffice-users] Re: QUESTION: Libreoffice documents constantly
need recovery
Sorry, but the only monitor connection that I have is the standard VGA
cable which is attached to the motherboard. Plus the Acer monitor uses
VGA cable as well. Now my 19 inch flat scree TV can use VGA or HDMI
cables. I have a VGA cable plugged into it for working with showing
stuff from a laptop to the TV for a larger display.
As for CRT, I have two massively have 17 inch ones in the bottom shelf
dead storage cabinet. I was thinking about installing 11.04 with one
of those installed instead of the 18 inch flat screen.
The Unity issue: well all I have read about 11.04 was that Unity was
the default GUI, but you could choose to use GNOME after the initial
install. It would be nice to have to choose Unity instead of it being
the default.
On 08/05/2011 08:28 AM, Tom Davies wrote:
Hi :)
Renaming the .libreoffice or even better, one of it's sub-folders (such as
the
user/3), has the same effect as deleting it except that you are able to have a
look at your old stuff even tho LibreOffice can't see it. It effectively
quarantines your old set-up.
I have tried installing 11.04 a couple of times and each time it has
automatically given me the Gnome DE rather than Unity because it couldn't
handle
my monitor/graphics-card. I think your particular issue is that you connect
your flat-screen using a Vga cable rather than Hdmi, Dvi or whatever. In my
case it's because my monitor is a horribly ancient and dying Crt. (My 2nd Crt
is still quite nice).
Hopefully the 11.10 due to be released at the end of October ('obviously',
(hence the .10)) will have beaten Unity into better shape. The 3rd alpha
release has just been released but i'm not keen to test things that early,
maybe
wait for beta 2.
The 10.04 and 10.10 are great but i am about to try out a few other distros
again as LiveCds and then perhaps dual/multi-boots if i like the look. I
might
even try contacting a few distro hoppers. I'm not keen to move away from
Ubuntu but there are a lot of ubuntu clones worth trying. I might try the
new
Zorin. Obviously i am going to try the more obvious ones such as Mint,
Mageia,
openSUSE but i have already had a quick go with most. Mint and Mageia are the
most interesting and worth trying imo.
http://distrowatch.com/
Regards from
Tom :)
From: webmaster for Kracked Press Productionswebmas...@krackedpress.com
To: users@global.libreoffice.org
Sent: Fri, 5 August, 2011 13:02:46
Subject: Re: [libreoffice-users] Re: QUESTION: Libreoffice documents
constantly
need recovery
I have not been following this thread, but the original question is something
that happened to me once.
What I did was:
uninstall LibreOffice.
delete the hidden folder .libreoffice [for Ubuntu] or delete LibreOffice's
Program Files folder [for Windows].
reinstall LibreOffice
That fixed the constant recovery [and failed recovery every time] on my
system.
I want to ask what GUI are you using for Ubuntu 11.04? Unity [default], KDE,
or
the optional GNOME?
I do not think I would use the Unity GUI though. I like having GNOME as my
GUI
with a lot of added KDE system packages installed. That way I have GNOME GUI
with many of the KDE packages that GNOME seems either not have or are not
fitting my needs.
-
I cannot install 11.04 on mine due to an unsupported monitor error. 1368 by
768 is the largest and default resolution. It should be able to use the 1024
by
768 resolution or lower, but 11.04 just will not. I think since the
motherboard's Nvidia chipset, it sees that the chipset supports 1920 by 1080
and
1440 by 900 so it defaults its startup resolution to one of those unsupported
resolutions for my monitor. Once day I will fix that issue and install 11.04
instead of having 10.04 LTS.
On 08/04/2011 06:13 PM, Tom Davies wrote:
Hi :)
A clean install of Ubuntu 11.04 should do the trick. Going for a dual-boot
or
multi-boot is a lot easier than it sounds. The standard install process
usually
gives you the option in the Partitioning Section. Possibly the 2nd or 3rd
standard option out of about 4 options on that page. The 4th option gets a
bit
technical but you can always click on the Back button if it's too
complicated
and then change to one of the standard 2 or 3 options. I think you could
handle
it tho.
Regards from
Tom :)
[libreoffice-users] Problem using a name as Source cell range in a combo box control
Hello, I tried to define a combo box in Scalc which take its source cell range from a table. When I enter the cell reference directly, it works as expected. I defined a name for the table, but when I try to used it instead of the direct cell reference, I just get a blank combo box. I tried several syntax like 'name', ='name' but that doen't make any difference. I tried that both under version 3.3.3 (on Windows XP Pro 32 bit) and version 3.4.2 (on Windows 7 64 bit). That doesn't make any difference either. Is there a way to make that works? (In fact the original file was made with MS Excel XP) Thanks in advance, Jean-Louis -- 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] There goes Open-Source in the White House
Well said Stan. On 08/05/2011 08:26 AM, Stan Goodman wrote: On 08/05/2011 02:39 PM, webmaster for Kracked Press Productions wrote: The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. The problem is not with the Chief Information Officer, buy with the Chief Community Organizer that appointed him knowing that the CIO is a MS shill, and with those who elected a know-it-all know-nothing to move into the White House. -- *** * -- 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: Base record access unacceptably slow
Hi All As I reported recently I wrote to a contact I have in regard to this thread. Part of what I said was . /*PLEASE DO* follow up on this - I think it is _VERY_ important for many users and some 'Official' Feedback' is VERY necessary. There are lots of very important points made in this thread!!! / He has just replied... /Thanks for your mail! The question is what the Steering Committee should do about this. What I would recommend is that one of the affected users either writes to the Developer Mailing List, or files a bug report. Is this something that could help? Florian -- Florian Effenberger flo...@documentfoundation.org Steering Committee and Founding Member of The Document Foundation Tel: +49 8341 99660880 | Mobile: +49 151 14424108 Skype: floeff | Twitter/Identi.ca: @floeff / This is NOT quite the reply I was hoping for. Is it worth passing this onto the Devs Mail List - I have a feeling somebody already did this. Base is working for me at the moment - sort of!! - but I would LOVE to see it sorted out!! I want to try the change to an early version of Java to see if that helps me or not at some time. Until then it looks as if we are all stuck with Base as it is!! Ian Whitfield -- 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] Removal of unwanted dictionaries
On 2011-08-04 5:00 PM, Dave Barton d...@tasit.net wrote: Original Message From: Tanstaafl tansta...@libertytrek.org To: users@global.libreoffice.org Date: Thu, 04 Aug 2011 15:04:42 -0400 On 2011-08-04 2:11 PM, nunojsi...@ist.utl.pt (Nuno J. Silva) Can't you just set the Dictionaries item to Not available (which will set all subitems to Not available) and then cherry-pick the dictionaries you want? That is exactly what I do (wasn't very specific though)... Does this work for you? I have always done this when installing LO on Win 7-64 and Win XP-32, but still have to go back and remove the unwanted dictionaries from the extensions sub-directory. Yes, it works for me... :) -- 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: Base record access unacceptably slow
Ian, On behalf of all Base users, thanks for trying! As you infer, it would have been encouraging to receive a more pro-active reply, especially from a Founder of TDF (and long-time ex-oOo active member). Perhaps it's difficult for him to say much else, if there are very few Base Developers. I guess they 'stayed' with oOo or have moved on to other things. It will be interesting to see if the oOo version fares any better...but that's another story! Regards, Tony Royston. -Original Message- From: Ian Whitfield [mailto:whitfi...@telkomsa.net] Sent: Friday,05 August, 2011 14:46 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Base record access unacceptably slow Hi All As I reported recently I wrote to a contact I have in regard to this thread. Part of what I said was . /*PLEASE DO* follow up on this - I think it is _VERY_ important for many users and some 'Official' Feedback' is VERY necessary. There are lots of very important points made in this thread!!! / He has just replied... /Thanks for your mail! The question is what the Steering Committee should do about this. What I would recommend is that one of the affected users either writes to the Developer Mailing List, or files a bug report. Is this something that could help? Florian -- Florian Effenberger flo...@documentfoundation.org Steering Committee and Founding Member of The Document Foundation Tel: +49 8341 99660880 | Mobile: +49 151 14424108 Skype: floeff | Twitter/Identi.ca: @floeff / This is NOT quite the reply I was hoping for. Is it worth passing this onto the Devs Mail List - I have a feeling somebody already did this. Base is working for me at the moment - sort of!! - but I would LOVE to see it sorted out!! I want to try the change to an early version of Java to see if that helps me or not at some time. Until then it looks as if we are all stuck with Base as it is!! Ian Whitfield -- 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 This message and any attachments may be privileged or otherwise protected from disclosure - Mercy Ships. -- 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: Base record access unacceptably slow
Ian, thank you from me also. When I see the number of people asking questions about Base on this forum it seems there is a lot of interest in having a database. So far the side by side install of the second, older version of Java has been working very well for me. On 08/05/2011 11:01 AM, Tony Royston wrote: Ian, On behalf of all Base users, thanks for trying! As you infer, it would have been encouraging to receive a more pro-active reply, especially from a Founder of TDF (and long-time ex-oOo active member). Perhaps it's difficult for him to say much else, if there are very few Base Developers. I guess they 'stayed' with oOo or have moved on to other things. It will be interesting to see if the oOo version fares any better...but that's another story! Regards, Tony Royston. -Original Message- From: Ian Whitfield [mailto:whitfi...@telkomsa.net] Sent: Friday,05 August, 2011 14:46 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Base record access unacceptably slow Hi All As I reported recently I wrote to a contact I have in regard to this thread. Part of what I said was . /*PLEASE DO* follow up on this - I think it is _VERY_ important for many users and some 'Official' Feedback' is VERY necessary. There are lots of very important points made in this thread!!! / He has just replied... /Thanks for your mail! The question is what the Steering Committee should do about this. What I would recommend is that one of the affected users either writes to the Developer Mailing List, or files a bug report. Is this something that could help? Florian -- Florian Effenbergerflo...@documentfoundation.org Steering Committee and Founding Member of The Document Foundation Tel: +49 8341 99660880 | Mobile: +49 151 14424108 Skype: floeff | Twitter/Identi.ca: @floeff / This is NOT quite the reply I was hoping for. Is it worth passing this onto the Devs Mail List - I have a feeling somebody already did this. Base is working for me at the moment - sort of!! - but I would LOVE to see it sorted out!! I want to try the change to an early version of Java to see if that helps me or not at some time. Until then it looks as if we are all stuck with Base as it is!! Ian Whitfield -- *** * -- 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] new book
thanks andrew for keeping up this great work. though a lot has been changed since your first book, would you consider inserting the new grid control in this new edition? best regards, alex On 08/05/2011 03:49 PM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- 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] There goes Open-Source in the White House
Thanks, Tom, for this hope-inducing update. Fascinating! Tom C. On 08/05/2011 06:08 AM, Tom Davies wrote: Hi :) There are other countries in the world and not all of them follow the US slavishly. It's not the government, it's just a government. Many other countries push OpenSource or at least non-MS, sometimes just because they don't see any need to make a foreign company richer, sometimes to support local languages and culture better. Brasil is not small and has a huge and specifically LibreOffice community. Germany and Italy are also strongly supportive of LibreOffice apparently along with France. Most of Europe has 20% of the market using OpenOffice or LibreOffice. Spanish governments (4/5 of them) put resources into developing their own variants of Ubuntu/Debain i think the other went with Arch. The Scientific Technological Research Council of Turkey develop Pardus which was one of the first distros to have LibreOffice by default. Vietnam and many other countries are supporting a strong push towards OpenSource. The One Laptop Per Child programme has helped children get a better education and is based on OpenSource. There is a lot of positive OpenSource action going on around the world which might leave corporate America lagging behind! Regards from Tom :) From: webmaster for Kracked Press Productionswebmas...@krackedpress.com To: LibreO - Users Globalusers@global.libreoffice.org Sent: Fri, 5 August, 2011 12:39:47 Subject: [libreoffice-users] There goes Open-Source in the White House The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. -- 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: LibreOffice 3.4.2
I see this same issue with US English. There are no Blue check marks and ABC in any of the settings. Going back to V3.4.0 solves the problem for me. I did not try V3.4.1. -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-4-2-tp3218560p3229275.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] There goes Open-Source in the White House
On Friday, August 05, 2011 05:26:54 AM Stan Goodman wrote: On 08/05/2011 02:39 PM, webmaster for Kracked Press Productions wrote: The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. The problem is not with the Chief Information Officer, buy with the Chief Community Organizer that appointed him knowing that the CIO is a MS shill, and with those who elected a know-it-all know-nothing to move into the White House. +1 our government is looking for big budget cuts. One would be replace all the MS stuff with open source software. -- Russ -- 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: LibreOffice 3.4.2
Hi, On Fri, Aug 5, 2011 at 19:06, thomasjk wrote: I see this same issue with US English. There are no Blue check marks and ABC in any of the settings. Going back to V3.4.0 solves the problem for me. I did not try V3.4.1. Maybe, please check up: Bug 37195 - Dictionary access lost after LibO upgrade https://bugs.freedesktop.org/show_bug.cgi?id=37195 See also: [Solved+Issue] 3.4.2 RC1 no dics installed Win7 http://user.services.openoffice.org/en/forum/viewtopic.php?f=101t=42613 mjk -- A Word of Thanks by Charles-H. Schulz http://standardsandfreedom.net/index.php/2011/07/29/a-word-of-thanks/ -- 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: LibreOffice 3.4.2
Thanks but I'll stick with 3.4.0 until this bug is fixed. I'm a fairly knowledgeable user of LO and this change is just too much to bother with right now. I agree with the comment that it should have been fixed before release. How can they expect average users to make a change like this? tkenne...@carolina.rr.com -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-4-2-tp3218560p3229498.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] There goes Open-Source in the White House
Tom and all On Fri, 2011-08-05 at 13:08 +0100, Tom Davies wrote: Hi :) There are other countries in the world and not all of them follow the US slavishly. It's not the government, it's just a government. Many other countries push OpenSource or at least non-MS, sometimes just because they don't see any need to make a foreign company richer, sometimes to support local languages and culture better. Brasil is not small and has a huge and specifically LibreOffice community. Germany and Italy are also strongly supportive of LibreOffice apparently along with France. Most of Europe has 20% of the market using OpenOffice or LibreOffice. Spanish governments (4/5 of them) put resources into developing their own variants of Ubuntu/Debain i think the other went with Arch. The Scientific Technological Research Council of Turkey develop Pardus which was one of the first distros to have LibreOffice by default. Vietnam and many other countries are supporting a strong push towards OpenSource. The One Laptop Per Child programme has helped children get a better education and is based on OpenSource. There is a lot of positive OpenSource action going on around the world which might leave corporate America lagging behind! Regards from Tom :) From: webmaster for Kracked Press Productions webmas...@krackedpress.com To: LibreO - Users Global users@global.libreoffice.org Sent: Fri, 5 August, 2011 12:39:47 Subject: [libreoffice-users] There goes Open-Source in the White House The new chief information officer for the federal government - White House Chief of Information Technology - is a former Microsoft Executive [and assistant to Bill Gates]. Since all these big wigs in Microsoft get large blocks of stock in the company, which he most likely still has, this new guy in the White House as a good reason to keep the government using MS products over free and open source ones. So I say; there goes the government's push to go open source and start using packages like LibreOffice. Well, MS tries to control the world's computers, and now they have a man in the White House to control the government's computer system and other technology to MS's favor. -- 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 I can see another reason for say Turkey or Russia using FOSS is that they can create a fork for local specialized needs of major FOSS project. I expect as more people get comfortable with FOSS solutions we will see more of this. It has started with Linux but could include LO, OO, Calligra where a specialized version is developed. -- 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
Re: [libreoffice-users] Re: how to select extension dictionary for spellchecking
Hi On Fri, 2011-08-05 at 08:32 -0400, webmaster for Kracked Press Productions wrote: On 08/05/2011 12:22 AM, planas wrote: Hi On Thu, 2011-08-04 at 23:49 -0400, webmaster for Kracked Press Productions wrote: So, would it be better to use the Oxford English or the British English form of spelling? Here in the USA, if we do not use proper American spelling our papers are rejected for sloppiness. I wrote colour once instead of color and the professor was upset with me. My 20 pound [weight] dictionary had the English spelling first, so I used it. I did not know better in those days before computer were smaller than a normal car or truck. So do we use en_GB or en_GB-oed as the default one for Queen and Country? I think use Americans sometimes spell our words differently so we can be different after we broke away from British rule. LibreOffice's ToolsLanguage SettingsLanguagesLocalized --- has 14 different listing for English. More languages than there are versions I can find to install or are in the install .deb files. http://libreoffice-na.us/English/add-on-dictionaries-large-list/US_English_April-19-2011-dic-file.oxt is the link to one that has the most up-to-date .dic file I could find. I found the file and updated the original .oxt file with it. Maybe someone could do that for en_GB-oed to my it better and more up-to-date than from a 2005 .dic file [which the one linked to before from OOo's site has]. Actually 500 years ago, most people could not read. So knowing how to spell was not important. Actually look at the number of different France/French language versions - 4 of them - plus a few localized ones that no longer are called French since they are so different. 20+ Spanish dictionaries are in the list I have at: http://libreoffice-na.us/English/extensions.html#dict . All localized to a country which uses it. On 08/04/2011 05:55 PM, Tom Davies wrote: Hi :) I think 500 years ago there wasn't even an agreed standard way of spelling any word. Shakespeare wrote his own name with many different spellings during his life. I did think that ise had been THE English way for a LOT longer tho! lol. Languages have to evolve and adapt to changing requirements. Regards from Tom :) From: webmaster for Kracked Press Productionswebmas...@krackedpress.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 20:55:36 Subject: Re: [libreoffice-users] Re: how to select extension dictionary for spellchecking So you are saying that the British English use of -ise instead of -ize is a new thing that is just a new way of spelling words that have been around, a new localized [or is it localised] way? I use American English which spells colour as color. But this is the first time I have heard of the -ise/-ize issue. Well they always say language involves. Take English in Britain about 500 years ago. The same words, but different spellings. So should I dump en_GB in favor en_GB-oed version? Should I not include en_CA or en_GB[oed] in my dictionary list in the USA? I know that one .oxt dictionary add-on that includes many different English files. Should people not use that type? en_GB-oed .dic file has 46,113 words in its word list. The Wiki page shows analyse in en_GB-oed and analyze in en_US. Well in the oed .dic file I cannot find analyse. Below is the word list where that word should be located, but it is not. ample/PT amplification/M anarchy/3Ww1SM anastigmatic Andaman/M aneroid Anglican/MS I found the word analyse in the en_GB .dic file dated 2010-02-15 analyze in the en_CA .dic file dated 2010-02-15 but neither spelling in the en_GB-eod version dated 2005-06-13. So the eod version has not kept up with what the Wiki page link shows for Oxford English. Of course, you could always edit a word list and keep only the spellings that Oxford English excepts. As I understand, the complete Oxford dictionary contains 20 volumes/books to hold all the words and definitions. I have a word list of over 200,000 words, but would you want to have a word processor spell checker dictionary with all those words, or only the ones you really want to use? The more words in the list, the more chances that your misspelled words are correct spelling for a different unwanted word. There is not good way around it, except edit your word list to remove the words that are not spelled correctly for your localized version of the language. On 08/04/2011 10:18 AM, ron.vandenbranden wrote: Hi, Thanks for your thoughts. On Thursday 4 August 2011 15:12:21, krackedpress [via Document Foundation Mail Archive] wrote: Could someone tell me what it the
Re: [libreoffice-users] There goes Open-Source in the White House
On 08/05/2011 05:57 PM, upscope wrote: our government is looking for big budget cuts. One would be replace all the MS stuff with open source software. If the united states government, or the government of the united kingdom ruled today that effective 1 January 2012, only FLOSS may be used by the government, and closed source, proprietary software was banned, the budget savings would, at the earliest, be visible in 2016, and probably not until 2020, or even 2025. This is simply due to the unbreakable contracts various software vendors have with those governments. Contracts that requires the vendors to be paid, regardless of whether or not the product meets the contract specifications, assuming it is delivered in the first place. Long term, FLOSS saves money. Short term, it doesn't save money, and can be described as costing money. jonathon -- If Bing copied Google, there wouldn't be anything new worth requesting. If Bing did not copy Google, there wouldn't be anything relevant worth requesting. DaveJakeman 20110207 Groklaw. -- 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: (help macro base)Open form with a button form another form with filter
the basetools extension (0.0.5) works in libreoffice 3.4.2 ? 2011/8/4 rogerio dandrea rolemo...@gmail.com well now with 3.4.2 ubuntu11.04 64bits and use hsql now I have error mensage in filter Why? 2011/7/29 rogerio dandrea rolemo...@gmail.com Alex , thank you. I will return to the problem when version 3.4.2 is launched (in july) 2011/7/28 Alexander Thurgood alex.thurg...@gmail.com Le 28/07/11 22:11, rogerio dandrea a écrit : Hi Rogerio, Sorry if this is a silly question but, how do I switch the focus from one form to another? I actually looked this up on the OpenOffice.org forum, but I can't find the link to the post anymore. There might also be a bug in LibreOffice that prevents the form from reloading. I seem to recall having seen something similar somewhere, because the filter.appply = true and form.reload used to work with OpenOffice.org. Alex -- 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] new book
I am actively adding content to this release of the book. I am currently working through the Calc section. When I finish with that, I will move on to the next section, which is not yet in the document. The German translation is on chapter 7 I believe. On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] new book
On 08/05/2011 08:59 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil 498 pages worth of Macros Explained could help a lot of people on these lists. Have downloaded it and exported it as a PDF file. I usually upload the current PDF version when I upload the ODT version. (for what it is worth). -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] new book
It might happen. I expect that to exist in the context of a Base document, however. Currently, OOME does not have BASE coverage. If I added it, it would likely include content from say AndrewBase.odt, which is rather out of date at this point. On 08/05/2011 11:37 AM, alex bodnaru wrote: thanks andrew for keeping up this great work. though a lot has been changed since your first book, would you consider inserting the new grid control in this new edition? best regards, alex On 08/05/2011 03:49 PM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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: Slow Calc Macros
Am 04.08.2011 09:03, Onyeibo Oku wrote: I did a python macro that adds sheets, renames them and fills in some formula in select cells. It also has a portion that deletes the sheets. I find that the sheet creation runs faster although there's more lines of code running. Whereas the sheet removal macro is just 2lines and runs 3-5times slower. Both routines use 'FOR' loops (the creating routine even has a nested loop). What could be responsible? Does calc recalculate for each removed sheet? Can that feature be toggled off via macro just before the removal loops ...and toggled back on? Thanks in advance :) - from twohot@device.mobile :) Removed sheets may have references, a new sheet can not have any references nor is it referenced. bAC = isAutomaticCalculationEnabled() doc.enableAutomaticCalculation(False) do_stuff doc.enableAutomaticCalculation(bAC) -- 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] password problem
On Thursday 04 August 2011 23:54:24 Bill Gradwohl wrote: On 08/04/2011 08:44 PM, Bob Stia wrote: I have a document that I have had for years. Time to time I must open it, edit it and close it again. It is Libreoffice password protected. A few days ago I opened the fdocument and then after editing closed it agaim. The other night I tried to open it again and the password failed. Bob Thanks for the repies, to the three of you. I will answer Bill first. The other two suggestions will require some work but I will try them and report back. Look at what happens carefully. Even experiment on another test doc to see a slight difference that may be significant. I've experienced password failures on password protected documents part way through the loading process after it successfully took my password and then manufactured a bogus password failure message a certain distance into the loading process. The password failure messages are different depending on if you really keyed in a wrong password or it pops up a bogus message. Create a test document, password protect it and then ATTEMPT to open it with a bad password. Is that the password message your real doc is getting or is it another one? The other one is a bogus message after the file's been corrupted. OK, as you suggested I created a test document and followed your advice. The failure messages on both my doc and the terst doc were exactly the same and failed immediately. No loading. I used bogey passwords several times on the test doc and then used the correct one. It opened prroperly so there was no corruption from trying that. Thanks for trying to help. It is appreciated. Bob S I noticed this on a large spreadsheet that takes quite a while to load. It would take my password, start to load, and then fail some seconds later on some internal error and puts up a bogus message. -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -- 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] Need Calc help
Hi, Hopefully someone can help me out. I maintain in Calc the regional section of a National membership file of Alumni. There are about 650 members in my regional Calc file. Each record is keyed to an unique College number and consists of about 26 fields of data including First/Last names, address, telephone number, etc. On a monthly basis, the national office sends me a 'pull' in Excel format from their national database. Since changes, additions, and deletions are not annotated by National, I have to manually compare each record in the latest listing with the appropriate record in my files. As you can imagine, doing this manually takes a long time when there are about 650 records involved. Assuming that the Column headers are the same in both files (not necessarily in the same order), is there a way that I can compare the two files to create a listing by College Number of fields that do not agree, and records that have been deleted or added? I am computer savvy but failed programming miserably so I need the input of the many smart people on this list. I do follow instructions well so could be led by the nose to create what is required. Thank you for your patience and help Preston -- 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] new book
Thank You Mr. Pitonyak for your Book. El vie, 05-08-2011 a las 09:49 -0300, rogerio dandrea escribió: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Atentamente, Jorge Rodríguez -- 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] Printing
Can anyone help with a print problem. I cannot print landscape. The page style says landscape, the printer settings menu says landscape, the printer properties menu says landscape and the preview screen says landscape but the printer says portrait and prints accordingly. This is specific to libre. Landscape prints everywhere else including OpenOffice. I cannot find anything in the setup which differs from Office. I use Mandriva 10.2 (reluctantly) and have a Brother HL 2040 printer. I installed Libre in the hope that it might remove some of the more infuruating things in Office but it doesn't, it only adds a few more. Alaric -- 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] Need Calc help
Hi There are two programs that you can use for check the diferences between both files: 1) Meld 2) Kdiff3 Both programs are in the Ubuntu repository. Regards, Jorge Rodríguez __ El vie, 05-08-2011 a las 19:50 -0300, Preston Smith escribió: Hi, Hopefully someone can help me out. I maintain in Calc the regional section of a National membership file of Alumni. There are about 650 members in my regional Calc file. Each record is keyed to an unique College number and consists of about 26 fields of data including First/Last names, address, telephone number, etc. On a monthly basis, the national office sends me a 'pull' in Excel format from their national database. Since changes, additions, and deletions are not annotated by National, I have to manually compare each record in the latest listing with the appropriate record in my files. As you can imagine, doing this manually takes a long time when there are about 650 records involved. Assuming that the Column headers are the same in both files (not necessarily in the same order), is there a way that I can compare the two files to create a listing by College Number of fields that do not agree, and records that have been deleted or added? I am computer savvy but failed programming miserably so I need the input of the many smart people on this list. I do follow instructions well so could be led by the nose to create what is required. Thank you for your patience and help Preston -- Atentamente, Jorge Rodríguez -- 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: looking for help on Base
On 08/05/2011 01:25 AM, Roberto Scotti wrote: Il giorno gio, 04/08/2011 alle 09.45 -0700, NoOp ha scritto: On 08/04/2011 01:19 AM, Roberto Scotti wrote: the site http://www.libreoffice.org/features/base/ states ... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access... When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: JDBC JDBC Oracle Adabas D Foglio elettronico dBASE Testo MySQL ODBC How do you activate the MS Access native-support driver? Is a SQLite native-support driver available? Many thanks, Roberto Scotti Maybe this will help: http://packages.ubuntu.com/natty/i386/database/libreoffice-base quote You can extend the functionality of LibreOffice Base by installing these packages: * unixodbc: ODBC database support * libmyodbc | odbc-postgresql | libsqliteodbc | tdsodbc | mdbtools: ODBC drivers for: - MySQL - PostgreSQL - SQLite - MS SQL / Sybase SQL - *.mdb (JET / MS Access) * libmysql-java | libpg-java | libjtds-java: JDBC Drivers for: - MySQL - PostgreSQL - MS SQL Server and Sybase Check to see if you have those installed. Yes, at least I tried to install mdbtools, the stand-alone viewer is working: gmdb2 0.6pre1 GNOME MDB Viewer is a grapical interface to MDB Tools. It lets you view and export data and schema from MDB files produced by MS Access 97/2000/XP/2003. What is needed next to have it available in LbreOffice-Base? Many thanks, rs It appears to still have issues. I'm getting this error: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed I'll post back when I get it figured out. -- 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] There goes Open-Source in the White House
On Fri, 2011-08-05 at 20:53 +, toki wrote: On 08/05/2011 05:57 PM, upscope wrote: our government is looking for big budget cuts. One would be replace all the MS stuff with open source software. If the united states government, or the government of the united kingdom ruled today that effective 1 January 2012, only FLOSS may be used by the government, and closed source, proprietary software was banned, the budget savings would, at the earliest, be visible in 2016, and probably not until 2020, or even 2025. This is simply due to the unbreakable contracts various software vendors have with those governments. Contracts that requires the vendors to be paid, regardless of whether or not the product meets the contract specifications, assuming it is delivered in the first place. Long term, FLOSS saves money. Short term, it doesn't save money, and can be described as costing money. jonathon -- If Bing copied Google, there wouldn't be anything new worth requesting. If Bing did not copy Google, there wouldn't be anything relevant worth requesting. DaveJakeman 20110207 Groklaw. Actually changing to another application/OS, etc will require a learning curve at the beginning. The advantage that FOSS has is the primary cost to using is the learning curve in most cases. I think often the actual costs of switching forget if I switched from LO to KOffice I have a learning curve, I do not know KOffice so I need to learn its quirks to become proficient. If a purchase is involved it just adds to the cost. -- 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
[libreoffice-users] Re: Need Calc help
Am 06.08.2011 00:50, Preston Smith wrote: Hi, Hopefully someone can help me out. I maintain in Calc the regional section of a National membership file of Alumni. There are about 650 members in my regional Calc file. Each record is keyed to an unique College number and consists of about Calc is a calculator which may be misused as a database to some extend. Your terminology describes a relational database. Deriving lists from other lists referring to unique records with keys and indices has always been the most natural thing to do in relational databases. -- 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: Slow Calc Macros
On 05/08/2011, Andreas Säger ville...@t-online.de wrote: Am 04.08.2011 09:03, Onyeibo Oku wrote: I did a python macro that adds sheets, renames them and fills in some formula in select cells. It also has a portion that deletes the sheets. I find that the sheet creation runs faster although there's more lines of code running. Whereas the sheet removal macro is just 2lines and runs 3-5times slower. Both routines use 'FOR' loops (the creating routine even has a nested loop). What could be responsible? Does calc recalculate for each removed sheet? Can that feature be toggled off via macro just before the removal loops ...and toggled back on? Thanks in advance :) - from twohot@device.mobile :) Removed sheets may have references, a new sheet can not have any references nor is it referenced. bAC = isAutomaticCalculationEnabled() doc.enableAutomaticCalculation(False) do_stuff doc.enableAutomaticCalculation(bAC) Thanks Andreas, I've done that but the problem persists. I also made another observation. One of the reserved sheets have formulas spanning about 10columns by 1750rows (some of them having up to 4-6levels of nested 'IF's with conditional formats). When I remove that sheet, the macro executes instantly. What I don't understand is why Calc still computes that sheet while deleting other sheets. The macro makes no reference to it and it doesn't reference the deleted sheets. The 'culprit' sheet uses named cell refs but all within itself except one cell that references a cache sheet which never gets deleted. More baffling is that it happens with AutomaticCalculation set to False. I wonder if watching the huge range with a listener will produce better performance results. -- 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] new book
Your very welcome! On 08/05/2011 09:22 PM, jorge wrote: Thank You Mr. Pitonyak for your Book. El vie, 05-08-2011 a las 09:49 -0300, rogerio dandrea escribió: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] how to have output in table from calc data?
hi, i searched for this but since i am totally new to calc i could not even understand what to search for. i have calc sheet named students demography with the name,age,gender,wt,height,BMI,sponsored candidate or not etc.now i need to make tables for comparing the data.say the row header contains *BMI 30 BMI 30* and the column of the table contains *male female*. what is the way to have this output from the calc data? @tomdavies i am attaching a proforma of the calc sheet and the expected output. any help will be highly appreciated.thanks in advance -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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: Slow Calc Macros
On 08/06/2011 01:14 AM, twohot wrote: On 05/08/2011, Andreas Sägerville...@t-online.de wrote: Am 04.08.2011 09:03, Onyeibo Oku wrote: I did a python macro that adds sheets, renames them and fills in some formula in select cells. It also has a portion that deletes the sheets. I find that the sheet creation runs faster although there's more lines of code running. Whereas the sheet removal macro is just 2lines and runs 3-5times slower. Both routines use 'FOR' loops (the creating routine even has a nested loop). What could be responsible? Does calc recalculate for each removed sheet? Can that feature be toggled off via macro just before the removal loops ...and toggled back on? Thanks in advance :) - from twohot@device.mobile :) Removed sheets may have references, a new sheet can not have any references nor is it referenced. bAC = isAutomaticCalculationEnabled() doc.enableAutomaticCalculation(False) do_stuff doc.enableAutomaticCalculation(bAC) Thanks Andreas, I've done that but the problem persists. I also made another observation. One of the reserved sheets have formulas spanning about 10columns by 1750rows (some of them having up to 4-6levels of nested 'IF's with conditional formats). When I remove that sheet, the macro executes instantly. What I don't understand is why Calc still computes that sheet while deleting other sheets. The macro makes no reference to it and it doesn't reference the deleted sheets. The 'culprit' sheet uses named cell refs but all within itself except one cell that references a cache sheet which never gets deleted. More baffling is that it happens with AutomaticCalculation set to False. I wonder if watching the huge range with a listener will produce better performance results. Perhaps you can also add doc.lockControllers() do something doc.unlockControllers() -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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
