[libreoffice-users] LO Base

2016-07-30 Thread Dale Erwin

I have a question about Base:

I used to work with standalone HSQLDB using Java on the OS/2 (eCS) 
platform.  During that time, it was announced that Sun's upcoming 
release of Open Office would include HSQL as the builtin database 
engine.  I have recently read that Open Office no longer uses HSQL. Is 
that also true of LO?


If HSQL is indeed the builtin database engine, is it really necessary to 
have another database product to do database work in LO Base?


I stopped using eCS a few years ago when the (at the time) latest 
version would not install on my new computer.  I am now using Windows 10 
(which I literally despise).


Dale Erwin

--
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: [MariaDB Announce] MariaDB Galera Cluster 10.0.12 GA and MariaDB 10.1.0 Alpha now available

2014-07-05 Thread Dale Erwin

On 7/4/2014 11:40 PM, Owen Genat wrote:

NoOp wrote

On 07/04/2014 12:37 AM, Tom Davies wrote:

Hi :)
There are a few reasons;
*  Base needs an external back-end but most new users wont be aware of
that

Interesting. I never knew that Base needs an external back-end...
Perhaps you can get the documentation folks to add that to the help
files and the Base docs

This will be unlikely to happen in the short term as the so-called split
configuration is considered to be for experts only. The idea behind the
embedded configuration (i.e., a database back-end inside an ODF container)
was developed to mask some of the database back-end detail and for
portability. While simpler, the embedded configuration is reported as
suffering greater data loss / corruption issues, due to the nature of the
packaging.

There are numerous threads over on the Apache OO forum about problems with
the embedded configuration. There is also a lengthy and detailed discussion
about  Base / ODF container portability
http://en.libreofficeforum.org/node/7876   that provides several links to
the mentioned Apache OO forum threads. Summary: In order for a split
configuration to become more widespread it would be ideal for some sort of
pack-n-go facility to be developed for Base to allow greater portability of
data in a manner more in keeping with office documents.


I thought Base had HSQLDB built into it, but COULD use a different back 
end if desired.  The only drawback I can see to using HSQLDB is that it 
needs to be accessed from a Java environment.  I have used standalone 
HSQLDB in Java apps and found it to be very robust and surprisingly fast 
in light of the fact that Java is an interpreted language.


Dale Erwin

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

2014-04-23 Thread Dale Erwin
I was searching via google for LO documentation and I found 
WG40-WriterGuideLO.pdf.  However, when I clicked on it, I received a 
document with 468 blank pages.


This was the URL: 
https://wiki.documentfoundation.org/images/3/35/WG40-WriterGuideLO.pdf


Dale Erwin

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

2014-04-23 Thread Dale Erwin

On 4/23/2014 4:49 PM, Dale Erwin wrote:
I was searching via google for LO documentation and I found 
WG40-WriterGuideLO.pdf.  However, when I clicked on it, I received a 
document with 468 blank pages.


This was the URL: 
https://wiki.documentfoundation.org/images/3/35/WG40-WriterGuideLO.pdf


Dale Erwin

Never mind... I connected from a different link and this time the 
document was populated.


Dale Erwin

--
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: Fwd: Why new page style after manual page break changes all pages?

2014-04-22 Thread Dale Erwin

On 4/22/2014 7:35 AM, Nino Novak wrote:

On 21.04.2014 22:30, Dale Erwin wrote:

[...]


I have never had this problem and have never had the need to create
sections.  Maybe it's because I always use page styles alternating from
right page to left page and back.  For instance, I begin a book with a page
style called Title, marked as right page only and set the next page style
to Copyright.  I set the Copyright style to left page only and the next
style as FrontMatterRight.  I set the FrontMatterRight style to right page
only and next style as FrontMatterLeft and set the FrontMatterLeft style to
left page only and next style to FrontMatterRight.  This puts me in a loop,
and to break out of the loop I insert a manual page break and check the
option to change the style.  I also set the FrontMatter styles to use lower
case roman numerals for page numbering and I can change the page numbering
at the same time as I break out of the loop with the insert manual page break.

Isn't what you describe exactly creating sections (even if you call it page
break with changing style or whatever)?

Nino


I should hope not.  On the Insert menu there is an option for Manual 
Break and an option for Section.  Why would that be considered the same 
thing?  And, if it is, why are two options necessary?


Dale Erwin

--
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: Fwd: [libreoffice-users] Why new page style after manual page break changes all pages?

2014-04-21 Thread Dale Erwin

On 4/21/2014 7:55 AM, Kevin O'Brien wrote:

Got caught by that misconfigured reply again.g


-- Forwarded message --
From: Kevin O'Brien zwiln...@gmail.com
Date: Mon, Apr 21, 2014 at 8:54 AM
Subject: Re: [libreoffice-users] Why new page style after manual page
break changes all pages?
To: Sean Darcy seandar...@gmail.com


By design, a Page Style will normally affect the entire document. If
you want to have different parts of the document use different Page
Styles, I would suggest that you create Sections. Each section can
have its own Page Style.


I have never had this problem and have never had the need to create 
sections.  Maybe it's because I always use page styles alternating from 
right page to left page and back.  For instance, I begin a book with a 
page style called Title, marked as right page only and set the next 
page style to Copyright.  I set the Copyright style to left page only 
and the next style as FrontMatterRight.  I set the FrontMatterRight 
style to right page only and next style as FrontMatterLeft and set the 
FrontMatterLeft style to left page only and next style to 
FrontMatterRight.  This puts me in a loop, and to break out of the loop 
I insert a manual page break and check the option to change the style.  
I also set the FrontMatter styles to use lower case roman numerals for 
page numbering and I can change the page numbering at the same time as I 
break out of the loop with the insert manual page break.


I find this necessary because I set my margins on right pages to have a 
larger margin on the left and on left pages to have a larger margin on 
the right.  This is for binding purposes.


Dale Erwin

--
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] Creating an Index

2014-04-17 Thread Dale Erwin
Could someone please point me to documentation that will explain how to 
create and maintain an index?  Thanks.


Dale Erwin

--
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] Modifying Styles

2014-03-30 Thread Dale Erwin
I was beginning to think I was going crazy.  I tried to modify 2 page 
styles in three different documents so that I could copy from one to the 
other without destroying the format.  After several attempts, I was 
still getting a different format when I copied from one file to 
another.  It turns out that if you don't save the document, the changes 
to the style are also not saved.


The odd part of this is that it is possible to close the file with no 
prompt for saving changes.  Now if I make a change to the text of a 
document, then try to close the file, I will get a prompt to either save 
or discard my changes, but I got no such prompt after changing styles 
with no change to the text.  Even more odd is that the save option is 
greyed out (inactive) unless a change has been made and it is not greyed 
out after changing a style even without changing text.


Dale Erwin

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

2014-03-25 Thread Dale Erwin

On 3/25/2014 12:19 PM, Toki wrote:

On 3/24/2014 5:27 PM, Virgil Arrington wrote:
I'm wondering if there is a way to define a field as the first word on
 the page and the last word on the page (like in a dictionary).

In the last decade, there have been roughly a dozen requests to 
various mailing lists for a feature along those lines.  Usually, but 
not always, it is related to dictionary construction.


The workarounds I'm aware of, have placed either the first word of the 
first new paragraph, or the first word of the last paragraph of the 
previous page, in the page header.




The only way I see possible to do this is to have a separate style for 
each page of the book.  Otherwise, every header of every page within a 
particular style always has the same text and formatting. If you change 
it on a succeeding page, all previous pages are also changed as long as 
they are governed by the same page style.


Dale Erwin

--
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 Documents, Office Suites, and the Underwood

2014-03-25 Thread Dale Erwin

On 3/25/2014 1:55 PM, Virgil Arrington wrote:
I imagine that there are, indeed, legitimate reasons why someone would 
want to control a master document through the sub-documents, but I 
would strongly suggest that before going that route, the user 
completely learns how to use the master documents the way they were 
designed. In the process, they just might find what they're looking 
for. I can't tell you the number of times I have found myself using 
LyX or Atlantis, or some other program because I believed it couldn't 
be done with LO. Then after a little self-education, I find that it, 
indeed, *can* be done with LO, and I just wasted a lot of time using 
another program.


My larger point, to which I still hold, is that far too many people do 
not take full advantage of their computers. Now, you might say this is 
a matter of personal preference, and so it is. But, in my profession 
(law), if a client is paying his lawyer $200.00/hour to write a legal 
brief, he'll save money if the lawyer learns how to fully use 
templates and styles. I've watched lawyers spend hours (at $200 a 
crack) typing a table of authorities, when MS Word or WordPerfect can 
automatically generate one in minutes. So, in *some* instances, our 
personal preferences *can* affect other people.


And, my second point was that people continue to use less effective 
methods because office suites continue to make them available in their 
attempts to be one size fits all programs. While I agree it is 
necessary for them to remain marketable, I think it is unfortunate. 


I admit that I, too, grew up using a typewriter and was an IBM mainframe 
programmer, and as such could not really see any need to use styles.  
Then I got involved in constructing documents by collaborating with 
co-authors located in various locations.  This gave rise to the use of 
master documents and showed me the error of my ways.  I also admit that 
even though I use page styles in my master document creation, I've never 
been able to understand how to use the paragraph and character styles 
and suspect that this might be limiting my formatting ability in LO.  I 
tried to define a paragraph style but had no luck.  How would you define 
a paragraph style to handle a dictionary entry such as this:


*canuscere*/v.t./ to know, to be familiar with.



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

2014-03-25 Thread Dale Erwin

On 3/25/2014 3:34 PM, Virgil Arrington wrote:


On 3/25/2014 3:38 PM, Dale Erwin wrote:


The only way I see possible to do this is to have a separate style
for each page of the book.  Otherwise, every header of every page
within a particular style always has the same text and formatting. If
you change it on a succeeding page, all previous pages are also
changed as long as they are governed by the same page style.

Dale Erwin



Not if there could be a field defined as the first (or last) word on
the page. You would insert the appropriate Field Name in the header,
and then the actual text would change from page to page without a need
for a new style. That's what fields do, like page numbers.

Virgil


Yes, but there is more to it than just the first word and the last word. 
 The first word is straightforward enough, except that sometimes it 
might consist of more than just one word.  But the last word does not 
refer to the actual last word on the page, but the last headword of a 
dictionary entry which also might sometimes consist of more than one 
word.  But it's moot since there are no such fields available.


Dale Erwin

--
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 Documents, Office Suites, and the Underwood

2014-03-25 Thread Dale Erwin

On 3/25/2014 2:55 PM, Dale Erwin wrote:

On 3/25/2014 1:55 PM, Virgil Arrington wrote:
I imagine that there are, indeed, legitimate reasons why someone 
would want to control a master document through the sub-documents, 
but I would strongly suggest that before going that route, the user 
completely learns how to use the master documents the way they were 
designed. In the process, they just might find what they're looking 
for. I can't tell you the number of times I have found myself using 
LyX or Atlantis, or some other program because I believed it 
couldn't be done with LO. Then after a little self-education, I find 
that it, indeed, *can* be done with LO, and I just wasted a lot of 
time using another program.


My larger point, to which I still hold, is that far too many people 
do not take full advantage of their computers. Now, you might say 
this is a matter of personal preference, and so it is. But, in my 
profession (law), if a client is paying his lawyer $200.00/hour to 
write a legal brief, he'll save money if the lawyer learns how to 
fully use templates and styles. I've watched lawyers spend hours (at 
$200 a crack) typing a table of authorities, when MS Word or 
WordPerfect can automatically generate one in minutes. So, in *some* 
instances, our personal preferences *can* affect other people.


And, my second point was that people continue to use less effective 
methods because office suites continue to make them available in 
their attempts to be one size fits all programs. While I agree it 
is necessary for them to remain marketable, I think it is unfortunate. 


I admit that I, too, grew up using a typewriter and was an IBM 
mainframe programmer, and as such could not really see any need to use 
styles.  Then I got involved in constructing documents by 
collaborating with co-authors located in various locations.  This gave 
rise to the use of master documents and showed me the error of my 
ways.  I also admit that even though I use page styles in my master 
document creation, I've never been able to understand how to use the 
paragraph and character styles and suspect that this might be limiting 
my formatting ability in LO.  I tried to define a paragraph style but 
had no luck.  How would you define a paragraph style to handle a 
dictionary entry such as this:


*canuscere*/v.t./ to know, to be familiar with.



I see my formatting was lost on that example.  The headword canuscere 
would be in 11 pt. boldface, while the rest of the line would  be in 9 
pt. normal, except that the v.t. would be italicized.



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

2014-03-24 Thread Dale Erwin

On 3/24/2014 2:51 PM, Tom Davies wrote:

Hi :)
Is it possible to completely disable all the styles in a master
document so that the ones from the sub-document do remain untouched?
Regards from
Tom :)
That should not be necessary if you follow the instructions for creating 
a master document.  First you create a template which has all the styles 
defined in it.  Then the master document and all subdocuments are 
created from this template.  The only problem is that if changes to any 
style becomes necessary, I've not found any way to make the changes in 
one place and have them take effect in all files which were alreated 
created before the changes were made. Up to now, I've had to make such 
changes in the template as well as in each file which has already been 
created from the template.



On 24 March 2014 09:31, Tom Davies tomc...@gmail.com wrote:

Hi :)
Arrgh, that approach sounds like it might be worth creating a new
master document and then
1.  import the existing master document into that (in the way Cley described)
2.  go into styles and modify the important ones to rename them

3.  use Cley's advice to import the styles from the first sub-document
4.  again rename the important changed styles

5  repeat 34 for each sub-document

This almost certainly wont be perfect first time so don't aim to do to
much or be too perfect, just treat it as a test-run to find out which
styles need to be renamed.

Regards from
Tom :)





On 24 March 2014 07:53, Cley Faye cleyf...@gmail.com wrote:

2014-03-22 21:04 GMT+01:00 Dale Erwin dale.er...@casaerwin.org:


Is there some reason why the master document does not render the
sub-documents in the same was as they are rendered when opened separately?


One possibility is that there is a style conflict/override.
Master document's styles override sub-document's. If you have the same
stule name in both the master document and the sub document, you will see
the master document's version only.

This is usually a neat feature (you can produce various output style for
the same sub-document), but might be a bit confusing. Even more confusing
is that this include page styles too, and that point is easily overlooked.

If you simply want all styles in the master document to be the same as in a
sub-document, you can try this: open the master document, open the format
list if not already open. In the style and format toolbar (or sidebar),
there is a button in the top-right corner (probably called new style from
selection in english). Click it, and select load styles, then from a
file, then select one of your sub-document.
These step should replace all styles in the master document with the one
in the sub-document. If this does fix your issue, remember to change only
styles in the master document to keep all of them in sync.

Of course, if that's not the issue at hand, feel free to dismiss my little
rant :)


--
Cley Faye
http://cleyfaye.net

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

2014-03-22 Thread Dale Erwin

Using LibreOffice 4.1.5 on Win 7 home premium:

I have a master document with 50 sub-documents.  The problem I am having 
is that the sub-documents are not rendered the same way when opened 
separately as when opened in the master document.


This is a bilingual dictionary with an English-Neapolitan section and a 
Neapolitan-English section.  Each letter of each section is contained in 
its own sub-document.  For each letter, at the top of the page, on left 
(even numbered) pages, there appears the first word on the page, 
left-justified, in slightly larger font, and on right (odd numbered) 
pages, the last word on the page, right-justified and in slightly larger 
font.


This cannot be accomplished using headers since it must be different on 
each page.  Well, I suppose it could be accomplished using headers but 
it would require a separate style for every page in the nearly 400 page 
book.  Consequently, I have used the first line on each page for this 
purpose with the regular text pushed down and beginning on the fourth line.


This has a very aesthetically pleasing appearance in the sub-documents, 
but in the master document the line spacing is obviously not rendered in 
the same way so that on some pages in the master document, the first 
line will be what was the last line in the previous page of the 
sub-document, pushing the headline word down... and obviously unusable.


Is there some reason why the master document does not render the 
sub-documents in the same was as they are rendered when opened separately?


Dale Erwin

--
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] mysterious foreign key integrity constraint violation

2013-12-30 Thread Dale Erwin
You could resolve this with a foreign key in the Products table (would 
require a new field) in which you store the primary key of the 
applicable row in the suppliers table.  This way one supplier could 
supply more than one product. However, this would not cover the case 
where one product can be supplied by more than one supplier.  For that 
you would need a third table just to handle the many-to-many relationship.


On 12/30/2013 6:39 PM, Larry Evans wrote:

I've 2 tables:

Table:Products with ProductName as primary key.
ProductName Inventory
--- -
product1  100
product2  200

Table:Suppliers with SupplierName as primary key.
SupplierName PhoneNumber
 ---
supplier1  111-
supplier2  222-

when I attempt to create a relationship:
  SupplierSuppliesProduct
between them, using the ToolsRelationship menu selection,
I get a Relation Design window with
both Tables and their fields displayed in the upper left.
In that window, I select the InsertNew Relation, menu item
resulting in a Relations window with:

   Tables Involved
 Products   Suppliers
   Fields Involved
 Products   Suppliers
    -

   [OK] [Cancel] [Help]

I enter ProductName under the Products column
and SupplierName under the Suppliers column, then press
the OK button, resulting in an error window containing
error message:

  SQL Status: 23000
  Error code: -177

  Integrity constraint violation -no parent
  product1, table: Products in statement
  [ALTER TABLE Products ADD FOREIGN KEY
  (ProductName) REFERENCES Suppliers
  (SupplierName)]

Googling sql foreign key got hit:

http://en.wikipedia.org/wiki/Foreign_key#Defining_foreign_keys

which contained:

  a foreign key is a field (or collection of fields) in one table
  that uniquely identifies a row of another table.

which is exactly what I want.  That hit also contained:

ALTER TABLE TABLE identifier
   ADD [ CONSTRAINT CONSTRAINT identifier ]
  FOREIGN KEY ( COLUMN expressionexpression}... )
  REFERENCES TABLE identifier [ ( COLUMN expression {, COLUMN 
expression}... ) ]

  [ ON UPDATE referential action ]
  [ ON DELETE referential action ]

which contains some of the same key words as the error message.
However, it doesn't help with the error message because I'm
not trying to alter the Products table, as the error message
suggests, I'm trying to create a new table, SupplierSuppliesProduct, 
containing a relationship between two already existing tables.  The

new table would look something like:

  Table: SupplierSuppliesProduct
 with primary keys SupplierName,ProductName
  showing which Supplier supplies which Product.

How should I do that?

TiA.

-regards,
Larry







--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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: saving documents written in Thai

2013-12-15 Thread Dale Erwin

On 12/15/2013 10:16 AM, CVAlkan wrote:

Dale:

To type and save documents in both Thai and English, which I do quite
successfully with LibreOffice and several other products, you need to
understand a few things that aren't at all obvious from the documentation.
At the end, I'll suggest an easy way to handle multi-lingual documents.

Since your difficulty is with LibreOffice Writer, let's start there. and
look at a couple things:

Open a new blank document. First, go to Format | Character and take a look
at the Font tab. In the top section, titled Western text font you will see
the font that is currently active.

The next two sections (Asian text font and CTL font) are key to
understand what's going on.

If your base font (the one listed in the top section) is NOT a Unicode font,
or if it is a Unicode font that doesn't contain Thai characters, you will
see the font that LibreOffice - in a not always successful attempt to be
helpful - uses as substitutes when you type in a particular character.

What happens, therefore, is that Libre Writer gives you the impression that
all is wonderful even though it is doing substitutions behind your back. In
itself a good thing, but sometimes leads to confusion.

It also isn't very clear that Asian text font is NOT what you use for your
Thai substitutions. Aside from the fact that Thai is actually an
Indo-European language, the Asian text font section seems to be only
applicable to languages that use ideographs (i.e. little pictures) even if
they have alphabetic characters. It also relates to languages that are
written vertically, although I'm not too sure about that as I don't speak
Chinese, Korean, Japanese and similar languages.

Now look at the CTL font section. What you want to do is to pick a font
that you know supports Thai, and choose it in the CTL font section as a
substitute. The font is listed first, then the size stuff, and then under
Language, you would choose Thai to indicate which group of characters within
the font are to be used.

A CTL font is what's used for substitutions when you are using an Input
Method to type on the keyboard. Since there are several of these in use
it's hard to tell you anything specific, but you've probably already solved
that, since I presume you do some typing in English, hit some switch
command, type a little Thai, then use the switch command to get back to
English.

By the way, the default you will often see under CTL font is one of the
Hindi fonts (I presume because of Thai's ancient relation to Indian
languages) - in Ubuntu, for instance, it is almost always Lohit Hindi - a
font that is part of the Ubuntu installation.

I used Format | Character as an example to make the explanation more clear;
obviously there are similar settings in various Paragraph and Style settings
as well, and they all work the same.

BUT - if you want to make things really simple, you could simply use a font
that has both English and Thai characters present, so no substitutions need
to take place. Unfortunately there isn't a great variety of really good
looking fonts (I'll list some below), but the advantage is that there are no
substitutions, and the font sizes are matched more closely than would be the
case with two different fonts. This is a matter of taste of course,
particularly with balancing Thai and English, since Thai nees room above and
below the characters for the various superscript and subscript vowels, tone
marks, and such things. (these same issues are not unique to Thai of course
- you'll run into them in both Hebrew and Arabic for instance).

So, here are my (so far) favorite combination fonts for easily mixing Thai
and English in the same document:

Free Serif (Serif)
Gentium Basic (Serif)  xxx
Gentium Book (Serif)  xxx
Norasi (Serif)
Kinnari (Serif)
Linux Libertine (developed for Linux, but works in Win)
Linux Biolinium (ditto)
Sawasdee  (go figure...) (light Sans Serif)
Droid Sans Thai (Sans Serif)
Garuda (Sans Serif)
Loma (Sans Serif)
Umpush (Sans Serif)
Waree (Sans Serif)
Purisa (informal handwriting style)
Tlwg Typist (mono typewriter)

Obviously if there are others who use both Thai and English, I'd be
interested in any of your favorite fonts.

As for moving your document to other machines, Libre Office now has the
ability in some versions to embed the fonts in the document file itself, but
I'm not sure if all versions and all platforms can utilize the embedded
fonts yet. (can anyone help here???)

I hope this helps you in your search.

-- Frank


Many thanks for your reply.  At last someone who knows what he's talking 
about.  I don't have all those fonts available, but I do have some and I 
can now save documents and reopen them intact.  I certainly do 
appreciate this information.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] saving documents written in Thai

2013-12-14 Thread Dale Erwin
Recently, I've been trying to learn Thai and have set up an alternate 
Thai keyboard layout.  All works pretty well until I try to save a 
document written in Thai.  It seems to save OK, but when I open it 
later, all the Thai text is represented by small rectangles... i.e. garbage.


What is the secret to saving documents in Thai?  I think it has 
something to do with unicode, but I have no idea how to deal with it.


Any help would be appreciated.

--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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] saving documents written in Thai

2013-12-14 Thread Dale Erwin

On 12/14/2013 10:35 AM, Dale Erwin wrote:
Recently, I've been trying to learn Thai and have set up an alternate 
Thai keyboard layout.  All works pretty well until I try to save a 
document written in Thai.  It seems to save OK, but when I open it 
later, all the Thai text is represented by small rectangles... i.e. 
garbage.


What is the secret to saving documents in Thai?  I think it has 
something to do with unicode, but I have no idea how to deal with it.


Any help would be appreciated.



I forgot to mention I am using LO 4.1.3.2 on Win 7.

--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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] saving documents written in Thai

2013-12-14 Thread Dale Erwin

On 12/14/2013 11:28 AM, Doug wrote:

On 12/14/2013 11:14 AM, Dale Erwin wrote:

On 12/14/2013 10:35 AM, Dale Erwin wrote:
Recently, I've been trying to learn Thai and have set up an 
alternate Thai keyboard layout.  All works pretty well until I try 
to save a document written in Thai. It seems to save OK, but when I 
open it later, all the Thai text is represented by small 
rectangles... i.e. garbage.


What is the secret to saving documents in Thai?  I think it has 
something to do with unicode, but I have no idea how to deal with it.


Any help would be appreciated.



I forgot to mention I am using LO 4.1.3.2 on Win 7.

Do you have Thai fonts in your font directory? I don't know where you 
get them, but that's what you need.


--doug



Seems to me that without Thai fonts I could not type text into the 
document at all.  I can type text into the document using Lucinda 
console font which comes with Win7.  The only problem is that after 
saving the document I can't retrieve it with the text intact.


I found a page through google on setting up a Thai keyboard and it said 
that win7 comes with several Thai fonts.  Another one mentioned is 
Malaga and the characters appear just fine in the document.  I can even 
print them, I just can't recover them after saving.


I have the same problem in Notepad, but in Notepad I get a warning that 
says:  This file contains characters in Unicode format which will be 
lost if you save this file as an ANSI encoded text file.  To keep the 
Unicode information, click Cancel below and then select one of the 
Unicode options from the Encoding drop down list, Continue? Problem is I 
can't find any Encoding drop down list.


In LO, however, there is no such warning.  It appears to have been 
successfully saved until I open it later and find garbage.


OK, I just found the Encoding drop down list in the save dialog, so I 
can now save documents in Notepad using the same Lucinda console font.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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] saving documents written in Thai

2013-12-14 Thread Dale Erwin

On 12/14/2013 11:28 AM, Doug wrote:

On 12/14/2013 11:14 AM, Dale Erwin wrote:

On 12/14/2013 10:35 AM, Dale Erwin wrote:
Recently, I've been trying to learn Thai and have set up an 
alternate Thai keyboard layout.  All works pretty well until I try 
to save a document written in Thai. It seems to save OK, but when I 
open it later, all the Thai text is represented by small 
rectangles... i.e. garbage.


What is the secret to saving documents in Thai?  I think it has 
something to do with unicode, but I have no idea how to deal with it.


Any help would be appreciated.



I forgot to mention I am using LO 4.1.3.2 on Win 7.

Do you have Thai fonts in your font directory? I don't know where you 
get them, but that's what you need.


--doug

No, it is not a font problem.  There are several Thai-capable fonts that 
come with Win 7.  One of them is Lucinda console.  The problem is that 
the Thai characters are Unicode while the latin characters are ANSI.  I 
have the same problem saving documents written in Thai on Notepad if I 
save them with ANSI encoding.  However, if I choose one of the Unicode 
options from the encoding drop box, the document is saved perfectly 
well, using the same font that I use for Thai in LO, Lucinda console.  
Unfortunately, LO gives no such option.  This is definitely a defect in LO.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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] Feature Request - Categories for special characters

2013-11-22 Thread Dale Erwin

On 11/22/2013 1:34 PM, Mark Bourne wrote:

Ruth Ann wrote:

OT maybe, but does anyone know the name for @ ?
Something I have been trying to discover for years :-)
Ruth Ann,
Cincinnati, OH USA


It depends who you ask, and in what language ;o) Unicode calls it 
commercial at. The article about it on Wikipedia is titled At 
sign, and mentions some other names:

  http://en.wikipedia.org/wiki/At_sign

Mark.



In Spanish, at least in Peruvian Spanish, it is called aroba (or maybe 
it's arroba).


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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] Engaging users: initial results of the survey

2013-11-10 Thread Dale Erwin

On 11/10/2013 1:46 PM, Charles-H. Schulz wrote:

Hello,

As there were some exchanges about the survey here and as I advertised
it on this mailing list as well, I thought you might be interested by
my initial analysis:
http://standardsandfreedom.net/index.php/2013/11/10/users-the-final-frontier/

Thank you for your participation!



I'm glad you think it was such a great success.  I personally feel you 
would have a much larger response had the questionnaire been better 
formulated.  So many of the questions' multiple choice answers had no 
choice which reflected my situation/experience. After a while I decided 
not to continue with it and discarded it because it was obvious that it 
would not have reflected my situation/experience (which I presume was 
the goal).  I suppose it is possible that for some questions there are 
only a few possible answers, but for most, the choice of other should 
be made available, or possibly even a blank line to fill in.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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: Shall we waste twelve more years promoting Free office suites instead of...

2013-11-09 Thread Dale Erwin
If everyone knows he's a troll why do so many bother responding in such 
great lengths.  Why bother feeding the troll.  Everyone knows this,  but 
still so many feel obligated to defend.  If you don't feed trolls, they 
go away.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


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

2013-11-06 Thread Dale Erwin

On 11/6/2013 12:59 PM, Urmas wrote:

James Knott:
https://en.wikipedia.org/wiki/AARD_code

Quote:
Microsoft disabled the AARD code for the final release of Windows 3.1

It's a myth.




But they didn't remove it and it could always be reenabled by changing a 
single byte of machine code.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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: [pt-br-usuarios] Estudantes da rede estadual de SP terão Office gratuito para até 5 PCs após parceria

2013-11-03 Thread Dale Erwin

On 11/2/2013 12:46 AM, Urmas wrote:

Les Howell:

Just a simple question, Do you know who originally designed Microsoft
Office?

Microsoft mostly.




BS!!!  The only thing MS ever developed from scratch without stealing 
anything was Bob.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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: Engaging Users in the LibreOffice Project

2013-11-01 Thread Dale Erwin

On 11/1/2013 2:05 PM, Ken Springer wrote:

On 11/1/13 7:04 AM, Charles-H. Schulz wrote:

Hello everyone,

Thank you for choosing and using LibreOffice!

My name is  Charles-H. Schulz and I'm one of the co-founders of the
Document Foundation.  Many people who contribute to the LibreOffice
project discussed the need for us to understand how we could enroll
regular users (whatever that means) to the LibreOffice project.

You obviously know that LibreOffice is Free Software and that it comes
with  rights and freedoms for you. But besides that LibreOffice is a
software development project populated by a community of people who
contribute their time and skills (and many skills are required, not
just the technical ones!) on a volunteer or on a paid basis.

But when we come to think of it, these people started somewhere, one
day, to contribute, and while they all have their own reasons, we (the
people in charge of marketing) thought that everybody has the ability
to contribute. The question is: how  can we make it 1)interesting 2)
accessible 3)easy to understand what the various tasks are 4)possible
to spread the word about it?

... And this is where you come in the picture. We worked on a short
survey that's anonymous (we don't require your name nor your email) and
we would really like it if you could take a few minutes of your time to
answer these questions. As you will see they are all about
understanding how we could include users of LibreOffice and turn them
into contributors. The survey is here:
https://survey.documentfoundation.org/index.php/574531/lang-en

We hope you're having a great time and thank you again for using
LibreOffice!

Best regards,


I went to do the survey, didn't complete it.  From going through the
pages, too many places didn't allow me to provide feedback on my
interests as well as concerns before becoming involved.  On a couple
of pages, I would like to have selected more than one.

IMO, surveys such as this are essentially slanted, and could give you
the answers you want to hear, not the ones you should hear.

Lastly, after clicking the Exit and Clear survey button, in the
following window, the close this window button did not work, even in
Safe Mode for Firefox.



I agree about the survey.  The multiple-choice type answers did not 
reflect my answers.  However, I had no trouble closing the window 
without completing the survey.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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] Automatic Capitalization of First Word

2013-09-08 Thread Dale Erwin

On 9/8/2013 9:54 AM, Tom Davies wrote:

Hi :)
It looks like you are not yet fully subscribed.


The confirmation email often goes into junk or spam folders if it can't be 
found in your inbox.

Sorry about that!
Regards from
Tom :)


I think I'm subscribed now.  The confirmation mail finally arrived, and 
today I received over 30 messages from the list.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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] Publishing a Dictionary

2013-09-08 Thread Dale Erwin
I have compiled a bilingual dictionary and am having lots of trouble 
trying to format it in LO Writer as well as in AOO Writer.  What I want 
to accomplish is having a field at the top of the page, left justified 
on left pages (even numbered) and right justified on right pages (odd 
numbered).  On left pages, this field would contain the first word on 
that page and on right pages, this field would contain the last word on 
that page.  This is quite common for dictionaries of all types.


Unfortunately, the header cannot be used for this short of having a 
separate style for every page in the book (over 300).  I have also tried 
putting these search words on the first text line of the page and then 
beginning the text two or three lines below that.  Then, if any 
modification results in an additional line, every subsequent page must 
be modified.


Maybe I'm missing something.  If anyone knows of a solution to this, I 
would certainly appreciate knowing about it.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
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] Automatic Capitalization of First Word

2013-09-07 Thread Dale Erwin
I know I have done this before, but I can't remember now where I found 
the setting.  I would like to disable the capitalization of the first 
word in a sentence or paragraph.


I am not sure if I am subscribed to this list.  I send an empty message 
to users+subscr...@global.libreoffice.org but I never received the 
confirmation mail.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


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