[libreoffice-users] Problem with comments

2013-02-11 Thread John R. Sowden
For the last several versions of LO, and I believe back to OO, I am having a data entry/display issue re: comments. On a calc sheet with frozen cells, if I am putting a comment in a cell at the top of the unfrozen area, I have a problem with data entry. It seems that the mouse cursor must be

[libreoffice-users] Feature Request

2013-02-12 Thread John R. Sowden
I know this is a bad time, since 4.0 was just released, but improvement is an ongoing process. For the 'recent documents' menu selection under 'file', it would be nice to: 1) allow us to set the number of recent documents, under tools/options. 2) allow us, in the recent menu, to right click and

Re: [libreoffice-users] Feature Request

2013-02-12 Thread John R. Sowden
/2013 11:33 AM, Joel Madero wrote: On Tue, Feb 12, 2013 at 11:04 AM, John R. Sowden jsow...@americansentry.net mailto:jsow...@americansentry.net wrote: I know this is a bad time, since 4.0 was just released, but improvement is an ongoing process. For the 'recent documents' menu

Re: [libreoffice-users] Feature Request

2013-02-12 Thread John R. Sowden
not be suggested because of the above and the fact that it is not clear where to request them. John On 02/12/2013 11:51 AM, Joel Madero wrote: On Tue, Feb 12, 2013 at 11:50 AM, John R. Sowden jsow...@americansentry.net mailto:jsow...@americansentry.net wrote: I went to the site that you

[libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or more tables, each containing one or more

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 07:27 AM, Dan Lewis wrote: On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 09:30 AM, Regina Henschel wrote: Hi John, John R. Sowden schrieb: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: Do you have

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 10:28 AM, Jay Lozier wrote: On 03/03/2013 12:39 PM, Mark Stanton wrote: I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 10:50 AM, Wolfgang Keller wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The main issue for me would be whether the database management system (some call it engine or whatever) actually enforces relational

[libreoffice-users] comments above the split line

2013-03-28 Thread John R. Sowden
When I have split a calc document to lock the titles, etc, I have a problem inserting/editing comments for a cell if the comment text area is above the split line. LO only accepts about 4 characters, then ignores further entry, I have to put the mouse cursor in the comment area and click on

[libreoffice-users] Receiving duplicate msgs, no replay from list admin

2013-05-30 Thread John R. Sowden
Good Morning: I have been receiving duplicate messages from the libreoffice users mailing list for about a month. Multiple messages to users+ow...@global.libreoffice.org is only resulting in a boilerplate email that talks mainly about how to unsubscribe from the list. How do I get a

[libreoffice-users] test-delete me

2013-05-30 Thread John R. Sowden
test-delete me -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive:

[libreoffice-users] test3-delete me

2013-05-30 Thread John R. Sowden
-- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All

[libreoffice-users] 2 'opens' in file menu?

2013-07-02 Thread John R. Sowden
I have 2 Open menu options, both seem to to do the same thing. I have version 4.0.2.2 under Ubuntu John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

[libreoffice-users] Default font and size

2013-07-02 Thread John R. Sowden
I am having a problem setting the default font in calc. This is usually not an issue, as I often start a new sheet from an existing sheet. But if I start from the first menu, I get a font called 'arial' (sounds like a mermaid or m$). Since I am using an oss program, i would prefer to use an

Re: [libreoffice-users] Default font and size

2013-07-02 Thread John R. Sowden
On 07/02/2013 01:56 PM, Regina Henschel wrote: Hi John, John R. Sowden schrieb: I am having a problem setting the default font in calc. This is usually not an issue, as I often start a new sheet from an existing sheet. But if I start from the first menu, I get a font called 'arial' (sounds

[libreoffice-users] Draw printing of large plans

2013-07-24 Thread John R. Sowden
We have created a floor plan, using LO Draw with a scale of 1/8 = 1'. Now we want to take it to Kinko's (Fed Ex) and have it printed for about $4.00 per page. Problem is they cannot print it. A few questions: 1) What is the standard file format (description and file type) for professional

Re: [libreoffice-users] Draw printing of large plans

2013-07-24 Thread John R. Sowden
On 07/24/2013 04:23 AM, Kracked_P_P---webmaster wrote: On 07/24/2013 06:41 AM, John R. Sowden wrote: We have created a floor plan, using LO Draw with a scale of 1/8 = 1'. Now we want to take it to Kinko's (Fed Ex) and have it printed for about $4.00 per page. Problem is they cannot print

Re: [libreoffice-users] Draw printing of large plans

2013-07-24 Thread John R. Sowden
the word out. Again thanks, John On 07/24/2013 06:41 AM, John R. Sowden wrote: We have created a floor plan, using LO Draw with a scale of 1/8 = 1'. Now we want to take it to Kinko's (Fed Ex) and have it printed for about $4.00 per page. Problem is they cannot print it. A few questions: 1

Re: [libreoffice-users] Draw printing of large plans

2013-07-25 Thread John R. Sowden
that is printed is the area inside this grayed box. tia, John On 07/24/2013 12:42 PM, John R. Sowden wrote: On 07/24/2013 06:41 AM, John R. Sowden wrote: We have created a floor plan, using LO Draw with a scale of 1/8 = 1'. Now we want to take it to Kinko's (Fed Ex) and have it printed

Re: [libreoffice-users] Draw printing of large plans

2013-07-25 Thread John R. Sowden
/2013 09:45 AM, John R. Sowden wrote: I am having another, yet related, problem. The drawing is larger than 8.5 x 11. When I display it on the screen, there is a grayed portrait double line box, which covers the same area that is printed, on the screen. I thought that was the page pane. Not so

[libreoffice-users] Feature Request

2013-08-08 Thread John R. Sowden
Similar to gedit (ubuntu), it would be nice if I could point my mouse _near_ the lower right corner to adjust the size of a libre office window, as opposed to placing the tip of the mouse pointer arrow on the pixel where the vertical and horizontal lines meet. Usually I cannot even get to the

[libreoffice-users] Screen goes dark gray, Libreoffice stops

2012-06-23 Thread John R. Sowden
I am running Ubuntu 12.04, the Libre Office 3.5.3.2 with 1 GB ram. I rarely go into my swap partition. When in calc, often the system grinds to a halt. Usually it takes about 15 seconds to allow mouse pointer change, etc. Meanwhile, I can run Freecell with no slowdown while I am waiting,

Re: [libreoffice-users] Screen goes dark gray, Libreoffice stops

2012-06-23 Thread John R. Sowden
On 06/23/2012 10:04 AM, Jay Lozier wrote: John, On 06/23/2012 12:15 PM, John R. Sowden wrote: I am running Ubuntu 12.04, the Libre Office 3.5.3.2 with 1 GB ram. I rarely go into my swap partition. When in calc, often the system grinds to a halt. Usually it takes about 15 seconds to allow

Re: [libreoffice-users] Screen goes dark gray, Libreoffice stops

2012-06-23 Thread John R. Sowden
: [libreoffice-users] Screen goes dark gray, Libreoffice stops To: users@global.libreoffice.org Date: Saturday, 23 June, 2012, 18:31 On 06/23/2012 10:04 AM, Jay Lozier wrote: John, On 06/23/2012 12:15 PM, John R. Sowden wrote: I am running Ubuntu 12.04, the Libre Office 3.5.3.2 with 1 GB ram. I rarely

Re: [libreoffice-users] Re: Screen goes dark gray, Libreoffice stops

2012-06-23 Thread John R. Sowden
On 06/23/2012 12:05 PM, Andreas Säger wrote: Am 23.06.2012 20:54, Tom Davies wrote: Hi :) Open Lo and go to Tools - Options - Java Once again: Not a single built-in Calc feature depends on Java. Like any other type of document, spreadsheets can be exported to XHTML which depends on Java,

[libreoffice-users] keep hidden files from being displayed in the open a file window

2012-11-07 Thread John R. Sowden
LO 3.6.2.2 on Xubuntu 12.10. when I dir to File-- open, I am presented with hundreds of hidden files (1st char is a period). How do I hide these. I searched help, and all of the tools--options area. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] keep hidden files from being displayed in the open a file window

2012-11-07 Thread John R. Sowden
On 11/07/2012 04:50 PM, John R. Sowden wrote: LO 3.6.2.2 on Xubuntu 12.10. when I dir to File-- open, I am presented with hundreds of hidden files (1st char is a period). How do I hide these. I searched help, and all of the tools--options area. found the answer: while in the open a file

[libreoffice-users] Saving to an ascii file

2013-01-31 Thread John R. Sowden
How do I 'save as' or export selected text in LO calc to an ascii file where i can exit it. I seem only to have the options for special file formats, PDF, XML, etc. Thanks, John -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] stopping superscript text in Calc

2013-10-11 Thread John R. Sowden
Been having the problem for a long time. Using Calc, I write a date, Oct 23rd, (I add the rd which shows as a superscript. Problem is whenever I add new text to the cell, it is in the superscript size, not regular text. John -- To unsubscribe e-mail to:

Re: [libreoffice-users] stopping superscript text in Calc

2013-10-11 Thread John R. Sowden
On 10/11/2013 12:51 PM, Mark Bourne wrote: John R. Sowden wrote: Been having the problem for a long time. Using Calc, I write a date, Oct 23rd, (I add the rd which shows as a superscript. Problem is whenever I add new text to the cell, it is in the superscript size, not regular text. John

Re: [libreoffice-users] stopping superscript text in Calc

2013-10-13 Thread John R. Sowden
On 10/13/2013 12:59 AM, Paul van Tooren wrote: John, After adding the rd insuperscript, you have to chance again back to normal script. Succes Paul van Tooren -Oorspronkelijk bericht- From: John R. Sowden Sent: Friday, October 11, 2013 8:21 PM To: users@global.libreoffice.org

Re: [libreoffice-users] duplicate open buttons

2013-10-25 Thread John R. Sowden
On 10/25/2013 12:02 PM, william drescher wrote: I just upgraded to Version 4.0.5.2 (Build ID: 5464147a081647a250913f19c0715bca595af2f) Now I have duplicate open buttons on the standard toolbar. Both have tooltips that say Open (ctrl + O) not a problem for me, just wondered bill same

Re: [libreoffice-users] duplicate open buttons

2013-10-25 Thread John R. Sowden
On 10/25/2013 01:57 PM, Joel Madero wrote: On 10/25/2013 01:15 PM, John R. Sowden wrote: On 10/25/2013 12:02 PM, william drescher wrote: I just upgraded to Version 4.0.5.2 (Build ID: 5464147a081647a250913f19c0715bca595af2f) Now I have duplicate open buttons on the standard toolbar. Both have

Re: [libreoffice-users] duplicate open buttons

2013-10-25 Thread John R. Sowden
On 10/25/2013 08:28 PM, baldwin linguas wrote: On Fri, Oct 25, 2013 at 11:09 PM, John R. Sowden jsow...@americansentry.net wrote: On 10/25/2013 01:57 PM, Joel Madero wrote: On 10/25/2013 01:15 PM, John R. Sowden wrote: On 10/25/2013 12:02 PM, william drescher wrote: I just upgraded

Re: [libreoffice-users] Re: Softmaker

2013-11-20 Thread John R. Sowden
On 11/19/2013 06:10 PM, Jay Lozier wrote: On 11/19/2013 07:30 PM, Virgil Arrington wrote: FreeOffice is interesting. In many ways, it resembles LO or OOo. Does anyone know if it was some form of fork or dirivative? Virgil Virgil I believe FreeOffice is proprietary and is the free version

[libreoffice-users] Font Qs

2013-12-11 Thread John R. Sowden
I just installed LO 4.1 on my win vista laptop. the font I normally use on my desktops (ubuntu 13.10) is freesans. There is no freesans in the font list. Is this a 'windows thing'? How large (in K) are each font file (I'm sure they vary somewhat)? How do I delete the ones that I will never

Re: [libreoffice-users] Font Qs

2013-12-12 Thread John R. Sowden
or find the best choice we have is a bad one. Regards from Tom :) On 11 December 2013 22:11, John R. Sowden jsow...@americansentry.net wrote: I just installed LO 4.1 on my win vista laptop. the font I normally use on my desktops (ubuntu 13.10) is freesans. There is no freesans in the font list

[libreoffice-users] Label creation Q

2013-12-17 Thread John R. Sowden
With the recent messages re: the label function, I created a shipping label. Worked very nicely. Is there a feature to populate the rest of the labels on a sheet (on the screen), from the top left one, so they are all the same? John -- To unsubscribe e-mail to:

[libreoffice-users] Re: Label creation Q

2013-12-18 Thread John R. Sowden
would make sense. John On 12/17/2013 02:32 PM, Don C. Myers wrote: Hi John, If you are using the table based templates, simply copy and paste. Don On 12/17/2013 02:35 PM, John R. Sowden wrote: With the recent messages re: the label function, I created a shipping label. Worked very nicely

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-05 Thread John R. Sowden
On 01/04/2014 08:12 PM, Brian Barker wrote: At 19:10 04/01/2014 -0500, Ryan Ashley wrote: I have developed a spreadsheet which contains a sheet for the cover and basic information as well as one sheet for every month. There is a cell with a number on every sheet at location H35. I want the

Re: [libreoffice-users] Query

2014-01-19 Thread John R. Sowden
On 01/19/2014 03:15 AM, Ernest Dale wrote: I run an important database on Lotus Approach and I have found that Approach will not install on a fresh version of Windows. To surmount the problem I have downloaded Libre Office and attempted to transfer the database on to it. I appear to have

[libreoffice-users] paste to the edit box?

2014-02-18 Thread John R. Sowden
Is it possible to copy text, then paste it into the edit box in calc 4,x under ubuntu 13.10? Now I have to put the cursor in the edit box, then click on edit- paste. John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] same calc sheet in 2 windows?

2014-03-06 Thread John R. Sowden
I have a calc sheet about 600 lines long with data at the top that I would like to see while I an using the data at, say line 400. Is it possible to open a second window showing the data at the top while editing the data at lower lines? John -- To unsubscribe e-mail to:

Re: [libreoffice-users] same calc sheet in 2 windows?

2014-03-06 Thread John R. Sowden
On 03/06/2014 01:34 PM, Brian Barker wrote: At 13:20 06/03/2014 -0800, John R. Sowden wrote: I have a calc sheet about 600 lines long with data at the top that I would like to see while I an using the data at, say line 400. Is it possible to open a second window showing the data at the top

Re: [libreoffice-users] same calc sheet in 2 windows?

2014-03-07 Thread John R. Sowden
On 03/07/2014 04:09 AM, Cley Faye wrote: 2014-03-06 22:49 GMT+01:00 John R. Sowden jsow...@americansentry.net: On 03/06/2014 01:34 PM, Brian Barker wrote: At 13:20 06/03/2014 -0800, John R. Sowden wrote: I have a calc sheet about 600 lines long with data at the top that I would like to see

[libreoffice-users] paste into the edit box

2014-04-21 Thread John R. Sowden
why can't I right click on paste to paste text into the edit box instead of having to go to the edit--paste drop down menu? no one has ever asked, or is there a technical reason? John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] paste into the edit box

2014-04-21 Thread John R. Sowden
On 04/21/2014 02:42 PM, Dave Liesse wrote: Don't think I've ever run across the right-click behavior you mention, but I just left-click in the box and then Ctrl-V (I never use a menu if there's a shortcut key available -- too slow!). Dave On 4/21/2014 13:09, John R. Sowden wrote: why can't

Re: [libreoffice-users] paste into the edit box

2014-04-22 Thread John R. Sowden
On 04/22/2014 11:39 AM, libreoffice-ml.mbou...@spamgourmet.com wrote: John R. Sowden wrote: why can't I right click on paste to paste text into the edit box instead of having to go to the edit--paste drop down menu? I assume you're referring to the input line (where you can type formulas etc

Re: [libreoffice-users] paste into the edit box

2014-04-24 Thread John R. Sowden
On 04/23/2014 11:56 AM, libreoffice-ml.mbou...@spamgourmet.com wrote: John R. Sowden wrote: re: alternatives, this is how I use it-might apply to others: Pay credit card on line Copy verification number from web site paste verification number to an empty cell change font from not free sans

[libreoffice-users] ss not expanding excel csv sheet to multiple columns

2014-05-13 Thread John R. Sowden
I have a vendor who allows me to download a spreadsheet of my monthly invoice. If she downloads it to herself, in the CSV format, she gets 1 field per column in Excel. If I download the sheet in the CSV format, I get all of the fields in 1 column. See headings below from libreoffice.

Re: [libreoffice-users] ss not expanding excel csv sheet to multiple columns

2014-05-13 Thread John R. Sowden
On 05/13/2014 12:10 PM, Cley Faye wrote: 2014-05-13 20:32 GMT+02:00 John R. Sowden jsow...@americansentry.net: I have a vendor who allows me to download a spreadsheet of my monthly invoice. If she downloads it to herself, in the CSV format, she gets 1 field per column in Excel. If I download

[libreoffice-users] different font size in different files

2014-07-10 Thread John R. Sowden
I have tried to standardize on freesans 10 point for most ss uses. I just came on a file with very small type size, yet when I selected the cell and the format - font, I got freesans 10 point. Not wanting to diagnose myself as blind and/or crazy, I brought up another file with the same

[libreoffice-users] write frustrations

2014-09-05 Thread John R. Sowden
Below is why I still use WordStar 5.5 in my office: I am creating a form (an invoice for my ebay purchases because many sellers don't send one). 1) ebay lower cases their name. I type 'ebay'. LO corrects me to make it Ebay. 2) I type seller:. on the next line I create an underline about

Re: [libreoffice-users] write frustrations

2014-09-05 Thread John R. Sowden
John, On 5 September 2014 22:20, John R. Sowden jsow...@americansentry.net wrote: Below is why I still use WordStar 5.5 in my office: I am creating a form (an invoice for my ebay purchases because many sellers don't send one). 1) ebay lower cases their name. I type 'ebay'. LO corrects me

[libreoffice-users] how to turn off read only

2014-09-05 Thread John R. Sowden
Now that I have created my invoice form, I went into file/properties and checked 'open as read only', so the form does not get filled in. Then I decided to make some improvements. When I opened the file, of course, it is set to read only, so I went to properties and found the check box

Re: [libreoffice-users] how to turn off read only

2014-09-06 Thread John R. Sowden
form with no mods to a new file name, exit LO, using Linux, delete the original file. I just assumed there was a way to unset what LO set. John On 09/05/2014 07:10 PM, Dave Barton wrote: Original Message From: John R. Sowden jsow...@americansentry.net To: users

Re: [libreoffice-users] how to turn off read only

2014-09-06 Thread John R. Sowden
' and 'apply user changes' buttons/boxes selections in the properties selection, but they had no effect. John On 09/06/2014 09:25 AM, John R. Sowden wrote: Good Morning All: Re: the properties/security/read only, this is where it all started, because I used that feature to secure the file

Re: [libreoffice-users] write frustrations

2014-09-06 Thread John R. Sowden
I hadn't even thought of/tried the undelete feature. I was unaware of Ctrl Z, but, as hex 26 is an end of file marker, in my mind I block that out. That was a trick that I have used to make part of a file unreadable, based on which editor was being used to view the file. Thanks, John On

[libreoffice-users] calc: Find has never worked for me

2014-09-16 Thread John R. Sowden
I have been using LO from the 'beginning'. I have never be able to get the menu command 'Find' to work. Just to be sure I just tried again. The Edit-Find Selection has the three dots after it, telling me that a dialog box/menu will open. Nothing happens, anywhere on the screen. When I press

Re: [libreoffice-users] calc: Find has never worked for me

2014-09-18 Thread John R. Sowden
On 09/17/2014 11:27 AM, Mark Bourne wrote: John R. Sowden wrote: I have been using LO from the 'beginning'. I have never be able to get the menu command 'Find' to work. Just to be sure I just tried again. The Edit-Find Selection has the three dots after it, telling me that a dialog box/menu

[libreoffice-users] Creating Envelope Forms

2014-09-30 Thread John R. Sowden
I am starting the long trek from WordStar/DOS to Libre Office/Ubuntu. I have many forms to create, about 6 are envelopes. Since our Dell Laser printer does not like to print envelopes en masse, I'm giving LO a go. Problem is in 'help', I am directed to 'insert envelope'. By insert, I

Re: [libreoffice-users] Creating Envelope Forms

2014-10-01 Thread John R. Sowden
On the other hand it can't hurt to have a quick look! ;) Regards from Tom :) On 1 October 2014 06:51, John R. Sowden jsow...@americansentry.net wrote: I am starting the long trek from WordStar/DOS to Libre Office/Ubuntu. I have many forms to create, about 6 are envelopes. Since our Dell Laser printer

Re: [libreoffice-users] Re: Business Cards - Printing - Libre Writer version 4.3.5.2

2015-03-18 Thread John R. Sowden
There is a program called gLabels. I use it to create mailing labels. Re: business cards, I would avoid laser, as business cards are usually stacked together, so they rub. They will wear off the laser toner. Ink is soaked into the paper so it won't come off. That would interfere with the

Re: [libreoffice-users] Filter algorithm question

2015-02-22 Thread John R. Sowden
On 02/22/2015 10:02 AM, Jay Lozier wrote: On 02/22/2015 12:18 PM, office76#xt wrote: Hi, This may sound like some ones homework but its really an algorithm question I have. Imagine you had a square plot of land. You could assign this to a grid and create a two dimensional graph

[libreoffice-users] How to put the column and line on the screen

2015-04-02 Thread John R. Sowden
I am moving a form from WordStar/DOS to LO. I have all of the coordinates, font sizes, etc. from the DOS doc; now I need to create the LO doc. How do I display the column and line numbers (on the LO screen, not the document). John -- To unsubscribe e-mail to:

[libreoffice-users] Feature Req: Indication that LO is doing something

2015-06-07 Thread John R. Sowden
LO v4.1, xubuntu v12.04 I have a 1000-2000 line spreadsheet with half of the cells with formulas. When I, say, delete 30 lines, it takes about 45 seconds. The problem is that I have no idea if it is still a work in progress, or its done. A simple indicator (flashing colored circle, etc.) to

Re: [libreoffice-users] [OT] Operating Environment Survey

2015-07-19 Thread John R. Sowden
always a good idea. this should be done about once every 6 mo. to also track trends. first the questions should be suggested and agreed upon. then, before the next survey 6 mo. down the road, we discuss modifications to the list; probably more additions than deletions, maybe a few wording

[libreoffice-users] Installing Libreoffice in Ubuntu

2015-10-08 Thread John R. Sowden
I have been dealing with this issue for years, going back to the Open Office days. How do you install Libreoffice under Ubuntu? Where are the step by step, clearly documented instructions? When are they not either on the download page in LO or a clear link on the download page? Here's what

Re: [libreoffice-users] Re: Installing Libreoffice in Ubuntu

2015-10-08 Thread John R. Sowden
I have been using the command line since trs-80, cp/m and dos before moving to linux. What are the commands? (Fresh PPA) John On 10/08/2015 08:50 PM, Andreas Säger wrote: Am 09.10.2015 um 04:47 schrieb John R. Sowden: I have been dealing with this issue for years, going back to the Open

[libreoffice-users] verified crash cause

2015-12-01 Thread John R. Sowden
Lo ver 4.4.3.2 Calc under Ubuntu 14.04. I entered "= up arrow" in a cell so the above cell equals the current cell. I have been using this sheet for > 5 years. I use this formula in each years sheet 72 times, this is the first error. I was able to duplicate it 3 times. The first 2 times

Re: [libreoffice-users] verified crash cause

2015-12-01 Thread John R. Sowden
More: This time I copied from a diffent cell to the same cell as before, immed crash. Also I do three columns like this. The first col was ok, the third col was ok, the lower of the two in the second col was ok, the upper of the second col went boom. On 12/01/2015 12:52 PM, John R. Sowden

Re: [libreoffice-users] verified crash cause

2015-12-01 Thread John R. Sowden
. John On 12/01/2015 01:16 PM, Tim Lloyd wrote: John, did you get LO from the ubuntu repos? I tried this under Fedora 23 and LO5.0.1.2 (from the LO website) with no problems. Cheers On 02/12/15 08:11, John R. Sowden wrote: More: This time I copied from a diffent cell to the same cell

[libreoffice-users] command line options

2015-12-23 Thread John R. Sowden
I want a link (launcher?) on my ubuntu 14.04 box to run LO in a directory that I specify without opening a specific file. I entered the "working directory" and the approved execution name (/usr/bin/libreoffice). Problem is LO comes up in, I think, the last directory that I used. How do I

[libreoffice-users] Online help issue

2015-11-20 Thread John R. Sowden
Why am I sent off to the internet when I press F1 for help if I have local help down loaded? (ubuntu 14.04, LO v4.4.3.2) If it tests for local help and cannot find it (installed incorrectly), how can I test for correct install myself (where is/what is the file, etc.) tia, John -- To

Re: [libreoffice-users] Online help issue

2015-11-21 Thread John R. Sowden
r problem, then I cannot help you further, but maybe someone else can. Graham On 20 November 2015 at 21:50, John R. Sowden <jsow...@americansentry.net <mailto:jsow...@americansentry.net>> wrote: Why am I sent off to the internet when I press F1 for help if I have local

Re: [libreoffice-users] Online help issue

2015-11-21 Thread John R. Sowden
Under help, I have 3 files, no dir. I created the en-US directory, then I moved the 3 files into the new dir. Tried LO again, but I still went to the net. John On 11/21/2015 10:36 AM, Regina Henschel wrote: Hi John, John R. Sowden schrieb: Thanks for the response. I found that LO

[libreoffice-users] LO suddenly very slow

2016-01-15 Thread John R. Sowden
I have a SS with about 6 pages, lots of calcs, lookups, etc. about 175K in size. I am running LO ver 5.0.3.2 under Ubuntu ver 14.04 with 4 GB ram.. The other year's sheets of the same size run fine (several a little larger). All of a sudden at about line 250 I hit a brick wall. I enter

Re: [libreoffice-users] LO suddenly very slow

2016-01-15 Thread John R. Sowden
that isn't ready for spreadsheet prime time. Virgil On 01/15/2016 02:20 PM, John R. Sowden wrote: I have a SS with about 6 pages, lots of calcs, lookups, etc. about 175K in size. I am running LO ver 5.0.3.2 under Ubuntu ver 14.04 with 4 GB ram.. The other year's sheets of the same size run

[libreoffice-users] calc slowing to a crawl

2016-02-04 Thread John R. Sowden
I have a spreadsheet that is about 500 rows long and about 20 columns wide. Column 1 is a date column. I do not process the date in any cell formulas. When I hit December, about half way through the 500 rows, it tales about 15 seconds to enter a number in a blank field. This is new, as I have

[libreoffice-users] Slow Loading a calc sheet

2016-03-15 Thread John R. Sowden
xubuntu 14.04 lts, LO v5.0.5.2 When I load a calc file it takes a long time. The progress bar at the bottom immediately goes the the middle, then stops. I have timed it at about 40 seconds until the file is opened. This seems to be an issue only with my "checkbook". We are on a

Re: [libreoffice-users] Re: shrinking an LO window

2016-03-19 Thread John R. Sowden
sorry xubuntu gnome (not unity) On 03/16/2016 01:35 PM, V Stuart Foote wrote: @John, * What OS and Desktop Environment. On Windows builds, there is a nice large target, at least 10 px, that triggers the corner "resize" grab. Have no problem resizing this OS. Stuart -- View this message

Re: [libreoffice-users] Slow Loading a calc sheet

2016-03-15 Thread John R. Sowden
, but I don't remember the processor speed (it was 3rd-fastest available when I got the machine, but that's about 5½ years ago now). Do you, perhaps, have a number of non-displaying calculated fields? That's the only thing that comes to mind. Dave Liesse On 3/15/2016 10:14, John R. Sowden

Re: [libreoffice-users] Re: Re-activating the Recent Documents Function in LibreOffice 5

2016-03-22 Thread John R. Sowden
RecentDocsThumbnail does not appear to be in the expert database. John On 03/22/2016 07:52 AM, V Stuart Foote wrote: Recent Documents and its related RecentDocsThumbnail (at 5.2) are configurable in Expert Configuration (Tools -> Options -> Advanced: Expert Configuration Open the Expert

[libreoffice-users] shrinking an LO window

2016-03-19 Thread John R. Sowden
In order to reduce the size of an LO window, the mouse is used to grab the lower right corner and bring it up/left. The problem is that it seems that the point of the mouse pointer must be on the corner pixel of the window. This is very tedious and time consuming. My first thought was this

Re: [libreoffice-users] function sumif question

2016-04-22 Thread John R. Sowden
On 04/21/2016 03:43 PM, Piet van Oostrum wrote: John R. Sowden wrote: > I have an accounting ledger in calc, with two columns in question. > > col 1 is credit (amount charged to account) and col 2 is the account > number (a 4 digit number currently formatted a number wit

[libreoffice-users] function sumif question

2016-04-21 Thread John R. Sowden
I have an accounting ledger in calc, with two columns in question. col 1 is credit (amount charged to account) and col 2 is the account number (a 4 digit number currently formatted a number with no decimal, but not text). My objective is to sum the amounts in column 1 if col 2=1234. Not a

Re: [libreoffice-users] very slow loading of a ods file

2016-04-30 Thread John R. Sowden
R. Sowden wrote: I wrote about this a few weeks ago, but got no response. Now I have done some testing and my results might cause someone to notice what the issue is. I am running Ubuntu 14.04 and LO Version 5.0.5.2. I have a spreadsheet of about 200k. it is about 6 pages and there are some

Re: [libreoffice-users] damaged file issue

2016-05-14 Thread John R. Sowden
ture to being a menu-item, such as the "Help" menu or somewhere. Regards from Tom :) On 13 May 2016 at 16:47, John R. Sowden <jsow...@americansentry.net> wrote: Whenever I start LO 5, I get a message about a file that is damaged and I am asked if I want to fix it. I say y

[libreoffice-users] damaged file issue

2016-05-13 Thread John R. Sowden
Whenever I start LO 5, I get a message about a file that is damaged and I am asked if I want to fix it. I say yes, LO comes back and says it cannot be fixed. I am able to access the file (password protected SS) with no problem. I am offered the option of deleting information regarding fixing

[libreoffice-users] very slow loading of a ods file

2016-04-29 Thread John R. Sowden
I wrote about this a few weeks ago, but got no response. Now I have done some testing and my results might cause someone to notice what the issue is. I am running Ubuntu 14.04 and LO Version 5.0.5.2. I have a spreadsheet of about 200k. it is about 6 pages and there are some links between a

Re: [libreoffice-users] Re: very slow loading of a ods file

2016-05-01 Thread John R. Sowden
On 04/30/2016 09:23 AM, Andreas Säger wrote: Am 30.04.2016 um 00:02 schrieb John R. Sowden: I then copied another test sheet and deleted all entries below December, calcs and cursor moves worked fine. Therefore I concluded that the problem is with the dates after December. I am doing no date

Re: [libreoffice-users] Use of variables in a cell

2016-07-20 Thread John R. Sowden
Barker wrote: At 10:23 20/07/2016 -0700, John R. Sowden wrote: I think you just introduced another set of questions. I don't think so ... Is the "&" used for macro substitution? Er, nope: it's the concatenation operator. I assume the lowercase n is a shorthand way of definin

[libreoffice-users] Use of variables in a cell

2016-07-20 Thread John R. Sowden
If I have a cell with following formula, can I replace a cell coordinate, such as the 52 below, with a variable that I can assign at the top of my spreadsheet? =sum(a1:a52) Thanks, John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Use of variables in a cell

2016-07-20 Thread John R. Sowden
with my mouse (manual), is it possible that the indirect() function will fail because the assignment was not reread? (I am thinking in terms of procedural code here (Basic, Pascal, xBase). John On 07/20/2016 09:35 AM, Brian Barker wrote: At 08:50 20/07/2016 -0700, John R. Sowden wrote: If

[libreoffice-users] Verified fatal error

2017-02-02 Thread John R. Sowden
I have a 5 page spreadsheet, one page that gets used ofter, the others are not used much. Page 2 is a chart of accounts that a column in page 1 refers to often. Page 1 is about 400 lines long, maybe 10 columns wide. There is a date column, but I do not do date math, and no other cells refer

[libreoffice-users] Verified fatal error

2017-02-02 Thread John R. Sowden
I have a 5 page spreadsheet, one page that gets used ofter, the others are not used much. Page 2 is a chart of accounts that a column in page 1 refers to often. Page 1 is about 400 lines long, maybe 10 columns wide. There is a date column, but I do not do date math, and no other cells refer

Re: [libreoffice-users] Verified fatal error

2017-02-05 Thread John R. Sowden
e most easily resolved with a rebuild (reinstall). Consider it an opportunity to improve the worksheet with better functions available more clear layout & formatting. On Sat, Feb 4, 2017 at 9:48 PM, John R. Sowden <jsow...@americansentry.net> wrote: Why has my message regarding a &quo

Re: [libreoffice-users] Default font in LO calc

2017-02-20 Thread John R. Sowden
I had this problem years ago, and wrote to the list for help. The solution was to create a separate empty spreadsheet, (and a write document?), then convert? it to a template, and label it somehow, in order to set the default font and size. The Elephant in this Room is: These two settings

Re: [libreoffice-users] Verified fatal error

2017-02-16 Thread John R. Sowden
GMT-0500 (Eastern Standard Time), John R. Sowden <jsow...@americansentry.net> wrote: Haven't tested by turning autocalc back on. Why not? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsub

  1   2   >