Re: [libreoffice-users] Share-point?

2013-02-15 Thread Steve Edmonds
On 2013-02-15 21:01, Felmon Davis wrote: On Fri, 15 Feb 2013, Tom Davies wrote: Hi :) Perhaps Moodle? I haven't looked into Moodle but keep meaning to. It's supposedly good for higher education but it might be more about just tutors and lecturers being able to place documents and text

Re: [libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-17 Thread Steve Edmonds
On 2013-02-18 07:31, Hylton Conacher (ZR1HPC) wrote: Hi Tom, On 14/02/13 16:41, Tom wrote: Hi :) Yes, of course you can ask different questions. I just thought it was exactly the same question again in which case my answer wouldn't have been so wrong. Thanks , I was hoping so. snip I

Re: [libreoffice-users] Any plans to incorporate anything from the Lotus Symphony UI?

2013-02-19 Thread Steve Edmonds
On 2013-02-20 06:25, Tanstaafl wrote: On 2013-02-19 11:44 AM, sun shine phaedr...@gmail.com wrote: On 19/02/13 16:33, Tanstaafl wrote: I read recently that IBM had finally donated all of the Lotus Symphony UI code to AOO... Are there any plans to at least take a look at this code and

[libreoffice-users] Headless conversion.

2013-02-19 Thread Steve Edmonds
Hi. My understanding is that LO4 will drop support for .sxw, .sxc, .sxd, .sdw?, .sdc? I have about 2500 of these and am looking to perform a headless conversion across the whole system. Is the filter name in the LO3.6 series for a writer document writer8. Although writer8 works I couldn't

Re: [libreoffice-users] Image - screen saver conflict?

2013-02-26 Thread Steve Edmonds
On 2013-02-27 07:41, Kolbjørn Stuestøl wrote: When awaking my computer after the screen saver has been activated, the images in Writer are gone. Only the image frame containing a Reading error message is left. Reloading the document get the images back. (Naturally it is only the document in

Re: [libreoffice-users] Calc: Finding data at end of column

2013-02-26 Thread Steve Edmonds
On 2013-02-27 08:37, John R. Sowden wrote: On 02/26/2013 11:04 AM, Jay Lozier wrote: On 02/26/2013 01:19 PM, John R. Sowden wrote: I create a lot of ledger spreadsheets, including date,doc no,item,debit,credit,balance,notes. I have a formula in the balance column that tests for data in the

Re: [libreoffice-users] Calc: Finding data at end of column

2013-02-26 Thread Steve Edmonds
On 2013-02-27 09:18, Dave Barton wrote: Original Message From: John R. Sowden jsow...@americansentry.net To: users@global.libreoffice.org Date: Tue, 26 Feb 2013 10:19:45 -0800 I create a lot of ledger spreadsheets, including date,doc no,item,debit,credit,balance,notes. I

Re: [libreoffice-users] How to view MS Word with Security Classification ?

2013-02-28 Thread Steve Edmonds
On 2013-02-28 20:06, Maxim wrote: When I open the MS Word file it comes up with some SECURITY protection and we can not see it properly. Please open the below link to view the screenshot and view the original MS Word file. The file was created by New Zealand Customs but I am not sure why Libre

Re: [libreoffice-users] Re: Vector Graphics in PDF

2013-02-28 Thread Steve Edmonds
Hi. I create PDF with vector graphics (EPS) because they are much cleaner, especially when zoomed for details. I usually print to postscript and use ps2pdf to create the PDF with a script. #! /bin/bash # convert ps to pdf path=`dirname $1` base=`basename $1` pdffile=${base%.*}.pdf

Re: [libreoffice-users] new version of LO gives gibberish for excel file.

2013-03-02 Thread Steve Edmonds
Opens fine in my Opensuse Version 3.6:build-304 (Build ID: 360m1(Build:304)) steve On 2013-03-02 03:18, David B Teague sr wrote: Hi I just downloaded an excel file from http://www.taxpolicycenter.org/taxfacts/displayafact.cfm?Docid=205 The file is the excel version of Historical Source of

Re: [libreoffice-users] Moving list items and re-numbering

2013-03-03 Thread Steve Edmonds
On 2013-03-04 05:49, M Henri Day wrote: 2013/3/3 Kevin O'Brien zwil...@zwilnik.com I have another question regarding lists. If I create a Numbered list, I have items numbered 1, 2, 3, 4, etc. On the Bullets and Numbering toolbar there are buttons for moving list items, which would let do

Re: [libreoffice-users] About.com Readers' Choice Awards 2013 for Office Software

2013-03-03 Thread Steve Edmonds
LO is not listed in office suits for business, but AOO is. I think this is important for business acceptance and not showing makes it look like its not suitable. Steve On 2013-03-04 05:54, Marc Paré wrote: FYI, the About.com Readers' Choice Awards 2013 for Office Software started on Feb. 19

[libreoffice-users] Setting default currency format.

2013-03-04 Thread Steve Edmonds
Hi. Looked through the help but not found what I am after. In calc if I go formatcellscurrency I have a list of formats. How do I choose which one is applied with the currency button or CTL-SHIFT-4. This is not changing the locale. Default I have is red for -ve amount but I want it to be

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

2013-03-05 Thread Steve Edmonds
On 2013-03-06 08:13, Wolfgang Keller wrote: I don't know if it will be suitable, but you can try Kexi (part of Calligra suite, I believe; but you can install it separately). I heard it is much better than LO Base, but I don't know enough to verify that statement. Kexi will become usable as

Re: [libreoffice-users] Horizontal alignment of text in table cells

2013-03-06 Thread Steve Edmonds
On 2013-03-07 20:27, Ken Heard wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I want to start the text put into a table cell at the left side of side of a group of cells. I would assume that after selecting the cells where I want to do that selecting the left margin icon in the

Re: [libreoffice-users]

2013-03-07 Thread Steve Edmonds
Hi. Is it users+unsubscr...@global.libreoffice.org mailto:users+unsubscr...@global.libreoffice.org or users+h...@global.libreoffice.org. The page at http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ states users+unsubscr...@global.libreoffice.org but it seems a lot of

[libreoffice-users] Currency conversion/display in calc

2013-03-08 Thread Steve Edmonds
Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a number. I found a long winded way, format it as currency and remove the ' that LO puts

Re: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Steve Edmonds
On 2013-03-10 01:23, Johnny Rosenberg wrote: 2013/3/9 Steve Edmonds steve.edmo...@ptglobal.com: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise

Re: Fwd: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Steve Edmonds
, I'm quite sure of that now… Anyway, here it is again, to the list this time: -- Forwarded message -- From: Johnny Rosenberg gurus.knu...@gmail.com Date: 2013/3/9 Subject: Re: [libreoffice-users] Currency conversion/display in calc To: Steve Edmonds steve.edmo...@ptglobal.com

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-14 Thread Steve Edmonds
So the bug is in the window that pops up for target (press the target button). It inserts sheet incorrectly as the target. This sounds an easier fix. But if I enter 2014,A1 as the target I get the error invalid range. Steve On 2013-03-15 09:17, Tinkerer wrote: For the benefit of others,

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-14 Thread Steve Edmonds
And for the group. On 2013-03-15 12:48, Tinkerer wrote: Steve Replace the comma with a stop. Alas it still does not work correctly. It moves the cursor to Sheet 2014 Cell A1, but it also moves the Hyperlink to Sheet 2014 as well. I have not the time to sort that out at present. Perhaps someone

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Steve Edmonds
Hi. What version LO are you using. I will fire up my mac and check there too, my last test was 3.6 on Suse. Steve On 2013-03-17 01:47, Tinkerer wrote: Steve There is no bug. Not all Hyperlinks will be to another Sheet, so adding a sheet location would cause more problems. The Documentation

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Steve Edmonds
On 2013-03-17 01:47, Tinkerer wrote: Steve There is no bug. Not all Hyperlinks will be to another Sheet, so adding a sheet location would cause more problems. The Documentation could be improved though. Thank you for your example, it works. I tried adding another Hyperlink to your Sheet 2012

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Steve Edmonds
On 2013-03-17 07:19, Tinkerer wrote: Hi Steve Doh! The solution is unbelievably simple. It does not much matter what technique you use as long as you have 2011.A1, or equivalent, in a Hyperlink. To make it work you have to SAVE the file before you use the Hyperlink. Any attempt to test it

Re: [libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Steve Edmonds
Hi. I have just laid out a custom label like yours and it seems to preview correct. I assumed an A4 sheet and centalised label positions. Steve On 2013-03-19 10:58, Gilles wrote: Thanks all for the input. I'll give it a try, and if it doesn't work, I'll just look for label sheets that have

Re: [libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Steve Edmonds
Hi. I opened a document then went NewLabels. Clicked on format and entered fairly much what you had but assumed that the page was A4 so put in the dimensions 29.7 and 21 down the bottom. Left margin 1.5, top margin 2.6. Saved it as Avery A4/Asia [user1] and away I went. Steve On 2013-03-19

Re: [libreoffice-users] Text Outlining

2013-03-22 Thread Steve Edmonds
Interesting word when you look into it. My first google of word and outlining text finds how to get the outline around the letters in the font (no font fill, LO character style outline), then how to control lists (outlining) but I suspect the original poster is interested in what I would call

Re: [libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Steve Edmonds
:) *From:* Steve Edmonds steve.edmo...@ptglobal.com *To:* Tom Davies tomdavie...@yahoo.co.uk *Cc:* Jason Paul Joines ja...@joines.org; LibreOffice Users users@global.libreoffice.org *Sent:* Monday, 25 March 2013, 0:52 *Subject:* Re: [libreoffice-users

Re: [libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Steve Edmonds
to paragraph instead of Anchor to page which i had previously preferred. It's difficult to get the balance right either way tho. Regards from Tom :) *From:* Steve Edmonds steve.edmo...@ptglobal.com *To:* Tom Davies

Re: [libreoffice-users] calc problem

2013-03-25 Thread Steve Edmonds
On 2013-03-26 09:44, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on

Re: [libreoffice-users] Summing a cell value by a background color cell style

2013-03-25 Thread Steve Edmonds
On 2013-03-26 11:30, Krunoslav Šebetić wrote: On 03/25/2013 11:08 PM, Brian Barker wrote: At 15:16 25/03/2013 +0100, Krunoslav Šebetić wrote: I need to make a Calc table. Table is structured vertically. Tables sums number values from columns in the last row of table. Every column stands for

Re: [libreoffice-users] Summing a cell value by a background color cell style

2013-03-25 Thread Steve Edmonds
On 2013-03-26 12:32, Krunoslav Šebetić wrote: On 03/25/2013 11:55 PM, Steve Edmonds wrote: On 2013-03-26 11:30, Krunoslav Šebetić wrote: On 03/25/2013 11:08 PM, Brian Barker wrote: At 15:16 25/03/2013 +0100, Krunoslav Šebetić wrote: I need to make a Calc table. Table is structured

Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-27 Thread Steve Edmonds
On 2013-03-27 20:47, Brian Barker wrote: At 07:15 26/03/2013 -0700, Jason C. Wells wrote: That works well. I'll check it against real data today. The details of the numerical comparison are hidden from me with that equation ... I'm sure you'll be able to analyse the formula

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread Steve Edmonds
On 2013-03-29 07:50, T. R. Valentine wrote: On 28 March 2013 13:33, Mirosław Zalewski mini...@poczta.onet.pl wrote: On 28/03/2013 at 19:13, Kevin O'Brien zwil...@zwilnik.com wrote: Yes, there is. ... unless you are using 4.0, in which it is not possible. See #60589:

Re: [libreoffice-users] Graph with two sets of Readings in Calc

2013-03-31 Thread Steve Edmonds
On 2013-04-01 14:13, Gulzar Singh wrote: I have two group of readings. First called as Standard. Second as Sample. Each group has 6 readings. I need to create a graph. X-axis with 'concentration'. Y-axis with 'OD'. PROBLEM: Standard readings should be plotted first and a straight line from

Re: [libreoffice-users] Graph with two sets of Readings in Calc

2013-03-31 Thread Steve Edmonds
wrote: Yes. Concentration values are same for both. Standard readings will create a straight line from origin with two or more values. On that line values of sample are to be plotted. Now that point will be used to determine concentration of sample. On Apr 1, 2013 8:19 AM, Steve Edmonds

Re: [libreoffice-users] Differences with LO OO

2013-04-05 Thread Steve Edmonds
Hi. What was the document created in and what version. Steve On 2013-04-05 14:39, James Knott wrote: I have both LibreOffice and OpenOffice on my computers. One thing I've noticed is that documents don't always appear the same in them. For example, I have one document which is a table in

Re: [libreoffice-users] Importing PDF problem

2013-04-06 Thread Steve Edmonds
On 2013-04-07 09:25, Doug wrote: On 04/06/2013 01:22 AM, Steve Edmonds wrote: Hi. I just tried an interesting thing. Uploaded a PDF with images to google drive. Right clicked the PDF and open with google docs. Then the PDF was converted to a google doc and I could download the PDF as an odt

Re: [libreoffice-users] Importing PDF problem

2013-04-06 Thread Steve Edmonds
] Importing PDF problem On 04/06/2013 01:22 AM, Steve Edmonds wrote: Hi. I just tried an interesting thing. Uploaded a PDF with images to google drive. Right clicked the PDF and open with google docs. Then the PDF was converted to a google doc and I could download the PDF as an odt and edit

Re: [libreoffice-users] Re: Writer - word wrap problem when image is left of the margin.

2013-04-10 Thread Steve Edmonds
Hi. I have confirmed the bug but can't change the status to confirmed. Steve. On 2013-04-11 06:46, Tom wrote: Hi :) Sorry chap! Your message didn't reach the mailing list. Have you subscribed to the mailing list or only to Nabble? I'm not completely sure which margin you are talking about. 1.

Re: [libreoffice-users] pasting numbers into Calc

2013-04-10 Thread Steve Edmonds
On 2013-04-11 11:36, Herbert Fruchtl wrote: This question seems to have been discussed before, but none of the replies I understand work for me. Here it goes: If I copy a column-based piece of text, containing numbers in some columns, into LibreOffie Calc and apply the (hopefully) correct

Re: [libreoffice-users] Adding values to CSV File via Terminal

2013-04-10 Thread Steve Edmonds
Hi. First thoughts I would do that with a bash or perl script. Steve On 2013-04-11 12:47, Joel Madero wrote: Hi All, I have files that have a ton of info and what I want to do is add a new column that's date pulled that is based on the file name (which is of course the date). So for instance

Re: [libreoffice-users] Re: Adding values to CSV File via Terminal

2013-04-11 Thread Steve Edmonds
On 2013-04-11 18:17, Alex Thurgood wrote: Le 11/04/2013 02:47, Joel Madero a écrit : Hi Joel, A quick trawl reveals several possibilities : http://stackoverflow.com/questions/4749658/inserting-filename-into-last-column-of-csv-file

Re: [libreoffice-users] Calendar software

2013-04-12 Thread Steve Edmonds
I too use Thunderbird and Lightning, Lightning syncs with my gmail calendar which syncs with my phone. So very useful and handles multiple calendars (mine, works, the families). On my Mac I use Thunderbird and the standard Mac calendar program synced with my gmail calendars. And yes, I

Re: [libreoffice-users] Re: Calendar software

2013-04-12 Thread Steve Edmonds
, but don't anymore. I came to the conclusion the average user shouldn't need to do this. On 4/12/13 1:36 PM, Steve Edmonds wrote: I too use Thunderbird and Lightning, Lightning syncs with my gmail calendar which syncs with my phone. So very useful and handles multiple calendars (mine, works

Re: [libreoffice-users] Preparing labels from a mailing list

2013-04-14 Thread Steve Edmonds
On 2013-04-15 09:31, Tony Arnold wrote: On 14/04/13 22:26, Muriel Parker wrote: I have been unable to prepare labels from my mailing list (database). I want to prepare sheets with a different address on each label. I am able to set up for the Avery labels I use. I get a message LO requires

Re: [libreoffice-users] Problem with inserting text using the apostrophe

2013-04-15 Thread Steve Edmonds
Hi. This came up last year, http://listarchives.libreoffice.org/global/users/msg23591.html Strange thing is that it works with numbers ('123). Can't figure out the CTL-Z thing though. steve On 2013-04-16 04:29, Kieran Peckett wrote: I also have this problem - I have reported the bug here:

Re: [libreoffice-users] OT : good cd import software on linux

2013-04-16 Thread Steve Edmonds
On 2013-04-17 00:52, Kracked_P_P---webmaster wrote: On 04/16/2013 03:25 AM, Dries Feys wrote: Hi all, This is way of topic, but as there are many linux adepts over here, I wonder what software you use to rip cd's to mp3. (or ogg vorbis, but I prefer mp3 as that's supported on more

Re: [libreoffice-users] OT : good cd import software on linux

2013-04-16 Thread Steve Edmonds
On 2013-04-17 09:05, Joep L. Blom wrote: On 16/04/13 14:52, Kracked_P_P---webmaster wrote: On 04/16/2013 03:25 AM, Dries Feys wrote: Hi all, This is way of topic, but as there are many linux adepts over here, I wonder what software you use to rip cd's to mp3. (or ogg vorbis, but I prefer

Re: [libreoffice-users] OT : good cd import software on linux

2013-04-16 Thread Steve Edmonds
On 2013-04-17 09:32, Gabriel Risterucci wrote: ogg is not lossless, but flac is. Anyway, if your starting quality is a CD, no matter what you use if you go over 320kbps you'll get almost lossless with any codec. Having been lost for an hour on research on how I am encoding, it seem there may

Re: [libreoffice-users] Libreoffice Calc cell copy very slow

2013-04-18 Thread Steve Edmonds
Hi. Near instantaneous (no noticeable lag) on my 3.6 on opensuse. Is this occurring with cells with text and cells with formulae. Does this happen with a sheet with only one cell with content (i.e. worse with larger sheets). steve On 2013-04-19 03:11, D. Baillard wrote: Selecting part of the

Re: [libreoffice-users] Libreoffice Calc cell copy very slow

2013-04-18 Thread Steve Edmonds
*De: *Steve Edmonds steve.edmo...@ptglobal.com *À: *D. Baillard b.doui...@free.fr *Cc: *users@global.libreoffice.org *Envoyé: *Jeudi 18 Avril 2013 19:51:40 *Objet: *Re: [libreoffice-users] Libreoffice Calc cell copy very slow Hi

Re: [libreoffice-users] How to permanently get rid of Full Screen toolbar in Writer when in Full Screen mode?

2013-04-21 Thread Steve Edmonds
On 2013-04-22 14:42, david wrote: On 04/21/2013 02:36 AM, M Henri Day wrote: 2013/4/21 david gn...@hawaii.rr.com mailto:gn...@hawaii.rr.com I'm using LibreOffice 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe198__9deee49c3) on Debian Sid Linux. The Full Screen toolbar won't

[libreoffice-users] CSV saving

2013-04-22 Thread Steve Edmonds
Hi. I work on a lot of CSV files with LO. With LO saving as a CSV type pads all lines to the same number of fields with the delimiter, i.e. 1,2,3,4,5,6,7,8 a,,, I then have to edit this and remove the superfluous delimiters. Alternatively I can use Calligra which saves CSV as

Re: [libreoffice-users] How to downgrade from 4.0.2. to 3.6.6

2013-04-23 Thread Steve Edmonds
Hi. I have had this with EPS drawings (with/without preview) for a long time. For those to not cause a problem I turn off OptionsLoad/SaveGeneralSave auto recovery information. Just a suggestion, you could give it a try. Steve On 2013-04-23 22:21, William Drago wrote: Well, I may wait for

Re: [libreoffice-users] Create a list of ascending numbers with repeats

2013-04-23 Thread Steve Edmonds
LO seems to extend the series with 5 x 1s, 5 x 2s and then 10 x 3s, 10 x 4s, etc. Possibly a bug and should be 5 x 3s, 5 x 4s, etc. I have found a couple of other cases where the series does not extend well. 123 was very good at extending series. I found Calligra gets it right. Steve On

Re: [libreoffice-users] Re: Am I the only one with Err 522 problems?

2013-04-24 Thread Steve Edmonds
Hi. On 2013-04-25 04:51, Johnny Rosenberg wrote: 2013/4/24 Alex Thurgood alex.thurg...@gmail.com: Le 02/04/2013 19:48, Johnny Rosenberg a écrit : Hi Johnny, Just a few thoughts in an attempt to narrow down the problem : - which version of OpenOffice.org did you originally use to create the

Re: [libreoffice-users] How to downgrade from 4.0.2. to 3.6.6

2013-04-24 Thread Steve Edmonds
On 2013-04-25 08:09, M Henri Day wrote: 2013/4/23 Steve Edmonds steve.edmo...@ptglobal.com mailto:steve.edmo...@ptglobal.com Hi. I have had this with EPS drawings (with/without preview) for a long time. For those to not cause a problem I turn off OptionsLoad/SaveGeneralSave

Re: [libreoffice-users] When does one cell equal another?

2013-04-25 Thread Steve Edmonds
On 2013-04-26 06:25, david_lynch wrote: On 25/04/2013 17:58, T. R. Valentine wrote: On 24 April 2013 11:47, david_lynchdavid_ly...@blueyonder.co.uk wrote: I use Libreoffice to process files over which I have no control. These are text files but sometimes contain unusual codes. LO

Re: [libreoffice-users] Paragraph styles

2013-04-29 Thread Steve Edmonds
Where styles will really shine is to give the students a project of doing a complex document with and without styles and then ask them to change certain aspects to attain some consistent characteristic. Change all headings to XXX, indentation and font on all paragraphs to yyy, outline

Re: [libreoffice-users] New bug 64028: Calc forgets cell format when cell is cut (^X)

2013-04-29 Thread Steve Edmonds
I can confirm that CTL+X removes the character and number formatting in LO 3.6 on opensuse. Steve On 2013-04-30 12:19, MR ZenWiz wrote: I'm running Xubuntu 12.04, LO 4.0.2.2. The pasted cell has the right format, but when I entered a 0 (zero) in the old cell (that was cut), it shows as 0, not

Re: [libreoffice-users] Paragraph styles

2013-04-30 Thread Steve Edmonds
On 2013-05-01 08:53, Virgil Arrington wrote: Dave asked, Are you implying that if I want to, say, indent one paragraph with no other changes, I should create a new style for that? Seems like a lot of work since it can be done with one mouse clicks (or, if I ever get around to learning how

Re: [libreoffice-users] XY Chart in Writer

2013-04-30 Thread Steve Edmonds
Hi. Insert as you have done as object. Add a series and the x column will be present. The chart is created with some demo data, delete these series. Steve On 2013-05-01 01:38, Rheinländer wrote: Hi, is it possible to create a true XY Chart in Writer? If I do Insert - Object - Chart and then

Re: [libreoffice-users] Re: colour printing bug in Writer?

2013-05-05 Thread Steve Edmonds
On 2013-05-06 10:15, Kracked_P_P---webmaster wrote: On 05/05/2013 04:00 PM, Steve Edmonds wrote: On 2013-05-05 22:29, Marc Paré wrote: Hi Raymond, Le 28/04/13 11:02 AM, L O a écrit : Hi I have made a writer document with two colour pictures in it and a bit of text. When I print

Re: [libreoffice-users] spreadsheet cell date format behaviour failure

2013-05-08 Thread Steve Edmonds
Doesn't happen on my Opensuse LO 3.6 Steve On 2013-05-08 18:35, e-letter wrote: Readers, Please review bug 36175 and confirm (or not) if the behaviour reported is also observed personally; thanks: https://bugs.freedesktop.org/show_bug.cgi?id=36175#c8 -- To unsubscribe e-mail to:

Re: [libreoffice-users] Testing again

2013-05-08 Thread Steve Edmonds
And don't be surprised if you don't see your own posts. Google host our mail domain and for some reason I don't see my own posts unless they are replied to by someone else. They are visible to me in Nabble thou'. Steve On 2013-05-09 05:28, Tom Davies wrote: Hi :) First time it got through

Re: [libreoffice-users] Printer settings

2013-05-10 Thread Steve Edmonds
Hi. I am on Opensuse. I get 2 different print dialogues depending on the application. I have to make sure the settings are consistent on both. One the printer tray setting is under another separate tag somewhere I always have to go looking. If you look in Firefox print dialogue options there

Re: [libreoffice-users] Re: colour printing bug in Writer?

2013-05-11 Thread Steve Edmonds
On 2013-05-12 07:18, Marc Paré wrote: Le 05/05/13 07:04 PM, Steve Edmonds a écrit : Do you see controls for Landscape? What does it do if you choose it It is some dicky issue with the Brother driver and LO on Linux. I have seen some discussion and it is just as easy to print to PDF

Re: [libreoffice-users] Re: Paste of Dates Incorrect in Calc

2013-05-12 Thread Steve Edmonds
Hi. Take a look at https://help.libreoffice.org/3.6/Calc/Date_and_Time_Functions To me the difference you are getting looks close to the difference between the date bases for day zero. Steve On 2013-05-13 08:45, Oogie McGuire wrote: OK following up on the suggestions. First the user profile

Re: [libreoffice-users] Re: colour printing bug in Writer?

2013-05-13 Thread Steve Edmonds
On 2013-05-13 17:09, Marc Paré wrote: Le 11/05/13 04:17 PM, Steve Edmonds a écrit : On 2013-05-12 07:18, Marc Paré wrote: Le 05/05/13 07:04 PM, Steve Edmonds a écrit : Do you see controls for Landscape? What does it do if you choose it It is some dicky issue with the Brother driver and LO

Re: [libreoffice-users] Re: colour printing bug in Writer?

2013-05-13 Thread Steve Edmonds
On 2013-05-14 13:15, Girvin R. Herr wrote: Steve Edmonds wrote: On 2013-05-13 17:09, Marc Paré wrote: Le 11/05/13 04:17 PM, Steve Edmonds a écrit : On 2013-05-12 07:18, Marc Paré wrote: Le 05/05/13 07:04 PM, Steve Edmonds a écrit : Do you see controls for Landscape? What does it do

Re: [libreoffice-users] Find and Replace Formatting?

2013-05-14 Thread Steve Edmonds
On 2013-05-14 21:39, Anthony Easthope wrote: Hey I have a document that needs to be formatted to be correctly wrapped - What I was wanting to do was remove the hard breaks at the end of every line. Is there an easy way to do this? The symbol looks like a backwards P (Standard non-printing

Re: [libreoffice-users] Find and Replace Formatting?

2013-05-14 Thread Steve Edmonds
http://nabble.documentfoundation.org/deleting-hard-returns-tp3541244p3541556.html On 2013-05-14 21:39, Anthony Easthope wrote: Hey I have a document that needs to be formatted to be correctly wrapped - What I was wanting to do was remove the hard breaks at the end of every line. Is there an

Re: [libreoffice-users] title1 style used for selected words, not paragraph

2013-05-14 Thread Steve Edmonds
On 2013-05-15 04:14, Mirosław Zalewski wrote: On 14/05/2013 at 10:32, 胡小柯 hot123tea...@gmail.com wrote: If I simply apply title1 style, then the paragraph is seen in the table of contents, which is not what I want. I could not just select Abstract, and apply the title1 style too. It doesn't

Re: [libreoffice-users] Uninstall LibreOffice 4.0.2

2013-05-16 Thread Steve Edmonds
Hi. If you open a terminal/konsole/command prompt and type libreoffice --writer and press return, does libreoffice start. If it does you may just have to add some start items to your menu. Steve On 2013-05-17 10:29, CVAlkan wrote: Hi: I uninstalled my 3.6 LibreOffice a few weeks ago when I

Re: [libreoffice-users] Re: file recovery

2013-05-16 Thread Steve Edmonds
Hi. Does it look like the file has become much smaller. You could try copying the file and changing the extension on the copy to .zip. Unzip the file and then see if you can find your bulk of text, may be in content.xml. If it seems to be there then that could be your last resort to use that

[libreoffice-users] VLOOKUP adapting to changes

2013-05-21 Thread Steve Edmonds
Hi. I have been using VLOOKUP recently and notice that if I insert a column in the lookup range that the insertion is not reflected in VLOOKUP parameters. Should it in the same way that SUM does. i.e. just by example I have a range A1:B25 and use =VLOOKUP(A30,A1:B25,2,0) to return the price

Re: [libreoffice-users] Replying to users

2013-05-21 Thread Steve Edmonds
Some of us have no option other than to reply-all because of the way our mailer works with this list. steve On 2013-05-22 09:15, James Knott wrote: Kieran Peckett wrote: Just a quick question - when on this list (users), shouldn't we keep the sender's email in the To / Cc list when we

[libreoffice-users] Bug with data validating

2013-05-21 Thread Steve Edmonds
Hi. I have found a bug in LO3.6 with data validating. If someone would be kind enough to check if it is resolved in LO4 before I file a bug report and a feature request. Bug To replicate create some data to be the validate list such as A1 = cat A2 = dog A3 = cat2 Now in a cell (A5) enter

Re: [libreoffice-users] Missing text styles in Writer

2013-05-22 Thread Steve Edmonds
On 2013-05-23 07:03, warnerwhite wrote: I am running LO 4 in Ubuntu 13.04. I have used LO and OOO for years, but suddenly my text styles have disappeared. RTF files that contain Text Body lines, for example, just show a blank. The only text that appears are Headings. I tried AbiWord and the

[libreoffice-users] Named range behaviour

2013-05-22 Thread Steve Edmonds
Hi. A have a spreadsheet with lots of sheets (dare we call it a workbook or is it a calcbook). I created a whole lot of named ranges on a sheet named steelcosts i.e. $steelcosts.$A$162:$C$177. I then reorganised my sheet order and the named ranges changed and now point to the wrong sheets. The

Re: [libreoffice-users] Re/.: Unable to Install LO 4.0.3.3.

2013-05-26 Thread Steve Edmonds
Hi. Try CTL-ALT-DEL and then from memory task manager. See if you can see any Libreoffice applications or processes running. From there you can terminate them. You could also try un-installing 3.3 and then installing 4.0 Steve On 2013-05-27 10:13, Muriel Parker wrote: There is no icon for

Re: [libreoffice-users] open slowly

2013-05-27 Thread Steve Edmonds
Hi. It opens in 14 seconds in my openSUSE 12.2/LO3.6. I have an Intel(R) Core(TM) i5-2500T CPU @ 2.30GHz, 8 GB ram. steve On 2013-05-28 10:35, Tim Lloyd wrote: In addition to my last email I'll highlight that I have LO open all the time. So any delay in opening a file is just that, it is not

Re: [libreoffice-users] LO Base/MySQL Backup??

2013-05-28 Thread Steve Edmonds
Hi Girvin. For security I created a mysql user 'backup' with read only access for backup. I make the cron script readable by root only -rwxr-x--- 1 root root 586 2012-12-05 16:19 /etc/cron.backup/dailytmp.bu MYSQL_PWD=*** mysqldump -ubackup --all-databases --add-drop-database | gzip -9

Re: [libreoffice-users] To the moderators

2013-05-29 Thread Steve Edmonds
Hi. This shows in my inbox at 23:53 my local time. I see you have a gmail account. When I post a message starting a thread with an account hosted by gmail I don't see the message in the my box. I don't see the message until someone replies to it and from that point it is seen. I think this is

Re: [libreoffice-users] Default Superscript and Subscript size

2013-05-30 Thread Steve Edmonds
Hi. To have the settings (changes) you make stay for a new document you may need to make these changes to the default style and then save the document as a template and make it your default. This is the first thing I do as I do not like the default font and margins. Steve On 2013-05-31

Re: [libreoffice-users] What happened to autoformat option?

2013-05-30 Thread Steve Edmonds
Hi. What about FormatAutocorrectAutocorrect optionsOptions. Untick capitalise first letter... On 31/05/13 1:21 PM, Girvin R. Herr wrote: Greetings, I upgraded to LO 3.6.6.2 and just installed it on my HP laptop. However, Calc keeps changing the 1st character of a filename in a text cell to

Re: [libreoffice-users] Default Superscript and Subscript size

2013-05-31 Thread Steve Edmonds
% just looks ridiculous :-\ Tim On 30/05/13 23:18, Steve Edmonds wrote: Hi. To have the settings (changes) you make stay for a new document you may need to make these changes to the default style and then save the document as a template and make it your default. This is the first thing I do as I

Re: [libreoffice-users] Some issues about Writer

2013-06-02 Thread Steve Edmonds
On 2013-06-03 04:58, NickKolok wrote: Greetings from Russia, comrads! I've installed Fedora and LibreOffice onto my girlfriend's computer. She started to use them some months ago and now we have some questions to you, dear developers. 1) There was a moment when LibreOffice alerted message

Re: [libreoffice-users] Calc issue w/display of file w/multiple sheets

2013-06-03 Thread Steve Edmonds
On 2013-06-04 07:29, Oogie McGuire wrote: I'm having a problem with Calc in a file that has multiple sheets. Sometimes when I open the file the various sheets are shown as tabs along the bottom as I'd expect. However after working in the spreadsheet for a while and sometimes when I open the

Re: [libreoffice-users] Importing a postscript file with proper formatting

2013-06-03 Thread Steve Edmonds
On 2013-06-04 09:54, MR ZenWiz wrote: Is there any way to do this into Writer? I have a number of files I originally created with FrameMaker (back when I still used Windows), and I could never get it to create the proper PDF output files, but I was able to create PS files from them. Now I'd

Re: [libreoffice-users] Importing a postscript file with proper formatting

2013-06-04 Thread Steve Edmonds
:) From: Steve Edmonds steve.edmo...@ptglobal.com To: MR ZenWiz mrzen...@gmail.com Cc: LibreOffice users@global.libreoffice.org Sent: Tuesday, 4 June 2013, 3:53 Subject: Re: [libreoffice-users] Importing a postscript file with proper formatting On 2013-06-04 09:54, MR ZenWiz wrote

Re: [libreoffice-users] CNET is claiming the best free MSO alternative is not LO

2013-06-08 Thread Steve Edmonds
On 2013-06-08 12:10, Virgil Arrington wrote: This has been fascinating reading all of the opinions about user interfaces and the dreaded ribbon. I've not found *anyone* who actually likes the ribbon. I agree with several of you who have observed that the ribbon makes using styles much harder.

Re: [libreoffice-users] Re: CNET is claiming the best free MSO alternative is not LO

2013-06-08 Thread Steve Edmonds
On 2013-06-08 10:10, Ken Springer wrote: On 6/7/13 3:41 AM, Tom Davies wrote: snip I too wouldn't touch Kingsoft with a barge pole. I want to steer towards using formats that will be around and usable in a few years time. I want to be able to open documents maybe 10-20 years from now

Re: [libreoffice-users] drag drop

2013-06-11 Thread Steve Edmonds
On 2013-06-12 02:22, Loren wrote: Hi I just got a new dell computer and need office type program, looking into this libreoffice my question I have my files saved to external harddrive is this the program that will allow me pull files off of th eexternal hardrive (Word, Spreadsheet, etc) or

Re: [libreoffice-users] Recent Documents List

2013-06-11 Thread Steve Edmonds
On 2013-06-12 10:15, Dan Lewis wrote: On 06/11/2013 11:53 AM, Mirosław Zalewski wrote: On 11/06/2013 at 16:09, Tom Davies tomdavie...@yahoo.co.uk wrote: Does anyone remember how to fix the list of recent documents to be longer than 10? I don't know how to fix list of recent documents, but

Re: [libreoffice-users] Recent Documents List

2013-06-11 Thread Steve Edmonds
On 2013-06-12 13:33, Dr. R. O Stapf wrote: On 12.06.2013 07:22, Steve Edmonds wrote: On 2013-06-12 10:15, Dan Lewis wrote: On 06/11/2013 11:53 AM, Mirosław Zalewski wrote: On 11/06/2013 at 16:09, Tom Davies tomdavie...@yahoo.co.uk wrote: Does anyone remember how to fix the list of recent

[libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-12 Thread Steve Edmonds
Hi. I want to enter {=MMULT(MINVERSE(A14:R31),S14:S31)} in a cell and to display this as the text {=MMULT(MINVERSE(A14:R31),S14:S31)} (without the quotes). Formatting the cell as text doesn't help. I thought once you could prepend with a ' to define the characters following as left aligned

Re: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-12 Thread Steve Edmonds
),S14:S31)} into an empty cell on a empty book. It is displaying as text, not calculating a formula.What am I d oing wrong? Четверг, 13 июня 2013, 9:44 +12:00 от Steve Edmonds steve.edmo...@ptglobal.com: Hi. I want to enter {=MMULT(MINVERSE(A14:R31),S14:S31)} in a cell and to display

Re: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-12 Thread Steve Edmonds
was editing it. Maybe if I knew something about the kind of math represented by these functions, I'd have a better clue. But I know nothing about that level of math. -- Tim === On 6/12/2013 6:07 PM, Steve Edmonds wrote: Thanks for the reply, please click into the cell

  1   2   3   4   5   6   7   8   9   10   >