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

2014-01-06 Thread James E Lang
This has been a most enlightening discussion. I am a big fan of open source software. That said, this discussion has shined a bright light on one of the most problematic areas of the concept. I might be totally off base here but as I view it, without a central management structure to _enforce_

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

2014-01-06 Thread Peter West
Peter West Where is he who has been born king of the Jews? On 6 Jan 2014, at 6:11 pm, James E Lang jim+...@lang.hm wrote: This has been a most enlightening discussion. I am a big fan of open source software. That said, this discussion has shined a bright light on one of the most

[libreoffice-users] problem with table header colors in ms word

2014-01-06 Thread Dries Feys
Hi, We just accountered a problem where colored tables in a .doc file aren't shown correctly in LO, though they are shown correctly in ms word. I filed a bug, but it would be nice if some of you could confirm the existence. https://www.libreoffice.org/bugzilla/show_bug.cgi?id=73319 Met

Re: [libreoffice-users] problem with table header colors in ms word

2014-01-06 Thread Fernand Vanrie
Dries , Same behavior here , but the troubles are coming from the way the doc is build. Kill the picture with the company logo's and the tables are colored. greetz Fernand We just accountered a problem where colored tables in a .doc file aren't shown correctly in LO, though they are

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/05/14 16:53, mariosv wrote: Please take a look to documentation: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Chapter 10 Linking Calc Data Linking to registered data

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/06/14 07:50, Larry Evans wrote: On 01/05/14 16:53, mariosv wrote: Please take a look to documentation: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Chapter 10 Linking Calc Data Linking to registered data

[libreoffice-users] Re: problem with table header colors in ms word

2014-01-06 Thread Tom
Hi :) I just had a quick go with this. It seems as though having a jpg image as the Watermark was the problem. Even when i did; Arranged to back Wrap through In background The jpg still seemed to remove the colours of the table headings. I used Gimp (badly) to convert to a Png, gave it an

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

2014-01-06 Thread Tom Davies
Hi :) You guys are over-complicating it. Just post a feature request via the bug-reporting system Similar problems occur in proprietary systems too but with less chance of reporting the problem. Also the bosses need to understand the problem and give it more attention than their golf handicap

Re: [libreoffice-users] Re: problem with table header colors in ms word

2014-01-06 Thread Tom Davies
Hi :) If the automated system can cope with a png or a modified template then it's hopefully fairly easy to fix. Does it get the jpg from some fairly obvious folder? Anyway! Good luck and regards from Tom :) On 6 January 2014 14:57, Dries Feys dries.f...@tvh.com wrote: Thanks to all who

Re: [libreoffice-users] Re: Problem when copying to another sheet

2014-01-06 Thread Tom Davies
Hi :) :) Thanks :) I don't know. Hopefully the op might let us know. I've not tried replicating the problem on my own system Regards from Tom :) On 5 January 2014 22:40, mariosv mari...@miguelangel.mobi wrote: Have you tried copying through right-click on the sheet tab: Move/Copy Sheet?

[libreoffice-users] Page Numbering Difficulties

2014-01-06 Thread CVAlkan
I'm using LibreOffice Version: 4.2.0.1 Build ID: 7bf567613a536ded11709b952950c9e8f7181a4a with 64 bit Ubuntu 12.04 LTS I have a reasonably large document (over 300 pages) which has several appendices - each of which has specific page style formatting. So, I created page styles for each of the

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

2014-01-06 Thread Ryan Ashley
I wanted to reply and let everybody know that the workaround using FREQUENCY works fine. The sheet is now out for users to test and will be going through a few cosmetic changes, but it works. If you are curious, the sheet is a vehicle mileage sheet for company vehicles, but I will be using it

Re: [libreoffice-users] Page Numbering Difficulties

2014-01-06 Thread Regina Henschel
Hi Frank, CVAlkan schrieb: I'm using LibreOffice Version: 4.2.0.1 Build ID: 7bf567613a536ded11709b952950c9e8f7181a4a with 64 bit Ubuntu 12.04 LTS I have a reasonably large document (over 300 pages) which has several appendices - each of which has specific page style formatting. So, I created

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/06/14 10:59, Larry Evans wrote: On 01/06/14 09:02, Alex Thurgood wrote: Le 05/01/2014 18:32, Larry Evans a écrit : Hi Larry, In calc, when I try to insert a link to: ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb from the InsertLink to external Data...

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/06/14 09:02, Alex Thurgood wrote: Le 05/01/2014 18:32, Larry Evans a écrit : Hi Larry, In calc, when I try to insert a link to: ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb from the InsertLink to external Data... the OK button remains disabled. How can I link

Re: [libreoffice-users] Re: Problem when copying to another sheet

2014-01-06 Thread Tom Davies
Hi :) Hmm, i just tried this myself using all 3 main image types that i use; jpg, png and gif and both XlsX and Ods file-types and couldn't replicate the problem at all. I was hoping that it might turn out to be something simple such as Jpgs in XlsX but i couldn't find any problems with any of

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/06/14 11:20, Larry Evans wrote: On 01/06/14 10:59, Larry Evans wrote: On 01/06/14 09:02, Alex Thurgood wrote: Le 05/01/2014 18:32, Larry Evans a écrit : Hi Larry, In calc, when I try to insert a link to: ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb

[libreoffice-users] Re: Page Numbering Difficulties

2014-01-06 Thread CVAlkan
Hi Regina: Thanks so much for responding. Bug 72452 is very definitely what I am experiencing, but in reading through the thread I thought it said that the fix was put into version 4.2 which I'm using. However, I will hop out of here right now and see if there is a newer build than what I'm

[libreoffice-users] Re: Page Numbering Difficulties

2014-01-06 Thread CVAlkan
Hi Regina: I forgot to mention that I had originally written a large portion of the document in MS Word and imported it into Writer. Given some of the comments in the Bug thread for Bug 72452, I thought that might be important. Frank -- View this message in context:

[libreoffice-users] Re: Page Numbering Difficulties

2014-01-06 Thread CVAlkan
Hi Again Regina: The version I currently have installed is from LibreOffice_4.2.0.1_Linux_x86-64_deb.tar.gz (19-Dec-2013 13:52). This shows up in the help dialog as Version: 4.2.0.1 Build ID: 7bf567613a536ded11709b952950c9e8f7181a4a. So if this version contains the fix I suspect it wasn't

Re: [libreoffice-users] Re: Page Numbering Difficulties

2014-01-06 Thread Regina Henschel
Hi Frank, CVAlkan schrieb: Hi Again Regina: The version I currently have installed is from LibreOffice_4.2.0.1_Linux_x86-64_deb.tar.gz (19-Dec-2013 13:52). This shows up in the help dialog as Version: 4.2.0.1 Build ID: 7bf567613a536ded11709b952950c9e8f7181a4a. So if this version contains the

[libreoffice-users] Antw: 2014 LibreOffice themed 12 page calendar - now A4 paper size and no holidays

2014-01-06 Thread P.J. Koeleman
Kracked_P_P---webmaster, In reply to your E-mail from 3-1-2014, 16:37 with subject [libreoffice-users] 2014 LibreOffice themed 12 page calendar - now A4 paper size and no holidays. So let me know what you think of these calendars. This weekend I have made my own version of a calendar created

Re: [libreoffice-users] Antw: 2014 LibreOffice themed 12 page calendar - now A4 paper size and no holidays

2014-01-06 Thread Kracked_P_P---webmaster
On 01/06/2014 05:02 PM, P.J. Koeleman wrote: Kracked_P_P---webmaster, In reply to your E-mail from 3-1-2014, 16:37 with subject [libreoffice-users] 2014 LibreOffice themed 12 page calendar - now A4 paper size and no holidays. So let me know what you think of these calendars. This weekend I

[libreoffice-users] Re: 2014 LibreOffice themed 12 page calendar - now A4 paper size and no holidays

2014-01-06 Thread mariosv
I think the proper place is: http://templates.libreoffice.org/template-center where there is already a category for calendars. Miguel Ángel. -- View this message in context: