Re: [libreoffice-users] Calc: Average value, multiple conditions

[TomW]

On 2012-09-06 13:59, Johnny Rosenberg wrote:

I have a spreadsheet with quite a lot of values and text.
Column C: Name.
Column D: Date.
Column H: Values (integers, currently in the range of 176 to 605).

R1: A specific name that matches many of the rows of column C.
P2: Start date.
Q2: End date.

I tried this:
{=SUM(($C$2:$C$1001=R$1)*($D$2:$D$1001>=$P2)*($D$2:$D$1001<$Q2)*$H$2:$H$1001)}
Works great. Gives 29072 in my specific spreadsheet. Expected value: 29072.

Now, I changed to:
{=AVERAGE(($C$2:$C$1001=R$1)*($D$2:$D$1001>=$P2)*($D$2:$D$1001<$Q2)*$H$2:$H$1001)}
Result: 52.29.
Expected value: Somewhere around 450.

Was I just too quick to assume that AVERAGE can be used in the same way as SUM?





Kind regards

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



Johnny:

You need to use this syntax to get an average value based on multiple 
criteria.


{=AVERAGE(IF(($C$2:$C$1001=R$1)*($D$2:$D$1001>=$P2)*($D$2:$D$1001<$Q2),$H$2:$H$1001))}

TomW

--
For unsubscribe instructions e-mail to: users+h...@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] Characters in Libre Office Formula Editor Foobared

[Jeff Hoogland]

Pinned down my own issue. Need the package fonts-opensymbol installed.

On Thu, Sep 6, 2012 at 6:35 PM, Jeff Hoogland wrote:

> Nothing looks out of place to the best of my knowledge ->
> http://www.enlightenment.org/ss/e-50493344d852c2.93935982.jpg
>
>
> On Thu, Sep 6, 2012 at 6:33 PM, Peter Langfelder <
> peter.langfel...@gmail.com> wrote:
>
>> On Thu, Sep 6, 2012 at 4:21 PM, Jeff Hoogland 
>> wrote:
>> > A number of characters are displaying as random symbols when I enter
>> them
>> > into the LibreOffice equation editor. Example screenshot:
>> > http://www.enlightenment.org/ss/e-50492fb8e49de7.63325761.jpg
>> >
>> > These characters are fine when using the normal writer part of
>> LibreOffice.
>> > I am using version 3.6.1 installed from the officially provided .debs
>> for
>> > download on the website on a 32bit Linux system. Any suggestions for
>> > resolving this? I use this editor for school and need it working ASAP.
>> >
>> Check the font? When you're in math editor, click Format->Fonts on the
>> menu bar, then check that all fonts make sense All standard fonts in
>> my Math editor are Times Roman (with italic for variables).
>>
>> HTH,
>>
>> Peter
>>
>
>
>
> --
> ~Jeff Hoogland 
> Thoughts on Technology , Tech Blog
> Bodhi Linux , Enlightenment for your Desktop
>
>


-- 
~Jeff Hoogland 
Thoughts on Technology , Tech Blog
Bodhi Linux , Enlightenment for your Desktop

-- 
For unsubscribe instructions e-mail to: users+h...@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] Characters in Libre Office Formula Editor Foobared

[Jeff Hoogland]

Nothing looks out of place to the best of my knowledge ->
http://www.enlightenment.org/ss/e-50493344d852c2.93935982.jpg

On Thu, Sep 6, 2012 at 6:33 PM, Peter Langfelder  wrote:

> On Thu, Sep 6, 2012 at 4:21 PM, Jeff Hoogland 
> wrote:
> > A number of characters are displaying as random symbols when I enter them
> > into the LibreOffice equation editor. Example screenshot:
> > http://www.enlightenment.org/ss/e-50492fb8e49de7.63325761.jpg
> >
> > These characters are fine when using the normal writer part of
> LibreOffice.
> > I am using version 3.6.1 installed from the officially provided .debs for
> > download on the website on a 32bit Linux system. Any suggestions for
> > resolving this? I use this editor for school and need it working ASAP.
> >
> Check the font? When you're in math editor, click Format->Fonts on the
> menu bar, then check that all fonts make sense All standard fonts in
> my Math editor are Times Roman (with italic for variables).
>
> HTH,
>
> Peter
>



-- 
~Jeff Hoogland 
Thoughts on Technology , Tech Blog
Bodhi Linux , Enlightenment for your Desktop

-- 
For unsubscribe instructions e-mail to: users+h...@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] Characters in Libre Office Formula Editor Foobared

[Peter Langfelder]

On Thu, Sep 6, 2012 at 4:21 PM, Jeff Hoogland  wrote:
> A number of characters are displaying as random symbols when I enter them
> into the LibreOffice equation editor. Example screenshot:
> http://www.enlightenment.org/ss/e-50492fb8e49de7.63325761.jpg
>
> These characters are fine when using the normal writer part of LibreOffice.
> I am using version 3.6.1 installed from the officially provided .debs for
> download on the website on a 32bit Linux system. Any suggestions for
> resolving this? I use this editor for school and need it working ASAP.
>
Check the font? When you're in math editor, click Format->Fonts on the
menu bar, then check that all fonts make sense All standard fonts in
my Math editor are Times Roman (with italic for variables).

HTH,

Peter

-- 
For unsubscribe instructions e-mail to: users+h...@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] Characters in Libre Office Formula Editor Foobared

[Jeff Hoogland]

A number of characters are displaying as random symbols when I enter them
into the LibreOffice equation editor. Example screenshot:
http://www.enlightenment.org/ss/e-50492fb8e49de7.63325761.jpg

These characters are fine when using the normal writer part of LibreOffice.
I am using version 3.6.1 installed from the officially provided .debs for
download on the website on a 32bit Linux system. Any suggestions for
resolving this? I use this editor for school and need it working ASAP.

-- 
~Jeff Hoogland 
Thoughts on Technology , Tech Blog
Bodhi Linux , Enlightenment for your Desktop

-- 
For unsubscribe instructions e-mail to: users+h...@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] bug search and replace in half height window

[anne-ology]

   I have not noticed this - but I have not upgraded from LO 3.4  ;-)
   and I use WIN not Mac.



On Wed, Sep 5, 2012 at 3:14 PM, Guy Voets  wrote:

Hello,
>
> I have a window with Writer that is half the height of my screen.
> I do a search & replace, but the text doesn't always move down in the
> window to show the next occurrence of the word I'm searching for.
> Quite annoying because either you scroll manually, or you say search (next)
> and at the end start from the beginning again, till you have found all
> occurrences of the word you want replaced.
>
> Anybody to confirm this?
>
> --
> Guy
> using LibO 3.6.1.1 on a iMac Intel DualCore MountainLion 10.8.1
> -- please reply only to users@global.libreoffice.org --
> Dodoes can't afford to have headaches
>

-- 
For unsubscribe instructions e-mail to: users+h...@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] AutoText and CR

[anne-ology]

   same here.

   There's only one way I know to stop this foolishness -
   change the setting to dis-allow auto-text  ;-)



On Wed, Sep 5, 2012 at 1:47 PM, leif  wrote:

I can confirm this behavior.
>
> There is already a bug report for that:
> https://bugs.freedesktop.org/show_bug.cgi?id=53023
>
> It seems to be a VERY old bug indeed.
>
> Cheers,
> Leif Lodahl
>
> On 05-09-2012 03:42, Thomas Blasejewicz wrote:
> > Good morning
> > I am trying to get used to AutoText.
> > Although I succeeded in creating 2 new entries, these ALWAYS are
> > kombined upon insertion with a carriage return, even though I selected
> > only the text.
> > So, whenever I insert that autotext, I get a new line and have to remove
> > that manually.
> >
> > 1) Is that normal?
> > 2) Is there a way to stop it? (insert only the text and do nothing else)
> >
> > Thank you.
> > Thomas
> >
>

-- 
For unsubscribe instructions e-mail to: users+h...@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: [3.5.3.2/Writer] H2 = underline until right margin?

[Gilles]

Thanks for the infos on how to change the styles and formatting. I only use
LO once in a while, so maybe I'll get around to reading its documentation
instead of googling for this type of thing.



--
View this message in context: 
http://nabble.documentfoundation.org/3-5-3-2-Writer-H2-underline-until-right-margin-tp4004505p4005953.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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: how i can rotate print like landscape?

[NoOp]

On 09/06/2012 02:43 AM, manuel_songo...@yahoo.it wrote:
> hello
> thank you.
> but problem is not resolved (but works as perfect but there are not 
> 'automatic' or 'save to default changed' when i changed config from "PDF" to 
> "PostScript (Level from driver)"
> this problem is not know where is problem from...from libreoffice or linux 
> distro (my is opensuse 12.1) this is not clear where is problm.. but few days 
> me and users(opensuse and libreoffice) will found resolved and i will reply 
> here email users.
> smile!
...

For some reason, each time I post this solution, the post never gets
through... so I'll try one more time:

> Subject: [libreoffice-users] [PDF instead of Postscript - Printing] Re:
> Problem printing an .xls file
> From: NoOp <...>
> Date: Fri, 03 Feb 2012 19:13:09 -0800
> 
>> > A possible workaround:
>> >
>> > Open spadmin (printer administration) & select the printer
>> > 'Properties|Device|Printer Language type: PostScript Level 2. Close
>> > spadmin & open LO (3.3.x or 3.4.x) and you should be ok for that
>> > printer. You can check by closing & reopening LO & 'File|Printer
>> > Settings||Properties|Device|'.
>> > - In LibreOffice 3.3.4 you should see 'from device driver'.
>> > - In LibreOffice 3.5.0rc2 you should see 'PostScript Level 2'.
>> >
>> > Again, it's a possible workaround & certainly not a fix. But give it a
>> > try & see if it works for you.
> 
> 
> 




-- 
For unsubscribe instructions e-mail to: users+h...@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: file name suggestion

[NoOp]

On 09/05/2012 02:27 PM, Paolo Debortoli wrote:
> in a message on facebook, somebody suggested that writer when first saving a 
> document should copy a feature of m$ word:  compose automatically the 
> document name  using the first vtwo words of the document itself, instead of 
> naming it something like 'document without name'.  it would be comfortable if 
> you have to save multiple documents in one directory
> 

Start your own thread rather than hijacking the original thread:
"3.6.1 dictionary installs (.deb) fail & bork dpkg/apt-get"

X-Mailer: YahooMailWebService/0.8.121.416
In-Reply-To: 
^
Archived-At: 

See

to see your thread hijack.
See: http://wiki.documentfoundation.org/Netiquette





-- 
For unsubscribe instructions e-mail to: users+h...@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: Average value, multiple conditions

[Dan Lewis]

Johnny Rosenberg wrote:

I have a spreadsheet with quite a lot of values and text.
Column C: Name.
Column D: Date.
Column H: Values (integers, currently in the range of 176 to 605).

R1: A specific name that matches many of the rows of column C.
P2: Start date.
Q2: End date.

I tried this:
{=SUM(($C$2:$C$1001=R$1)*($D$2:$D$1001>=$P2)*($D$2:$D$1001<$Q2)*$H$2:$H$1001)}
Works great. Gives 29072 in my specific spreadsheet. Expected value: 29072.

Now, I changed to:
{=AVERAGE(($C$2:$C$1001=R$1)*($D$2:$D$1001>=$P2)*($D$2:$D$1001<$Q2)*$H$2:$H$1001)}
Result: 52.29.
Expected value: Somewhere around 450.

Was I just too quick to assume that AVERAGE can be used in the same way as SUM?

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

 The SUM is exactly that: the total of the numbers that are 
generated from the given rows. An AVERAGE is the sum divided by how many 
numbers were generated.
  Comment: With the sum being 29072 and expected average of 450, 
there had to be about 65 numbers that your array added. With the sum 
being 29072 and actual average of 52.29, there was about 556 numbers. Do 
you have any idea how many numbers would be created by your array?

  I am a little curious though. Which number is closer: 65 or 556?

--Dan


--
For unsubscribe instructions e-mail to: users+h...@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: how i can rotate print like landscape?

[manuel_songokuh]

hello

you said: problem is not with libreoffice..right but go to see bug report this 
mean is problem is FROM LIBREOFFICE...
go to see: https://bugs.freedesktop.org/show_bug.cgi?id=44664

ok?you can see code from
/usr/lib64/libreoffice/share/psprint/psprint.conf
test and try it ok?




 Da: Marc Paré 
A: users@global.libreoffice.org 
Inviato: Giovedì 6 Settembre 2012 14:57
Oggetto: [libreoffice-users] Re: how i can rotate print like landscape?
 
Hi Manuel,

Le 2012-09-06 05:43, manuel_songo...@yahoo.it a écrit :
> hello
> thank you.
> but problem is not resolved (but works as perfect but there are not 
> 'automatic' or 'save to default changed' when i changed config from "PDF" to 
> "PostScript (Level from driver)"
> this problem is not know where is problem from...from libreoffice or linux 
> distro (my is opensuse 12.1) this is not clear where is problm.. but few days 
> me and users(opensuse and libreoffice) will found resolved and i will reply 
> here email users.
> smile!
> 

I think you will find that the problem is not with LibreOffice, but with the 
printer settings with your Linux distro (OpenSuse). You need to go into your 
printer setup and make sure that you have chosen the right preferences and the 
right driver. If your printer uses SPL (Samsung Printer Language), then you may 
want to try the SpliX driver to see if this will fix the problem.

As you say in your message, it will be nice to know how you fixed this. Thanks 
for doing this.

Cheers,

Marc


-- Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


-- For unsubscribe instructions e-mail to: users+h...@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
-- 
For unsubscribe instructions e-mail to: users+h...@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] Calc: Average value, multiple conditions

[Johnny Rosenberg]

I have a spreadsheet with quite a lot of values and text.
Column C: Name.
Column D: Date.
Column H: Values (integers, currently in the range of 176 to 605).

R1: A specific name that matches many of the rows of column C.
P2: Start date.
Q2: End date.

I tried this:
{=SUM(($C$2:$C$1001=R$1)*($D$2:$D$1001>=$P2)*($D$2:$D$1001<$Q2)*$H$2:$H$1001)}
Works great. Gives 29072 in my specific spreadsheet. Expected value: 29072.

Now, I changed to:
{=AVERAGE(($C$2:$C$1001=R$1)*($D$2:$D$1001>=$P2)*($D$2:$D$1001<$Q2)*$H$2:$H$1001)}
Result: 52.29.
Expected value: Somewhere around 450.

Was I just too quick to assume that AVERAGE can be used in the same way as SUM?





Kind regards

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

-- 
For unsubscribe instructions e-mail to: users+h...@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] What is the status of Java security vs. LibreOffice?

[Tanstaafl]

On 8/30/2012 2:33 PM, Jay Lozier  wrote:

The security problems are Java problems and are not OS or app related
and can affect any computer running the unpatched Java version(s). My
understanding is the transmission is likely via rogue or corrupted
websites that use Java rather than via a downloaded Java app.


Or you can use Firefox+NoScript, and only selectively allow java for 
trusted sites (just like it does for javascript)...


--
For unsubscribe instructions e-mail to: users+h...@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] help exporting to macromedia flash

[Tanstaafl]

On 8/31/2012 3:15 PM, Jerry Geis  wrote:

I have found a "limited" solution. export the PPT as PDF,


Were you trying to export a .ppt file?

Whenever working in Libreoffice, you should always use the native file 
formats... only save to the Microsoft Office format if you need to send 
an editable document to them.


Try saving the .ppt to a .odp and see if it works. If it still doesn't, 
recreate it from scratch in .odp format and try again.


--
For unsubscribe instructions e-mail to: users+h...@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: Libreoffice and Java

[V Stuart Foote]

Yes, that is correct. Would still be broken if you don't also clean up the 
javasettings .xml configuration file.
 
Additionally, for folks on a 64-bit build of Windows,  if you install both a 
32-bit and a 64-bit JRE, you need to watch which JRE gets called with 
LibreOffice.  Oracle installers place copies of latest installed executable 
into the C:\Windows\system32 (the 64-bit executables), and also in 
C:\Windows\SysWOW64 (for the 32-bit executables).
 
They are copied from the respective  installation directories of the JREs, but 
with a default installation these executables will be "found" before any other 
instance referred by the PATH environment, so they are the JREs used by 
default--and that can cause problems if not expected (as can issues with 
location of a MS C++ runtime not being present with the Java virtual machine 
libraries).  
 
To convince yourself, leave the C:\Windows copies intact and run a Command 
Window, and then execute "java -version", if you have the 64-bit JRE installed 
and you will see the version labeled as 64-bit build--not the 32-bit. And that 
also seems to causes problems for LibreoOffice which on Windows remains 32-bit.
 
To precisely control which JRE is used, you have to remove the executables from 
the system32 and SysWOW64 directories, and then establish a specific location 
on the PATH for them. Can be anywhere in the PATH environment variable, but for 
security after the Windows OS components. Also by convention you can create a 
JAVA_HOME environment variable and use a "%JAVA_HOME%\bin" reference in the 
PATH.  Very useful (and the norm in Linux) in that you can programmatically 
change the JAVA_HOME variable when you need a different JRE (either the version 
or use of a 64-bit build).
 
Stuart



From: Tanstaafl [mailto:tansta...@libertytrek.org]
Sent: Thu 9/6/2012 10:21 AM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] RE: Libreoffice and Java



Thanks Stuart...

So, if you (like I always do) first uninstall JRE 1.6, then install 1.7
(32bit of course), will it still be broken?




-- 
For unsubscribe instructions e-mail to: users+h...@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: Libreoffice and Java

[Tanstaafl]

Thanks Stuart...

So, if you (like I always do) first uninstall JRE 1.6, then install 1.7 
(32bit of course), will it still be broken?


On 8/28/2012 12:10 PM, V Stuart Foote  wrote:


Bob McDonald wrote


JRE 1.7 32 bit edition works if (and only if) JRE 1.6 is installed first
and is pointed to in the options.  (you can even uninstall JRE 1.6
afterward...)
Neither of the 64 bit versions work.  (or show up as Java versions in the
options list under LO)



Actually, that is completely wrong and in reality is one of the reasons so
many folks have problems with the transition from JRE 1.6 to JRE 1.7--they
do not clear out the old and incorrect configurations.

Here are extracts of the javasettings_Windows_x86.xml configuration file
with the JRE in use by Libre Office. It is found per-user at
C:\Users\\AppData\Roaming\LibreOffice\3\user\config

For JRE 1.6u34:



Oracle Corporation
file:///C:/Program%20Files%20(x86)/Java/jre6
1.6.0_34
0
0

and of JRE 1.7u6



Oracle Corporation
file:///C:/Program%20Files%20(x86)/Java/jre7
1.7.0_06
0
0

This .XML configuration file is NOT updated when you upgrade your JRE!  It
must be deleted and allowed to rebuild--using your system environment PATH,
or you will end up with non-functional LO Java functions.


--
For unsubscribe instructions e-mail to: users+h...@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] Libreoffice and Java

[Tanstaafl]

On 8/28/2012 9:57 AM, Bob McDonald  wrote:

JRE 1.7 32 bit edition works if (and only if) JRE 1.6 is installed
first and is pointed to in the options.  (you can even uninstall JRE
1.6 afterward...)


Are you absolutely certain that a fresh/clean install of Windows 7 
64bit, with a fresh/clean install of Java 1.7 (without there having been 
a 1.6 installed prior) and a fresh/clean install of Libreoffice will 
result in a NON functional Java environment?


If that is so, then the Libreoffice installation/startup initialization 
process is broken.


--
For unsubscribe instructions e-mail to: users+h...@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] file name suggestion

[Tom Davies]

Hi :)
I think the op was talking about the default name.  Of course the person saving 
the document can change from the default to something more sensible.  

The default used by LO at the moment is very old-school.  Files called things 
like Doc1, Doc2, Doc3 are even less helpful than picking the 1st 2 words.  If 
it could be cleverer and choose the 1st 2 words of the first main heading that 
might be more useful.  Perhaps there might be some way using the contents of 
the Navigator?  Perhaps more than 2 words, such as using the entire 1st main 
title?  Perhaps adding the date in -mm-dd order to the end?  

Regards from
Tom :)  





>
> From: webmaster-Kracked_P_P 
>To: users@global.libreoffice.org 
>Sent: Thursday, 6 September 2012, 0:13
>Subject: Re: [libreoffice-users] file name suggestion
> 
>On 09/05/2012 05:51 PM, Dan Lewis wrote:
>> Paolo Debortoli wrote:
>>> in a message on facebook, somebody suggested that writer when first saving 
>>> a document should copy a feature of m$ word:  compose automatically the 
>>> document name using the first vtwo words of the document itself, instead of 
>>> naming it something like 'document without name'.  it would be comfortable 
>>> if you have to save multiple documents in one directory
>>      Questions: How do you determine what a document's content is by looking 
>>at the first two words? Why would people save a file without giving it a name 
>>that makes sense to the author? What would happen if more than one text 
>>document has the same beginning two words? No, I think the best thing is to 
>>name each file when it is first opened by Writer.
>> 
>> --Dan
>> 
>I always hated M$ to decide things for me.  They usually got the name for the 
>document to be something that did not work for me.  I think they picked it 
>from the first line of text.
>
>I tend to make a file name be a short sentence of under 30 to 40 characters 
>that describe the document or image.  M$ could not do that easily.
>
>
>
>-- For unsubscribe instructions e-mail to: users+h...@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
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@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] Cursor shape+color

[Tom Davies]

Hi :)
There are a lot of options in
Tools - Options - Appearance
but i don't think the cursor itself is in there.  

One way to play "spot the cursor" is to press the shift key while moving the 
cursor around as "selects" characters (or entire lines if up/down is used 
rather than just to and fro).  If you use Ctrl and shift it selects entire 
words at a time.  

Also most OSes have "Accessibility" options or even something hidden in 
mouse-settings that can be set to produced moving concentric circles or 
something homing-in on either the mouse or the cursor.  In Gnu&Linux i often 
add a pair of eyes to the menu-bar / taskbar / panel and they follow my mouse 
around or flick up at the sky if i move to another monitor.  

As Jay says it is worth exploring your OS to see if you can change settings 
system-wide because i don't think LibreOffice has the option internally.

Regards from
Tom :)  





>
> From: Jay Lozier 
>To: users@global.libreoffice.org 
>Sent: Thursday, 6 September 2012, 13:40
>Subject: Re: [libreoffice-users] Cursor shape+color
> 
>On 09/06/2012 05:45 AM, Thomas Blasejewicz wrote:
>> Good evening
>> Probably this is a very stupid question - and not actually a "technical
>> problem":
>>
>> Is it possible to change (customize) the shape and color of the cursor?
>>
>> Currently it is a thin, vertical black line.
>> I can see it blinking when it is within a blanc area of the screen,
>> but when I have the whole screen full of text and move around a little,
>> this thin black line is
>> "dam near impossible to see" - like the golden snitch in the Harry
>> Potter movies.
>>
>> It would be very helpful, if I could change its shape and preferrably
>> also color so something that is easier to find.
>> (I could do that ages ago in WordPerfect (very helpful!), but have no
>> idea whether it is possible in Word)
>>
>> But this is only my personal wishful thinking and everybody else is
>> perfectly happy ...
>>
>> Thank you
>> Thomas
>>
>Hi
>
>You might try checking your OS' available cursors and see if one of them
>has the features you want. This will be a global change affecting all apps.
>
>-- 
>Jay Lozier
>jsloz...@gmail.com
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@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
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@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: how i can rotate print like landscape?

[webmaster-Kracked_P_P]

Maybe the problem is solved with opensuse 12.2 - which an article 
announced that it was out now.



On 09/06/2012 05:43 AM, manuel_songo...@yahoo.it wrote:

hello
thank you.
but problem is not resolved (but works as perfect but there are not 'automatic' or 'save to default 
changed' when i changed config from "PDF" to "PostScript (Level from driver)"
this problem is not know where is problem from...from libreoffice or linux 
distro (my is opensuse 12.1) this is not clear where is problm.. but few days 
me and users(opensuse and libreoffice) will found resolved and i will reply 
here email users.
smile!





  Da: Marc Paré 
A: users@global.libreoffice.org
Inviato: Mercoledì 5 Settembre 2012 17:47
Oggetto: [libreoffice-users] Re: how i can rotate print like landscape?
  
Congrat Manuel!


Le 2012-09-04 14:04, manuel_songo...@yahoo.it a écrit :

hello
i RESOLVE THANKK FROM OPENSUSE!!!
go to see link forum topic:
http://forums.opensuse.org/english/get-technical-help-here/applications/472640-libreoffice-doesnt-print-landscape-files-properly.html



BTW ... the fix for the same problem on Samsung and other printers is to 
install the opensource SpliX driver (it may be in the various linux 
repositories). The driver is for any printer making use of the Samsung Printer 
Language (SPL), some of which include printer made from: Samsung, Xerox, Dell, 
Toshiba ...

Once installed it fixes the problems with landscape printing.

Cheers,

Marc

-- Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


-- For unsubscribe instructions e-mail to: users+h...@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



--
For unsubscribe instructions e-mail to: users+h...@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: how i can rotate print like landscape?

[Marc Paré]

Hi Manuel,

Le 2012-09-06 05:43, manuel_songo...@yahoo.it a écrit :

hello
thank you.
but problem is not resolved (but works as perfect but there are not 'automatic' or 'save to default 
changed' when i changed config from "PDF" to "PostScript (Level from driver)"
this problem is not know where is problem from...from libreoffice or linux 
distro (my is opensuse 12.1) this is not clear where is problm.. but few days 
me and users(opensuse and libreoffice) will found resolved and i will reply 
here email users.
smile!



I think you will find that the problem is not with LibreOffice, but with 
the printer settings with your Linux distro (OpenSuse). You need to go 
into your printer setup and make sure that you have chosen the right 
preferences and the right driver. If your printer uses SPL (Samsung 
Printer Language), then you may want to try the SpliX driver to see if 
this will fix the problem.


As you say in your message, it will be nice to know how you fixed this. 
Thanks for doing this.


Cheers,

Marc


--
Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


--
For unsubscribe instructions e-mail to: users+h...@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] Cursor shape+color

[Jay Lozier]

On 09/06/2012 05:45 AM, Thomas Blasejewicz wrote:
> Good evening
> Probably this is a very stupid question - and not actually a "technical
> problem":
>
> Is it possible to change (customize) the shape and color of the cursor?
>
> Currently it is a thin, vertical black line.
> I can see it blinking when it is within a blanc area of the screen,
> but when I have the whole screen full of text and move around a little,
> this thin black line is
> "dam near impossible to see" - like the golden snitch in the Harry
> Potter movies.
>
> It would be very helpful, if I could change its shape and preferrably
> also color so something that is easier to find.
> (I could do that ages ago in WordPerfect (very helpful!), but have no
> idea whether it is possible in Word)
>
> But this is only my personal wishful thinking and everybody else is
> perfectly happy ...
>
> Thank you
> Thomas
>
Hi

You might try checking your OS' available cursors and see if one of them
has the features you want. This will be a global change affecting all apps.

-- 
Jay Lozier
jsloz...@gmail.com


-- 
For unsubscribe instructions e-mail to: users+h...@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] custom column (piled) graph in Calc

[Mélodie]

Hello,

I am looking for a way to create a column graph. I have 6 series, and I 
would like 3 of these series to be piled, and the other 3 not piled (a 
separate column each).


Is this possible?

The closest I can get is using a column and line graph, with 3 columns 
piled and 2 lines, but unfortunately, I really do need that 6th series 
(if I do it this way, it needs to be a single column, not piled with the 
others), otherwise my graph doesn't make sense !


Melodie



--
For unsubscribe instructions e-mail to: users+h...@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] Cursor shape+color

[Thomas Blasejewicz]

Good evening
Probably this is a very stupid question - and not actually a "technical
problem":

Is it possible to change (customize) the shape and color of the cursor?

Currently it is a thin, vertical black line.
I can see it blinking when it is within a blanc area of the screen,
but when I have the whole screen full of text and move around a little,
this thin black line is
"dam near impossible to see" - like the golden snitch in the Harry
Potter movies.

It would be very helpful, if I could change its shape and preferrably
also color so something that is easier to find.
(I could do that ages ago in WordPerfect (very helpful!), but have no
idea whether it is possible in Word)

But this is only my personal wishful thinking and everybody else is
perfectly happy ...

Thank you
Thomas

-- 
For unsubscribe instructions e-mail to: users+h...@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: how i can rotate print like landscape?

[manuel_songokuh]

hello
thank you.
but problem is not resolved (but works as perfect but there are not 'automatic' 
or 'save to default changed' when i changed config from "PDF" to "PostScript 
(Level from driver)"
this problem is not know where is problem from...from libreoffice or linux 
distro (my is opensuse 12.1) this is not clear where is problm.. but few days 
me and users(opensuse and libreoffice) will found resolved and i will reply 
here email users.
smile!





 Da: Marc Paré 
A: users@global.libreoffice.org 
Inviato: Mercoledì 5 Settembre 2012 17:47
Oggetto: [libreoffice-users] Re: how i can rotate print like landscape?
 
Congrat Manuel!

Le 2012-09-04 14:04, manuel_songo...@yahoo.it a écrit :
> hello
> i RESOLVE THANKK FROM OPENSUSE!!!
> go to see link forum topic:
> http://forums.opensuse.org/english/get-technical-help-here/applications/472640-libreoffice-doesnt-print-landscape-files-properly.html
> 
> 

BTW ... the fix for the same problem on Samsung and other printers is to 
install the opensource SpliX driver (it may be in the various linux 
repositories). The driver is for any printer making use of the Samsung Printer 
Language (SPL), some of which include printer made from: Samsung, Xerox, Dell, 
Toshiba ...

Once installed it fixes the problems with landscape printing.

Cheers,

Marc

-- Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


-- For unsubscribe instructions e-mail to: users+h...@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
-- 
For unsubscribe instructions e-mail to: users+h...@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