Re: [libreoffice-users] Re: Page formatting in writer goes nuts

[Steve Edmonds]

I have had this one quite frequently as I edit the same manuals from 
Linux, Mac and Windows machines, all in LO.
I found that the cause was that the font Arial was not the same on all 
machines, so I took my font package from Linux and installed it on all 
machines I edit on and now the jumping lines have stopped.

Steve

On 2016-09-24 23:00, Bo Siltberg wrote:

I have noticed another odd behaviour which may be related to the "picture
problem" vs page formatting.

I have a page in my large doc with only text. This first picture shows the
content when the document is freshly loaded.
https://drive.google.com/open?id=0BzKxVP7gn2uTTTJSdzBBUkNRQ00
Then, after a change somewhere (that does not affect the page count), bot
sure exactly what triggers it, it becomes
https://drive.google.com/open?id=0BzKxVP7gn2uTT3ZJdzA1cHp3U2c

Notice that the spacing between the lines has increased and that the last
line from the first picture now has spilled over to next page.
Of course, this creates seemingly unmotivated changes in the page
formatting.
Anyone has an idea what is going on here and if I can influence this
behaviour?

Thanks


2016-09-10 16:59 GMT+02:00 Bo Siltberg :


Thank you Wiebe for updating the existing bug report, that should be
enough. However their reply indicates that it may be difficult to solve.
Not sure that status *needinfo* means, if they want more info from us. I
hope they will take a look at this bug as it is easy to reproduce.

I have seen similar problems with pagination in tables and frames too,
where no pictures were involved. Starting with this pic bug, I hope it may
solve some other bug too related to page formatting.





--
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] Spelling check funnies

[Marco A.G.Pinto]

Hello!

You can e-mail the words directly to me, or open a case in GitHub:
https://github.com/marcoagpinto/aoo-mozilla-en-dict

Usually people send me private e-mails with the missing words.

Thanks!

Kind regards,
   >Marco A.G.Pinto
 


On 26/09/2016 00:23, Steve Edmonds wrote:
> Hi Marco.
> I often (not every day) come across missing words, would you like me
> to send these too you or is there a better place to list omissions.
> Steve
>
> On 2016-09-26 11:46, Marco A.G.Pinto wrote:
>> Hello!
>>
>> I am the en_GB speller maintainer.
>>
>> I have just added to it:
>> 15023) Ainsworth (+'s - name - Wikipedia)
>> 15024) Bleiler (+'s - name - Wikipedia)
>> 15025) Colburn (+'s - name - Wikipedia)
>> 15026) Chetham (+'s - name - Wikipedia)
>> 15027) Routledge (+'s - name - Wikipedia)
>> 15028) Malkin (+'s - name - Wikipedia)
>> 15029) Potts (+'s - name - Wikipedia)
>> 15030) Slater (+'s - name - Wikipedia)
>> 15031) Crossley (+'s - name - Wikipedia)
>> 15032) Heswall (+'s - name - Wikipedia)
>>
>> Every two months there is a release for OpenOffice and LibreOffice.
>>
>> It will be fixed when that happens.
>>
>> Kind regards,
>>   >Marco A.G.Pinto
>> 
>>
>>
>> On 24/09/2016 13:06, John Willerton wrote:
>>> Hi All,
>>>
>>>
>>> I read the forum regularly but this is my first post. It's only
>>> light-hearted but I don't see why that should be against the rules.
>>>
>>> Using the spelling checker in LO Writer version 5.0.5.2 on Windows 7
>>> Pro, I
>>> recently passed over a fairly common English surname, "Ainsworth".
>>>
>>> The spelling checker gave some wonderful suggestions, namely
>>> Wandsworth,
>>> Wadsworth,
>>>
>>> AIRWORTHY,
>>>
>>> WORDSWORTH,
>>>
>>> UNSEAWORTHY and
>>>
>>> NEWSWORTHY (my capitalisations).
>>>
>>> Has anyone else found some funnies. If so ,why not share them? The
>>> forum
>>> does not have to be grindingly technical all day every day.
>>>
>>
>
>


-- 

-- 
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] Writer Objects?

[Ricardo]

El 2016-09-25 20:07, Dave escribió:

Can someone tell me what Writer defines as "Objects"? The term seems to
be loosely and often inaccurately used in menus and the "Help" 
facility.


For example, drawing items appear to be defined a "Objects", but then 
so

do frames.

According to the "Help" facility:
"Objects;Definition
An object is a screen element containing data. It can refer to
application data, such as text or graphics.
Objects are independent and do not influence each other. Any object
containing data can be assigned certain commands. For example, a 
graphic

object has commands for image editing 8<-- snip -->8 ."

A totally inaccurate and contradictory "garbled" statement in itself.

In the "Help" facility, the "Selecting;Objects" section also makes
totally false, inaccurate and meaningless claims about selecting and
grouping *ALL* those things claimed to be "Objects".

AFAICT the only genuine Writer "Objects" are "Drawing Objects". Does
anyone know of any other genuine Writer "Objects"?


Math objects are "valid" as well. You can also insert a Calc table on a 
Writer document, for example, in which case it will be an object. It is 
also possible to insert a "Writer object" into Draw.


Frames can be considered as objects in part because they can display the 
content of external documents: this is how master documents work.


A common feature of all objects is that when you try to manipulate their 
content the "parent" program will open: double click on an equation will 
open Math, double click on a Calc table inserted in Writer will open 
Calc and so on.


Regards,
Ricardo




Dave

--
Please address any reply to the mailing list only. Any messages sent to
this noreply@ address are automatically deleted from the server and 
will

never be read.


--
Il mio blog in italiano: https://ilpinguinoscrittore.wordpress.com/
Mi blog en español: https://elpinguinotolkiano.wordpress.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] Spelling check funnies

[Marco A.G.Pinto]

Hello!

I am the en_GB speller maintainer.

I have just added to it:
15023) Ainsworth (+'s - name - Wikipedia)
15024) Bleiler (+'s - name - Wikipedia)
15025) Colburn (+'s - name - Wikipedia)
15026) Chetham (+'s - name - Wikipedia)
15027) Routledge (+'s - name - Wikipedia)
15028) Malkin (+'s - name - Wikipedia)
15029) Potts (+'s - name - Wikipedia)
15030) Slater (+'s - name - Wikipedia)
15031) Crossley (+'s - name - Wikipedia)
15032) Heswall (+'s - name - Wikipedia)

Every two months there is a release for OpenOffice and LibreOffice.

It will be fixed when that happens.

Kind regards,
 >Marco A.G.Pinto
   


On 24/09/2016 13:06, John Willerton wrote:
> Hi All,
>
>
> I read the forum regularly but this is my first post. It's only
> light-hearted but I don't see why that should be against the rules.
>
> Using the spelling checker in LO Writer version 5.0.5.2 on Windows 7 Pro, I
> recently passed over a fairly common English surname, "Ainsworth".
>
> The spelling checker gave some wonderful suggestions, namely Wandsworth,
> Wadsworth,
>
> AIRWORTHY,
>
> WORDSWORTH,
>
> UNSEAWORTHY and
>
> NEWSWORTHY (my capitalisations).
>
> Has anyone else found some funnies. If so ,why not share them? The forum
> does not have to be grindingly technical all day every day.
>


-- 

-- 
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] Writer Objects?

[Dave]

On 25.09.2016 20:50, Ricardo wrote:
> El 2016-09-25 20:07, Dave escribió:
>> Can someone tell me what Writer defines as "Objects"? The term seems to
>> be loosely and often inaccurately used in menus and the "Help" facility.
>>
>> For example, drawing items appear to be defined a "Objects", but then so
>> do frames.
>>
>> According to the "Help" facility:
>> "Objects;Definition
>> An object is a screen element containing data. It can refer to
>> application data, such as text or graphics.
>> Objects are independent and do not influence each other. Any object
>> containing data can be assigned certain commands. For example, a graphic
>> object has commands for image editing 8<-- snip -->8 ."
>>
>> A totally inaccurate and contradictory "garbled" statement in itself.
>>
>> In the "Help" facility, the "Selecting;Objects" section also makes
>> totally false, inaccurate and meaningless claims about selecting and
>> grouping *ALL* those things claimed to be "Objects".
>>
>> AFAICT the only genuine Writer "Objects" are "Drawing Objects". Does
>> anyone know of any other genuine Writer "Objects"?
>
> Math objects are "valid" as well. You can also insert a Calc table on
> a Writer document, for example, in which case it will be an object. It
> is also possible to insert a "Writer object" into Draw.
>
> Frames can be considered as objects in part because they can display
> the content of external documents: this is how master documents work.
>
> A common feature of all objects is that when you try to manipulate
> their content the "parent" program will open: double click on an
> equation will open Math, double click on a Calc table inserted in
> Writer will open Calc and so on.
>
> Regards,
> Ricardo
>
>> Dave

Hi Ricardo,

Thanks for kindly taking the time to respond. Having been involved with
this software since Sun open sourced the Star Office code in 2001, I was
already aware of the the things you refer to. However, you have
overlooked the point I was making:

We describe all of those things as being "Objects", but then in the
"Help" facility "Selecting;Objects" section we go on to tell "half
truths" about selecting and grouping *ALL* of those things described as
being "Objects".  You can combine several graphic objects into a
group so that you can use them like a single object. .

In fact the only "Objects" you can select and combine are "Drawing
Objects". Not graphic (picture) objects, Math objects, Calc tables,
Frames, or any other inserted objects.

Regards
Dave
-- 
Please address any reply to the mailing list only. Any messages sent to
this noreply@ address are automatically deleted from the server and will
never be read.




-- 
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] Spelling check funnies

[James E. Lang]

Interesting to know Marco but where's the sense of humor?

-- 
Jim

-Original Message-
From: "Marco A.G.Pinto" 
To: users@global.libreoffice.org
Sent: Sun, 25 Sep 2016 15:47
Subject: Re: [libreoffice-users] Spelling check funnies

Hello!

I am the en_GB speller maintainer.

I have just added to it:
15023) Ainsworth (+'s - name - Wikipedia)
15024) Bleiler (+'s - name - Wikipedia)
15025) Colburn (+'s - name - Wikipedia)
15026) Chetham (+'s - name - Wikipedia)
15027) Routledge (+'s - name - Wikipedia)
15028) Malkin (+'s - name - Wikipedia)
15029) Potts (+'s - name - Wikipedia)
15030) Slater (+'s - name - Wikipedia)
15031) Crossley (+'s - name - Wikipedia)
15032) Heswall (+'s - name - Wikipedia)

Every two months there is a release for OpenOffice and LibreOffice.

It will be fixed when that happens.

Kind regards,
 >Marco A.G.Pinto
   


On 24/09/2016 13:06, John Willerton wrote:
> Hi All,
>
>
> I read the forum regularly but this is my first post. It's only
> light-hearted but I don't see why that should be against the rules.
>
> Using the spelling checker in LO Writer version 5.0.5.2 on Windows 7 Pro, I
> recently passed over a fairly common English surname, "Ainsworth".
>
> The spelling checker gave some wonderful suggestions,

…

> Has anyone else found some funnies. If so ,why not share them? The forum
> does not have to be grindingly technical all day every day.
>

-- 
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] Spelling check funnies

[Steve Edmonds]

Hi Marco.
I often (not every day) come across missing words, would you like me to 
send these too you or is there a better place to list omissions.

Steve

On 2016-09-26 11:46, Marco A.G.Pinto wrote:

Hello!

I am the en_GB speller maintainer.

I have just added to it:
15023) Ainsworth (+'s - name - Wikipedia)
15024) Bleiler (+'s - name - Wikipedia)
15025) Colburn (+'s - name - Wikipedia)
15026) Chetham (+'s - name - Wikipedia)
15027) Routledge (+'s - name - Wikipedia)
15028) Malkin (+'s - name - Wikipedia)
15029) Potts (+'s - name - Wikipedia)
15030) Slater (+'s - name - Wikipedia)
15031) Crossley (+'s - name - Wikipedia)
15032) Heswall (+'s - name - Wikipedia)

Every two months there is a release for OpenOffice and LibreOffice.

It will be fixed when that happens.

Kind regards,
  >Marco A.G.Pinto



On 24/09/2016 13:06, John Willerton wrote:

Hi All,


I read the forum regularly but this is my first post. It's only
light-hearted but I don't see why that should be against the rules.

Using the spelling checker in LO Writer version 5.0.5.2 on Windows 7 Pro, I
recently passed over a fairly common English surname, "Ainsworth".

The spelling checker gave some wonderful suggestions, namely Wandsworth,
Wadsworth,

AIRWORTHY,

WORDSWORTH,

UNSEAWORTHY and

NEWSWORTHY (my capitalisations).

Has anyone else found some funnies. If so ,why not share them? The forum
does not have to be grindingly technical all day every day.






--
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] Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Philip Jackson]

On 25/09/16 14:21, Brooks wrote:
> I'm formatting a master document.
> 
> My chapter headings are like this:
> "CHAPTER 1
> Blah Blah Blah
> 
> textbody_textbody_etc_etc"
> 
> When I update the master doc LO inserts a page break between the 2 headings
> on separate lines, so:
> "CHAPTER 1"
> .page break
> "Blah Blah Blah
> 
> textbody_textbody_etc_etc"
> 
> If I manually delete the page break, when I update the master doc it gets
> re-inserted.

Just a short query, are you really sure you need the added complexity of
a master document plus chapter documents?

I started out on this basis for a book because it seemed a nice and
logical thing to do. But then found that it was not necessary.

LO Writer can handle easily a technical document with some 15 chapters,
70 diagrams, Table of Contents with 3 or 4 levels, alphabetical index
etc with no difficulty.

Of course your requirements may well be different.

Philip

-- 
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] How to fill in "Read filter criteria from"

[jorge]

Hi Larry and all:

At first you have to copy the headers of your table at you side of you
table for example or at the end if it isn't big.

Then you have to add the filter that you need and put bellow of the
header that you want to filter.

Then run the wizard : Advanced Filter (Before select the table that you
want to filter) and in options you can select where to put the datas
filtereds.

Example:

Table

Province Sells Costs Profits
Alajuela 10 2 8
Puntarenas 20 1 19
Limón 20 4 16
Heredia 10 7 3
San José 20 5 15
Alajuela 10 8 2
Heredia 40 9 31
Puntarenas 50 12 38

Advanced Filter:(Read Filter Criteria From)

Province Sells Costs Profits
> 20 

Results of Advance data Filtereds: 

Province Sells Costs Profits
Heredia 40 9 31
Puntarenas 50 12 38

In this case, we filtered the column Sells to show only Province that
have sells higher than 20

I hope this help,

Jorge Rodríguez



El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: 
> I selected Data>Filter>Advanced Filter; however,
> I had no idea what to do next.  I selected Help button,
> which sent my browser to:
> 
>  
> https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter=en-US=UNIX=5.1#bm_id3151113
> 
> which was, again, no help.
> 
> How do I fill out the "Advanced Filter" dialog?
> 
> -regards,
> Larry
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
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] How to fill in "Read filter criteria from"

[jorge]

Hi  again:

I hope in this way you can see better my last e-mail:

At first you have to copy the headers of your table at you side of you 

> table for example or at the end if it isn't big.
> 
> Then you have to add the filter that you need and put bellow of the
> header that you want to filter.
> 
> Then run the wizard : Advanced Filter (Before select the table that you
> want to filter) and in options you can select where to put the datas
> filtereds.
> 
> Example:
> 
> 
>  Province
> Sells
> Costs
>   Profits
>  Alajuela
>10
> 2
> 8
>Puntarenas
>20
> 1
>19
> Limón
>20
> 4
>16
>   Heredia
>10
> 7
> 3
>  San José
>20
> 5
>15
> Alajuela
>10
> 8
> 2
> Heredia
>40
> 9
>31
> Puntarenas
>50
>12
>38
> Advanced Filter:(Read Filter Criteria From) 
> Province
> Sells
> Costs
> Profits
> 
> 
> 
> > 20
> 
> 
> 
> 
> 
> 
> Results of Advance data Filtereds: 
> Province
> Sells
> Costs
> Profits
> Heredia
>40
> 9
>31
> Puntarenas
>50
>12
>38
> In this case, we filtered the column Sells to show only Province that
> have sells higher than 20




Regards,

Jorge Rodríguez



El sáb, 24-09-2016 a las 11:59 +, jorge escribió: 

> Hi Larry and all:
> 
> At first you have to copy the headers of your table at you side of you
> table for example or at the end if it isn't big.
> 
> Then you have to add the filter that you need and put bellow of the
> header that you want to filter.
> 
> Then run the wizard : Advanced Filter (Before select the table that you
> want to filter) and in options you can select where to put the datas
> filtereds.
> 
> Example:
> 
> Table
> 
> Province Sells Costs Profits
> Alajuela 10 2 8
> Puntarenas 20 1 19
> Limón 20 4 16
> Heredia 10 7 3
> San José 20 5 15
> Alajuela 10 8 2
> Heredia 40 9 31
> Puntarenas 50 12 38
> 
> Advanced Filter:(Read Filter Criteria From)
> 
> Province Sells Costs Profits
> > 20 
> 
> Results of Advance data Filtereds: 
> 
> Province Sells Costs Profits
> Heredia 40 9 31
> Puntarenas 50 12 38
> 
> In this case, we filtered the column Sells to show only Province that
> have sells higher than 20
> 
> I hope this help,
> 
> Jorge Rodríguez
> 
> 
> 
> El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: 
> > I selected Data>Filter>Advanced Filter; however,
> > I had no idea what to do next.  I selected Help button,
> > which sent my browser to:
> > 
> >  
> > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter=en-US=UNIX=5.1#bm_id3151113
> > 
> > which was, again, no help.
> > 
> > How do I fill out the "Advanced Filter" dialog?
> > 
> > -regards,
> > Larry
> > 
> 


-- 
Atentamente,

Jorge Rodríguez

-- 
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: LibreOffice Base and SQLite

[Michael Manning]

Many thanks to Alex for putting me on the right track.

I have also found the information at:
https://crcok.wordpress.com/2014/10/24/using-sqlite-database-with-openoffice-org/


I seemed to have got into a twist with the installation of ODBC and
multiple odbcinst.ini and odbc.ini files in my system.

The possible use of Kexi as a possible simple database system has also been
hightlighted.

cheers

Mike

On 22 September 2016 at 20:05, Alexander Thurgood 
wrote:

> Le 22/09/2016 à 06:41, Michael Manning a écrit :
>
> Hi Michael,
>
> > After installing the various packages, I am not able to run
> >
> >> sudo ODBCConfig
> >
>
>
> Try installing ODBCManageDataSourcesQ4 and its co-application
> ODBCCreateDataSourceQ4. These are QT4 apps, but they worked for me on
> LinuxMint 18.
>
> Alternatively, you can configure the odbcinst.ini and odbc.ini files by
> hand and put them in the appropriate places.
>
> You might also want to bear in mind that not all datatypes available in
> sqlite are correctly supported/interpreted by LibreOffice, even over
> ODBC. This stems from the weak typing of sqlite, which LibreOffice
> doesn't necessarily know how to interpret correctly.
>
>
> Alex
>
>
> --
> 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] How to fill in "Read filter criteria from"

[jorge]

I'm sorry, ... it looks worst 

Jorge Rodríguez




El sáb, 24-09-2016 a las 12:20 +, jorge escribió: 

> Hi  again:
> 
> I hope in this way you can see better my last e-mail:
> 
> At first you have to copy the headers of your table at you side of you 
> 
> > table for example or at the end if it isn't big.
> > 
> > Then you have to add the filter that you need and put bellow of the
> > header that you want to filter.
> > 
> > Then run the wizard : Advanced Filter (Before select the table that you
> > want to filter) and in options you can select where to put the datas
> > filtereds.
> > 
> > Example:
> > 
> > 
> >  Province
> > Sells
> > Costs
> >   Profits
> >  Alajuela
> >10
> > 2
> > 8
> >Puntarenas
> >20
> > 1
> >19
> > Limón
> >20
> > 4
> >16
> >   Heredia
> >10
> > 7
> > 3
> >  San José
> >20
> > 5
> >15
> > Alajuela
> >10
> > 8
> > 2
> > Heredia
> >40
> > 9
> >31
> > Puntarenas
> >50
> >12
> >38
> > Advanced Filter:(Read Filter Criteria From) 
> > Province
> > Sells
> > Costs
> > Profits
> > 
> > 
> > 
> > > 20
> > 
> > 
> > 
> > 
> > 
> > 
> > Results of Advance data Filtereds: 
> > Province
> > Sells
> > Costs
> > Profits
> > Heredia
> >40
> > 9
> >31
> > Puntarenas
> >50
> >12
> >38
> > In this case, we filtered the column Sells to show only Province that
> > have sells higher than 20
> 
> 
> 
> 
> Regards,
> 
> Jorge Rodríguez
> 
> 
> 
> El sáb, 24-09-2016 a las 11:59 +, jorge escribió: 
> 
> > Hi Larry and all:
> > 
> > At first you have to copy the headers of your table at you side of you
> > table for example or at the end if it isn't big.
> > 
> > Then you have to add the filter that you need and put bellow of the
> > header that you want to filter.
> > 
> > Then run the wizard : Advanced Filter (Before select the table that you
> > want to filter) and in options you can select where to put the datas
> > filtereds.
> > 
> > Example:
> > 
> > Table
> > 
> > Province Sells Costs Profits
> > Alajuela 10 2 8
> > Puntarenas 20 1 19
> > Limón 20 4 16
> > Heredia 10 7 3
> > San José 20 5 15
> > Alajuela 10 8 2
> > Heredia 40 9 31
> > Puntarenas 50 12 38
> > 
> > Advanced Filter:(Read Filter Criteria From)
> > 
> > Province Sells Costs Profits
> > > 20 
> > 
> > Results of Advance data Filtereds: 
> > 
> > Province Sells Costs Profits
> > Heredia 40 9 31
> > Puntarenas 50 12 38
> > 
> > In this case, we filtered the column Sells to show only Province that
> > have sells higher than 20
> > 
> > I hope this help,
> > 
> > Jorge Rodríguez
> > 
> > 
> > 
> > El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: 
> > > I selected Data>Filter>Advanced Filter; however,
> > > I had no idea what to do next.  I selected Help button,
> > > which sent my browser to:
> > > 
> > >  
> > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter=en-US=UNIX=5.1#bm_id3151113
> > > 
> > > which was, again, no help.
> > > 
> > > How do I fill out the "Advanced Filter" dialog?
> > > 
> > > -regards,
> > > Larry
> > > 
> > 
> 
> 
> -- 
> Atentamente,
> 
> Jorge Rodríguez
> 


-- 
Atentamente,

Jorge Rodríguez

-- 
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: Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Wiebe van der Worp]

On 25-09-16 15:19, Brooks wrote:

I guess part of the problem is that I do want to have an automatic page
break before each chapter, so yes, page break is on in the text flow tab in
the master document.


Assuming you are working with styles and that you defined your heading 
as starting on a new page, you probably want the same style-sheet for 
the sub-documents and the master.


That is hard to achieve in LO out off the box. But you may want to use 
Template Changer for that, extension: 
http://bugs.documentfoundation.org/attachment.cgi?id=103039


Having exactly the same templates for the master and the sub-documents 
makes life much easier ;-)


--
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] Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Brooks]

Hello (world - 1st post. Many more to come I feel:)

I'm formatting a master document.

My chapter headings are like this:
"CHAPTER 1
Blah Blah Blah

textbody_textbody_etc_etc"

When I update the master doc LO inserts a page break between the 2 headings
on separate lines, so:
"CHAPTER 1"
.page break
"Blah Blah Blah

textbody_textbody_etc_etc"

If I manually delete the page break, when I update the master doc it gets
re-inserted.

So, dear community - how do I fix this please?

Cheers,

Brooks





--
View this message in context: 
http://nabble.documentfoundation.org/Paragraph-Style-Heading-Master-Doc-Inserting-Unwanted-Page-Break-Between-Title-on-Two-Lines-tp4194736.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] Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Ricardo]

El 2016-09-25 14:21, Brooks escribió:

Hello (world - 1st post. Many more to come I feel:)

I'm formatting a master document.

My chapter headings are like this:
"CHAPTER 1
Blah Blah Blah

textbody_textbody_etc_etc"

When I update the master doc LO inserts a page break between the 2 
headings

on separate lines, so:
"CHAPTER 1"
.page break
"Blah Blah Blah

textbody_textbody_etc_etc"

If I manually delete the page break, when I update the master doc it 
gets

re-inserted.

So, dear community - how do I fix this please?

Cheers,

Brooks





--
View this message in context:
http://nabble.documentfoundation.org/Paragraph-Style-Heading-Master-Doc-Inserting-Unwanted-Page-Break-Between-Title-on-Two-Lines-tp4194736.html
Sent from the Users mailing list archive at Nabble.com.


Definition of styles on the master have precedence over styles of the 
same name defined on sub-documents. Check the definition of your heading 
style on the master → Text flow tab to see if there is any automated 
page break set there. If that do not solve the problem, please try to 
create a minimum example (the master and one sub-document with just a 
bit of dummy text) and upload it anywhere so we can see what's going on.


Regards,
Ricardo


--
Il mio blog in italiano: https://ilpinguinoscrittore.wordpress.com/
Mi blog en español: https://elpinguinotolkiano.wordpress.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: Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Brooks]

Hi Ricardo,

Many thanks for the prompt response...

I guess part of the problem is that I do want to have an automatic page
break before each chapter, so yes, page break is on in the text flow tab in
the master document.

As a quick workaround I can just insert whitespace, so the chapter title is
on one line but appears to be below it on the page - it looks wrong though
(like the hack it is:).

Hmm



--
View this message in context: 
http://nabble.documentfoundation.org/Paragraph-Style-Heading-Master-Doc-Inserting-Unwanted-Page-Break-Between-Title-on-Two-Lines-tp4194736p4194742.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: How to fill in "Read filter criteria from"

[Larry Evans]

On 09/24/2016 07:28 AM, jorge wrote:
> I'm sorry, ... it looks worst
>
> Jorge Rodríguez
>
>
>
>
> El sáb, 24-09-2016 a las 12:20 +, jorge escribió:
>
>> Hi  again:
>>
>> I hope in this way you can see better my last e-mail:
>>
>> At first you have to copy the headers of your table at you side of you
Ok.  Did that.  Those are shown in attached in E2:G2
>>
>>> table for example or at the end if it isn't big.
>>>
>>> Then you have to add the filter that you need and put bellow of the
>>> header that you want to filter.
I'm not sure what this means.  When you say "add the filter" I guess
that means under the "select_op" column I should put a comparison
operator such as > or >= or <=.  Is that right?  But where can I put
the logical operators, AND or OR, that are available with the
Standard Filter?
>>>
>>> Then run the wizard : Advanced Filter (Before select the table that you
>>> want to filter) and in options you can select where to put the datas
>>> filtereds.
Where do I find this wizard : Advanced Filter? I looked under
File>Wizards; however, there was no mention Advanced Filter among the
Wizards listed
>>>
>>> Example:
>>>
>>>
>>>  Province
>>> Sells
>>> Costs
>>>   Profits
>>>  Alajuela
>>>10
>>> 2
>>> 8
>>>Puntarenas
>>>20
>>> 1
>>>19
>>> Limón
>>>20
>>> 4
>>>16
>>>   Heredia
>>>10
>>> 7
>>> 3
>>>  San José
>>>20
>>> 5
>>>15
>>> Alajuela
>>>10
>>> 8
>>> 2
>>> Heredia
>>>40
>>> 9
>>>31
>>> Puntarenas
>>>50
>>>12
>>>38
>>> Advanced Filter:(Read Filter Criteria From)
>>> Province
>>> Sells
>>> Costs
>>> Profits
>>>
>>>
>>>
 20

I'm guessing that this is:

  > 20

and it's a row underneath the Province column in the filter table?

>>>
>>>
>>>
>>>
>>>
>>>
>>> Results of Advance data Filtereds:
>>> Province
>>> Sells
>>> Costs
>>> Profits
>>> Heredia
>>>40
>>> 9
>>>31
>>> Puntarenas
>>>50
>>>12
>>>38
>>> In this case, we filtered the column Sells to show only Province that
>>> have sells higher than 20
>>
[snip]
>>>
>>> El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió:
 I selected Data>Filter>Advanced Filter; however,
 I had no idea what to do next.  I selected Help button,
 which sent my browser to:


 
https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter=en-US=UNIX=5.1#bm_id3151113


 which was, again, no help.

 How do I fill out the "Advanced Filter" dialog?

 -regards,
 Larry

[snip]

--
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: Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Ricardo]

El 2016-09-25 15:19, Brooks escribió:

Hi Ricardo,

Many thanks for the prompt response...

I guess part of the problem is that I do want to have an automatic page
break before each chapter, so yes, page break is on in the text flow 
tab in

the master document.

As a quick workaround I can just insert whitespace, so the chapter 
title is
on one line but appears to be below it on the page - it looks wrong 
though

(like the hack it is:).


Thus, I do not understand your problem ;)

On your first message it seemed that you had an unwanted page break, but 
on the second you said that there must be a page break but somehow that 
page break is "wrong" on the master and that you are "fixing" it by 
inserting some space... on the subdocuments or in the master?


So, can you please provide a sample file that shows the problem? AFAIK, 
this list do not accept attachments so you need to upload it somewhere 
else.


Regards,
Ricardo





Hmm



--
View this message in context:
http://nabble.documentfoundation.org/Paragraph-Style-Heading-Master-Doc-Inserting-Unwanted-Page-Break-Between-Title-on-Two-Lines-tp4194736p4194742.html
Sent from the Users mailing list archive at Nabble.com.


--
Il mio blog in italiano: https://ilpinguinoscrittore.wordpress.com/
Mi blog en español: https://elpinguinotolkiano.wordpress.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: How to fill in "Read filter criteria from"

[Larry Evans]

On 09/25/2016 09:39 AM, Larry Evans wrote:


On 09/24/2016 07:28 AM, jorge wrote:

I'm sorry, ... it looks worst

Jorge Rodríguez




El sáb, 24-09-2016 a las 12:20 +, jorge escribió:


Hi  again:

I hope in this way you can see better my last e-mail:

At first you have to copy the headers of your table at you side of you

Ok.  Did that.  Those are shown in attached in E2:G2

OOPS.  I should have read:

https://wiki.documentfoundation.org/Netiquette#Avoid_Attachments

The .png file showing this, as well as the actual .odf file,
can be found at these links:

https://www.dropbox.com/s/5uosutupnclnxrg/find_transaction.advanced_filter.png?dl=0

https://www.dropbox.com/s/da11qtifkes1q01/find_transactions.ods?dl=0

Hope this makes things clearer.

[snip]



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

[Dave]

Can someone tell me what Writer defines as "Objects"? The term seems to
be loosely and often inaccurately used in menus and the "Help" facility.

For example, drawing items appear to be defined a "Objects", but then so
do frames.

According to the "Help" facility:
"Objects;Definition
An object is a screen element containing data. It can refer to
application data, such as text or graphics.
Objects are independent and do not influence each other. Any object
containing data can be assigned certain commands. For example, a graphic
object has commands for image editing 8<-- snip -->8 ."

A totally inaccurate and contradictory "garbled" statement in itself.

In the "Help" facility, the "Selecting;Objects" section also makes
totally false, inaccurate and meaningless claims about selecting and
grouping *ALL* those things claimed to be "Objects".

AFAICT the only genuine Writer "Objects" are "Drawing Objects". Does
anyone know of any other genuine Writer "Objects"?

Dave

-- 
Please address any reply to the mailing list only. Any messages sent to
this noreply@ address are automatically deleted from the server and will
never be read.

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