Re: [libreoffice-users] Re: libreoffice 4.4.0.2 on opensuse 13.2 tumbleweed, kde 4.14.4

2015-01-28 Thread ianseeks
On Wednesday 28 Jan 2015 13:56:54 Graham P Davis wrote: > On Wed, 28 Jan 2015 09:33:36 + > > ianseeks wrote: > > Cheers. LO is my favoured office tool so i doubt it'll upset me too > > much. I can't be sure it was LO causing the issue. I've had issues > > with copy and paste from other thing

Re: [libreoffice-users] New to Libre Office

2015-01-28 Thread Brian Barker
At 18:55 28/01/2015 +, Mary Sandlin wrote: Just got LibreOffice and have a problem. Have been using excel for many years and now using calc. My problem is keeping the formula from printing a zero in my spreadsheet. I use this for my invoices and when a line with a formula is not used (no en

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Tom Davies
Hi :) I'm not sure why you are having a problem downloading LibreOffice, nor why you are apparently only getting a small chunk of it, nor why you haven't been this unlucky before. There are too many factors to explore. Have you tried rebooting the router? Are you using a wireless connection or i

Re: [libreoffice-users] Re: [libreoffice-website] New to Libre Office

2015-01-28 Thread Tim Lloyd
Hi Mary, welcome to LO! try this: * right click on the cell(s) in question * Choose "format cells" * when the options appear you want to be in the "Numbers" tab * set "Leading zeroes" to 0 I think this is what you are after. BTW, pls respond to users@global.libreoffice.org to reach the la

Re: [libreoffice-users] Merging columns, not cells

2015-01-28 Thread Brian Barker
At 18:01 28/01/2015 -0800, Mark Howe wrote: Can you give me an example of a concatenation formula for a column of text merged with a column of numbers? The resulting column would have the text and number in one cell. You can concatenate values using the CONCATENATE() function or - more easily

Re: [libreoffice-users] Sumproduct with a AND

2015-01-28 Thread Brian Barker
At 12:57 28/01/2015 -0600, Wade Smart wrote: What I'm looking to do is, if O column has an "x", count how a range of numbers. AW column has numbers that fall in the 20's, 30's, 40's etc. I want to do something like less than 40 greater than 30. I tried AND but that caused an error. =SUMPRODU

Re: [libreoffice-users] Merging columns, not cells

2015-01-28 Thread Mark Howe
Brian and Rob; Can you give me an example of a concatenation formula for a column of text merged with a column of numbers? The resulting column would have the text and number in one cell. -Original Message- From: Brian Barker Sent: Wednesday, January 28, 2015 9:07 AM To: users@global.

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread jonathon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/01/15 15:49, Philip Jordan wrote: > I'm using an almost new Toshiba Laptop with Windows 8.1 What edition of Windows 8.1 are you using? What localization of Windows 8.1 are you using? jonathon -BEGIN PGP SIGNATURE- Version: GnuPG v1 Com

[libreoffice-users] Re: [libreoffice-website] New to Libre Office

2015-01-28 Thread Cico
Dear Mary Sandlin, I'm forwarding your mail to users@global.libreoffice.org The list webs...@global.libreoffice.org is for the libreoffice website maintenance only, not for user support. Refer to this page for more: http://www.libreoffice.org/get-help/mailing-lists/ Please be aware that if yo

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Tom Davies
Hi :) It is kinda overkill to install Ubuntu purely for this issue. On the other hand it would free you from the sorts of problems you seem to dislike about Windows generally. You don't need to constantly keep buying new things so often and new computers every couple of years just in order to kee

Re: [libreoffice-users] Merging columns, not cells

2015-01-28 Thread Tom Davies
Hi :) It might be possible by saving as a .csv file (possibly losing all the formulas and certainly all the formatting) and then use a text-editor to remove some of the commas. It's not much more elegant and would probably take even longer and maybe even make quite a mess - but it might be an opti

[libreoffice-users] Sumproduct with a AND

2015-01-28 Thread Wade Smart
What Im looking to do is, if O column has an "x", count how a range of numbers. AW column has numbers that fall in the 20's, 30's, 40's etc. I want to do something like less than 40 greater than 30. I tried AND but that caused an error. =SUMPRODUCT(O2:O168="x", $AW$2:$AW$168 <30) -- Registered

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
Thanks Gordon & Tom I'm afraid that the 40 minutes suggested is rather more than a tad optmistic e.g. Items 1-5 inc will each take me some considerable time i.e. they all involve me far beyond my comfort zone! But thanks for trying to help ATB Philip Jordan On 28 January 2015 at 17:33, Gor

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Charles-H. Schulz
There is some major work going on on this. We have a viewer in beta version. But we aim this year to get an editor and viewer version released. Right now we need to develop and improve our base system first. Best, Charles. On 28 janvier 2015 18:35:40 CET, Gordon Burgess-Parker wrote: >On

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Gordon Burgess-Parker
On 28/01/15 17:27, Tom Davies wrote: Of course MS are unlikely to be happy about people finding out that the alternatives are not only better but are also often free so they apparently put a lot of work into trying to prevent people from staying outside their eco-system. So how soon will the A

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Gordon Burgess-Parker
On 28/01/15 17:06, Philip Jordan wrote: & how long to do what where when etc please ref Ubuntu.? here's the definitive guide: http://ubuntuguide.org/wiki/Ubuntu:All#Dual-Booting_Windows_and_Ubuntu There's a lot of information on that page. In Brief: 1. Ensure you have a Windows Recovery

Re: [libreoffice-users] Merging columns, not cells

2015-01-28 Thread Brian Barker
At 06:44 28/01/2015 -0800, Mark Howe wrote: I can't find help for merging columns or ranges. Is it possible? Merging cells is so easy, but I hate to have to do it a million times. I don't think so. You can merge two cells into one. Or a range of cells into one - so a column or columns into a s

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
& how long to do what where when etc please ref Ubuntu.? I mean I know I'm retired but my use for IT is as support ref life i.e. not taking over what remains of my life!! All the best & thanks On 28 January 2015 at 16:53, Gordon Burgess-Parker wrote: > > On 28/0

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Gordon Burgess-Parker
On 28/01/15 16:51, Philip Jordan wrote: - but as to W 8.1: I'm bereft of suitable words! then do what I did - dual-boot Ubuntu :-) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Postin

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
Brilliant - well your reply is Gordon - but as to W 8.1: I'm bereft of suitable words! On 28 January 2015 at 16:40, Gordon Burgess-Parker wrote: > On 28/01/15 15:43, Philip Jordan wrote: > >> Thanks >> >> & though I'll do what you say, it must be emphasized that as far as I can >> tell >> >> m

[libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Werner
On 1/28/2015 17:30, Charles-H. Schulz wrote: The installation file would be the file you downloaded, the one that changed from .msi to .man. True enough I should not need to tell you all these details about compatibility and so on and so forth, but it seems that either Windows 8.1 or some settin

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Gordon Burgess-Parker
On 28/01/15 15:43, Philip Jordan wrote: Thanks & though I'll do what you say, it must be emphasized that as far as I can tell more than once, I downloaded from the site you show on Sunday & I did this as the link from Computer active didn't work & too, I only went to Microsoft for an Icon as my

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Charles-H. Schulz
The installation file would be the file you downloaded, the one that changed from .msi to .man. True enough I should not need to tell you all these details about compatibility and so on and so forth, but it seems that either Windows 8.1 or some setting peculiar to some systems create a very ba

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
Thanks Charles FWIW it's at least good to know it's not just me & too, I'd like to tell ComputerActive about this as not only did their current edition feature a good i.e. favourable LO review BUT TOO they're currently running stuff on how to use Windows 8.1 - given all the trouble But too, thou

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Charles-H. Schulz
Dear Philip, Sorry for the question on your laptop; it does explain why there is such as thing as an "App Store". It also seems to explain what you're going through. On our other community support venue, somebody else reported exactly the same problem one month ago: http://ask.libreoffice.org

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
Dear Charles I'm sure I've covered this before, but: I'm using an almost new Toshiba Laptop with Windows 8.1 & though I followed Stuarts instruction/link in downloading the file with the msi end it said man on the Laptop after this was done - or does that mean I failed to replace the existing m

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
Thanks & though I'll do what you say, it must be emphasized that as far as I can tell more than once, I downloaded from the site you show on Sunday & I did this as the link from Computer active didn't work & too, I only went to Microsoft for an Icon as my laptop refused to install the software by

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Charles-H. Schulz
Dear Philip, Forgive me to answer before Stuart but do you mean to say that you followed the link and ended up with downloading a file with a .man extension at its end? I have just tried your link and got a file with a .msi ,which is a very common form of Windows Installer. By the way, what

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
Thanks V Stuart I've followed your instruction & to be very specific it meant I downloaded from this link http://mirror.catn.com/pub/tdf/libreoffice/stable/4.3.5/win/x86/LibreOffice_4.3.5_Win_x86.msi (gb, prio 100) So far so good - & incidentally an exact replica of file resulted/replacing like

Re: [libreoffice-users] Merging columns, not cells

2015-01-28 Thread Rob Jasper
Mark, With merging I assume you mean concatenating the strings into one column... I generally put a concatenate formula in a separate column, then select cut that complete column and special past values to the desired column. Rob. Op 28 jan. 2015, om 15:44 heeft Mark Howe het volgende geschre

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Charles-H. Schulz
Dear Philip, For some reason this thread of discussion does not seem to help and I must confess that it is not clear to me what problem you're doing through aside that you're struggling at the download/installation phase. Would you mind following the steps below and tell us the outcome? As a

[libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread V Stuart Foote
@Phillip, We can try to make this easier for you since you seem to be having issues. The LibreOffice project uses as system of download mirrors to deliver the released official versions of the program. On Windows that will be as Microsoft Installer package--.msi There is a way to directly acce

[libreoffice-users] Merging columns, not cells

2015-01-28 Thread Mark Howe
I can’t find help for merging columns or ranges. Is it possible? Merging cells is so easy, but I hate to have to do it a million times. Mark W. Howe San Juan Capistrano, CA 949-496-3453 home/ office 949-525-3914 cell [not for messages] "Phao Binh" http://swcenter.fortlewis.edu/finding_aids/i

Re: [libreoffice-users] syntax hilighter for writer

2015-01-28 Thread Tim---Kracked_P_P---webmaster
Does anyone know if Coooder works with 4.x.x? That is what this person might need, but it has not been updated the end of the 3.x.x line[s]. http://extensions.libreoffice.org/extension-center/coooder On 01/28/2015 07:53 AM, Andrew Douglas Pitonyak wrote: what do you want to syntax highlight?

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
Thanks, but I'm not sure that exactly solves my problem! Nor for that matter does it exonerate LibreOffice e.g. why can't they save everyones time by saying at the outset that their software only downloads via certain browsers &/or how come I never had such problems with any other downloads?!

[libreoffice-users] Re: libreoffice 4.4.0.2 on opensuse 13.2 tumbleweed, kde 4.14.4

2015-01-28 Thread Graham P Davis
On Wed, 28 Jan 2015 09:33:36 + ianseeks wrote: > Cheers. LO is my favoured office tool so i doubt it'll upset me too > much. I can't be sure it was LO causing the issue. I've had issues > with copy and paste from other things like Firefox where it won;t > paste anything i copied from Firefox

Re: [libreoffice-users] Conditional inserted images in Calc

2015-01-28 Thread Tom Davies
Hi :) I think other people have had a lot of trouble with this sort of thing. I think trying to contain an image into a specific cell is difficult and i am not sure if it can even be done at all. It might be that you need to use Base or html pages to do something like this. Regards from Tom :)

[libreoffice-users] Re: [MariaDB Announce] MariaDB 10.0.16 now available

2015-01-28 Thread Tom Davies
Hi :) I know a few people here use MariaDb or are in the process of migrating away from MySql to the more ethical MariaDb. So hopefully this post from the MariaDb announcement mailing list might be of some interest to some people here. I noticed we had someone trying to use a back-end that was be

Re: [libreoffice-users] Conditional inserted images in Calc

2015-01-28 Thread Kolbjørn Stuestøl
Den 28.01.2015 13:14, Tom Davies skreiv: Hi :) I think other people have had a lot of trouble with this sort of thing. I think trying to contain an image into a specific cell is difficult and i am not sure if it can even be done at all. It might be that you need to use Base or html pages to do

Re: [libreoffice-users] syntax hilighter for writer

2015-01-28 Thread Andrew Douglas Pitonyak
what do you want to syntax highlight? On 01/28/2015 01:39 AM, m_pahlevanzadeh wrote: Dear All, I have been searhed for syntax highliter, But i found a set of under milestone 4.x , Do you know compatiable with milestone 4.x? --Regrads Mohsen -- View this message in context: http://nabble.do

Re: [libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Tom Davies
Hi :) Ahah. I think we are stumbling into finding out what is going wrong at last! :) Many people have more than 1 web-browser and i think that is really the best way forwards. There are arguments about which is the best so having more than one means you get the best of at least 2 worlds. I ten

Re: [libreoffice-users] Re: libreoffice 4.4.0.2 on opensuse 13.2 tumbleweed, kde 4.14.4

2015-01-28 Thread ianseeks
On Tuesday 27 Jan 2015 16:03:56 Tom Davies wrote: > Hi :) > If it starts happening a lot, or if you just feel like it, then it > might be worth reinstalling one of the 4.3.x. That 3rd digit is a bit > like a "Service Pack" on MS products. Generally the higher that > number the less unexpected pro

Re: [Bulk] Re: [libreoffice-users] libreoffice 4.4.0.2 on opensuse 13.2 tumbleweed, kde 4.14.4

2015-01-28 Thread ianseeks
On Tuesday 27 Jan 2015 19:41:50 Mark Bourne wrote: > ianseeks wrote: > > On Monday 26 Jan 2015 19:18:24 Tim Lloyd wrote: > >> Hi Ian, > >> > >> I am assuming this is an existing document. Not new? Any document in > >> particular or any? > > > > An exisitng ODT, nothing complicated in the file, ju

[libreoffice-users] Re: Message as sent yesterday

2015-01-28 Thread Philip Jordan
Thanks all for help so far & PLEASE SEE REPLIES BELOW IN CAPS On 27 January 2015 at 20:31, anne-ology wrote On the assumption you are really attempting to seek help NOT SURE I UNDERSTAND? I shall respond in the hope that you will THANKS! > (1) start to enjoy using LO WOULD THAT I COU