Re: [libreoffice-users] brochure printing RESOLVED

[Mike Scott]

On 07/10/15 19:57, Regina Henschel wrote:


Have you really checked both options "Use only paper tray from printer
preferences" and "Use only size form printer preferences" in the tab
"Options"? After this options are enabled, the settings in the printer
properties should be enabled.


Duhh!  I've just looked back, and that's exactly what you said 
originally. And I didn't. Sorry - and yes, that fixes it; thank you (twice!)



But - isn't this a bit of an odd user interface? You set the brochure 
option on /this/ tab, enable setting the paper size on /that/ tab, then 
click a button on yet another tab to open the dialogue to actually set 
the size. Could this not be tidied up? (And the defaults must have 
changed - I'm sure I've never had to worry about this before) Nor, 
AFAICS, is this mentioned anywhere in the help file (which I did read!)



Incidentally, I notice that the 'brochure' setting now is stored with 
the document (it used not to be), as is 'Use only paper tray' 
whereas "Use only size from printer preferences" isn't saved and needs 
resetting every time the document is opened. But thankfully the paper 
size and orientation are saved. Curious design.



Anyway, problem solved; apologies again, and thanks for your patience.



--
Mike Scott
Harlow, Essex, England

--
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] help with conditional text

[Hendrik Maryns]

Hi there,  (@nl: you can answer me in Dutch)

I am trying to insert conditional text based on a database field just 
like it is explained here: 
https://help.libreoffice.org/Writer/Defining_Conditions#To_display_conditional_text_based_on_the_contents_of_a_database_field:


But it doesn’t work: I get the ‘no’ text always.  I do not know what I 
am doing wrong.  Can someone check my document and tell me?


Please contact me, I am trying to make a minimal example now.

Cheers, H.
--
Hendrik Maryns

Drielandenhoek 24
NL-2034 LV Haarlem
+31237370263
+31634861841 (staat meestal uit, enkel nootgevallen)
http://hendrikmaryns.name/
===
Wat moet ik met signature.asc?!?  Kort gezegt: niks, lang antwoort:
→ http://en.wikipedia.org/wiki/PGP
→ http://mindprod.com/project/mailreadernewsreader.html
Kan je niet spellen?!?  Toch wel hoor:
→ http://hendrikmaryns.name/spelling.php

--
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] Printing in Impress

[Malcolm Moore]

If I create a presentation in Impress and set the 
page size to A3 landscape, how do I print it ?


It always comes out  ( partly on ) A4 and the 
dropdown to change the paper size in the print 
dialog is greyed out at A4


In the end I PDF'ed it and printed it out that way 
but that's less than elegant !


LO 5.0.2 openSuse BTW


Ta


Mal
-- 
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: [nl-users] help with conditional text

[Hendrik Maryns]

Hi all,

I found out: there were spaces in the column names in the database. 
Removing them solved the problem.  I’ll file a bug about this.


Cheers, H.

Op 08-10-15 om 13:23 schreef Hendrik Maryns:

Hi there,  (@nl: you can answer me in Dutch)

I am trying to insert conditional text based on a database field just
like it is explained here:
https://help.libreoffice.org/Writer/Defining_Conditions#To_display_conditional_text_based_on_the_contents_of_a_database_field:


But it doesn’t work: I get the ‘no’ text always.  I do not know what I
am doing wrong.  Can someone check my document and tell me?

Please contact me, I am trying to make a minimal example now.

Cheers, H.


--
Hendrik Maryns
http://hendrikmaryns.name

--
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] Printing in Impress

[Regina Henschel]

Hi Malcome,

Malcolm Moore schrieb:

If I create a presentation in Impress and set the
page size to A3 landscape, how do I print it ?


It always comes out  ( partly on ) A4 and the
dropdown to change the paper size in the print
dialog is greyed out at A4


What paper size is your printer able to print on? Has hit got A3? Can it 
print A4 borderless?


For to enable the printer settings you need to check the options "Use 
only paper tray from printer preferences" and "Use only size form 
printer preferences" in the tab "Options".


Kind regards
Regina

--
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: [nl-users] help with conditional text

[Ad Rienks]

Hi Hendrik,

2015-10-08 14:19 GMT+02:00 Hendrik Maryns :

> I’ll file a bug about this.


To me that does not look like a bug; variable names can not have spaces in
it.

Regards
Ad Rienks

-- 
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: Percentage with bracket as negative

[Andreas Säger]

Am 08.10.2015 um 03:24 schrieb Yudi Wijaya:
> Dear Andreas,
> First of all.. thank you for your reply :-D
> 
> Your 1st method doesn't work (turn on special number), you're right.. the
> datas are too bad.
> 
> Your 2nd method almost works.. but i think need some modification
> Search: ^\s*\(([[:digit:].]+)\s*%\s*\)\s*$
> Replace: $1%
> 
> I tested it, if the data is (25.24 % ) will replace it with 25.24%
> The problem is LibreOffice only recoqnize 25,24% instead 25.24% (so must
> use "," than ".")
> For example if i change the data into (25 % ), then your regular expression
> correct.
> 
> Do you know how to replace . (dot) with , (comma) ?
> 
> I already tried use English (UK) but can not
> 
> Thanks!
> 
> Best Regards,

The currency comes with comma as thousands separator. This would be in
conflict with any comma as decimal separator.
I would not handle this mess with spreadsheets. First I would blame the
creator of this ugly shit. Ask for clean text data with no leading and
trailing spaces, currency symbols "Rp" in extra columns and proper
numerals. If this is not an option, I would write a simple script to
clean up the mess.


-- 
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: Percentage with bracket as negative

[Andreas Säger]

OK, this is what I can achieve with a simple text editor:
Replace all "Rp" with "Rp|"
Replace all " % " with "%"
Replace all %) with )%
Copy all and paste into a spreadsheet with English(UK) as import locale.
Both, space and | as column delimiters with "Merge" option and "special
numbers" option.
This imports all dates, percents and currencies as correct numeric values.


-- 
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: Percentage with bracket as negative

[Steve Edmonds]

On 2015-10-09 06:10, Andreas Säger wrote:

Am 08.10.2015 um 03:24 schrieb Yudi Wijaya:

Dear Andreas,
First of all.. thank you for your reply :-D

Your 1st method doesn't work (turn on special number), you're right.. the
datas are too bad.

Your 2nd method almost works.. but i think need some modification
Search: ^\s*\(([[:digit:].]+)\s*%\s*\)\s*$
Replace: $1%

I tested it, if the data is (25.24 % ) will replace it with 25.24%
The problem is LibreOffice only recoqnize 25,24% instead 25.24% (so must
use "," than ".")
For example if i change the data into (25 % ), then your regular expression
correct.

Do you know how to replace . (dot) with , (comma) ?

I already tried use English (UK) but can not

Thanks!

Best Regards,

The currency comes with comma as thousands separator. This would be in
conflict with any comma as decimal separator.
I would not handle this mess with spreadsheets. First I would blame the
creator of this ugly shit. Ask for clean text data with no leading and
trailing spaces, currency symbols "Rp" in extra columns and proper
numerals. If this is not an option, I would write a simple script to
clean up the mess.


Coming in late here, but this looks like reports I import from our 
accounting system up to 4 times an hour.


| 1|02/10/2015|17-2202200|MAKMUR   |  24 |
| 1|03/10/2015|14-1403837|SARIPAH  |  24 |


I think Andreas regexp is good and could be used with a little tweek. 
Part of your problem may be to do with locale.
The report uses point as decimal and comma as thousands separator. I 
think you are saying your locale uses comma as decimal and point as 
thousands separator.

Do you have to import these often.
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] Re: Percentage with bracket as negative

[Steve Edmonds]

On 2015-10-09 06:35, Andreas Säger wrote:

OK, this is what I can achieve with a simple text editor:
Replace all "Rp" with "Rp|"
Replace all " % " with "%"
Replace all %) with )%
Copy all and paste into a spreadsheet with English(UK) as import locale.
Both, space and | as column delimiters with "Merge" option and "special
numbers" option.
This imports all dates, percents and currencies as correct numeric values.


That is simple. Also minimal processing with a script, in fact a few 
simple lines with sed.

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] Re: [nl-users] help with conditional text

[Hendrik Maryns]

Hi

Op 08-10-15 om 15:00 schreef Ad Rienks:

Hi Hendrik,

2015-10-08 14:19 GMT+02:00 Hendrik Maryns :


I’ll file a bug about this.



To me that does not look like a bug; variable names can not have spaces in
it.


You do have a point, but then the help instructions should be clear on 
this point, they aren’t now.  Maybe that will be the outcome of the bug.


Cheers, H.
--
Hendrik Maryns
http://hendrikmaryns.name

--
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] Start a list at a level other than 1

[anne-ology]

   Probably you could accomplish this through a new template.



From: Lone Peregrine 
Date: Wed, Oct 7, 2015 at 7:38 PM
Subject: [libreoffice-users] Start a list at a level other than 1
To: users@global.libreoffice.org


Is it possible to /start / a list at a level other than 1? If so, how?

Here's why I want to find this out. I've created five different paragraph
styles of headers, and each successive header's indentation is a 1/2"
greater than the last. From hitting Enter directly after any of these header
styles, I want to automatically enter a list that has the same level of
indentation as the header just above, but it can still be promoted to the
left or right.



--
View this message in context:
http://nabble.documentfoundation.org/Start-a-list-at-a-level-other-than-1-tp4162529.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: JRE and LibreOFFICE

[anne-ology]

   I think the whole list should see who you are.



-- Forwarded message --
From: Forna 
Date: Thu, Oct 8, 2015 at 3:06 AM
Subject: Re: JRE and LibreOFFICE
To: anne-ology 


WHAT!?!!?

*"**Assuming this is a legitimate question ..."*

After a registration on LO site to a forum that doesn't let you post
anything, after having read FAQ, I found this mail after having looked for
some help and it was written this is for any problem related to
LibreOffice... so YES! THIS IS A LEGITIMATE QUESTION.


*"Where did you download LO?; - *
*  if not from the LO site, I would suggest you un-install what you
did download & re-install from the LO site for a 'clean' version."*

I downloaded from LO site.


*"where did you download java? -   that is not something you should
need to download, since is already on these computers;"*

I downloaded from Java site. What?!? Java is already on the computers?!!? I
think you are wrong. In all my computer history I've never found Java
already intsalled.

* " [am assuming you meant java rather than lava - if you meant what you
typed then I would think your computer needs to be cleaned before it's
allowed to contaminate any of your data and/or others']"*

Lava... ok ok... it was a type error OMG...

Contaminate datas?!? I downloaded software from official site.

Now, I give you an answer that solve the problem and could be of interest
for other people that encounter this problem:

I tried to download the previous version (8.40) and... *voilà!* Now it
works.
So there is something wrong with Java last version.




2015-10-07 21:29 GMT+02:00 anne-ology :

   Assuming this is a legitimate question ...
>   assuming you're new to computers ...
>
>therefore, will attempt to answer your question(s) ...
>   and hoping others on this list will as well; by filling in
> further details,
>
>Java when needed for some programs, sites, ...
>   can be allowed to open either permanently or temporarily by
> clicking on 'options' then selecting to allow;
>
>I don't think LO requires this.
>
>Where did you download LO?; -
>   if not from the LO site, I would suggest you un-install what you
> did download & re-install from the LO site for a 'clean' version.
>
>   where did you download java? -
>that is not something you should need to download, since is already
> on these computers;
>   [am assuming you meant java rather than lava - if you meant what
> you typed then I would think your computer needs to be cleaned before it's
> allowed to contaminate any of your data and/or others']
>
>Hoping this helps,
>
>
>
> From: Forna 
> To: users@global.libreoffice.org
> Cc:
> Date: Wed, 7 Oct 2015 12:01:20 +0200
> Subject: [libreoffice-users] JRE and LibreOFFICE
>
> Hi Guys... I've LibreOFFICE 5.0.2.2 and I wish to give a try to the
> Database feature.
>
> When I tried to create a new table, I can't do nothing cause it tells me it
> needs java.
> I downloaded lava from website ( v8 update 60) but it continue telling me
> that java is defective and I need to install the right version
>
> Which is the right version, so I could try Databse?
>
>

-- 
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] Installing Libreoffice in Ubuntu

[John R. Sowden]

I have been dealing with this issue for years, going back to the Open 
Office days.


How do you install Libreoffice under Ubuntu?

Where are the step by step, clearly documented instructions?

When are they not either on the download page in LO or a clear link on 
the download page?


Here's what I find on the net including a google search:

1) Use the Software Center in Ubuntu.  Never mind that it is not the 
current version.  Never mind that  the version is not posted in the 
"more Info" description, along with the date of the version.


or

20 Go to libreoffice.org.  Press the big download button.  Now what?  
Start googling for instructions.

Expect the instructions to not tell you:
an explanation of each command.
where the program will end up on your system.
whether it will automatically get rid of the remnant files and even 
the original downloaded files.

how to deal with the help, and why.

or

3) Google like I did last night and find that there are "ppa"s, with a 
well written explanation of the "fresh ppa" being better and why. Now 
try to find how to install the most current version, whether you have a 
copy on your computer or not.


and

How to deal with dependencies, not just finding out that you have 
"dependency problems" but also that LO will not install due to them.


It seems that this is a universal Linux problem.  If you don't know the 
intricacies of Linux, then you shouldn't be using it.  So much for 
attaining more market share.


John Sowden










--
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: Installing Libreoffice in Ubuntu

[Andreas Säger]

Am 09.10.2015 um 04:47 schrieb John R. Sowden:
> I have been dealing with this issue for years, going back to the Open
> Office days.
> 
> How do you install Libreoffice under Ubuntu?
> 

Using the command line, this is a matter of seconds. If you can not use
a command line, stick with the version that is distributed with Ubuntu.


-- 
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: Installing Libreoffice in Ubuntu

[John R. Sowden]

I have been using the command line since trs-80, cp/m and dos before 
moving to linux.  What are the commands?  (Fresh PPA)


John


On 10/08/2015 08:50 PM, Andreas Säger wrote:

Am 09.10.2015 um 04:47 schrieb John R. Sowden:

I have been dealing with this issue for years, going back to the Open
Office days.

How do you install Libreoffice under Ubuntu?


Using the command line, this is a matter of seconds. If you can not use
a command line, stick with the version that is distributed with Ubuntu.





--
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: Installing Libreoffice in Ubuntu

[Евгений]

I think fresh PPA is - https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

There are instaructions on how to add ppa in your distro (see "Read about 
installing").
After that you can use any way to install libreoffice.
I am using fresh ppa on 12.04 and have no problems with dependencies.

If you can not do something - post what you do and what happens or what errors 
you get.


09.10.2015, 12:21, "John R. Sowden" :
> I have been using the command line since trs-80, cp/m and dos before
> moving to linux. What are the commands? (Fresh PPA)
>
> John
>
> On 10/08/2015 08:50 PM, Andreas Säger wrote:
>>  Am 09.10.2015 um 04:47 schrieb John R. Sowden:
>>>  I have been dealing with this issue for years, going back to the Open
>>>  Office days.
>>>
>>>  How do you install Libreoffice under Ubuntu?
>>  Using the command line, this is a matter of seconds. If you can not use
>>  a command line, stick with the version that is distributed with Ubuntu.
>
> --
> 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

[libreoffice-users] Re: Percentage with bracket as negative

[Andreas Säger]

Am 08.10.2015 um 19:46 schrieb Steve Edmonds:
> Coming in late here, but this looks like reports I import from our
> accounting system up to 4 times an hour.
> 
> | 1|02/10/2015|17-2202200|MAKMUR   |  24 |
> | 1|03/10/2015|14-1403837|SARIPAH  |  24 |
> 
> 
> I think Andreas regexp is good and could be used with a little tweek.
> Part of your problem may be to do with locale.
> The report uses point as decimal and comma as thousands separator. I
> think you are saying your locale uses comma as decimal and point as
> thousands separator.
> Do you have to import these often.
> Steve
> 

Yes, and there are negative percents in braces with lots of spaces and
the % within the braces.
Calc has no problem with (20)% which correctly imports as -0.2. Calc it
does not interprete (20%).
I could not find a locale for currencies with leading "Rp". Indonesian
should work because it has such currency formats but Indonesian import
locale gives text.

And yes, a trivial sed script can fix this. But I'm not familiar with
sed and most users use Windows.
Since LO comes with Python, Python could provide a cross-platform solution.


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