[libreoffice-users] Re: Writer and EPS images.

[V Stuart Foote]

At 4.2.4 we moved the EPS preview rendering to pstoedit, with fall back to
convert.

tdf#85748    
.eps files included in Writer documents “disappear” on printing

and 

tdf#89073   - eps
graphics or images don't get printed or exported to PDF in Writer on 10.10.2
OS X 

are both really duplicates of  tdf#67465
  - EPS
rendering: locating pstoedit on Mac a problem

Believe, on OS X an EPS with a preview used in Writer, that preview gets
clobbered and not-regenerated during PS printing. Lack of prefered pstoedit
in system path results in "red box with annotation" reported. 



--
View this message in context: 
http://nabble.documentfoundation.org/Writer-and-EPS-images-tp4142814p4142825.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Writer and EPS images.

[Steve Edmonds]

Hi.
I have imagemagic and ghostscript.
As I mentioned LO4.1 works fine. This was on my linux (opensuse 
12.2,13.2) and mac(osx 10.6 - 10.8 I think).
It is only LO4.2 and beyond with the problem. The problem is more 
accurately described by your second reference


https://bugs.documentfoundation.org/show_bug.cgi?id=81497

Which my reference may be a duplicate of (or may be not).
Anyway it is good that the offending commit seems to have been 
identified and AOO is a work around.

Steve

On 2015-03-11 14:38, V Stuart Foote wrote:

Nothing new there...

But, you don't mention OS. Also, do you have pstoedit, imagemagick or
ghostscript installed?

Please see these issues for a better grasp of the issue.

https://bugs.documentfoundation.org/show_bug.cgi?id=67464
Request for built-in EPS rendering ...

https://bugs.documentfoundation.org/show_bug.cgi?id=81497
PRINTING: to PDF with Adobe Distiller or GS based PDF printer, EPS images
not rendered to PS vector for PDF, instead print uses the preview of EPS
image

https://bugs.documentfoundation.org/show_bug.cgi?id=81592
Bad Quality/Rendering of EPS graphics in LO 4.2 and 4.3





--
View this message in context: 
http://nabble.documentfoundation.org/Writer-and-EPS-images-tp4142814p4142817.html
Sent from the Users mailing list archive at Nabble.com.




--
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 messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Writer and EPS images.

[V Stuart Foote]

Nothing new there...

But, you don't mention OS. Also, do you have pstoedit, imagemagick or
ghostscript installed?

Please see these issues for a better grasp of the issue.

https://bugs.documentfoundation.org/show_bug.cgi?id=67464
Request for built-in EPS rendering ... 

https://bugs.documentfoundation.org/show_bug.cgi?id=81497
PRINTING: to PDF with Adobe Distiller or GS based PDF printer, EPS images
not rendered to PS vector for PDF, instead print uses the preview of EPS
image

https://bugs.documentfoundation.org/show_bug.cgi?id=81592
Bad Quality/Rendering of EPS graphics in LO 4.2 and 4.3





--
View this message in context: 
http://nabble.documentfoundation.org/Writer-and-EPS-images-tp4142814p4142817.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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 messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Writer and EPS images.

[Steve Edmonds]

Just a heads up in case, like me, someone uses EPS images in their 
documents.
Most of my data sheets have EPS images (for the vector graphics) output 
from our cad system. Up until LO4.1 went to 4.2.. these were printed 
correctly.
I just updated to 4.3 and noticed this was broken, went back to 4.1 and 
OK, tried 4.2 and 4.4 and both broken also.
There is a bug filed at 
https://bugs.documentfoundation.org/show_bug.cgi?id=85748


Good news, Apache OO 4.1.1 is not broken and prints EPSs ok.
Steve

--
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Instability with LO 4.4.1.2

[david_lynch]

On 10/03/2015 20:00, libreoffice-ml.mbou...@spamgourmet.com wrote:

david_lynch wrote:

I upgraded from 4.4.1.1 to 4.4.1.2 this week (on Windows 8).

I have a fairly complex spreadsheet that worked well on 4.4.1.1.

In 4.4.1.2:

Whenever I try to add a column, Calc crashes with an "unexpected error"
(no further detail). I can recover the file and usually a second attempt
at adding a column works.

Some formulae involving names give incorrect results. If I rewrite them
using A1:B2 notation they work.

It is significantly slower.

I have tried increasing the memory allocated, with no change in
behaviour.

Help would be welcome, please.

David Lynch


Unless you have a particular reason for sticking to 4.1.x versions,
it's probably best to upgrade to the latest "still" (4.3.6) or "fresh"
(4.4.1) version from http://www.libreoffice.org/

The 4.1.x versions are quite old now. If you must stick to that line,
the latest is 4.1.6, and can be downloaded from:
http://downloadarchive.documentfoundation.org/libreoffice/old/4.1.6.2/
Even that's almost a year old though. There won't be any more releases
on that line to fix bugs, and any bug reports raised against it are
likely to be closed unless they can be easily reproduced with a recent
version.

Mark.


Mark,

Sorry, I meant I upgraded from 4.4.1.1 to 4.4.1.2.

Tom,

A fresh user profile doesn't help.

David


--
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc formula ...

[David Love]

David Love  wrote:

> Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build
> ID 420M0(Build2)
> 
> I have a three column spreadsheet.
> 
> Column A. Date - The dates are consecutive
> 
> Column B. Production - The Production has a daily target of 10,000 units
> and each production period is of seven days.
> 
> Column C. a formula every seventh cell.
> 
> Is it possible to construct a formula which will show in the seventh
> cell of column C the average for the number of days  of production i.e.
> if day 1 reaches a production of 10,000 units I want this figure entered
> into the seventh cell in column C.  If days 1+2+3+4 total, say, 42,500 I
> want the seventh cell in column C to show the average of 10,265.  In
> other words I want the average shown for the actual days of production
> each seven day period.

Thank you Steve, Brian and Johnny for your prompt replies.  I will work
through the suggestions and report back.

I should, however, make a confession :-)  I used the word "Production" as
I wanted members to see this as a "business" rather than a "personal"
question.

In reality, Column A is the numbers of steps I take each day. Ten thousand
is considered to be the number necessary to keep healthy.

What I want, in simple terms, is to determine the average number of steps
I am taking every week.

Hopefully, this explanation will answer the questions reaided.

DL
-- 
David Love
Bachelor: A guy who has cheated a woman out of a divorce.  

-- 
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 messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Update Java and LO to 4.4.1002 and now LO won't start

[V Stuart Foote]

Suggest you go ahead and install Apple 2014-001

http://support.apple.com/kb/DL1572

Please see  tdf#74877
  





--
View this message in context: 
http://nabble.documentfoundation.org/Update-Java-and-LO-to-4-4-1002-and-now-LO-won-t-start-tp4142800p4142803.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Instability with LO 4.1.2

[libreoffice-ml . mbourne]

david_lynch wrote:

I upgraded from 4.1.1 to 4.1.2 this week (on Windows 8).

I have a fairly complex spreadsheet that worked well on 4.1.1.

In 4.1.2:

Whenever I try to add a column, Calc crashes with an "unexpected error"
(no further detail). I can recover the file and usually a second attempt
at adding a column works.

Some formulae involving names give incorrect results. If I rewrite them
using A1:B2 notation they work.

It is significantly slower.

I have tried increasing the memory allocated, with no change in behaviour.

Help would be welcome, please.

David Lynch


Unless you have a particular reason for sticking to 4.1.x versions, it's 
probably best to upgrade to the latest "still" (4.3.6) or "fresh" 
(4.4.1) version from http://www.libreoffice.org/


The 4.1.x versions are quite old now. If you must stick to that line, 
the latest is 4.1.6, and can be downloaded from:

  http://downloadarchive.documentfoundation.org/libreoffice/old/4.1.6.2/
Even that's almost a year old though. There won't be any more releases 
on that line to fix bugs, and any bug reports raised against it are 
likely to be closed unless they can be easily reproduced with a recent 
version.


Mark.


--
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 messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Update Java and LO to 4.4.1002 and now LO won't start

[bunk3m]

Hello.I updated my Java to Java 8u40 and deleted the old Java 7 from
/Library/Java/and updated LO to the recent 4.4.1002 for Mac 64 bit.  I 
am using
OSX 10.9.5I tried to start LO and it won't complete the start saying that I
need to install Java 6 from Apple.  When I click on "Not Now" LO
quits.I understand from the Nabble posts that at one time 64 bit Java
didn't work with LO but those posts were a few years back and
besides, LO ran quite happily on another Mac we have that doesn't
have Java at all as far as I can tell.  We never use Base.How do I trick LO 
to start so I can tell it to use Java 8 in the
prefs?  Or how do I get LO to start without needing to install the
Old Java SE 6 from Apple?I have googled this and I have read the install 
docs and a few dozen
forum posts.  I haven't found something that addresses this so far
so if it exists please help me to find it.Thanks in advance for your 
help.PS I'm on digest mode so please cc me directly.  Thank you!
-- 
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 messages sent to this list will be publicly archived and cannot be deleted

Fwd: [libreoffice-users] Calc formula ...

[Johnny Rosenberg]

Sorry, I accidently sent my reply to the very wrong place…

-- Forwarded message --
From: Johnny Rosenberg 
Date: 2015-03-10 19:26 GMT+01:00
Subject: Re: [libreoffice-users] Calc formula ...
To: cpaul...@alumni.middlebury.edu


Another idea would probably be to first enter the first formula on the
seventh row, then the following formulas could check if the seventh cell
above is a formula…
For instance, the first formula in C7, than in C8:
=if(isformula(C1);average(B2:B8);"")
That cell could then be copied down as far as needed.

Something like that…



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


2015-03-10 12:49 GMT+01:00 Carl Paulsen :

> Wow, excellent suggestions Brian.  Your ideas are always spot on. Thanks.
> Carl
>
>
> On 3/10/15 4:08 AM, Brian Barker wrote:
>
>> At 19:20 10/03/2015 +1300, David Love wrote:
>>
>>> I have a three column spreadsheet.
>>> Column A. Date - The dates are consecutive
>>> Column B. Production - The Production has a daily target of 10,000 units
>>> and each production period is of seven days.
>>> Column C. a formula every seventh cell.
>>>
>>> Is it possible to construct a formula which will show in the seventh
>>> cell of column C the average for the number of days of production i.e. if
>>> day 1 reaches a production of 10,000 units I want this figure entered into
>>> the seventh cell in column C.
>>>
>>
>> Hold on! How do you know this is going to be the average for the week? Do
>> your workers celebrate reaching the daily target and take the rest of the
>> week off? Surely they need to attempt the same daily target on each of the
>> next six days? Or do you mean that 1 is the *weekly* target? If so,
>> what happens when it is reached? Does production automatically stop to
>> prevent its being exceeded? Or could some weeks exceed 1 - even by
>> accident?
>>
>>  If days 1+2+3+4 total, say, 42,500 I want the seventh cell in column C
>>> to show the average of 10,265. In other words I want the average shown for
>>> the actual days of production each seven day period.
>>>
>>
>> So 1 isn't a weekly limit. In that case, what is the significance of
>> the 1? If four days exceed 1, as here, it's not a daily limit
>> either: at least one of these days must have exceeded 1. I'm beginning
>> to suspect that it has no significance for the calculation (so you didn't
>> need to tell us): it may be of interest only to the workers' supervisor in
>> interpreting the results.
>>
>> You can find the average of non-negative values (i.e. non-zero values in
>> your case, assuming production cannot be negative) by putting in, say, C7:
>> =AVERAGEIF(B1:B7;">0")
>> If you copy this and paste it into every seventh row of column C, you
>> will have what you need.
>>
>> But that leaves you with the rather messy requirement to paste separately
>> into every seventh row - a process very prone to error. Instead, in C7 try:
>> =IF(MOD(ROW();7)=0;AVERAGEIF(B1:B7;">0");"")
>> ROW() returns the current row number. The MOD() function returns the
>> remainder on dividing by 7. If this is zero - as it will be for row 7 and
>> every seventh row thereafter - the required average is shown; otherwise the
>> null string ensures that there is no display in the cell. You can copy or
>> fill this down column C without the same risk of error as the previous
>> suggestion. Note that comparing the result of the MOD() function with zero
>> will show results in rows 7, 14, 21, and so on. You will have to change the
>> "0" to "1" to show results instead in rows 8, 15, 22, and so on - and
>> similarly for other possibilities. Once you have found the appropriate
>> value, you can fill the formula containing it down the column.
>>
>> Is it possible for there to be no production at all in a particular week?
>> The above formula, in evaluating the average of no values, attempts to
>> divide by zero and displays #DIV/0! . You could test for this and avoid it
>> in various ways. If days with no production have empty cells in column B,
>> =IF(AND(COUNT(B1:B7)>0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;">0");"")
>> would suffice. If they have (or may have) explicit zero values, try:
>> =IF(AND(COUNTIF(B1:B7;">0")>0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;">0");"")
>>
>> I trust this helps.
>>
>> Brian Barker
>>
>>
>>
> --
>
> Carl Paulsen
>
> 8 Hamilton Street
>
> Dover, NH 03820
>
> (603) 749-2310
>
>
>
> --
> 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 messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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
Lis

Re: [libreoffice-users] UK thesaurus

[Doug]

On 03/10/2015 09:19 AM, Tim---Kracked_P_P---webmaster wrote:


The one I use is Artha, which is an offline one.  IT is not a spell checking 
dictionary, but, it is a dictionary and has many thesaurus types of information.

I prefer offline ones since laptop users may not have Internet access when they 
need to use a thesaurus or find what the word actually means.

http://artha.sourceforge.net/wiki/index.php/Home

There are binaries for Windows and Linux.  Many distros of Linux have Artha in 
their repositories.

Once it is loaded, it stays loaded until you reboot.  You reopen it with Ctrl 
Alt W or whatever keyboard shortcut you define other than the default.

I have not installed it in a long while, so I do not remember if it used your 
system's default language or if you can choose the language[s] you want to use.


/snip/

I have been using Artha for a long time. I don't have to reload it--I have put 
the icon on the panel, and it is ready to use
as soon as you boot your computer up. I have stumped it occasionally, but not 
often. I have it installed on PCLinuxOS and on Windows,
both 7 and 8.1. It can sometimes guess at your meaning even when you have 
misspelled the input, which is something the spell checkers
never do.

--doug

--
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] UK thesaurus

[Tom Davies]

Hi :)
Weird!  I thought you made some fantastic dictionaries and put them on the
Extensions website?  Pretty much everyone who installed those said they
were a huge improvement.  I was being shy of pointing them out because i'd
noticed you were back from hospital or where-ever.
Regards from
Tom :)


On 10 March 2015 at 13:19, Tim---Kracked_P_P---webmaster <
webmas...@krackedpress.com> wrote:

>
> The one I use is Artha, which is an offline one.  IT is not a spell
> checking dictionary, but, it is a dictionary and has many thesaurus types
> of information.
>
> I prefer offline ones since laptop users may not have Internet access when
> they need to use a thesaurus or find what the word actually means.
>
> http://artha.sourceforge.net/wiki/index.php/Home
>
> There are binaries for Windows and Linux.  Many distros of Linux have
> Artha in their repositories.
>
> Once it is loaded, it stays loaded until you reboot.  You reopen it with
> Ctrl Alt W or whatever keyboard shortcut you define other than the default.
>
> I have not installed it in a long while, so I do not remember if it used
> your system's default language or if you can choose the language[s] you
> want to use.
>
>
>
> On 03/09/2015 05:04 PM, anne-ology wrote:
>
>> Also Roget's Thesaurus is on-line;
>> http://www.thesaurus.com/Roget-Alpha-Index.html
>>
>>
>>
>> From: Tom Davies 
>> Date: Mon, Mar 9, 2015 at 6:35 AM
>> Subject: Re: [libreoffice-users] UK thesaurus
>> To: Tim Lloyd 
>> Cc: "users@global.libreoffice.org" 
>>
>> Hi :)
>> I think there is an Extension for Uk.  However isn't it also possible to
>> get the download for the "English (Uk)" "local"/foreign language for both
>> the UI and the help-guide?
>> Regards from
>> Tom :)
>>
>>
>>
>> On 9 March 2015 at 10:37, Tim Lloyd  wrote:
>>
>>  Hi, following this link:
>>>
>>> http://www.linuxquestions.org/questions/linux-general-1/
>>> apparent-lack-of-uk-thesaurus-for-libreoffice-writer-4175536114/
>>>
>>> is there a UK thesaurus for LO?
>>>
>>> Cheers
>>>
>>>
>
> --
> 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 messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Instability with LO 4.1.2

[Tom Davies]

Hi :)
Err, can you try renaming the User Profile too?  Sudden unexpected errors
between different versions within the same branch really shouldn't be
happening.  So it might be something to do with some odd change in the User
Profile.

On the other hand, in life there is often a huge chasm between what "should
be" and "what is".
Regards from
Tom :)



On 9 March 2015 at 22:55, david_lynch  wrote:

> I upgraded from 4.1.1 to 4.1.2 this week (on Windows 8).
>
> I have a fairly complex spreadsheet that worked well on 4.1.1.
>
> In 4.1.2:
>
> Whenever I try to add a column, Calc crashes with an "unexpected error"
> (no further detail). I can recover the file and usually a second attempt at
> adding a column works.
>
> Some formulae involving names give incorrect results. If I rewrite them
> using A1:B2 notation they work.
>
> It is significantly slower.
>
> I have tried increasing the memory allocated, with no change in behaviour.
>
> Help would be welcome, please.
>
> David Lynch
>
> --
> 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 messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] UK thesaurus

[Tim---Kracked_P_P---webmaster]

The one I use is Artha, which is an offline one.  IT is not a spell 
checking dictionary, but, it is a dictionary and has many thesaurus 
types of information.


I prefer offline ones since laptop users may not have Internet access 
when they need to use a thesaurus or find what the word actually means.


http://artha.sourceforge.net/wiki/index.php/Home

There are binaries for Windows and Linux.  Many distros of Linux have 
Artha in their repositories.


Once it is loaded, it stays loaded until you reboot.  You reopen it with 
Ctrl Alt W or whatever keyboard shortcut you define other than the default.


I have not installed it in a long while, so I do not remember if it used 
your system's default language or if you can choose the language[s] you 
want to use.



On 03/09/2015 05:04 PM, anne-ology wrote:

Also Roget's Thesaurus is on-line;
http://www.thesaurus.com/Roget-Alpha-Index.html



From: Tom Davies 
Date: Mon, Mar 9, 2015 at 6:35 AM
Subject: Re: [libreoffice-users] UK thesaurus
To: Tim Lloyd 
Cc: "users@global.libreoffice.org" 

Hi :)
I think there is an Extension for Uk.  However isn't it also possible to
get the download for the "English (Uk)" "local"/foreign language for both
the UI and the help-guide?
Regards from
Tom :)



On 9 March 2015 at 10:37, Tim Lloyd  wrote:


Hi, following this link:

http://www.linuxquestions.org/questions/linux-general-1/
apparent-lack-of-uk-thesaurus-for-libreoffice-writer-4175536114/

is there a UK thesaurus for LO?

Cheers




--
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Excel file .xls not opening properly

[Carl Paulsen]

Thanks, Bill.  After trying a few things, I discovered that this file 
doesn't open in Windows using M$ Office either, so there's something 
wrong with it.  I had moved 3 files from Windows to my Mac to work on 
them, and that's where I noticed the problem.  The other two files had 
opened fine on the Windows machine but I guess I hadn't checked this 
third one.  My hint (inspired by your reply) was that TextEdit on a Mac 
thought the file was empty except for two blank lines.  That program can 
usually open any file, so there was clearly something odd going on.


Carl


On 3/10/15 5:09 AM, William Drago wrote:
Just because a file has a .xls extension does not mean it's actually a 
spreadsheet file. I'd open the file in a text editor to make sure it's 
not an HTML file. Also, if you think it's being treated as a .doc 
file, then I'd rename it .doc and then try opening it.


-Bill

On 3/9/2015 2:08 PM, cpaulsen10 wrote:
LibreOffice is trying to open a recent file with the extension .xls 
as if it were a .doc file.  When opened directly (by saving the file 
to the hard drive then double clicking it) I get an error that says 
"this page uses frames but your browser doesn't support them" and I 
get only text-style menus and tools.  I'm NOT trying to open this in 
a browser and there's no browser involved when trying to open it.


This file was originally generated by Salesforce, which often saves 
it as if it were an html/web file.  But with a save-as operation in 
MS Excel, the file saves correctly as a spreadsheet file (.xls). I'm 
using MS Office 2007, so it's not a new file type, and I've had no 
problems in the past.


Any idea what is happening?  I've tried opening a blank spreadsheet 
and inserting from a file, but no luck.  Nothing happens when I do that.


Thanks,
Carl






--
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc formula ...

[Carl Paulsen]

Wow, excellent suggestions Brian.  Your ideas are always spot on. Thanks.
Carl


On 3/10/15 4:08 AM, Brian Barker wrote:

At 19:20 10/03/2015 +1300, David Love wrote:

I have a three column spreadsheet.
Column A. Date - The dates are consecutive
Column B. Production - The Production has a daily target of 10,000 
units and each production period is of seven days.

Column C. a formula every seventh cell.

Is it possible to construct a formula which will show in the seventh 
cell of column C the average for the number of days of production 
i.e. if day 1 reaches a production of 10,000 units I want this figure 
entered into the seventh cell in column C.


Hold on! How do you know this is going to be the average for the week? 
Do your workers celebrate reaching the daily target and take the rest 
of the week off? Surely they need to attempt the same daily target on 
each of the next six days? Or do you mean that 1 is the *weekly* 
target? If so, what happens when it is reached? Does production 
automatically stop to prevent its being exceeded? Or could some weeks 
exceed 1 - even by accident?


If days 1+2+3+4 total, say, 42,500 I want the seventh cell in column 
C to show the average of 10,265. In other words I want the average 
shown for the actual days of production each seven day period.


So 1 isn't a weekly limit. In that case, what is the significance 
of the 1? If four days exceed 1, as here, it's not a daily 
limit either: at least one of these days must have exceeded 1. I'm 
beginning to suspect that it has no significance for the calculation 
(so you didn't need to tell us): it may be of interest only to the 
workers' supervisor in interpreting the results.


You can find the average of non-negative values (i.e. non-zero values 
in your case, assuming production cannot be negative) by putting in, 
say, C7:

=AVERAGEIF(B1:B7;">0")
If you copy this and paste it into every seventh row of column C, you 
will have what you need.


But that leaves you with the rather messy requirement to paste 
separately into every seventh row - a process very prone to error. 
Instead, in C7 try:

=IF(MOD(ROW();7)=0;AVERAGEIF(B1:B7;">0");"")
ROW() returns the current row number. The MOD() function returns the 
remainder on dividing by 7. If this is zero - as it will be for row 7 
and every seventh row thereafter - the required average is shown; 
otherwise the null string ensures that there is no display in the 
cell. You can copy or fill this down column C without the same risk of 
error as the previous suggestion. Note that comparing the result of 
the MOD() function with zero will show results in rows 7, 14, 21, and 
so on. You will have to change the "0" to "1" to show results instead 
in rows 8, 15, 22, and so on - and similarly for other possibilities. 
Once you have found the appropriate value, you can fill the formula 
containing it down the column.


Is it possible for there to be no production at all in a particular 
week? The above formula, in evaluating the average of no values, 
attempts to divide by zero and displays #DIV/0! . You could test for 
this and avoid it in various ways. If days with no production have 
empty cells in column B,

=IF(AND(COUNT(B1:B7)>0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;">0");"")
would suffice. If they have (or may have) explicit zero values, try:
=IF(AND(COUNTIF(B1:B7;">0")>0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;">0");"")

I trust this helps.

Brian Barker




--

Carl Paulsen

8 Hamilton Street

Dover, NH 03820

(603) 749-2310


--
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 messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Support options

[Andreas Säger]

Am 06.03.2015 um 13:59 schrieb Cor Nouws:
> Cor Nouws wrote on 22-01-15 21:39:
>> Dave Barton wrote on 18-01-15 14:06:
>>
>>> The solution is simple. Just log in to the forum and post the announcement.
>>
>> Ah yes. Will do that. IIRC there will be some major release shortly ;)
>> I guess some of the moderators must make it stick in the announcement
>> section then.
> 
> I posted a topic about 4.4.1 a week ago, but it has been parked in a sub
> forum, not placed on top as other announcements. Alas. I posted a
> request to one of the moderators, but have not yet seen a response.
> 
> Cheers,
> Cor
> 

Your topic
https://forum.openoffice.org/en/forum/viewtopic.php?f=101&t=75656 is
always on top of the LibreOffice subforum now.


-- 
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc formula ...

[Steve Edmonds]

Ok. OP has stated "each production period is of seven days" so answers 
my first question.

On 2015-03-10 19:20, David Love wrote:

Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build
ID 420M0(Build2)

I have a three column spreadsheet.

Column A. Date - The dates are consecutive

Column B. Production - The Production has a daily target of 10,000 units
and each production period is of seven days.

Column C. a formula every seventh cell.

Is it possible to construct a formula which will show in the seventh cell
of column C the average for the number of days  of production i.e. if day
1 reaches a production of 10,000 units I want this figure entered into the
seventh cell in column C.  If days 1+2+3+4 total, say, 42,500 I want the
seventh cell in column C to show the average of 10,265.  In other words I
want the average shown for the actual days of production each seven day
period.

DL




--
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc formula ...

[Brian Barker]

At 19:20 10/03/2015 +1300, David Love wrote:

I have a three column spreadsheet.
Column A. Date - The dates are consecutive
Column B. Production - The Production has a daily target of 10,000 
units and each production period is of seven days.

Column C. a formula every seventh cell.

Is it possible to construct a formula which will show in the seventh 
cell of column C the average for the number of days of production 
i.e. if day 1 reaches a production of 10,000 units I want this 
figure entered into the seventh cell in column C.


Hold on! How do you know this is going to be the average for the 
week? Do your workers celebrate reaching the daily target and take 
the rest of the week off? Surely they need to attempt the same daily 
target on each of the next six days? Or do you mean that 1 is the 
*weekly* target? If so, what happens when it is reached? Does 
production automatically stop to prevent its being exceeded? Or could 
some weeks exceed 1 - even by accident?


If days 1+2+3+4 total, say, 42,500 I want the seventh cell in column 
C to show the average of 10,265. In other words I want the average 
shown for the actual days of production each seven day period.


So 1 isn't a weekly limit. In that case, what is the significance 
of the 1? If four days exceed 1, as here, it's not a daily 
limit either: at least one of these days must have exceeded 1. 
I'm beginning to suspect that it has no significance for the 
calculation (so you didn't need to tell us): it may be of interest 
only to the workers' supervisor in interpreting the results.


You can find the average of non-negative values (i.e. non-zero values 
in your case, assuming production cannot be negative) by putting in, say, C7:

=AVERAGEIF(B1:B7;">0")
If you copy this and paste it into every seventh row of column C, you 
will have what you need.


But that leaves you with the rather messy requirement to paste 
separately into every seventh row - a process very prone to error. 
Instead, in C7 try:

=IF(MOD(ROW();7)=0;AVERAGEIF(B1:B7;">0");"")
ROW() returns the current row number. The MOD() function returns the 
remainder on dividing by 7. If this is zero - as it will be for row 7 
and every seventh row thereafter - the required average is shown; 
otherwise the null string ensures that there is no display in the 
cell. You can copy or fill this down column C without the same risk 
of error as the previous suggestion. Note that comparing the result 
of the MOD() function with zero will show results in rows 7, 14, 21, 
and so on. You will have to change the "0" to "1" to show results 
instead in rows 8, 15, 22, and so on - and similarly for other 
possibilities. Once you have found the appropriate value, you can 
fill the formula containing it down the column.


Is it possible for there to be no production at all in a particular 
week? The above formula, in evaluating the average of no values, 
attempts to divide by zero and displays #DIV/0! . You could test for 
this and avoid it in various ways. If days with no production have 
empty cells in column B,

=IF(AND(COUNT(B1:B7)>0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;">0");"")
would suffice. If they have (or may have) explicit zero values, try:
=IF(AND(COUNTIF(B1:B7;">0")>0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;">0");"")

I trust this helps.

Brian Barker


--
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 messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc formula ...

[Steve Edmonds]

Hi.
Yes it is. May some clarification though.
Is it the prior 7 days like a rolling average or the days say Monday to 
Sunday, every Sunday.
Are you only averaging days where production exceeds 1, so in your 
1st example day 1 is the only day exceeding 1 so the average=1 
and in your second example 4 days exceed 1 so those 4 are averaged.

Steve
On 2015-03-10 19:20, David Love wrote:

Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build
ID 420M0(Build2)

I have a three column spreadsheet.

Column A. Date - The dates are consecutive

Column B. Production - The Production has a daily target of 10,000 units
and each production period is of seven days.

Column C. a formula every seventh cell.

Is it possible to construct a formula which will show in the seventh cell
of column C the average for the number of days  of production i.e. if day
1 reaches a production of 10,000 units I want this figure entered into the
seventh cell in column C.  If days 1+2+3+4 total, say, 42,500 I want the
seventh cell in column C to show the average of 10,265.  In other words I
want the average shown for the actual days of production each seven day
period.

DL




--
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 messages sent to this list will be publicly archived and cannot be deleted