Re: OpenOffice 4.1.10 crashes after splash screen
Leslie, I am running AOO 4.1.14 under Slackware Linux 15.0 with gtk2 and gtk3 and I am not having this problem. I checked my system and although there is a "soffice.bin" file in "/opt/openoffice4/program/", there is no "soffice.bin-gtk-tqt-application" file there. I also did a "find" from "/" for "soffice.bin-gtk-tqt*" with no hits. That begs the question: where did you get your copy of openoffice? My policy is to download openoffice directly from the OpenOffice website. Maybe your copy is flawed or it has been altered by a 3rd party distributor. If you haven't done so, I would suggest downloading the known-good copy from the trusted source: https://www.openoffice.org/ . It is also a good idea to verify the downloaded file's integrity by checking the signatures. The links to the ASC, SHA256 and SHA512 files to compare with are on the download page: https://www.openoffice.org/download/index.html HTH. Girvin On 7/18/23 21:00, J Leslie Turriff wrote: Help! :-) I'm trying to get OpenOffice to work (required by another software I want to use). I have successfully installed openoffice, but when I try to start any of its components it fails with "The application gtk2-tqt-engine (soffice.bin-gtk-tqt-application) crashed and caused the signal 6 (SIGABRT)." It looks like the cause is imbedded somewhere in OpenOffice? Not sure. I've attached a trace. (The following response was sent by the supporters of the Desktop Environment that I use: Looking at the stack trace the problem was deep within OpenOffice, probably while analyzing a true type font while cataloging fonts, perhaps while preparing a menu of fonts. The mention of gtk2 engine seems to be spurious. Nor does there seem to be any connection with TDE. Possibly an OpenOffice bug or a broken font. TIA, Leslie -- Platform: Linux Distribution: openSUSE Leap 15.4 (x86_64) Desktop Environment: Trinity Qt: 3.5.0 TDE: R14.1.0 tde-config: 1.0 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Change my email address
Linda, I had this problem a few years ago and at that time, iirc, I had to unsubscribe using my old email address and after waiting for a confirmation from that, re-subscribe under my new address. Of course, you need your old address active to unsubscribe from to be successful. If not, there is always the list moderator, who may do it for you. Here is a copy of the footer containing the links which is on on most emails from the users server: - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Good luck. Girvin On 6/17/23 13:25, Linda Marker wrote: I want to change my OpenOffice account mailing address. Please let me know how to do this. Thank you. Linda Marker linda.mar...@icloud.com I will sing to the Lord, because He has dealt bountifully with me. (Psalm 13:6) - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: grey font in menu etc
Martin, I sympathize with you. I hate it when some website selects gray on gray or white on gray. It is an assault on the user. I am running AOO 4.1.12 under Xfce4 under Slackware Linux 14.2 (k4.4.x). I am not having a problem reading the AOO dialogs and my eyes are not young. I am not sure the Aoo window's font is all that under AOO's control. I believe AOO picks up whatever the system or desktop is defining, using its styles. You may want to look into your desktop's window font/color settings. That said, one area I would suggest to look at, under Tools > Options > View, there are some styles and font options to look into. Especially, the "Use system font for user interface" option. Mine is checked. Since none of my checks seem to change the window font/color, I strongly suspect as I have said, that this is under the control of the desktop. Xfce4 in my case, KDE, or whatever your system is using. Most likely, you need to look there. Hope this helps. Girvin Herr On 5/9/23 1:14 AM, Dr. Martin Senftleben wrote: Hi, I try to attach an image, because it's otherwise difficult to describe. You see in that image that the GUI font is grey instead of black, and on a grey background, it is hard to read. This goes across the entire OpenOffice, and only there, no other app has this kind of appearance. Hence I believe it's something in OO which I should be able to adjust, I just do not know where to do that. I'm using Manjaro Linux, which I keep up to date. OO-version is 4.1.14, but the problem exists since I returned to OO. I hope that somebody can help me with this. Thanks! Martin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OO Writer dictionary
KV, First, I hope you have created your own dictionary containing your words, not just add your words to the OpenOffice dictionary distributed with OpenOffice. The latter stands a good chance of losing your words at the next update. Creating your own dictionary should prevent such loss. I did some checking and discovered my dictionary was not enabled. You may check if yours is enabled by: Tools > Spelling and Grammar... > Options Ensure your dictionary is in the list and if not checked, then click on the box and enable it. It could be that updates to not carry over the check, for I had my dictionary enabled at some time in the past and now it was not. Select Edit and verify your words are in your dictionary selected. This should prove your dictionary is still present in OpenOffice. If not there, then it must be reinstalled. My dictionary is in: ~/.openoffice/4/user/wordbook This is under Linux, of course. YMMV. It may be a good idea to back up this directory before updating, so you can restore your dictionary after the update if it goes missing. In fact, it may be even better to back up the whole */4/ directory. HTH. Girvin On 4/12/23 9:24 AM, K V wrote: Hopefully this will reach someone. I find that in each update to Open Office that my dictionary rarely migrates all my specific spellings, in both place names and surnames. This is quite aggravating since I am a historian and author working on numerous history projects and several books. It would be very helpful if in the system updates one's dictionary was extracted and migrated to the new update dictionary so that we don't have to teach/correct the Open Office Writer dictionary each and every time. Thanks in advance for your attention to this. Kevin V. Bunker (longtime OpenOffice user) - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Back Up
Harry, Maybe. Check Tools -> Options -> Load/Save "Always create backup copy". You might also consider "Save AutoRecovery information every"... on the same dialog and select a time. The periodic autorecovery saving can be annoying, but it is better than losing data and time. Note the backup copy is only created when the file is closed, and if "Save"d without closing, the old last-saved version is backed up. So it has limits. There is a way to specify where the backup file is saved: Tools -> Options -> OpenOffice -> Paths You can edit the "Backups" path to where you would prefer to store such backups. If you need to recover the backup file, you should copy it from the backup directory (to prevent inadvertent over-writing) and change its ".bak" suffix to the proper ".od?" suffix before opening it in OpenOffice. HTH. Girvin On 12/30/22 9:57 AM, HARRY APPLEBY JR wrote: Is my document automatically backed up? How do I access it? Sent from my iPhone - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: database copying in AOO Base
On 9/15/22 8:30 PM, Brian Barker wrote: At 12:51 15/09/2022 -0700, you wrote: I would like to import the table structure (_Not_ the data), SQL queries, data entry forms, and maybe as a bonus, the reports, from one of the databases into the other database. I'm no expert, but how about duplicating the original database and deleting all the data in it? If and when the above is done: within the same destination database, can I merge (i.e. copy-append) data within one table into the new database table created in #1 above? As above but don't delete the data in that table? I trust this helps. Brian Barker - privately Brian et al, Sorry it took so long to get back to this thread, but I got tied up elsewhere. To make a long story short, I used the procedure in the LO Base Handbook, and it worked fine. They used a click, hold and drag operation to copy a table from the source database to the destination database. It even worked fine for queries, reports, and forms. In short time, I had what I wanted. It saved me hours of work. Here is the procedure I used, if anyone wants to know: 1. Open the source database and select "T_a_bles" under "Database" in the left pane. Do the same with the destination database. 2. Click, hold and drag the source database table name in the "Tables" pane, to the destination database "Tables" pane. Release the mouse button. 3. In the resulting "Copy" dialog, select "Definition" for only the format without the data, or "Definition and data" if the data is needed also. Note that in the "Table name" area, the source database.table is shown. If so, change it to the destination database.table. If this is not done, a "Table exists" error will result. (Note to devs: this should be changed!) 4. Click on "Next". The dialog now allows selection of which fields to copy. I wanted all fields, so I chose ">>". Click on Next. 5. In the resulting dialog, changes to the field formatting can be done. I didn't need to do anything there, so I clicked on "Create". The table is copied. I then changed both databases to "_Q_ueries" in the left pane and used the click-n-drag method to copy the queries I wanted over to the destination database. I then changed both databases to "For_m_s" in the left pane, and did the same for the form I needed to copy. Needless to say, some tweaking needed to be done. The queries were still using the source database names, so they needed editing. I changed the table name and the query name, so the query name in the form "data" source needed to be changed also. This is done by bringing up the form in "Edit" mode and clicking on the "Form" icon on the left when no controls are selected. This will bring up the "Form Properties" dialog. Select the "Data" tab and edit the "Content" field for the proper data source, query or table. When all that was done, I was able to access the new blank table and I am now entering data into it. I have modified the reports in LO, since AOO still does not have a reliable report generator yet. Enjoy! Girvin
Re: Form Name sorting inconsistency
Greetings,
I discovered the key to sorting these lists is to close the database and
reopen it. The lists are only sorted when something is added to the list
or the database is opened. Just switching to another list and back does
not re-sort it.
It is a work-around. My immediate problem is solved.
Girvin
On 10/15/22 4:08 PM, Girvin Herr wrote:
Here is an addendum:
Since I posted this thread, I copied a form from another database and
the new form was put at the bottom of the list, even though it should
have gone in somewhere in the middle if sorted (unless I switched
universes and in this universe, P comes after V). That implies these
names are in some sort of chronological order of creation, rather than
sorted. If not sorted, is there a way to manually edit where these
names are stored in order to manually sort them?
Thanks.
Girvin
On 10/15/22 12:12 PM, Girvin Herr wrote:
Greetings,
I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
Base internal server, but mariadb as an external server and the mysql
connector in the middle.
I am getting some strange, inconsistent with sorting norms and
expectations, form name sorting under the Forms option in AOO Base. I
just tried renaming my database forms with a dash (-) prefix in order
to force those names to the top of the list, i.e.:
inventories.CS_Computer_Software_Data_entry
after renaming becomes:
inventories.-CS_Computer_Software_Data_entry
I cannot place the dash before "inventories" because that is the
database name and as such cannot be changed or other failures will
occur. However, as a result the AOO Forms list sorting becomes as
this snippet shows:
...
inventories.au_song_Title_Data_entry
inventories.-CS_Computer_Software_Data_entry
inventories.CS8_Computer_Software_Data_entry
...
Since when is a dash character subordinate to a lower-case character
("a" in the above case), let alone _any_ alpha-numeric character!? I
was hoping the dash would force the listing to go to the head of the
list, before any lower case entries.
Is there any way to correct this and get it to sort properly, or is
this a bug?
Thanks.
Girvin
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Form Name sorting inconsistency
Here is an addendum:
Since I posted this thread, I copied a form from another database and
the new form was put at the bottom of the list, even though it should
have gone in somewhere in the middle if sorted (unless I switched
universes and in this universe, P comes after V). That implies these
names are in some sort of chronological order of creation, rather than
sorted. If not sorted, is there a way to manually edit where these names
are stored in order to manually sort them?
Thanks.
Girvin
On 10/15/22 12:12 PM, Girvin Herr wrote:
Greetings,
I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
Base internal server, but mariadb as an external server and the mysql
connector in the middle.
I am getting some strange, inconsistent with sorting norms and
expectations, form name sorting under the Forms option in AOO Base. I
just tried renaming my database forms with a dash (-) prefix in order
to force those names to the top of the list, i.e.:
inventories.CS_Computer_Software_Data_entry
after renaming becomes:
inventories.-CS_Computer_Software_Data_entry
I cannot place the dash before "inventories" because that is the
database name and as such cannot be changed or other failures will
occur. However, as a result the AOO Forms list sorting becomes as this
snippet shows:
...
inventories.au_song_Title_Data_entry
inventories.-CS_Computer_Software_Data_entry
inventories.CS8_Computer_Software_Data_entry
...
Since when is a dash character subordinate to a lower-case character
("a" in the above case), let alone _any_ alpha-numeric character!? I
was hoping the dash would force the listing to go to the head of the
list, before any lower case entries.
Is there any way to correct this and get it to sort properly, or is
this a bug?
Thanks.
Girvin
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Form Name sorting inconsistency
Greetings,
I am using AOO 4.1.12 under Slackware Linux 4.4.301, xfce4, mariadb
1.0.38, mysql-connector-java 5.1.42. Note that I am not using the AOO
Base internal server, but mariadb as an external server and the mysql
connector in the middle.
I am getting some strange, inconsistent with sorting norms and
expectations, form name sorting under the Forms option in AOO Base. I
just tried renaming my database forms with a dash (-) prefix in order to
force those names to the top of the list, i.e.:
inventories.CS_Computer_Software_Data_entry
after renaming becomes:
inventories.-CS_Computer_Software_Data_entry
I cannot place the dash before "inventories" because that is the
database name and as such cannot be changed or other failures will
occur. However, as a result the AOO Forms list sorting becomes as this
snippet shows:
...
inventories.au_song_Title_Data_entry
inventories.-CS_Computer_Software_Data_entry
inventories.CS8_Computer_Software_Data_entry
...
Since when is a dash character subordinate to a lower-case character
("a" in the above case), let alone _any_ alpha-numeric character!? I was
hoping the dash would force the listing to go to the head of the list,
before any lower case entries.
Is there any way to correct this and get it to sort properly, or is this
a bug?
Thanks.
Girvin
database copying in AOO Base
Greetings, I am running AOO 4.1.12 under Slackware Linux 14.2 (K4.4.301), with Mariadb 10.0.38 and mysql-connector-java 5.1.42. I have two databases (separate mariadb database files and separate AOO .odb files) which I would like to work on and I have two questions about that work: 1. I would like to import the table structure (_Not_ the data), SQL queries, data entry forms, and maybe as a bonus, the reports, from one of the databases into the other database. Does Base have functions to do that (i.e. Ctrl-C / Ctrl-V across database lines) or do I need to reinvent the wheel and recreate the structures in the destination database? 2. If and when the above is done: within the same destination database, can I merge (i.e. copy-append) data within one table into the new database table created in #1 above? I am pretty sure this can be done in Mariadb (MySql), but I think it would be more time-consuming and difficult without a GUI. The answers to these two questions will determine my procedure. Thanks. Girvin
Is MySQL-connector-java driver still needed for Base?
Greetings, I am using AOO 4.1.12 under Slackware Linux 4.4, XFCE4, and Mariadb 10. I am using the Oracle MySQL-connector-java driver to access my Mariadb 10 database server with AOO. This has been working well for some years. However, I am now looking into switching to the Mariadb Connector/J 3.0.4 driver, but before I make that effort, I seem to remember sometime back about AOO talking to the MySQL server directly - "natively", without needing the Java connector. Is this available in 4.1.12, or is this still vaporware? If it is available, where do I find the setup instructions? Thanks. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Fwd: [ANNOUNCE] Apache OpenOffice 4.1.12 released
Matthias, Reload refreshed it and it is now showing 4.1.12 in the selection box. Thanks. Girvin On 5/5/22 2:18 PM, Matthias Seidel wrote: Hi, I would suggest to clear the browser cache... Regards, Matthias Am 05.05.22 um 23:07 schrieb Keith N. McKenna: Girvin Herr wrote: Greetings Carl, Umm. It might be nice to update the web page ( https://www.openoffice.org/download/ ) to allow downloading 4.1.12. It is still stuck on 4.1.11 as the latest. Girvin Herr Forwarded Message Subject: [ANNOUNCE] Apache OpenOffice 4.1.12 released Date: Wed, 4 May 2022 18:24:00 -0400 From: Carl Marcum Reply-To: annou...@openoffice.apache.org Organization: Apache Software Foundation To: annou...@openoffice.apache.org 04 May 2022 - The Apache OpenOffice project is pleased to announce the release of Apache OpenOffice 4.1.12. This release is dedicated to Jörg Schmidt, who was a valued contributor to the project and suddenly passed away at the end of last year. Apache OpenOffice is a popular Open Source office document productivity suite available in 41 languages on Windows, macOS and Linux. Apache OpenOffice 4.1.12 is a maintenance release incorporating bug fixes and other enhancements. This release also includes the latest dictionaries. All users of Apache OpenOffice 4.1.11 or earlier are advised to upgrade. For the complete overview see the list in Bugzilla: https://s.apache.org/AOO-4112changes Full version of this announcement: https://s.apache.org/AOO-4112announcement Apache OpenOffice 4.1.12 Release Notes: https://s.apache.org/AOO-4112releasenotes Download the source: https://openoffice.apache.org/downloads.html Download Apache OpenOffice 4.1.12 from the original source only: https://www.openoffice.org/download/ Follow Apache OpenOffice: Twitter https://twitter.com/apacheoo Facebook https://www.facebook.com/ApacheOO YouTube https://www.youtube.com/openoffice Mail https://openoffice.apache.org/mailing-lists.html Girven; At 17:03 EST in the United States, it is showing 4.1.12 as latest. If itis still showing 4.1.11 for your locale, please get back to us. Regards Keith N. McKenna - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Fwd: [ANNOUNCE] Apache OpenOffice 4.1.12 released
Greetings Keith, Yep! That's got it. Downloading now... Thanks. Girvin On 5/5/22 2:07 PM, Keith N. McKenna wrote: Girvin Herr wrote: Greetings Carl, Umm. It might be nice to update the web page ( https://www.openoffice.org/download/ ) to allow downloading 4.1.12. It is still stuck on 4.1.11 as the latest. Girvin Herr Forwarded Message Subject: [ANNOUNCE] Apache OpenOffice 4.1.12 released Date: Wed, 4 May 2022 18:24:00 -0400 From: Carl Marcum Reply-To: annou...@openoffice.apache.org Organization: Apache Software Foundation To: annou...@openoffice.apache.org 04 May 2022 - The Apache OpenOffice project is pleased to announce the release of Apache OpenOffice 4.1.12. This release is dedicated to Jörg Schmidt, who was a valued contributor to the project and suddenly passed away at the end of last year. Apache OpenOffice is a popular Open Source office document productivity suite available in 41 languages on Windows, macOS and Linux. Apache OpenOffice 4.1.12 is a maintenance release incorporating bug fixes and other enhancements. This release also includes the latest dictionaries. All users of Apache OpenOffice 4.1.11 or earlier are advised to upgrade. For the complete overview see the list in Bugzilla: https://s.apache.org/AOO-4112changes Full version of this announcement: https://s.apache.org/AOO-4112announcement Apache OpenOffice 4.1.12 Release Notes: https://s.apache.org/AOO-4112releasenotes Download the source: https://openoffice.apache.org/downloads.html Download Apache OpenOffice 4.1.12 from the original source only: https://www.openoffice.org/download/ Follow Apache OpenOffice: Twitter https://twitter.com/apacheoo Facebook https://www.facebook.com/ApacheOO YouTube https://www.youtube.com/openoffice Mail https://openoffice.apache.org/mailing-lists.html Girven; At 17:03 EST in the United States, it is showing 4.1.12 as latest. If itis still showing 4.1.11 for your locale, please get back to us. Regards Keith N. McKenna - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Fwd: [ANNOUNCE] Apache OpenOffice 4.1.12 released
Greetings Carl, Umm. It might be nice to update the web page ( https://www.openoffice.org/download/ ) to allow downloading 4.1.12. It is still stuck on 4.1.11 as the latest. Girvin Herr Forwarded Message Subject:[ANNOUNCE] Apache OpenOffice 4.1.12 released Date: Wed, 4 May 2022 18:24:00 -0400 From: Carl Marcum Reply-To: annou...@openoffice.apache.org Organization: Apache Software Foundation To: annou...@openoffice.apache.org 04 May 2022 - The Apache OpenOffice project is pleased to announce the release of Apache OpenOffice 4.1.12. This release is dedicated to Jörg Schmidt, who was a valued contributor to the project and suddenly passed away at the end of last year. Apache OpenOffice is a popular Open Source office document productivity suite available in 41 languages on Windows, macOS and Linux. Apache OpenOffice 4.1.12 is a maintenance release incorporating bug fixes and other enhancements. This release also includes the latest dictionaries. All users of Apache OpenOffice 4.1.11 or earlier are advised to upgrade. For the complete overview see the list in Bugzilla: https://s.apache.org/AOO-4112changes Full version of this announcement: https://s.apache.org/AOO-4112announcement Apache OpenOffice 4.1.12 Release Notes: https://s.apache.org/AOO-4112releasenotes Download the source: https://openoffice.apache.org/downloads.html Download Apache OpenOffice 4.1.12 from the original source only: https://www.openoffice.org/download/ Follow Apache OpenOffice: Twitter https://twitter.com/apacheoo Facebook https://www.facebook.com/ApacheOO YouTube https://www.youtube.com/openoffice Mail https://openoffice.apache.org/mailing-lists.html
Re: Downloaded OpenOffice to my iPad and I can’t find it
On 2/13/22 1:30 PM, D. A. wrote: Hello, I downloaded Apache OpenOffice to my iPad and I have absolutely no idea where it is so I can actually open it and use it. I see it when I click on “Downloads” on my Firefox browser but it doesn’t do anything or go anywhere. I don’t see anything so basic in the whole support section. Can you help me? Sorry, I’m clueless. It's good to have aspirations in life, but we are most fulfilled by love, not dreams. ~ Lila Rose, founder, LiveAction Live carefully, but not fearfully. ~ DJT Sent with [ProtonMail](https://protonmail.com/) Secure Email. I am not an iPad user, but assuming FireFox's are generally all the same did you look at: Edit -> Settings -> General and scroll down to "Downloads". The default location FF saves downloaded files to is in the "Save files to" box. HTH. G. Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenOffice database and forms
Welcome to fun with AOO Base, ptillery! You need to get the form into edit mode by right-clicking on the form name in the main Base window and selecting "Edit". Then you may need to open the form properties window by clicking on the "Form" icon (3rd one down from the arrow icon on the left toolbar). This should open a "Form Properties" window. Make sure the "Data" tab is selected and "Content type" is set to "Table". Then under "Content", select your table. Now your form should be linked to your table. Then you may have to associate your form controls with a specific field in your table. Take a look at the AOO Base section, Chapter 8, in the Getting Started Guide at: https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Chapters Being a Getting Started Guide, it is not fully detailed, but it may answer your questions going forward. If that does not answer your questions, another resource is the LO Base Handbook at: https://documentation.libreoffice.org/en/english-documentation/ The LO manuals are pretty close to the AOO functions. I would suggest you start with the LO 4.0 Base Handbook at the bottom of this page rather than the latest and greatest LO 7.2 version at the top. The older version may be closer to the current AOO version but without the additional confusing features of the latest LO version of Base. Another option I use a lot is to create a form query and associate my form to that query instead of directly to the table. Use of the query allows additional form features such as sorted lists in the form, functions such as summing fields to get totals, etc. There is also the "Sub-Form" option, but I do not have any experience with that feature, so I cannot comment on it. A note on Base Reports. As far as I know, AOO still does not have a working report generator. Some people have had success with the Oracle Report Builder extension, but I have not had any success with it on version 4.x. LO does have a working built-in report generator and I keep LO around only to do my database reports. I can imagine your next question: why don't I use LO for everything? Plug: Contrary to some others, I found that AOO is much more stable than LO. Features on LO fail while the same or similar features on AOO just work reliably. Apache seems to be doing a much better job at producing a stable release. IMO: LO seems to be focused more on trying to keep up with the latest from Redmond. HTH. Girvin On 1/5/22 2:05 PM, ptillery wrote: I am a total Newby so please forgive my dumb question. I figired out how to build a simple database which I have been using in table mode for years. I got over confident and decided to start using a form. I built one in the data base. Now how do I get them together?Thank you!Sent from my Galaxy - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: [No longer] Mysterious ' in Calc
On 6/28/21 4:55 PM, Dave Fisher wrote: Sent from my iPhone On Jun 28, 2021, at 4:45 PM, Girvin Herr wrote: On 6/28/21 3:36 PM, Brian Barker wrote: At 22:55 28/06/2021 +0100, David Deeks wrote: Thanks very much for your explanation re the Text to Columns facility Brian. That's not my experience or, I imagine, anyone else's. Brian et al., Your imagination is wrong. I have seen it. I just saw it on one of my spreadsheets. In my case it is sensitive to the cell's line length. If the text ends close to the right side of the cell, but not quite close enough to wrap, the row will be double height (wasted white space). I deleted one character and the row jumped to the proper single height. When I put the character back again, the row stayed the proper height. I am pretty sure if I close the file and reopen it again, I will have the double height back. Confirmed - I did a save and "File" -> "Reload" and the row is back to double-height. I have also seen the opposite - row text that is definitely two lines, but the row is single height, making the text cropped and unreadable until I double-click on the row bottom, then it will pop up to the proper double height. I have no idea what is causing it. It seems somewhat random sometimes, but random action does not apply to a computer program. This "feature" has not been fatal to my work, so I just work-around it. What you describe is a font metrics problem where the metrics used don’t match the font used. Can you describe your OS version, OpenOffice version, font including style and size selected, and if that font is present in your system. Regards, Dave Dave, Oops. I should have provided that: OpenOffice 4.1.10, AOO4110m2(Build:9807) - Rev. b1cdbd2c1b 2021-04-19 18:17 - Linux i686 on Slackware 14.2 Linux K4.4.261. In this case I am using "Liberation Sans" 8pt "Regular" with no effects and "Wrap text automatically" checked in the alignment dialog. The font is on my system - liberation-fonts-ttf-1.07.4-noarch-1 : ... usr/share/fonts/TTF/LiberationSans-Bold.ttf usr/share/fonts/TTF/LiberationSans-BoldItalic.ttf usr/share/fonts/TTF/LiberationSans-Italic.ttf usr/share/fonts/TTF/LiberationSans-Regular.ttf usr/share/fonts/TTF/LiberationSansNarrow-Bold.ttf usr/share/fonts/TTF/LiberationSansNarrow-BoldItalic.ttf usr/share/fonts/TTF/LiberationSansNarrow-Italic.ttf usr/share/fonts/TTF/LiberationSansNarrow-Regular.ttf ... HTH Girvin I don't know exactly what you can be doing to cause this. Oh, you are not saving your document in the foreign Microsoft .xls format, are you? I'm not sure that would be the culprit, but it can cause problems. As Joyce Grenfell said to George, "Don't do that". Use OpenOffice's native Open Document Format formats - here .ods. I _never_ save in M$ format. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: [No longer] Mysterious ' in Calc
On 6/28/21 3:36 PM, Brian Barker wrote: At 22:55 28/06/2021 +0100, David Deeks wrote: Thanks very much for your explanation re the Text to Columns facility Brian. That's not my experience or, I imagine, anyone else's. Brian et al., Your imagination is wrong. I have seen it. I just saw it on one of my spreadsheets. In my case it is sensitive to the cell's line length. If the text ends close to the right side of the cell, but not quite close enough to wrap, the row will be double height (wasted white space). I deleted one character and the row jumped to the proper single height. When I put the character back again, the row stayed the proper height. I am pretty sure if I close the file and reopen it again, I will have the double height back. Confirmed - I did a save and "File" -> "Reload" and the row is back to double-height. I have also seen the opposite - row text that is definitely two lines, but the row is single height, making the text cropped and unreadable until I double-click on the row bottom, then it will pop up to the proper double height. I have no idea what is causing it. It seems somewhat random sometimes, but random action does not apply to a computer program. This "feature" has not been fatal to my work, so I just work-around it. I don't know exactly what you can be doing to cause this. Oh, you are not saving your document in the foreign Microsoft .xls format, are you? I'm not sure that would be the culprit, but it can cause problems. As Joyce Grenfell said to George, "Don't do that". Use OpenOffice's native Open Document Format formats - here .ods. I _never_ save in M$ format. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Girvin Herr
Unexpected insert field dialog feature
Greetings, I am not sure this is a bug, but it looks suspect. I am using AOO 4.1.10 A004110m2(Build:9807) Rev. b1cdbd2c1b 2021-04-19 18:17 - Linux i686 on Slackware Linux 14.2 (k4.4.261). Preparation: Since I need to insert many field cross-references to a table, I have the insert-fields-other dialog off to the side of my document. I have pictures in the document which have caption frames around them. The annoyance: If I click on a caption outer frame to adjust it, the insert fields dialog disappears. When I click on something other than the frame. the fields dialog box reappears right in front of me, obstructing what I am working on, which is very annoying. The dialog seems to have reset as if I just opened it again, meaning the settings I had made before it disappeared, such as "Insert reference to" - "Category and Number" is no longer selected and I get "Page" instead of "Category and Number", which is a further annoyance. It seems that "undo"ing the caption frame selection results in the same behavior - the fields dialog pops up right in front of where I am working. Note that this "feature" does not cause AOO to crash or make me lose information, it is just an annoyance to me, but since it is unexpected and unintuitive, it may be a bug. Note that I have experienced similar insert fields dialog movement in response to other actions. I do not remember what precipitated those moves at this time. It seems that the dialog does not remember its last position and so just pops up in the middle of the screen when it reappears - Not very well-behaved. Actually, it is not in the exact center. I is off a bit to the upper left corner. Moving the AOO document window does not change that, it seems to reappear in a consistent place on the screen. Any ideas to stop this behavior? Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Excel equivalent
On 5/3/21 8:48 AM, Brian Barker wrote: Such users will also miss facilities present in the new product that they know nothing of. Here's an example. Suppose you want to concatenate the text in two adjacent spreadsheet cells into a single cell. In OpenOffice, you can merge the two cells - when OpenOffice will offer to combine the contents and even helpfully interpose a blank character - and then immediately unmerge them. The combined text ends up in the first cell. Of course you can achieve the same result in Microsoft Excel, but not (I believe) in the same way or indeed anywhere near as easily. I might add that this feature is not in Calc alone. Writer tables can also merge and split cells. I have used it to create forms with varying width blocks. I am not sure if msWord tables do this. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Ignoring a divide by zero error in Writer table formula
Greetings, I am using AOO 4.1.6 under Slackware Linux 14.2. In Writer, I am trying to create a blank data entry form or template with a table to be filled out later, so all of the to-be-entered values in the table's cells are zero or null. In a few cells I want to create a formula that in part divides one cell value by another cell value, both of which are, of course, zero or null at this time. Normally this divide by zero is an error, and I am getting an "Expression is faulty" error. It isn't the expression that is faulty, but the data. How do I get Writer to ignore this error so the form is clean, until something other than 0.00 is entered in the divisor cell? Is there a way to use a conditional in the formula cell, such as: "if divisor = 0.00 then use 0.01 for divisor else use divisor"? That would fake it out and keep the form clean (blank with no error messages) until data is entered and the divisor becomes not zero. Thanks. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: In Calc, can the horizontal and vertical scroll sections be enlarged?
As an update, I just did some experimenting and I changed my xfce4 desktop window settings under "Applications" -> "Settings" -> "Settings Manager" -> "Appearance" -> "Style" to "xfce-4.4". IMHO, that style gives me larger Calc tabs and still is a pleasant window frame. There are many more styles there that will enlarge the tabs. Some do not. I do recommend, however, to stay away from "Oxygen GTK" which crashed Kplayer when I tried it. As I said, I use xfce4, so other desktops, such as kde, YMMV. In case it may help, here is a screenshot of the style settings available in xfce4: HTH. Girvin On 6/11/20 4:41 PM, Girvin Herr wrote: Slackware Linux 14.2 (32-bit k4.4) and xfce4. I believe this "problem" has been brought up recently before. IIRC That thread resolved the problem to the height of the horizontal scroll bar on the bottom right, which is in the same horizontal field of the window as the sheet tabs and as such, drives the height of the tabs. This cannot be changed in AOO as it stands. The field height may be changed by selecting another window style in the desktop configuration. I did some experimenting with it and found a window style that presented a higher (wider) scroll bar and which did present larger tabs and font. I wasn't satisfied with other attributes of that style, so I selected another style and now I can't remember how I got the higher-tab style to go back to. So, the short answer is to change desktop window manager window styles and see if there is one that works better for you. Girvin On 6/11/20 3:14 PM, Peter Kovacs wrote: Hi Kay, I did not have any Issues with very small tabs size on Linux. Can you specify the Distribution, Windowmanager (KDE, GNome, mate etc) and if you use any themes? I know that we have Issues with themes. So maybe this belongs in this topic too? Or maybe Do you have a 4K Monitor? All the Best Peter Am 11.06.20 um 23:21 schrieb Kay Schenk: Thanks for the tip, and my apologizes for the bad syntax of my first message. -- "Don't let anyone dull your sparkle." __ Kay On 6/11/20 1:00 PM, Brian Barker wrote: At 12:08 11/06/2020 -0700, Kay Schenk wrote: I am using AOO 4.1.7 on Linux-64. A have a spreadsheet with multiple sheets. Once I could easily navigate from one to the next but now, with the VERY SMALL bottom scroll area, this is nearly impossible. The bottom area for showing the sheets seems to be bounded in height by the height of the horizontal scroll bar eight. I could have sworn that using the Zoom facility also enlarged this bottom area in the past, but this is NOT the case now. Any help would be greatly appreciated. I don't see how to change this, but it may be helpful to know that Ctrl+PageDown moves to the next sheet (and so on) - and Ctrl+PageUp the other way. If your version of Linux interferes with this, you may be able to set alternative keyboard shortcuts. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: In Calc, can the horizontal and vertical scroll sections be enlarged?
Slackware Linux 14.2 (32-bit k4.4) and xfce4. I believe this "problem" has been brought up recently before. IIRC That thread resolved the problem to the height of the horizontal scroll bar on the bottom right, which is in the same horizontal field of the window as the sheet tabs and as such, drives the height of the tabs. This cannot be changed in AOO as it stands. The field height may be changed by selecting another window style in the desktop configuration. I did some experimenting with it and found a window style that presented a higher (wider) scroll bar and which did present larger tabs and font. I wasn't satisfied with other attributes of that style, so I selected another style and now I can't remember how I got the higher-tab style to go back to. So, the short answer is to change desktop window manager window styles and see if there is one that works better for you. Girvin On 6/11/20 3:14 PM, Peter Kovacs wrote: Hi Kay, I did not have any Issues with very small tabs size on Linux. Can you specify the Distribution, Windowmanager (KDE, GNome, mate etc) and if you use any themes? I know that we have Issues with themes. So maybe this belongs in this topic too? Or maybe Do you have a 4K Monitor? All the Best Peter Am 11.06.20 um 23:21 schrieb Kay Schenk: Thanks for the tip, and my apologizes for the bad syntax of my first message. -- "Don't let anyone dull your sparkle." __ Kay On 6/11/20 1:00 PM, Brian Barker wrote: At 12:08 11/06/2020 -0700, Kay Schenk wrote: I am using AOO 4.1.7 on Linux-64. A have a spreadsheet with multiple sheets. Once I could easily navigate from one to the next but now, with the VERY SMALL bottom scroll area, this is nearly impossible. The bottom area for showing the sheets seems to be bounded in height by the height of the horizontal scroll bar eight. I could have sworn that using the Zoom facility also enlarged this bottom area in the past, but this is NOT the case now. Any help would be greatly appreciated. I don't see how to change this, but it may be helpful to know that Ctrl+PageDown moves to the next sheet (and so on) - and Ctrl+PageUp the other way. If your version of Linux interferes with this, you may be able to set alternative keyboard shortcuts. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
How do I create custom Appendix page numbers in Writer?
Greetings, Using Aoo 4.1.6 Writer under Slackware Linux 14.2 (K4.4.217) and xfce4. I have a document which I need to add an appendix to at the end. I read the Writer Guide, but there does not seem to be an example of what I want to do with the appendix page numbers. I do not want them to continue from the main document page numbers, so I created an Appendix page style and used that in the page break dialog to restart the appendix page numbers at 1. What I want is to have the page numbers be prefixed by "A" for appendix, to differentiate them from the document main body in the TOC. I could just add an "A" before the page number field in the footer, but that "A" would not be reflected in the TOC page numbers. I want the TOC to reflect "A1", "A2",..., not just restarting at "1" again. The guide has an example of the Chapter number prefix type of numbering, such as "2-1", as in Chapter 2, Page 1, but that is not quite what I want. Is there a way to add such an arbitrary prefix to page numbers and have the entire page number, including the arbitrary prefix, be reflected in the TOC? Thanks. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Database Wizard
On 11/21/19 9:28 AM, Rory O'Farrell wrote: On Thu, 21 Nov 2019 10:21:41 -0700 David Belina wrote: As to USB stick usage: For setup, just answer yes to all prompts if you want the default configuration. as to USB drives and how to use them: USB flash drives can withstand between 10,000 to 100,000 write/erase cycles, depending on the memory technology used. When the limit is reached, some portion of the memory may not function properly, leading to lost of data and corruption. Dave As to set up, just answering yes to all prompts no to all the prompts should give you a default configuration. Dave To prevent corruption and resulting data loss, it is essential to observe the operating system's USB device removal protocols. The flash memory write cycle limit includes updating the file access timestamp in file directories on operating systems that have an access time directory element. This includes *nix-derived OS's such as Linux and probably Macs. Even read cycles could quickly "wear out" the flash memory if access time is changed for reads. The solution for Linux users, in /etc/fstab, all flash memory mounts should have the "noatime" option to prevent access time changes for just reading the file. I have had this option set for many years and have not had any flash corruption. HTH. Girvin Often on en-Forum we see complaints of data loss when users work direct to the USB key; this is why we recommend transfer of files to the hard disk and working with them there. On November 21, 2019 at 10:08:47 AM, Alan Pearce (alannpea...@talktalk.net.invalid) wrote: I can't answer your question but from information I have gleaned from another group, working on thumb drives/usb sticks isn't a good idea as apparently they don't like long term multiple access. So download to your pc and carry out your work then upload to store seems to be the answer. But I am no expert.Cheers,Alan Original message From: James Wheeler Date: 21/11/2019 14:30 (GMT+00:00) To: users@openoffice.apache.org Subject: Database Wizard I have recently purchased a new computer and installed OpenOffice. It’s asking me if I want to create a new database or use an existing? I have a thumb drive full of documents that are in OpenOffice format and all that I want to do is plug in the thumb drive and continue working on the files that are already there. What is the simplest way to set this program up?Thanks,Jim -To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Spreadsheet
On 10/31/19 11:35 AM, Johnny Rosenberg wrote: Den ons 30 okt. 2019 kl 23:29 skrev Stag Mist : Dear OpenOffice Team, I'm using OpenOffice on a Mac. My problem is that when I open the app it automatically opens a Text Document. Is there any option to change it from opening a Text Document to a opening Spreadsheet? How can I set this? I don't have a Mac and it was a long time since I had Apache OpenOffice, but do n't you have icons somewhere for each and every one of the different parts of Open Office? if not, maybe you can change the line that starts the application? On my system, Manjaro with LibreOffice, the line for launching LibreOffice Calc looks like this: libreoffice --calc %U I' don't remember what command starts Apache OpenOffice, maybe it's still ”soffice”? In that case, did you try ”soffice --calc %U”? Maybe opening a terminal and enter something like ”man soffice” will give you a hint or two? Kind regards Johnny Rosenberg Thanks in advance, SM Greetings, It has been a long time since I had no documents open and I am not a Mac user, but I think when you have all but the last document closed, there is a second "X" on the last document's window at the top right. There is the usual "X" to close the window (AOO), but the lower "X" will close the last document and then the window should display the options page, including options to create a new document or open an existing document. If you shut down with this "default" window, AOO should then start with this window when next started. However, if you shut down AOO with a document open, that document should be opened the next time you start AOO. I have several documents that I use a lot and they all open up when I start AOO. HTH. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Printing issue
Dave, In addition to these good replies, may I ask if you tried Ctrl-P and selected "All sheets"? Calc seems to default to printing the "selected" sheet, which is the one you are currently looking at. Using the "quick" print icon on the toolbar will also default to the "selected" sheet and not print the others. This is not controlled by the Print Ranges, except that if a sheet is not in the print range, "All Sheets" will still not print it. Calc likes to _not_ print stuff. Very frustrating at times. HTH. Girvin On 10/27/19 12:00 PM, Christel Lugo wrote: Hello, I am having a problem with Calc-specifically, it won’t print the pages I need printed. I keep trying to print three specific pages and it will only ever print one of them. The print preview only shows one of them, too. I have tried defining the print range via format and highlighting to no avail. I have also tried simply selecting a page number range in the print screen. I have tried deleting the print range under format, but nothing works. Can you help? Thanks, Dave Lugo Sent from my iPhone - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Header problem
Greetings, I am using AOO 4.1.6 under Slackware 14.2 Linux. I am having a problem with my document's headers in Writer. I set both Left Page and Right page styles' header to "Same content left/right". However, when I change the header on a right page, the header on the left page does not reflect those changes. Is there another option somewhere to enable this? Thanks. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Printing Open Office spreadsheet
Todd, Do you have a Print Range specified? OpenOffice Calc will default to printing nothing if no print range is set: Format > Print Ranges > Edit And if under "Print range" you see "none", then change it to "Entire sheet". You can change the rows and columns to repeat, if needed. But they will not prevent printing if empty and you probably don't want that for printing a form. Note that the print range setting defaults to "none" on all sheets (tabs), so it needs to be changed on all sheets needing to be printed. Changing it on one sheet will not change it for other sheets in the file. Also, make sure the printer is set: File > Printer settings and select the printer "Name" from the list. If you got the file from someone else, the default printer may be their printer name, not yours, so the print would go to a non-existent printer on your system. The selected printer is usually saved when the file is saved. HTH. Girvin On 4/4/19 7:57 AM, Todd Bontrager wrote: Hi, I'm trying to help friends of mine print their tax document in spreadsheet, they can print other things but nothing in OpenOffice. Is there a setting somewhere in OpenOffice where the printer needs to be turned on? They are using a Dell desktop and a Xerox printer. Thanks, Todd - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Heading outline numbering not working right
Greetings, I found out how to fix this outline numbering problem. I wanted to see if LibreOffice exhibited the same anomaly, so I performed the process using LO. It behaved the same way. However, I clicked on the "1.1" paragraph to bring up the paragraph context menu and there was an option to "Continue Previous Numbering" right under the "Restart numbering" option. I used it and the 1.1 paragraph changed to 2.1, just as it should. Without saving the LO modified document, I brought it back into OpenOffice and checked the same context menu and that "Continue Previous Numbering" option is there also. I don't know why I didn't see that option before posting my message. That is the solution. Girvin Herr On 2/5/19 12:11 PM, Girvin Herr wrote: Greetings. I am using AOO 4.1.6 under Slackware Linux. I have a document I created in April 2010 that I am updating and am having a problem with "Heading 2" outline numbering. This is a example of what I start with: 1 Introduction 2 General 2.1 Subject When I try to add a new heading between "2" and "2.1", by inserting a paragraph after 2's text and changing its style to "Heading 2", I get this: 1 Introduction 2 General 1.1 2.1 Subject Where I would expect: 1 Introduction 2 General 2.1 2.2 Subject It appears that the new "Heading 2" style is set to start over, but examination of the style does not have the restart option set. I tried using "Format" > "Default reformatting" on the new "Heading 2" paragraph and nothing changes. The "Heading 2" style "Outline & Numbering" tab has The "Outline level" set to "Level 2" and greyed out, and "Numbering" > "Numbering Style" is set to "Outline Numbering" and greyed out. "Line numbering" > "Include this paragraph in line numbering" is unchecked, but checking it does not change the result. "Restart at this paragraph" is unchecked and greyed out. "Start with" is set to "1" but greyed out. The "Organizer" tab Has "Linkled with" set to "Heading". "Contains" is: "Western text: 14 pt + Not Italic + bold + Numbering(Outline) + 2 + don't count lines" Note that if I copy a correct "Heading 2" heading from one part of the document to where I need a "Heading 2", the result is correct - with the correctly incremented outline number. This only occurs when I create a new "Heading 2" paragraph by changing the paragraph style to "Heading 2". Note also that this happens when I set the paragraph style to "Heading 3". I get 1.1.1. Is there somewhere else that I need to change to continue the outline numbering from the last Heading? I do have the copy workaround to this problem, but I would like to understand why this is not working correctly or what I am doing wrong. Thanks. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenProj
Alan B, Thanks for the ProjectLibre link. One caveat is that the Sourceforge download page indicates that this free version will not print. That may be a deciding factor for some people here, including the OP. Despite that, I downloaded it and will check it out as an alternative to OpenProj. I tried ganttproject a while back, but it had a lot of problems and I gave up on it. When I get time, I will try ProjectLibre, but without printing, it will most likely be useless for me. Thanks again. Girvin On 1/23/19 3:54 AM, Alan B wrote: Hello Lee, To access all program features you may want to check ProjectLibre, https://www.projectlibre.com/. ProjectLibre is an open source "fork" of OpenProj, written by the original authors of OpenProj. Download the "Community Edition" of ProjectLibre to install and run on a pc and have access to features in ProjectLibre that are not available in the free version of OpenProj. On Tue, Jan 22, 2019 at 1:42 PM Lee Garrett wrote: Hello, I used OpenProj. When I go to print and want to change some settings, I can't select certain options. How can I get full use of the applications? -- Lee Garrett 404.388.0164 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
win10 update wiping out files
Oops, I deleted the thread where I mentioned the latest win10 update wiping out files. So I am starting a new thread. I was searching for an unrelated subject and ran into this: https://www.techrepublic.com/article/windows-10-file-wiping-bug-what-happens-if-youre-affected/ HTH. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Bug in Open Office Version 4.1.5 in Windows 10 platform.
Greetings, I am not a windows user, but I did read that Microsoft has a problem with the latest update on win10. It makes files disappear! The recommendation is to not install the latest update until they fix it. Note that lately there have been a lot of complaints about OpenOffice files going missing on this and the LibreOffice forums. This could be related. Girvin Herr On 10/21/18 8:34 AM, Satyabrata Datta wrote: Dear Sirs, I am an user of Open Office for Windows since its inception. At present I am using Version 4.1.5 installed in Windows 10. I was facing problems with auto spell check in documents saved in .doc format in Open Office. It was highlighting the entire document as spelling errors. Recently I have changed my Computer and installed the same with Windows 10 and thereafter installed Open Office 4.1.5 therein. Initially, it was all OK. With completion of updation of the Windows 10 the same error again started even with earlier saved .doc files whereas the same is not showing such errors while opening the same with Office 365 (Word). Request please look into the matter and arrange fixing of the same. Thanks & regards, SATYABRATA DATTA. Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Unable to get a spread sheet to print with a grid. I have checked the square requesting same. Also unable to print a blank spread sheet...at all, but wish it with grid.
Greetings, Openoffice Calc will not normally print a blank spreadsheet. It only prints up to the last row (and column) with data. What I do to print a blank sheet with cell borders is to place a period "." or some other nondescript character in the last cell of a sheet. You can enable the page break indication to determine where the page break lies. Put a period in a cell in the row and last column just above the page break indicator line and to the left of the right page break line. That should print the blank cells up to the period cell. Also, make sure your "Print Ranges" (Format > Print Ranges > Edit) shows "entire sheet" in "Print range", otherwise nothing will be printed. HTH. Girvin Herr On 08/29/2018 11:01 AM, dewe...@gmail.com wrote: Sent from Mail for Windows 10 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I am trying to find a #10 envelope template...
On 04/26/2018 11:36 AM, SHAWN STOPPER wrote: I am trying to find a #10 envelope template on openoffice.org. Please let me know if you have one. Thank you. Shawn Stopper Greetings, I am not aware of a template as such. I made my own long ago and I don't remember how I did it. That said, try opening a new document and choose Insert -> Envelope and under "Size", select "Format" and then select #10 and see if this works for you. If it does, then save it as a template for your future use. If not, you can fiddle with margins, page size, etc. to make your own. HTH Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office base will not recognise and usae JRE.
Juliet, Are you sure you have the correct 32-bit or 64-bit JRE (Java Runtime Environment) installed to match the OpenOffice you have installed? They cannot be mixed. I am currently using 32-bit Oracle Java 1.8u131 which seems to work fine. http://www.oracle.com/technetwork/java/javase/downloads/index.html I assume you set up AOO to use the JRE with Tools -> Options -> OpenOffice - Java and selecting the JRE you need to use. You don't say if you are using the internal AOO database engine or an external database server such as MySQL. I have no experience with the AOO internal server, but there are additional steps needed to connect AOO Base to an external server. Have you "registered" the database? Tools -> Options -> OpenOffice Base -> Databases Use "New" to add (register) a database. Then you should be able to bring up Base on that registered database. HTH. Girvin Herr On 02/06/2018 04:37 AM, Juliet Blackburn wrote: Open Office base will do nothing without JRE - it won't print, it won't export and the wizards don't work. I am on a home XP computer and I have tried installing loads of different Java run-times. Although Open Office base recognises that it is there, it will not use it! When I give it the right location to look, it says that the run files are not there. I just want to print out a query or export it. regards Juliet - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: open office reinstall - lost to computer repair
Andrea, Must have been. You are most likely correct. I did prefix my assertion with "IIRC" after all. I am probably mixing up AOO with LibreOffice or maybe OO before Apache. Thanks for clearing that misperception up. Girvin On 02/05/2018 11:39 AM, Andrea Pescetti wrote: Girvin Herr wrote: IIRC, AOO once did pop up a message about donating to the cause before downloading. This was never the case. Apache OpenOffice NEVER solicited donations in an obtrusive way. There is a Donate link on the website, and occasional it is given some more visibility, but that's all. No pop-ups, no interference with the download process. I now see that that message, since going to Sourceforge, is no longer there. Apache OpenOffice downloads have been always hosted at SourceForge, as a reinforcement that Apache OpenOffice never had a donations popup. It must have been some other software. Regards, Andrea. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: open office reinstall - lost to computer repair
James, IIRC, AOO once did pop up a message about donating to the cause before downloading. It could be ignored or bypassed, but it could be confusing for some users. I now see that that message, since going to Sourceforge, is no longer there. That could be what the OP is talking about. Girvin Herr On 02/04/2018 09:47 AM, James Knott wrote: As I mentioned, just go to www.openoffice.org and download for free. I have no idea where that fee suggestion came from, as I've never seen it. On 02/04/2018 12:43 PM, susan leelike wrote: the free open office was available for many years about a year ago the free version renewal suggested a fee (i'd have to look at what it was, something like $25) and over the years the program did change (as everything else does). when my computer was repaired they not provide all of the programs i had on it - adobe reader and open office being two that i use a lot. and since the last time i updated open office there was a fee, i do not want to pay another fee to reinstall it. every improvement of the computer takes me further out of the picture. i guess i am a true luddite and do not find any robotic improvements to be beneficial to humans. SO HERE'S THE QUESTION i just want to reinstall open office where do i go what do i do i am a hater of apps, twitter and all of that i am also 80 thanks On Sun, Feb 4, 2018 at 12:18 PM, James Knott <james.kn...@rogers.com> wrote: You don't have to pay for OpenOffice. It's a free download from www.openoffice.org. I don't know who you paid for OpenOffice, but there are many who charge for what is a free download. Some load it with "crapware" or claim this user mail list is "support". It's not. We're users, just like you. However, we do try to help others. On 02/04/2018 11:40 AM, susan leelike wrote: users@openoffice.apache.org When my computer was repaired a new drive was installed Not only did I lose my old gmail account I also lost my PAID FOR open office program All I want to do is reinstall it so I can get back to work This is getting stupid sleeli...@gmail.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Question
On 02/02/2018 07:30 PM, Martin Groenescheij wrote: On 03/02/18 12:05 PM, Girvin Herr wrote: Kathleen, I am assuming you are concerned about the files listed in File -> Recent Documents as your "...folder icon in Open Office". Unless someone else here knows more, from my experience one cannot delete one file from the file list in File -> Recent Documents. I believe there are two ways to clear all files from this list, but both will clear the entire list and one would have to start over to get a new list without the file you no longer want. Here are the two methods I can think of: 1. "clear" the user profile as described over and over again on this list. But that would clear out everything you have configured AOO for. 2. Use File -> Recent Documents and at the bottom of the list, there is the option "Clear List". Click on that and the entire file history list should then be blank. Of course, you will have to then add the files you do want by opening them. Easier to remove the Recent Documents from the File menu under Tools -> Customize Martin, I don't see how to do this under Tools -> Customize. Can you be more specific and/or give a more detailed procedure? Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Question
That would delete the file off the system, not delete the file from the AOO recently used file list. I am not sure that is what the OP wants to do. Girvin Herr On 02/03/2018 05:54 AM, James Knott wrote: One method is to use File > Open to find the file. Then right click on it and select delete. That works for me, at least on Linux. On 02/02/2018 10:30 PM, Martin Groenescheij wrote: On 03/02/18 12:05 PM, Girvin Herr wrote: Kathleen, I am assuming you are concerned about the files listed in File -> Recent Documents as your "...folder icon in Open Office". Unless someone else here knows more, from my experience one cannot delete one file from the file list in File -> Recent Documents. I believe there are two ways to clear all files from this list, but both will clear the entire list and one would have to start over to get a new list without the file you no longer want. Here are the two methods I can think of: 1. "clear" the user profile as described over and over again on this list. But that would clear out everything you have configured AOO for. 2. Use File -> Recent Documents and at the bottom of the list, there is the option "Clear List". Click on that and the entire file history list should then be blank. Of course, you will have to then add the files you do want by opening them. Easier to remove the Recent Documents from the File menu under Tools -> Customize Note also, that this file list is limited to N number of files, where N is 10 in my AOO. As new files are accessed, the oldest files over N are removed. Therefore, you could use this "feature" to remove the file you don't want, by adding new different files until the unwanted file is scrolled off the bottom. If you want to see more history with the ability to remove individual entries download the Oblivion extension HTH. Girvin Herr On 02/02/2018 04:41 PM, Martin Groenescheij wrote: Sent from my mobile device. On 2 Feb 2018, at 11:21 pm, Kathleen Q <cuddleyv...@yahoo.com.INVALID> wrote: How can I delete a text document I do not want listed on my folder icon in Open Office? OpenOffice is an application to create and maintain office documents. Sometimes I write a text or letter whichever you want to call it and do not need to keep it anymore. I see no delete option. You have your Operating System to do the house cleaning. Please advise?Kathleen Quinlan - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Question
Kathleen, I am assuming you are concerned about the files listed in File -> Recent Documents as your "...folder icon in Open Office". Unless someone else here knows more, from my experience one cannot delete one file from the file list in File -> Recent Documents. I believe there are two ways to clear all files from this list, but both will clear the entire list and one would have to start over to get a new list without the file you no longer want. Here are the two methods I can think of: 1. "clear" the user profile as described over and over again on this list. But that would clear out everything you have configured AOO for. 2. Use File -> Recent Documents and at the bottom of the list, there is the option "Clear List". Click on that and the entire file history list should then be blank. Of course, you will have to then add the files you do want by opening them. Note also, that this file list is limited to N number of files, where N is 10 in my AOO. As new files are accessed, the oldest files over N are removed. Therefore, you could use this "feature" to remove the file you don't want, by adding new different files until the unwanted file is scrolled off the bottom. HTH. Girvin Herr On 02/02/2018 04:41 PM, Martin Groenescheij wrote: Sent from my mobile device. On 2 Feb 2018, at 11:21 pm, Kathleen Q <cuddleyv...@yahoo.com.INVALID> wrote: How can I delete a text document I do not want listed on my folder icon in Open Office? OpenOffice is an application to create and maintain office documents. Sometimes I write a text or letter whichever you want to call it and do not need to keep it anymore. I see no delete option. You have your Operating System to do the house cleaning. Please advise?Kathleen Quinlan - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Latest AOO on Fedora 27 x86_64
JD, Are you trying to run AOO from a shell command line or in an xterm inside your desktop? If the former, keep in mind AOO requires a desktop (xfce, kde, etc) to run under (unless you are trying to run as "headless"). I don't know what AOO will do running from a shell command line without a desktop and without the headless option. I checked my Slackware Linux system and there is no soffice symlink in /usr/bin. I did find a /usr/bin/openoffice4 script which runs /opt/openoffice4/program/soffice "$@". So you might try running /usr/bin/openoffice4 instead of /usr/bin/soffice. Try running openoffice4 from an xterm in your desktop and see if there are any messages spit out on the xterm. If so, the message may give you a hint. HTH. Girvin Herr On 01/26/2018 05:12 PM, JD wrote: Hi all, 1. I first UNINSTALLED LibreOffice, only to find 2 mate desktop packages depend on some libreoffice package. So, now I have something slightly broken in my dnf database. 2. In downloaded AOO, and I installed it without any problems. 3. from the command line, I executed /usr/bin/soffice which is a symlink to /opt/openoffice4/program/soffice 4. Nothing happens. NOTHING Waited for many minutes. Nothing!!! So, what do you suggest I do? P.S: on older fedora releases, I had no such problem. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: There is a problem with the shared '/usr/bin/soffice' between Libreoffice and OpenOffice.
Greetings, In my Slackware Linux packages, I have no conflict. There is no soffice file in my /usr/bin directory. I do have: /usr/bin/libreoffice5.3 which is a symlink to /opt/libreoffice5.3/program/soffice and /usr/bin/openoffice4 Which is a shell script: #!/bin/sh /opt/openoffice4/program/soffice So, as can be seen, the main entry points for these two programs in /usr/bin are vectors to the separate soffice programs in /opt. If you make these changes, your conflicts should disappear. I use both programs, even at the same time, and they work fine without conflicts. Note that you may need to change your ~/Desktop files to change the filenames and possibly your desktop icons to change the filenames to the new names in /usr/bin. HTH. Girvin Herr On 11/19/2017 01:55 PM, Wroger Wroger wrote: How to fix this? Possibly uninstall open office - (older version) do the libre office upgrade and then install the latest Open Office version Any ideas? It won't FIX the shared libraries issue, but it keeps me going. How to do the fix though? Synaptic package manager.. Summary of fault. E: /var/cache/apt/archives/libreoffice-common_1%3a5.1.6~rc2-0ubuntu1~xenial2_all.deb: trying to overwrite '/usr/bin/soffice', which is also in package openoffice-debian-menus 4.1.3-9783 Synaptic package manager install of Libreoffice updates. (Reading database ... 672148 files and directories currently installed.) Preparing to unpack .../libreoffice-common_1%3a5.1.6~rc2-0ubuntu1~xenial2_all.deb ... Unpacking libreoffice-common (1:5.1.6~rc2-0ubuntu1~xenial2) ... dpkg: error processing archive /var/cache/apt/archives/libreoffice-common_1%3a5.1.6~rc2-0ubuntu1~xenial2_all.deb (--unpack): trying to overwrite '/usr/bin/soffice', which is also in package openoffice-debian-menus 4.1.3-9783 rmdir: failed to remove '/var/lib/libreoffice/share/prereg/': No such file or directory rmdir: failed to remove '/var/lib/libreoffice/share/': No such file or directory rmdir: failed to remove '/var/lib/libreoffice/program/': No such file or directory rmdir: failed to remove '/var/lib/libreoffice': No such file or directory rmdir: failed to remove '/var/lib/libreoffice': No such file or directory Processing triggers for gnome-menus (3.13.3-6ubuntu3.1) ... Processing triggers for desktop-file-utils (0.22-1ubuntu5.1) ... Processing triggers for mime-support (3.59ubuntu1) ... Processing triggers for gnome-icon-theme (3.12.0-1ubuntu3) ... Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ... Processing triggers for shared-mime-info (1.5-2ubuntu0.1) ... Processing triggers for man-db (2.7.5-1) ... Errors were encountered while processing: /var/cache/apt/archives/libreoffice-common_1%3a5.1.6~rc2-0ubuntu1~xenial2_all.deb E: Sub-process /usr/bin/dpkg returned an error code (1) A package failed to install. Trying to recover: dpkg: dependency problems prevent configuration of libreoffice-help-en-us: libreoffice-help-en-us depends on libreoffice-l10n-en-us; however: Package libreoffice-l10n-en-us is not installed. dpkg: error processing package libreoffice-help-en-us (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of libreoffice-style-galaxy: libreoffice-style-galaxy depends on libreoffice-common (= 1:5.1.6~rc2-0ubuntu1~xenial2); however: Package libreoffice-common is not installed. dpkg: error processing package libreoffice-style-galaxy (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of libreoffice-core: libreoffice-core depends on libreoffice-common (>> 1:5.1.6~rc2); however: Package libreoffice-common is not installed. dpkg: error processing package libreoffice-core (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of libreoffice-l10n-en-gb: libreoffice-l10n-en-gb depends on libreoffice-common; however: Package libreoffice-common is not installed. dpkg: error processing package libreoffice-l10n-en-gb (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of libreoffice-style-elementary: libreoffice-style-elementary depends on libreoffice-style-galaxy; however: Package libreoffice-style-galaxy is not configured yet. libreoffice-style-elementary depends on libreoffice-common (= 1:5.1.6~rc2-0ubuntu1~xenial2); however: Package libreoffice-common is not installed. dpkg: error processing package libreoffice-style-elementary (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of python3-uno: python3-uno depends on libreoffice-core (= 1:5.1.6~rc2-0ubuntu1~xenial2); however: Package libreoffice-core is not configured yet. dpkg: error processing package python3-uno (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of libreoffice-l10n
Re: OpenOffice Database Question
On 10/27/2017 01:20 PM, cajunm...@cox.net wrote: I'm using Open Office 4.1.3 and in the database module, there is are 4 icons, "databases", "queries", "forms" and "reports". I generate a report from a query. I just need to learn how to format the report. The Report Generator (aka Report Builder) is a graphical way to design and edit reports, test them, display the results, and print them. The report generator takes the report query as input and allows you to specify what and where on the page you want a piece of data. You can also group data, calculate totals, change fonts, orientation, etc. The Report Generator output is fed to AOO Writer or to AOO Calc for display and printing. I use Writer, but that is my preference. If you do not have the Report Generator extension installed, then when you select "Reports" -> [select report] -> "Edit" and log in to your database server, you will get a message similar to this: The document "[report name]" could not be opened. The report "[report name]" requires the extension Oracle Report Builder. This may be a good place to start getting information on the report generator: https://wiki.openoffice.org/wiki/Documentation/How_Tos/Getting_Started_With_the_Report_Builder_Extension Also, why would a person want a database if they could not get a report on the info in the database? Why, indeed! Join a group, for instance, yahoo has many groups. You join the group and then you can post questions and have people provide answers, info. Same with QuickBooks and most software. The "group" in this case is this forum. Yes, I would recommend joining this forum if you want to ask questions about problems you are having with AOO. Keep in mind, the forum is made up of users like yourself, who may or may not, have more experience than yourself to help out. Note that there are other ways to access this forum, but I have no experience with them. Perhaps someone else can address that. HTH. Girvin Herr I wonder if we are talking about the same thing. Thanks for the reply. -Original Message- From: Martin Groenescheij [mailto:mar...@groenescheij.com] Sent: Thursday, October 26, 2017 5:33 PM To: users@openoffice.apache.org Cc: mar...@groenescheij.com Subject: Re: OpenOffice Database Question On 27/10/17 8:04 AM, Girvin Herr wrote: Louis, The short answer is: you can't from OpenOffice. There is no Report Generator bundled with OpenOffice. There used to be a Report Generator extension, but that was not maintained and is no longer compatible with the later OO versions. The Oracle Report Builder is still working and can be downloaded here <https://extensions.openoffice.org/en/project/oracle-report-builder>. I keep LibreOffice installed to run my reports because LO still has a bundled Report Generator. I use OpenOffice to do everything else because I think OO is more stable. I am not sure what you mean by "join a group", since "join" is a database-word. If you mean to join database tables, that depends on your database structure. If you mean to join a user's group, then that is your choice. But if you do not join the user's group, you may not see the responses to your questions. HTH. Girvin Herr On 10/26/2017 01:41 PM, Louis Daigle wrote: How can I get a report to run from a querry? Also, do I need to join a group or something like that? Thanks Louis - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenOffice Database Question
On 10/26/2017 03:33 PM, Martin Groenescheij wrote: On 27/10/17 8:04 AM, Girvin Herr wrote: Louis, The short answer is: you can't from OpenOffice. There is no Report Generator bundled with OpenOffice. There used to be a Report Generator extension, but that was not maintained and is no longer compatible with the later OO versions. The Oracle Report Builder is still working and can be downloaded here <https://extensions.openoffice.org/en/project/oracle-report-builder>. Maybe so, but the last update was in 2007 and this page still shows it as 3.x compatible, not 4.x. That said, I will test it with 4.1.4 and see if it works for me. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: HTML to PDF Conversion (failed - error converting file. task did not complete within timeout)
On 09/18/2017 12:28 PM, Prabhakaran Subramanian wrote: Hi Team, I am using OpenOffice 3.x to convert the HTML files into PDF. Getting the below error for some of the html files. failed - error converting file. task did not complete within timeout It’s taking more time to convert and finally got failed. Is there a way how to find out what kind of issue in the HTML file? Also, how to enable more logs in OpenOffice? In our side, OpenOffice is installed in Linux env. Any help would be appreciated. Thanks, Prabhakaran Subramanian. You could try startx > logfile 2>&1 To start your desktop. This will save all desktop messages in logfile, so you will have to look at the file after exiting the desktop and find the pertinent messages. X has a log for X messages, usually in /var/log/Xorg.0.log but that probably does not help you much for an app error. You could also try bringing up the app in a shell window. Sometimes that will display app error messages in the shell window. You might also look at the OpenOffice command line arguments with openoffice3 -h There may be something there that you could use. Good luck. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Different hash number when downloading Open Office en-US
On 07/28/2017 08:45 AM, Brian Barker wrote: At 16:27 28/07/2017 +0200, Anthony Scales wrote: I have downloaded the exe file "Apache_OpenOffice_4.1.3_Win_x86_install_en-US" and the md5 file that belongs to it. When I upload the md5 file to the recommended websites I get a different hash numbers to that in the exe file. You will, because you should not be submitting the MD5 file to anything. The instructions at the web site are not entirely clear and you seem to be misinterpreting them. What should I do? Use whatever means you wish to process the (large) downloaded installation file and derive its MD5 hash value. But don't also do this with the MD5 file. Instead, open the MD5 file in a text editor: it contains only the required comparison hash value and the name of the relevant installation file. Compare the MD5 value from the installation file with the *content* of the MD5 file. They need to match. I trust this helps. Brian Barker Brian et al, That is painful and error-prone. I know, I used to do it. Then I automated the process: md5sum --check --strict That uses the best tool, the computer, to do the checking and give a yes/no result. Much better than verifying each and every character in the long md5sum. HTH. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Is there a way to simplify summing Writer table cells?
Steve, Thanks for your response. As you may have already seen from my response to Brian's reply, the solution to my problem is to use F2 rather than the sum icon from the toolbar. This produces and allows the formula =sum to be used and stick. The sum icon seems to convert such a formula to the long form of =sum(||...|), which is tedious and error-prone to edit and change. Thanks again. Girvin On 07/13/2017 05:02 PM, Steve Ahlers wrote: Girvin (sorry about the misspelling), What formula do you get when you click and drag? That should give you the correct format that you can follow for other columns or in a spread sheet you can "copy" the result cell and "paste special" to other columns' result cells. Sent from my iPhone On Jul 13, 2017, at 4:14 PM, Girvin Herr <ghe...@fastmail.com> wrote: Steven, I just tried both, and with and without the <> and got the same results: **Expression is faulty **. Thanks for the help. Girvin On 07/13/2017 03:47 PM, Steven Ahlers wrote: Givin, Have you tried a "," or a ";" instead of a ":" ? Sent from my iPhone On Jul 13, 2017, at 3:11 PM, Girvin Herr <ghe...@fastmail.com> wrote: Greetings, I have a Writer document with about 50 rows in a table. At the bottom of the table, I want to sum the above column of cells in each row (a total). Currently, the only way to add a new row or rows to this sum is to add the cell reference(s) (i.e. |) to the long string of cell references to sum. Is this the only way, other than dragging from the first cell to the last cell? I tried =sum(J2:Jn) and even =sum(:) but that just displays a formula error message in the sum cell. I would like to be able to add rows to this table as needed and have an easy way to add the new cells to the sum. A way of specifying a range of cells is perfect. As I now do it, the more rows I need to add, the more tedious and error-prone this process becomes. Thanks. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Is there a way to simplify summing Writer table cells?
On 07/14/2017 03:34 AM, Brian Barker wrote: Aha! I wasn't using the Sum icon, and it does indeed lead to a formula listing the cells in the range individually - instead of as a range. I don't see why this should be. This indeed makes subsequent dragging problematic. And I now see where your parentheses come from. Instead, try this: o Put the cursor into the cell to contain the total. o Press F2: you will see an equals sign in the Formula Text window. o Add just the three letters "sum" - nothing more - to read "=sum". (Er, certainly no parentheses!) o Now just drag over the range of cells. You should now see just =sum , and the dragging I proposed before should now work for modifications. Good-oh! Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Brian, Yes! That worked. Now the =sum formula sticks and is not converted to the long form. I don't know where the long form started. This is an old template that I have been using and I no longer remember how I initially created the sum. However, now that I know how to use the range form, it is sticky and consistent. I can simply edit the range with F2 whenever I append new rows to the table. I also see that the range changes with a new drag, rather than appending the new range to the long form list. That is an option now too. So, the key is to stop using the sum icon from the toolbar and use F2 instead. Thanks much. Now I have to change my templates... Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Is there a way to simplify summing Writer table cells?
On 07/13/2017 04:58 PM, Brian Barker wrote: At 15:11 13/07/2017 -0700, Girvin Herr wrote: I have a Writer document with about 50 rows in a table. At the bottom of the table, I want to sum the above column of cells in each row (a total). Currently, the only way to add a new row or rows to this sum is to add the cell reference(s) (i.e. |) to the long string of cell references to sum. Is this the only way, other than dragging from the first cell to the last cell? Dragging is surely not such a bind? If you have the formula =sum and you add a fifty-first row of data, o Put the cursor into the cell containing the total. o Press F2 to display the Input Line at the top (as you see in using a spreadsheet). The Formula Text window still displays =sum . o Drag across the new range. The Formula Text (also shown in the total cell) changes to =sum . Actually, no. What it changes to is =sum(||...|). If I then drag a new set of cells, the new range is appended to the long string of cell references. That means that I must delete the original string before dragging the new set. I just tried some experiments with dragging and it is a mess - very error prone. I did try you're example of =sum() and it produced the ** Expression is faulty ** message. However, when I selected the Sum icon again and used the green check to okay it without changing anything, the error went away and the correct sum was displayed again. I didn't really do anything to the formula. Also, the was changed to the ||...| again. So it did not stick. o Either click the green "Apply" tick mark in the Input Line, or simply press Enter. I would like to be able to add rows to this table as needed and have an easy way to add the new cells to the sum. A way of specifying a range of cells is perfect. As I now do it, the more rows I need to add, the more tedious and error-prone this process becomes. This is problematic only if you choose or need to add rows *outside* the existing range of rows to be summed - before the first row or after the last row in the existing summed range, that is. This suggests two further possibilities: 1. Insert your new row of data somewhere else - within the existing range, that is. (You are given the option to insert new rows Before instead of After, which may help.) If the order of your data in the table rows is not significant, this may suffice. I tried this and it worked. However, I got the error message again and had to do the clicking on the sum icon and the green check icon again, then it fixed itself. The good news is that this option is closest to what I would like to see. I can insert as many rows as I need and still get the sum to follow it without manually editing that long string of cell references. It is a reasonable option to me. 2. Alternatively, if you want to maintain some order and insert your new data, say, at the end of the existing material, here is a workaround: o Insert your new row *before* the last row of the existing data - so that it becomes the new fiftieth row of what are now fifty-one rows. (The total cell's formula has been automatically modified to =sum ). o Select the entire fifty-first row (your original fiftieth row). o Cut this data and paste it into the new fiftieth row. o Add your new data to the now empty new fifty-first row. No need to touch the formula. Yes, I have done this in Calc. Until you mentioned it, I was not aware it can also be done in Writer tables. I trust this helps. Brian Barker Yes, Brian, it has helped. Thanks. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Is there a way to simplify summing Writer table cells?
Steven, I just tried both, and with and without the <> and got the same results: **Expression is faulty **. Thanks for the help. Girvin On 07/13/2017 03:47 PM, Steven Ahlers wrote: Givin, Have you tried a "," or a ";" instead of a ":" ? Sent from my iPhone On Jul 13, 2017, at 3:11 PM, Girvin Herr <ghe...@fastmail.com> wrote: Greetings, I have a Writer document with about 50 rows in a table. At the bottom of the table, I want to sum the above column of cells in each row (a total). Currently, the only way to add a new row or rows to this sum is to add the cell reference(s) (i.e. |) to the long string of cell references to sum. Is this the only way, other than dragging from the first cell to the last cell? I tried =sum(J2:Jn) and even =sum(:) but that just displays a formula error message in the sum cell. I would like to be able to add rows to this table as needed and have an easy way to add the new cells to the sum. A way of specifying a range of cells is perfect. As I now do it, the more rows I need to add, the more tedious and error-prone this process becomes. Thanks. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Is there a way to simplify summing Writer table cells?
Greetings, I have a Writer document with about 50 rows in a table. At the bottom of the table, I want to sum the above column of cells in each row (a total). Currently, the only way to add a new row or rows to this sum is to add the cell reference(s) (i.e. |) to the long string of cell references to sum. Is this the only way, other than dragging from the first cell to the last cell? I tried =sum(J2:Jn) and even =sum(:) but that just displays a formula error message in the sum cell. I would like to be able to add rows to this table as needed and have an easy way to add the new cells to the sum. A way of specifying a range of cells is perfect. As I now do it, the more rows I need to add, the more tedious and error-prone this process becomes. Thanks. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Lost Password
Gregory, Have you tried "Caps Lock"? Maybe it was set or is set now and so the password capitalization is not matching. That has happened to me in the past. Other than trying such things, you are hosed. From what I read, there is no practical way to recover such a document. HTH. Girvin Herr On 07/06/2017 09:51 AM, Gregory Truby wrote: Hello, I have recently made a document and locked it with a password. And now the password I saved it with isn’t working. I am wondering how I can delete the password or bypass it? Or even reset it? Please help Kind Regards, Gregory Truby - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: pagination
On 05/28/2017 04:22 AM, Martin Groenescheij wrote: On 28/05/17 2:52 AM, Leslie Fink wrote: I work on a Mac and recently upgraded from 10.5 to 10.11 (operating system - Le Capitain). I was using Microsoft Word for Mac but the learning curve was proving very difficult and time-consuming. It was suggested I install Apache Open Office. I create large documents for clients, and previously I was set up for autofill pagination. No page 1, but automatically page 2, 3 and so on. This has disappeared. Can you please tell me how I can set up this automatic pagination ? It’s always been in the header, centre, at the top of the page. Go to Insert -> Header once the Header is inserted place your mouse inside the Header and go to Insert -> Fields -> Page Number If you double click the page number it opens a menu where you can set the number format, at the bottom you see a field to set the Offset f you set this to -1 it start numbering page two as 1 etc. Martin, AOO 4.1.3; Slackware Linux 14.2. I don't use a Mac, but when I use your process, and I change anything in the popup menu and return, the page number disappears and only the grey field indicator remains. Bug? Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Short time saving problem
On 05/09/2017 05:17 PM, jhivacavi...@aol.com wrote: I sent you a message that the automatic saving of a fileoccors at too short of an interval and is extremely annoying. I have not heard back from you. I have also gone to your help menu and have found nothing that guides me to changing to a longer interval. Does the programhave such a change? Thank You. James Ingram Sent from Mail for Windows 10 James, Look at Tools -> Load/Save -> General and you should see a "Minutes" value to the right of the autosave option. Set it to something you can live with. Mine is set to the default of 15 minutes. It is a bit obnoxious when it saves in the middle of some operation, but the alternative of loosing data if it crashes is far worse. HTH. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: For What Home-Office Tasks are you Using AOO-BASE?
On 03/09/2017 01:57 PM, VinceB. wrote: Hello Group: Steven Ahers made a ref: to AOO BASE within his reply comments to one of my previous posts. I have not seen (m)any postings via the email list with regard to AOO BASE or the several other modules, for that matter. I have yet to come up with a practical use of the AOO BASE module. I wonder in what way BASE is being used by HomeOffice operators? An application of using BASE for developing a "Telephone Directory" database is what first comes to my mind; I did begin to do that here, but find that AOO CALC is easier for me. Anyone care to give their list of BASE task applications? Becoming aware of how HomeOffice operators are using BASE would be beneficial to me, and may give me reason to reconsider using a DBM rather than a spreadsheet tool in some instances. Regards, VinceB. Vince, I use Base as a front end (client) to my Mariadb (MySQL) databases. I use it mainly for inventory maintenance with several tables of items and thousands of records on some tables. I also have my music and video library on it and print quarterly reports (listings) of what I have. It also helps keep me from buying something I already have. HTH. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Quick Method to Insert Rows
On 03/04/2017 09:50 AM, VinceB. wrote: Hello: In AOO Calc 4.1.3, is there a quicker method for adding rows other than one at a time? There has been need to insert, for example, ten rows between two existing rows. Doing this one row at a time is "dull". Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Vince, Yes. Left click on the row number (far left column) you want to start insertion. While holding the left mouse button down, drag the mouse down the number of rows you want to insert and release the left button. Right click somewhere on the selected row numbers and select "Insert rows". The number of rows selected should shift down and create the number of blank rows for you. HTH. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Libre Office
On 02/06/2017 01:56 PM, James Plante wrote: On Feb 6, 2017, at 2:42 PM, Girvin Herr <ghe...@fastmail.com <mailto:ghe...@fastmail.com>> wrote 2. AOO does not include a database report generator, which is crucial to my work. You can create the database, but there is no way in AOO to print it out nicely. LO does include a report generator and it works fine. Are you sure it needs a report generator? Can you not open your database as a data source in Writer to produce reports? A report is really just a big, complex form letter. Jim, Umm. I guess I will have to amend my "no way" to "no easy way". The report generator does use either Writer or Calc to do the formatting/printing. However, I have spent a good amount of time formatting my reports the way I want them. To throw that out and start over is not acceptable. It is much easier to use LO when I need to print a report. I think I tried manually using writer for a report once and the results were not pretty. I admit I am not experienced in this process but it seems it would take a lot of recurring work to format the data in Writer for each table, of which I have many, and each update, which are ongoing. The Report Generator just makes it so much easier. It is like a wizard for the data. Would you like to use writer to create and maintain your forms? You can, but that doesn't mean you should, unless you are into pain. 3. LO does not restore a session properly, where AOO does. I like to keep several oft-used files open all the time. I do not close these files before I shut down. I expect these files to be reopened at startup the next time I use the system, so I don't have to manually open them all. AOO does this properly. LO, from version 4.x on, does not. Thank you, Girvin. You just gave me a useful idea. Jim Plante You're welcome. Girvin
Re: can't print out spreadsheets on HP printer now
On 01/17/2017 06:32 PM, Martin Groenescheij wrote: On 18/01/17 10:32 AM, Girvin Herr wrote: Yes, I have seen that too. Usually a new spreadsheet may print until at some unpredictable time in the future, it stops printing. I don't know why it changes. I have not tested it. IMHO, the whole print ranges process should default to "Entire Sheet" for all sheets, including added sheets, unless changed. That's exactly what it does, if no tab has a print range defined (the default) than it print all sheets where it finds data. That has not been my experience. I have had multi-sheet spreadsheets with all print ranges blank (undefined or "default") and they would not print. On top of that, they may have started out printing, but then for some unexplained reason, stopped printing - still with the blank print ranges. I had to define a print range of "Entire Sheet" on each sheet to get it to print all of the sheets. It sounds like the OP has experienced the same thing (bug?). I am just saying the default behavior is sometimes frustrating for the non-power user and when it fails, the cause is not very intuitive. The fact that the OP, and other previous posters with the same problem, had to ask for help on this forum is proof of that. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: can't print out spreadsheets on HP printer now
Yes, I have seen that too. Usually a new spreadsheet may print until at some unpredictable time in the future, it stops printing. I don't know why it changes. I have not tested it. IMHO, the whole print ranges process should default to "Entire Sheet" for all sheets, including added sheets, unless changed. That is probably what the vast majority of users need. The way it is implemented now is a PITA. If you have 10 sheets, you need to set Print Ranges for all 10. That is excessively labor intensive, which is prone to error. Glad to hear it worked for you. Girvin On 01/17/2017 09:33 AM, tedandel...@cox.net wrote: Hi, Thanks for the suggestion. It worked! Don't know why after several years of doing things one way they mysteriously don't work anymore. Ted ---- Girvin Herr <ghe...@fastmail.com> wrote: Ted, Do you have a "Print Range" defined? If not, you would see the symptoms you describe. Format > Print Ranges > edit... Then select "Entire Sheet" from the "Print Range" list. If you want rows to be repeated on each page, then select "User Defined" under "Rows to Repeat" and/or enter a row designation (i.e. $1 for row #1) in the box to the right. Note that this is required on a sheet-by-sheet basis, so if you have more than one sheet to print, then you must select the print range for each sheet. HTH. Girvin Herr On 01/16/2017 09:58 AM, tedandel...@cox.net wrote: Hi, I have used Open Office for several years and it is a great program. However, lately I can't get spreadsheets to print to my HP Officejet 4500 printer. I tried reinstalling the printer, but still nothing prints. When I select print from the drop down or the icon on an OO document nothing shows on the to be printed display, and thus nothing prints out.HELP! Thanks, Ted - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: SETTINGS
On 01/16/2017 01:13 PM, Brian Barker wrote: At 10:59 16/01/2017 -0800, Girvin Herr wrote: On 01/15/2017 10:50 PM, Brian Barker wrote: [...] Go to Tools | Detective > | Remove All Traces. This "Detective" interested me, so I took a look at my AOO 4.1.3 for Linux version and it does not have a Tools | Detective option. Is this OS-dependent or is it not OpenOffice? It's certainly OpenOffice. See https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Finding_and_fixing_errors . There is no indication there of its being operating-system-dependent. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Brian, Yes, I see it now. I don't know how I missed it before. This looks like a pretty good tool to use. Thanks for pointing it out. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: SETTINGS
On 01/15/2017 10:50 PM, Brian Barker wrote:
At 15:35 15/01/2017 -0500, Doug Gambichler wrote:
I USE OPEN OFFICE ALL THE TIME...
Er, there's no need to shout!
... THE EXCEL SHEET, MOSTLY.
Microsoft Excel is a part of Microsoft Office and has no connection
with OpenOffice. If you need help with Excel, you should look for it
elsewhere. Or are you talking about creating and editing spreadsheets
in OpenOffice (Calc) instead?
IN A RUSH TO MAKE CHANGES ON THE SHEET, i CLICKED SOMETHING AND NOW
THE FIRST PART OF THE PAGE HAS ARROWS ...
It may be that you have accidentally toggled on the Detective, which
can show which cells are used as parameters by a formula elsewhere
("precedents") and which formulae elsewhere use it as a parameter
("dependents"). As you say, these are indicated by arrows between the
cells.
IT SAYS GO TO FORMATTING AND CLICK OPTIONS AND THEN OFF. THERE IS NO
OFF.
I'm not sure where you might have found that instruction.
HOW DO I GET THESE ANNOYING THINGS OFF MY SHEET?
Go to Tools | Detective > | Remove All Traces.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Brian,
This "Detective" interested me, so I took a look at my AOO 4.1.3 for
Linux version and it does not have a Tools | Detective option. Is this
OS-dependent or is it not OpenOffice?
Girvin Herr
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Re: can't print out spreadsheets on HP printer now
Ted, Do you have a "Print Range" defined? If not, you would see the symptoms you describe. Format > Print Ranges > edit... Then select "Entire Sheet" from the "Print Range" list. If you want rows to be repeated on each page, then select "User Defined" under "Rows to Repeat" and/or enter a row designation (i.e. $1 for row #1) in the box to the right. Note that this is required on a sheet-by-sheet basis, so if you have more than one sheet to print, then you must select the print range for each sheet. HTH. Girvin Herr On 01/16/2017 09:58 AM, tedandel...@cox.net wrote: Hi, I have used Open Office for several years and it is a great program. However, lately I can't get spreadsheets to print to my HP Officejet 4500 printer. I tried reinstalling the printer, but still nothing prints. When I select print from the drop down or the icon on an OO document nothing shows on the to be printed display, and thus nothing prints out.HELP! Thanks, Ted - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Mysql Connector Java version
Greetings, I am upgrading software and I downloaded the MySQL_connector_java driver version 5.1.40 for use in connecting AOO 4.1.3 Base to my MySQL databases. Previously, I have been using version 5.1.18, which worked fine. Has anyone had experience with the 5.1.40 version and can verify it will work with Base? I also installed java 1.8u112, previously 1.8u40. Thanks. Girvin Herr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: What is soffice.exe?
Paul, It is good to hear someone who takes computer security seriously. Your questions are valid. I will try to answer your questions below. HTH. Girvin Herr On 12/11/2016 03:28 PM, Paul wrote: Hi, I'm a regular user of Open Office. Since a recent update (4.1.3), each time I left click my Open Office desktop icon a message pops up requesting permission to allow soffice.exe to alter my PC. I resent outside influences asking to change my PC without first explaining why and what this means. I have also found that by right clicking this same desktop icon and then left click the "open" option the program launches as it had always done previous to the update. What is this soffice.exe? soffice.exe is the OpenOffice primary executable. The name goes way back in time to the StarOffice program, a predecessor to OpenOffice. I do not know why this confusing legacy name is not changed. There may be some dependency out there somewhere that expects this name for some reason. Will it benefit my use of Open Office and how? Yes, it initializes and runs the OpenOffice programs. Is it a trojan, or other malicious file? No. Unless it has been compromised somewhere other than OpenOffice.org. What changes will it render on my PC if I allow it? Unknown. But the changes it may make are required to run OpenOffice. How can I remove it? Probably by uninstalling OpenOffice. Your feedback will be appreciated. Thanks, Paul - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: page numbers
Bill, I assume you are using Calc, the spreadsheet part of OpenOffice. Go to Format -> Page and under the Header tab, click on Edit. That should bring up a dialog with three area panes - left, center, and right. Delete the unwanted fields/text in these areas and click on OK. Then do the same for the Footer tab, if wanted. Then click on OK -> OK . The data in these header and footer "areas" are defining what is printed at the top (header) and bottom (footer) on each page/sheet. If you don't want any header or footer at all, you can remove the check in the "Footer on" and/or "Header on" boxes in the Header and Footer tabs. HTH. Girvin Herr On 12/08/2016 11:12 AM, Bill Dearling wrote: Hi there when I go to print a page, the sheet # appears at the top and the page # appears at the bottom. it also prints when I print the sheet. Is there a way that I can print my sheet and not have the page and sheet number appear? Thank you for any help you can give me Bill - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: desktop icon shortcut`
On 04/27/2014 05:02 AM, James Knott wrote: LEON FAGER wrote: i downloaded Apache Open Office and it seemed to download ok. But i cannot seem to get a shortcut icon on my desktop as i had on another computer where i could open and it would ask me if i wanted a text document, etc. Could you please tell me how to do this? Many Thanks, Leon Fager You don't mentioned what operating system you're using, but it's certainly easy enough in Windows. Just work your way through the Start menu until you find the OpenOffice icon. Then right click on it and select Send to Desktop. --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org It is even easier in KDE4. ...right-click on it and select Add to desktop. (Replace Start menu with K menu.) HTH Girvin Herr --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: re duplex
On 02/13/2014 07:50 PM, Doug wrote: On 02/13/2014 09:26 PM, Des wrote: Hello Everybody I have Open Office 4.01 connected to a Brother MFC-4710DW printer I would like to do duplex printing so I can save on the number of trees being used for printing. My printer is able to do duplex printing Unfortunately I have not been able to find a setting on Open Office which I can use to set up duplex printing. Your help in this matter would be appreciated. All The Best Desmond --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Normally that is a setup in the printer driver that you use in your Linux to setup the printer. Probably under Options or Properties. In OpenOffice 4.0.0 under the Print command is a Printer Settings menu, then Properties, that allows you to set duplex printing. Don't know about 4.1. --doug --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org You don't say what OS you are using, but if you are using CUPS for printing, the default printer settings can be adjusted there. In your browser, type the URL http://localhost:631/ To get into CUPS and add/delete/modify printer settings. If the printer has duplex, then it can be set ON as default. As was defined by Doug, in OpenOffice, try File - Printer Settings - (select the printer) - Properties To enable duplex. Also, Selecting the Device tab will show a list of printer properties that can be changed. There should be a Duplexer Installed option, or some such name. If it is not installed, then you can select the duplexer option and then a list of Installed or Not Installed should show up in the right pane. You should be able to install it there. But the best thing is to enable it in the CUPS driver as default. If you are not using CUPS, then I am not sure this applies. Hope this helps. Girvin Herr
Re: HP LaserJet question
Doug, I just had a similar thing happen to my HP Laserjet 4050tn. It was very slow getting the pages out. I was using the CUPS Postscript driver and isolated the problem to the printer. Cups showed the document sent and completed as far as it was concerned, but the printer LED was still flashing and after 30 minutes, still had not printed even the first page. I discovered changing the CUPS driver from Postscript to the HP PCL3 driver made it work fine. Now pages print within seconds of clicking on Print. All of my computers are Slackware 14.0 Linux and all of my HP printers are networked. I may note that this problem started when I upgraded to Slack 14.0 with the new 3.x kernel. It may be that the newer Postscript causes the older Postscript engines in the relatively old HP printers to hang up. Hope this helps. Girvin Herr On 09/06/2013 04:16 PM, Doug wrote: I have an HP LaserJet 2200dn, networked with 3 computers--one normally running Windows 7 and two normally running PCLOS. From Linux, when I send it something to print, sometimes--not always--the busy light will start to flash, and then it may print a couple hours, or a day later, or never. Other times it will print right away. Does anyone reading here know of a way to tickle it to make it print what it's sitting on? (Other times, it prints right away.) (There is no HP support--the printer is over 5 years old, so HP has disowned it.) --doug - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
