Re: [libreoffice-users] [Numbers]

[Brian Barker]

At 13:52 16/10/2016 -0400, Doug McNutt wrote:
... I learned that there are two kinds of numbers: Cardinals include 
a zero, decimal points, and negatives. [...] Ordinals, or "counting 
numbers" start at +1 and do not understand fractional parts such as 
1.5. There is no zero.


No, ordinal numbers are those representing an order, i.e. first, 
second, third, ... instead of one, two, three, ... . Your distinction 
here is between "real" numbers - which can have any value - and 
"integers". Integers have no fractions, but they can be zero or negative.


I just picked up a recent technical book ... . The first few pages 
are called the PREFACE and the page numbers therein are noted in 
lower case Roman numerals like iv, v, vi, viii.


It is standard, of course, for books to have three parts: a title 
page, what is called "front matter", and the main text. And it is 
usual for front matter to be numbered using lower case roman numerals 
and the main text using arabic numbers.



Can LibreOffice do that?


Of course. Page numbers are a property of page styles, so you just 
need separate styles for each part. And there are a number of arabic, 
roman, and cyrillic styles for page numbers.



The first page would have to be i because there is no zero.


Surely the first page is i because it is the first page, not the 
zeroth one! In fact, the title page is usually considered the first 
page but unnumbered, so the front matter will start with ii (or 
possible later).


Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Master Document Chapters Auto-numbering

[Ricardo]

El 2016-10-16 19:52, Doug McNutt escribió:




I just picked up a recent technical book with paper pages and no
pushbuttons.  The first few pages are called the PREFACE and the page
numbers therein are noted in lower case Roman numerals like iv, v, vi,
viii. Can LibreOffice do that? The first page would have to be i
because there is no zero.


Sure. Just modify the page style used on the preface, go to the "Page" 
tab and under "Page layout" select the kind of page numbers you need 
from the "Page numbers" drop down menu.







--
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] Master Document Chapters Auto-numbering

[Doug McNutt]

The problem of counting has been a pain of my life. As a mathematics and 
physics student I learned that there are two kinds of numbers:


Cardinals include a zero, decimal points, and negatives. If you want the 
length of a fence you had better start counting posts with number zero. 
The common 12 inch ruler uses cardinals.


Ordinals, or "counting numbers" start at +1 and do not understand 
fractional parts such as 1.5. There is no zero. Algebra never uses them 
in a formula. They also are the only numbers in the Roman numerals of 
IVCLM fame. That permitted the Arabs, with their cardinals, to beat out 
the Romans with their inability to calculate interest rates.


I just picked up a recent technical book with paper pages and no 
pushbuttons.  The first few pages are called the PREFACE and the page 
numbers therein are noted in lower case Roman numerals like iv, v, vi, 
viii. Can LibreOffice do that? The first page would have to be i because 
there is no zero.


It's not so bad as one might think but it probably advances the logic of 
those who believe the 20th century ended in December 2001.  Somewhere on 
the WWW I found that the Christian era started in such a way that there 
was no +0 or -0 on either side of the famous birth. Those two years, of 
365 days each, do not exist if you're chasing ancestors.


On 10/16/2016 10:34 AM, Julian Brooks wrote:

Thanks both so much, great info.

Will check the doc now Robert and report back on how it all transpires.





--
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: Apostrophe prepended to MM/DD/YYYY

[Jean-Francois Nifenecker]

Hi Tom,

Le 11/10/2016 19:10, Tom Davies a écrit :


Can find&replace get rid of the ' marks to make the values revert to
'numbers/dates' rather than being forced into being text?


Nope.

But you may fix that after the import process has run without having to 
relaunch it.


-- Just select the offending column
-- Go to  Data > Text to columns.
You'll get into a dialog similar to the text import one.
-- Go to the lower panel and select the column by clicking its heading.
-- In the Column type list, select the appropriate format for the data. 
Here, it would be Date (YMD).

-- Click OK.

You're done.

HTH,
--
Jean-Francois Nifenecker, Bordeaux


--
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 change Writer form letter database connection

[Gary Dale]

Thanks Paul. You're right, that does work. However it begs the question 
of why bother to bring up the database selection dialogue in the initial 
Mail Merge panel - especially given that it doesn't actually work?


IMHO the Edit | Exchange Database menu item is a travesty that should be 
removed. Instead the database selection dialogue in the Mail Merge panel 
should be used at run time to select the database/query rather than just 
the specific records.


I will further note that having to go through arcane gyrations to change 
the query is also nuts. A common use case to have multiple different 
queries that can be associated with a specific form letter. Each query 
would be given a meaningful name and the secretary / office 
administrator who is responsible for the getting the letters out selects 
the appropriate one.


Again, this functionality appears to be present in the Mail Merge panel 
but doesn't work.


Or to put it in more direct terms, the database/query selection should 
be part of the mail merge operation, not part of the document 
definition. The document should contain simply the database field name.




On 14/10/16 11:20 AM, Paul D. Mirowsky wrote:
In my circumstance, I am copying over an old database to a new one and 
changing the name. Then I add new data to the new database. After that 
I update the query to access the new data only.


I copy over to a new database as a way to remove old records (data) 
and keep Base from losing it when it has to many records. No data lost 
and old data is stored away.


In every case, in Writer, from the menu , I 
select the new database and select the new query. All fields update 
appropriately except  which I do manually.


As I understand it, if you are not changing database or fields. You 
should be able to just update your query to select the records you want.


Hope this helps.


On 10/13/2016 4:46 PM, Gary Dale wrote:

On 12/10/16 11:00 AM, Paul D. Mirowsky wrote:

Are the field names identical from original to newer data?

Are you creating new/updated queries?

I'm always switching to new single source databases from boilerplate 
Writer and haven't had a problem. I have not tried multiple sources 
though.


Also beware that while the fields may update to the new data, record> has to be applied manually.  (Seems to be true in most 
versions of LibreOffice).


I'm using a Base database (pasted the data in from a spreadsheet so I 
could run queries that were apparently too complex for simple 
conditional text). The field names haven't changed. If they did, then 
I would expect that I'd have to update the merge document.


When I View | Field Names (ctrl-F9), I not only see the database name 
for both the old database (in the fields that I haven't updated 
manually) and the new database (in the fields that I did re-insert to 
this year's database) but also the name of the query that was used.


This is absurd. The form letter should just contain the name of the 
fields and let the user select which database and/or query they wants 
to use. As it stands, I am apparently required to not only stick with 
the same database but also keep the same query name.


Even the menu item (Field Names) seems to be poorly thought out. 
Toggling it switches the view from just the Field Names to the full 
database, query, Field Names. In both cases I see Field Names. It 
probably should be named "Query Path" - although as I have stated, 
the document shouldn't even use that information.








--
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] Master Document Chapters Auto-numbering

[Julian Brooks]

Thanks both so much, great info.

Will check the doc now Robert and report back on how it all transpires.

Cheers,

Julian

On 16 October 2016 at 15:04, Robert Großkopf 
wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Julian,
>
> > 1. My Master Documents chapters numbering always starts from 1 -
> > how can this run concurrently for chapter1, chapter 2 etc etc.?
> >
> > 2. My introductory chapter has several subheadings, with the
> > proviso of the above, how can I auto-number my introductions
> > subheadings (0.1, 0.1.1 etc.)?
>
> Have tested all these. Could it be you have set the style for the
> headings beginning with '1'.
>
> Have uploaded a file. Hope it shows how it works:
> http://robert.familiegrosskopf.de/download/MasterDoc.zip
>
> Regards
>
> Robert
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJYA4jbAAoJELDKYwaoS9AIJpgP/3Gm+8pPlO2Pm1XIGRUHheN9
> iG49tD5c+d4c6Gx0eE2EXDB5fIu9bEwV1xHiA++w8zi1tjE8t1yhBkH8TA7BxSBn
> 6e/21QcyICwzSUCgb7aD840NhrrN6Dw24GlxhjUROc881CKuJsKimA9GQnOUk0gc
> ybi3DAWpbfQxrhMmzdviSKV9NHcwj1UAAeegWQ5IbNMsYrfPVYFUZwXwUCCpIrMF
> 8h40adxWLmuPSd1WYTOknLSsbC77N8PRCGtY9GgwyUX9YcklmR7YiQXS1utoOILC
> pvNAUYjt+L1ugYpuoW5BnVJLNNPSQFJF0986a+dZG0R5BAGc4FSXEfjls5zvPTHa
> qDRfy5VbYonTeciNV+mdLzm22nrEWrk/E6XnM+JehhgQSikSmyvfyFn/3iH6aOzF
> i/2idmSdWWcjLS8Y+n0F2WxohIgKLQfddfHQ62YPqSoVPbJzecnM8d0QDic0+hnc
> yH4dUwkdfslc4PHhzqwoFrYug0Th48SvdTMeabdYFNyXXtickIDgyf/0Hfm/L6pP
> +lnTa/TGeEvxeaGW7ExspRoTkzmeNDenDGW5vBW6K9sWd0YbSldA2cNNs2ihu1D1
> ZgiNMpu0Q2s71tIFTXb2XZ3UdLAoebaXgfcmH8q5f8NtBaswv2hoPJqWVwNCfstj
> qKHwshJ8NoGrOsZJo2Xy
> =/mZB
> -END PGP SIGNATURE-
>
> --
> 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] Master Document Chapters Auto-numbering

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Julian,

> 1. My Master Documents chapters numbering always starts from 1 -
> how can this run concurrently for chapter1, chapter 2 etc etc.?
> 
> 2. My introductory chapter has several subheadings, with the
> proviso of the above, how can I auto-number my introductions
> subheadings (0.1, 0.1.1 etc.)?

Have tested all these. Could it be you have set the style for the
headings beginning with '1'.

Have uploaded a file. Hope it shows how it works:
http://robert.familiegrosskopf.de/download/MasterDoc.zip

Regards

Robert

-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYA4jbAAoJELDKYwaoS9AIJpgP/3Gm+8pPlO2Pm1XIGRUHheN9
iG49tD5c+d4c6Gx0eE2EXDB5fIu9bEwV1xHiA++w8zi1tjE8t1yhBkH8TA7BxSBn
6e/21QcyICwzSUCgb7aD840NhrrN6Dw24GlxhjUROc881CKuJsKimA9GQnOUk0gc
ybi3DAWpbfQxrhMmzdviSKV9NHcwj1UAAeegWQ5IbNMsYrfPVYFUZwXwUCCpIrMF
8h40adxWLmuPSd1WYTOknLSsbC77N8PRCGtY9GgwyUX9YcklmR7YiQXS1utoOILC
pvNAUYjt+L1ugYpuoW5BnVJLNNPSQFJF0986a+dZG0R5BAGc4FSXEfjls5zvPTHa
qDRfy5VbYonTeciNV+mdLzm22nrEWrk/E6XnM+JehhgQSikSmyvfyFn/3iH6aOzF
i/2idmSdWWcjLS8Y+n0F2WxohIgKLQfddfHQ62YPqSoVPbJzecnM8d0QDic0+hnc
yH4dUwkdfslc4PHhzqwoFrYug0Th48SvdTMeabdYFNyXXtickIDgyf/0Hfm/L6pP
+lnTa/TGeEvxeaGW7ExspRoTkzmeNDenDGW5vBW6K9sWd0YbSldA2cNNs2ihu1D1
ZgiNMpu0Q2s71tIFTXb2XZ3UdLAoebaXgfcmH8q5f8NtBaswv2hoPJqWVwNCfstj
qKHwshJ8NoGrOsZJo2Xy
=/mZB
-END PGP SIGNATURE-

-- 
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] Master Document Chapters Auto-numbering

[Ricardo]

Hi!

El 2016-10-16 13:21, Julian Brooks escribió:

HI again,

I have a couple of questions regarding auto-numbering.

Apologies in advance if this has already been answered - I've spent 
umpteen
hours attempting to sort this over several days on and off, pouring 
through

documentation and the archives.

Two questions:

1. My Master Documents chapters numbering always starts from 1 - how 
can

this run concurrently for chapter1, chapter 2 etc etc.?


That's weird, because it should be as you want by default. Without 
seeing the actual document it is quite difficult to guess what's wrong. 
Check if the styles selected on Tools → Outline numbering are the same 
on Master and subdocuments.




2. My introductory chapter has several subheadings, with the proviso of 
the
above, how can I auto-number my introductions subheadings (0.1, 0.1.1 
etc.)?


That's not easy, sorry. It seems Writer belong to the school of thinking 
that says "zero is not a natural number" so even if there is no numbered 
heading before, a subheading will start with "1.1" instead of 0.1.


If you really want a leading zero, I think your only chance is to fake 
the numbering. Remember that you can set an "outline level" to any 
paragraph style on the "Outline and numbering" tab of the style 
definition, so you can "clone" the first and second level paragraph 
styles used on the rest of the document, set those clones to get outline 
level 1 and 2 and then fake the numbering either by writing them by hand 
or by using a sequence field.


You'll need to later fix the TOC, though




Cheers,

Julian


--
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] Multiple Page Margins in Template for Large Document (ToC)

[Virgil Arrington]

As they say in the NFL, upon further review, I realize I didn't use section 
breaks but rather manual page breaks. I think I was confusing my technique with 
LO with my technique with MS-Word. Sorry for my own confusion.

Virgil

On 10/15/2016 10:24 PM, Julian Brooks wrote:
Thanks Virgil, look forward to reading the doc.

After some more investigation I think much of my woe stemmed from having the 
'no manual editing' tickbox selected in the ToC (the ol' user-error issue eh:).

Still having some issues with appendices though, so appreciate your assistance.

Regards,

Julian

On 16 October 2016 at 02:36, Virgil Arrington 
mailto:cuyfa...@hotmail.com>> wrote:
If I understand your question, I've used section breaks and page styles
to achieve different page formatting. I've never used a master document
as I've never written anything long enough to justify it, but for my
longer documents, I set it up this way.

Title page -- using a page style I call TitlePage

(section break)

Front matter (table of contents, etc.) using a page style called FrontMatter

(section break)

Main matter (body of my document) using my standard page style (or if
it's double sided, I may have different page styles for right and left
sided pages.

With each section break, I reset the page numbering to "1," using lower
case roman numerals for the front matter and Arabic numbers for the main
body.

Hope this helps.

I'll email you directly a sample document showing my page styles, etc.

Virgil


On 10/15/2016 7:30 AM, Julian Brooks wrote:
> Hi all,
>
> With a huge nod of appreciation to Virgil, I've managed to start building a
> thesis template. This I'll push to the list when done.
>
> I have another question though:
>
> In my large Master doc I've now got margins for the text chapters that I
> really like. Unfortunately this really doesn't look good for the ToC, which
> is now way too squished (there's also a couple of the appendices that are
> now borked).
>
> How can I edit certain pages so they can have minimal margins. Something
> like the title page but can't use the title page as that ruins the page
> numbering.
>
> Also is there weird rules with it being the ToC? I don't want to finalise
> the ToC (ie make a copy) as it's still in flux.
>
> So change the page margins whilst keeping the flexibility that makes the
> ToC so good in the first place? Then I'll move onto the appendices:)
>
> Regards to all,
>
> Julian
>


--
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] Master Document Chapters Auto-numbering

[Julian Brooks]

HI again,

I have a couple of questions regarding auto-numbering.

Apologies in advance if this has already been answered - I've spent umpteen
hours attempting to sort this over several days on and off, pouring through
documentation and the archives.

Two questions:

1. My Master Documents chapters numbering always starts from 1 - how can
this run concurrently for chapter1, chapter 2 etc etc.?

2. My introductory chapter has several subheadings, with the proviso of the
above, how can I auto-number my introductions subheadings (0.1, 0.1.1 etc.)?

Cheers,

Julian

-- 
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] DisposedException at queryInterface

[brooke]

I use Ubuntu 16.04, Tomcat 8, PHP 7, JavaBridge 6.2.1, Libreoffice
5.14. Below is my codings.

$ComponentContext=Java("com.sun.star.comp.helper.Bootstrap")->bootstrap(array("--nologo","--nodefault","--norestore","--nolockcheck","--headless"));
$ServiceManager=$ComponentContext->getServiceManager();
$Desktop=$ServiceManager->createInstanceWithContext("com.sun.star.frame.Desktop",$ComponentContext);

Everything is still OK...

$ComponentLoader=Java("com.sun.star.uno.UnoRuntime")->queryInterface(Java("com.sun.star.frame.XComponentLoader")->class,$Desktop);

Here I got "com.sun.star.lang.DisposedException".

I run "ps -aux" and found that soffice was still running.

tomcat8    941  0.0  0.0 206168  3372 ?    Sl  
10:24   0:00 /usr/lib/libreoffice/program/oosplash
--accept=pipe,name=uno6335492298840663686;urp; --nologo --nodefault
--norestore --nolockcheck --headless
tomcat8    982  0.0  0.3 923312 55924 ?    Sl  
10:24   0:00 /usr/lib/libreoffice/program/soffice.bin
--accept=pipe,name=uno6335492298840663686;urp; --nologo --nodefault
--norestore --nolockcheck --headless
tomcat8    983  0.0  0.0  0 0 ?   
Z    10:24   0:00 [soffice.bin] 

How could I find out what's wrong?

Brooke


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