Re: [libreoffice-users] Re: entering records

[rounak jain]

made a crosspost in one of the link suggested above:
http://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=61646


On Sat, May 11, 2013 at 11:17 AM, Alexander Thurgood <
alex.thurg...@gmail.com> wrote:

> Le 11/05/13 05:28, rounak jain a écrit :
>
> Hi,
>
> Have a look here :
>
> http://www.oooforum.org/forum/viewforum.phtml?f=10
>
>
> or here :
>
>
> http://forum.openoffice.org/en/forum/viewforum.php?f=13&sid=49d212187c5621a71ea71b35b6897abf
>
> and you will probably find what you are looking for and more.
>
>
> 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

[libreoffice-users] Re: entering records

[Alexander Thurgood]

Le 11/05/13 05:28, rounak jain a écrit :

Hi,

Have a look here :

http://www.oooforum.org/forum/viewforum.phtml?f=10


or here :

http://forum.openoffice.org/en/forum/viewforum.php?f=13&sid=49d212187c5621a71ea71b35b6897abf

and you will probably find what you are looking for and more.


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

[libreoffice-users] entering records

[rounak jain]

Three Tables:
I am writing the fields in Table.FieldName format below.

1a. Customer.ID
1b. Customer.Name

2a. Invoice.ID
2b. Invoice.Customer Name
2c. Invoice.Customer ID

3a. Invoice Details.ID
3b. Invoice Details.Invoice ID

1a, 2a, 3a are all primary fields.

Relationship one to many between:
1. Customer ID.ID ->Invoice.Customer ID
2. Invoice.ID -> Invoice Details.Invoice ID

Now, in Filemaker this was the way to use the forms:
Create a new Invoice (i.e. create a new record using a Form based on
Invoice Table).
Enter a value in the field Invoice.Customer Name  (a combo box populates it
with values from Customer.Name)
I have been able to reach upto here in Base.

This is the part where I need help:
In Filemaker, the Invoice.Customer ID field used to be setup as a lookup
field to auto-retrieve the Customer ID number from the Customer Table when
an entry was made in Invoice.Customer Name. The obvious purpose of doing
this is to link the Invoice and Customer table. I do not know how I am
supposed to get this done in Base. Hope I am clear. Kindly let me know if I
am not. Thank you for your time.

-- 
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] 4.0.3 64-bit DEB removed my extensions, but Windows version did notI

[Kracked_P_P---webmaster]

Here is the error I got when I tried to install 4.0.3 on an Ubuntu 13.04 
with MATE de.
I installed the files without errors till I got to the 
desktop-integration part.


Here is the listing from the terminal.



timothy@timothy-Inspiron-1525:~/Lib/DEBS/desktop-integration$ sudo dpkg 
-i *.deb

Selecting previously unselected package libreoffice-debian-menus.
dpkg: regarding libreoffice4.0-debian-menus_4.0.3-3_all.deb containing 
libreoffice-debian-menus:

 libreoffice-core conflicts with libreoffice-unbundled
  libreoffice-debian-menus provides libreoffice-unbundled and is to be 
installed.


dpkg: error processing libreoffice4.0-debian-menus_4.0.3-3_all.deb 
(--install):

 conflicting packages - not installing libreoffice-debian-menus
Errors were encountered while processing:
 libreoffice4.0-debian-menus_4.0.3-3_all.deb
timothy@timothy-Inspiron-1525:~/Lib/DEBS/desktop-integration$

--

So, to get rid of the issue, I went to the Package Manager and removed 
all of installed LO files.

Then I reinstalled LO 4.0.3 and the menu part.

" libreoffice-core conflicts with libreoffice-unbundled "
seems to tell me that I must uninstall the previous version on 13.04 
before I install the next one.  I got this with installing 4.0.2 as well 
on this system.


This is the second laptop that was upgraded from 12.04 or 12.10 to 
13.04, with this system being a clean install over an upgrade.



On 05/10/2013 10:30 AM, Don C. Myers wrote:
Hopefully there are some folks out there who are using the other 
desktops who can help you and give you some feedback. I don't know 
anybody who is using them to check with. Sorry.



On 05/10/2013 10:05 AM, Kracked_P_P---webmaster wrote:


YES, it works for you but I am not using Unity.
How many users with MATE are having the same issues?
Do anyone using KDE or the other desktop have any issues.

I know that there has been work done to make the DEB install work 
properly with Unity.
Has there been any work to make sure it works as well with the other 
desktops?


That might be the issue here.
MATE and Cinnamon are the desktops for people who liked GNOME 2.x 
style of desktop and did not want to switch to Unity, GNOME 3.x, KDE 
or the others.  I hate Unity and GNOME 3.x.  The same reasons I hate 
Win8's desktop.  If you read the articles, you will find many users 
went to Mint Linux and other distros to get away from Unity.  Mint 
having both MATE and Cinnamon desktop versions, got a lot of users 
from Ubuntu.  I stuck with Ubuntu, but chose MATE desktop environment.


SO
it may be a MATE issue, or may not.
So I ask if any MATE or Cinnamon desktop users are having the same 
issues.




On 05/09/2013 10:25 PM, Don Myers wrote:
I installed LO 4.0.3.3 tonight on a third computer, also with Ubuntu 
13.04 and with Unity. No problems there either.



On 05/09/2013 08:19 PM, Kracked_P_P---webmaster wrote:


I extract them to the /home folder
then rename it to Lib
then I
cd Lib
cd DEBS
then
sudo dpkg -i *.deb

I tend to not run an command on a folder that I am not in.
I learned that in my mainframe days as a safety feature.

So far, I have installed it on Ubuntu 12.04 and 13.04 with MATE 
desktop.  I HATE Unity and GNOME 3.x.
Been using Ubuntu since 9.04 or 9.10 for a few months till 10.04 
LTS came out.  I skipped 11.xx and when to 12.04 and 13.04.


13.04 gave me errors when I tried the desktop-integration install.  
Kept giving me errors stating it was not matching the "core" install.


The only fix I came up with, for it on 13.04 was to remove the 
current version of LO then install the new one over again.


On 05/09/2013 06:55 PM, Don Myers wrote:

Hi,

I installed LO 4.0.3.3 on two machines running Ubuntu 13.04 with 
Unity today. I always download LO from the LO site, extract it to 
the desktop, and then run the following commands in the terminal:

1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.3-3_all.deb


Everything was fine with both.

I've used this method since Ubuntu 9.04 in the days of OpenOffice, 
and I've never had a problem with anything missing or failing.


Don


On 05/09/2013 06:00 PM, Kracked_P_P---webmaster wrote:

On 05/09/2013 05:16 PM, Dan Lewis wrote:

On 05/09/2013 03:40 PM, Kracked_P_P---webmaster wrote:


I just installed 4.0.3 on two systems

The 64-bit DEB install removed my extensions and the persona I 
has setup.

The Windows install did not do this.

Any idea way the 64-bit DEB install in Ubuntu 12.04 would 
remove my added items, but Windows did not?


I do not know if it is a bug, or not.  If other have seen this, 
than it might be.
 It is a little difficult to say since you did not say what 
version of LibreOffice you had installed on the two systems. 
That is likely to be impo

[libreoffice-users] Re: Base data-loss and other problems

[mariosv]

Hi Tom,

in fact, if I am right, the decision on change the database backend to
Firebird, has been taken, look in:

https://wiki.documentfoundation.org/Development/GSoC/Ideas#Support_for_Firebird_Database_in_Base
https://bugs.freedesktop.org/show_bug.cgi?id=51780

In the first link is clearly explained what are the reasons for change
"causes severe performance problems primarily around the frequency of Java
to C++ transitions", so I think it is no too much to say.

Regards
Miguel Ángel.



--
View this message in context: 
http://nabble.documentfoundation.org/Base-data-loss-and-other-problems-tp4055060p4055307.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] Seeking for list moderators

[anne-ology]

   Wow, thank you for these kind words;
you're mighty sweet!

   With all the best of wishes for you & yours, now & always,
your friend always,

   BTW - I'm quite curious as to the play you're working on;
I've always been involved in the arts too.



On Fri, May 10, 2013 at 6:15 PM, Anthony Easthope wrote:

The thing that amuses me is the creative or at least literary geniuses
> we seem to have on this list. Anne I compliment you! Although I don't
> often respond to the list much these days I still make the effort to
> read all threads! I have often considered some aspects of what it is I
> can do and I'm still stuck on the time and involvement, It sucks being
> in the position where you constantly are traveling and unable to
> keep on top of this all!  Anyhow, I'd best be off I've got rehearsals
> to go to! well on that note - Currently using LO to draft a play that a
> youth theatre group will be using as part of the International Festival
> of the Arts!
>
>
>
> Cheerio!
> Ant
>
>

-- 
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] Base data-loss and other problems

[Tom Davies]

Hi :)
I used "Forwards" rather than "Reply to all" to send the message there but it 
didn't arrive in the right thread, of course.  Using Nabble's "Quote" button 
and then copy&paste might have been better.  

If you want to see the thread in Marketing then try using Nabble.  you wont be 
able to post unless you are subscribed to the list but at least you can read.  
I wouldn't recommend it though as i got a pasting about it.  Again.  To be fair 
it was a bit off-topic!  
Regards from 
Tom :)  





- Original Message -
> From: anne-ology 
> To: users@global.libreoffice.org
> Cc: 
> Sent: Friday, 10 May 2013, 19:36
> Subject: Re: [libreoffice-users] Base data-loss and other problems
> 
>        I'm curious as well.
> 
> 
> 
> On Fri, May 10, 2013 at 12:47 PM, Mark Stanton 
> wrote:
> 
> How are we to see this thread in the marketing list Tom?  Just
>>  joining the list won't give it, will it?
>> 
>>  Regards
>>  Mark Stanton
>>  One small step for mankind...
>> 
>> 
> 

-- 
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] Seeking for list moderators

[Anthony Easthope]

The thing that amuses me is the creative or at least literary geniuses
we seem to have on this list. Anne I compliment you! Although I don't
often respond to the list much these days I still make the effort to
read all threads! I have often considered some aspects of what it is I
can do and I'm still stuck on the time and involvement, It sucks being
in the position where you constantly are traveling and unable to
keep on top of this all!  Anyhow, I'd best be off I've got rehearsals
to go to! well on that note - Currently using LO to draft a play that a
youth theatre group will be using as part of the International Festival
of the Arts!



Cheerio!

Ant



On Fri, 10 May 2013, at 11:56 AM, e-letter wrote:

> On 08/05/2013, Sigrid Carrera  wrote:

> > Hi,

> >

> >

> > On 8 May 2013 08:41, e-letter  wrote:

> >

> >> On 04/05/2013, Sigrid Carrera  wrote:

> >> > Hi Tom,

> >> >

> >> >

> >> > On 4 May 2013 18:47, Tom Davies  wrote:

> >> >

> >> >> Hi :)

> >> >> That is a very generous offer but i suspect you would have more
fun

> >> >> an

> >> be

> >> >> more useful in other areas of the project!!

> >> >>

> >> >[...]

> >>

> >

> >>

> >

> >> Would you please "moderate" their posts particularly? ;) Please
mark

> >> "top-post spam: delete"

> >>

>

> A deliberate addition to see who would bite the bait and prefer not
to

> discuss the original topic; it worked ;)

>

> --

> 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





--

Anthony Easthope

antiso...@myopera.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] GSOC = Google's Summer Of Code

[Tom Davies]

Hi :)
Blimey!!  Quite a lot of ideas.  Looks interesting too.  Thanks Mirosław
Regards from 

Tom :)  





>
> From: Mirosław Zalewski 
>To: users@global.libreoffice.org 
>Sent: Thursday, 9 May 2013, 16:30
>Subject: Re: [libreoffice-users] GSOC = Google's Summer Of Code
> 
>
>On 09/05/2013 at 16:45, Tom Davies  wrote:
>
>> Anyone any idea what is being put forwards this year?
>
>Take a look of ideas page on a wiki:
>
>
>This is by no means list of things that will be done. It's only a list of 
>things that developers has volunteered to mentor. We still do not know how 
>many students will be associated to LibreOffice, what are they skills and 
>personal interests.
>-- 
>Best regards
>Mirosław Zalewski
>
>-- 
>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] Printer settings

[Steve Edmonds]

Hi.
I am on Opensuse. I get 2 different print dialogues depending on the 
application. I have to make sure the settings are consistent on both. 
One the printer tray setting is under another separate tag somewhere I 
always have to go looking. If you look in Firefox print dialogue options 
there is a setting, is that the same as LO.

Steve

On 2013-05-11 02:27, Malcolm Moore wrote:

I don't understand ...It's late Friday so I'm probably being thick !

The default setting on the CUPS server is 'Auto' paper tray and 
'Plain/Recycled' paper
Everyone else gets this but I fiddled now I can't get rid of the 'Bypass' and 
Thick 3 settings
LO seems to remember it somewhere. If I set it back to what it should be when I
reopen Writer or Calc etc and try and print it's gone back to Bypass and Thick 3


I can't remember what I did to set it to Bypass etc but now I can't get rid of 
it


Ta


M


   _

From: Cor Nouws [mailto:oo...@nouenoff.nl]
To: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info]
Cc: users@global.libreoffice.org
Sent: Fri, 10 May 2013 14:07:56 +
Subject: Re: [libreoffice-users] Printer settings

Malcolm Moore wrote (10-05-13 09:41)
   > Somehow I have changed my printer settings to use the bypass tray and
   > for the life of me I can't work out how to get it to go back to auto
   >
   > I tried setting it in spadmin but the LO apps ignore it
   > I tried removed ~/.config/libreoffice and that doesn't work
   
   LibreOffice typically does this in the page styles.

   Format > Page opens the settings for the page style used in the current
   page. On the tab called Page there is that setting.
   
   I would know of no way (apart from automating) to change the setting for

   all documents and such.
   
   When the setting is changed for all your new documents, then you may

   have to set/change the default template.
   
   HTH,

   Cor
   
   
   --

 - Cor
 - http://nl.libreoffice.org
 - www.librelex.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
   
 



--
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] Base data-loss and other problems

[anne-ology]

   I'm curious as well.



On Fri, May 10, 2013 at 12:47 PM, Mark Stanton wrote:

How are we to see this thread in the marketing list Tom?  Just
> joining the list won't give it, will it?
>
> Regards
> Mark Stanton
> One small step for mankind...
>
>

-- 
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] Base data-loss and other problems

[Mark Stanton]

How are we to see this thread in the marketing list Tom?  Just 
joining the list won't give it, will it?

Regards
Mark Stanton
One small step for mankind...



-- 
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] Currency format always gets lost/screwed up

[anne-ology]

   Since your re-using the older one, merely changing the numbers -
   [that's my system too]
 it should work, therefore I would guess there's now a bug
somewhere - but not with you;
   can you revert back to an older - workable - version of LO?
   [I've never updated since 3.4  ;-)  ]

   Lots of luck in finding a solution to this weird problem,



On Fri, May 10, 2013 at 3:32 AM, Mathias Koerber wrote:

I am using Libreoffice to write invoices.
>
> I have a table with several fields that need to be formatted
> as currency (SGD).
>
> I basically re-use an older document to save as a new one.
> Then I change the values.
>
> Most of the time one of the following happens:
>
> a) when I change just the numerical digits of the value,
>the cell is no longer detected as numerical (and thus
>counts as 0, detectable by the wrong sum in a SUM field
>further down). It seems that it converts the old 'S$'
>prefix found in the cell as text now.
>
> b) the 'S$' prefix gets lost and the value stands naked.
>
> Trying to correct this by selecting the value and
> applying
> Table/Number format/selecting 'SGD' and
>   pressing ENTER often does nothing.
>
> Neither does selecting a different cell that still has the
> correct format applied, selecting the brush and trying
> to brush the format back into the cell that was screwed u.
>
> It takes me usually several minutes to clean out the cells
> and try to correct everything.
>
> It gets worse when I need to add or delete a row from the
> table and thus reapply the format to the new row or such.
>
> Is there no way to 'fix' the format for those cells, so that
> editing cannot screw up the format?
>
> Currency formatting in LO seems to be really broken :(
>
> I'm using
> Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)
> TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time:
> 2013-03-26_15:52:16
>
>

-- 
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: Italics and bold in BASE

[anne-ology]

   I don't know how or why this message got taken out of circulation;
   and hoping an answer can be found for you -
   (as well as to uncovering this mysterious blocking of your message.)




Thanks to everybody.

I'm sending a print screen about my question. This is what I´d like to do,
and I'm doing it with Writer without problems. It have regular, bold and
italics:



When I copy and paste it in BASE this is the result:



And I can´t do it directly in BASE anyway... What could I do to use it?

Thanks,
Antonio Canela

-- 
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: Download ?

[Nino Novak]

Am 10.05.2013 18:44, schrieb Carol Bamrick:

> I have been running the Libra Office Suite 3.3 and my startup file is
> "gone".  I would like to download the latest Libra Suite, my question
> is will the new Suite be compatible with my old Libre files?

LibreOffice is in general fully backward compatible.

If you encounter problems, please ask here again.

Nino

-- 
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] Download ?

[James Knott]

Carol Bamrick wrote:


I have been running the Libra Office Suite 3.3 and my startup file is "gone".  
I would like to download the latest Libra Suite, my question is will the new Suite be 
compatible with my old Libre files?




Yes, it will be compatible.  LibreOffice 4.0 is available from 
www.libreoffice.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] Download ?

[Carol Bamrick]

I have been running the Libra Office Suite 3.3 and my startup file is "gone".  
I would like to download the latest Libra Suite, my question is will the new 
Suite be compatible with my old Libre files? 



Carol Bamrick 

-- 
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] 4.0.3 64-bit DEB removed my extensions, but Windows version did notI

[Don C. Myers]

Hopefully there are some folks out there who are using the other 
desktops who can help you and give you some feedback. I don't know 
anybody who is using them to check with. Sorry.



On 05/10/2013 10:05 AM, Kracked_P_P---webmaster wrote:


YES, it works for you but I am not using Unity.
How many users with MATE are having the same issues?
Do anyone using KDE or the other desktop have any issues.

I know that there has been work done to make the DEB install work 
properly with Unity.
Has there been any work to make sure it works as well with the other 
desktops?


That might be the issue here.
MATE and Cinnamon are the desktops for people who liked GNOME 2.x 
style of desktop and did not want to switch to Unity, GNOME 3.x, KDE 
or the others.  I hate Unity and GNOME 3.x.  The same reasons I hate 
Win8's desktop.  If you read the articles, you will find many users 
went to Mint Linux and other distros to get away from Unity.  Mint 
having both MATE and Cinnamon desktop versions, got a lot of users 
from Ubuntu.  I stuck with Ubuntu, but chose MATE desktop environment.


SO
it may be a MATE issue, or may not.
So I ask if any MATE or Cinnamon desktop users are having the same 
issues.




On 05/09/2013 10:25 PM, Don Myers wrote:
I installed LO 4.0.3.3 tonight on a third computer, also with Ubuntu 
13.04 and with Unity. No problems there either.



On 05/09/2013 08:19 PM, Kracked_P_P---webmaster wrote:


I extract them to the /home folder
then rename it to Lib
then I
cd Lib
cd DEBS
then
sudo dpkg -i *.deb

I tend to not run an command on a folder that I am not in.
I learned that in my mainframe days as a safety feature.

So far, I have installed it on Ubuntu 12.04 and 13.04 with MATE 
desktop.  I HATE Unity and GNOME 3.x.
Been using Ubuntu since 9.04 or 9.10 for a few months till 10.04 LTS 
came out.  I skipped 11.xx and when to 12.04 and 13.04.


13.04 gave me errors when I tried the desktop-integration install.  
Kept giving me errors stating it was not matching the "core" install.


The only fix I came up with, for it on 13.04 was to remove the 
current version of LO then install the new one over again.


On 05/09/2013 06:55 PM, Don Myers wrote:

Hi,

I installed LO 4.0.3.3 on two machines running Ubuntu 13.04 with 
Unity today. I always download LO from the LO site, extract it to 
the desktop, and then run the following commands in the terminal:

1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.3-3_all.deb


Everything was fine with both.

I've used this method since Ubuntu 9.04 in the days of OpenOffice, 
and I've never had a problem with anything missing or failing.


Don


On 05/09/2013 06:00 PM, Kracked_P_P---webmaster wrote:

On 05/09/2013 05:16 PM, Dan Lewis wrote:

On 05/09/2013 03:40 PM, Kracked_P_P---webmaster wrote:


I just installed 4.0.3 on two systems

The 64-bit DEB install removed my extensions and the persona I 
has setup.

The Windows install did not do this.

Any idea way the 64-bit DEB install in Ubuntu 12.04 would remove 
my added items, but Windows did not?


I do not know if it is a bug, or not.  If other have seen this, 
than it might be.
 It is a little difficult to say since you did not say what 
version of LibreOffice you had installed on the two systems. That 
is likely to be important. Also from where did you download 
LibreOffice 4.0.3?
 I have installed 4.0.3.3 (Debian 64 Bit) that I downloaded 
from the LibreOffice website. I did not notice any problems. But 
this might have been because I already had 4.0.3.2 installed.


--Dan



Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539)

I downloaded it today from the LO site, after it was announced. I 
try not to download RCversions.


I had a different problem with the 13.04 Ubuntu I have on my 
laptop, which is an issue with 13.04 [I think since it effects 
more than LO].  I run Ubuntu with MATE desktop environment.


But on my Ubuntu 12.04 desktop, I had the problem withthe loss of 
the extensions and persona. On 13.04 I did not have that issue, 
but an install problem until I removed all of the LO files with 
the Package Manager.  But it kept the extensions and persona.
















--

*~~*
Don C. Myers
Manager, Farm and Rural Property Division
e-PRO Certified by the National Association of Realtors
Don's Cell Phone: 814-571-9518, Don's Home Phone: 814-422-8111
Don's E-mail: donmy...@myersfarm.com 
*RE/MAX Centre Realty
**1375 Martin Street, State College, PA 16803*
Office Phone: 814-231-8200 Fax: 814-231-8220
Visit the Farm and Rural Property Division web site at 
_www.CentralPaRuralProperty.com  _
Visit the RE/MAX Centre Realty main web site at 
_www.StateCollegeHomeSales.

Re: [libreoffice-users] Printer settings

[Malcolm Moore]

I don't understand ...It's late Friday so I'm probably being thick !

The default setting on the CUPS server is 'Auto' paper tray and 
'Plain/Recycled' paper
Everyone else gets this but I fiddled now I can't get rid of the 'Bypass' and 
Thick 3 settings
LO seems to remember it somewhere. If I set it back to what it should be when I
reopen Writer or Calc etc and try and print it's gone back to Bypass and Thick 3


I can't remember what I did to set it to Bypass etc but now I can't get rid of 
it


Ta


M


  _  

From: Cor Nouws [mailto:oo...@nouenoff.nl]
To: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info]
Cc: users@global.libreoffice.org
Sent: Fri, 10 May 2013 14:07:56 +
Subject: Re: [libreoffice-users] Printer settings

Malcolm Moore wrote (10-05-13 09:41)
  > Somehow I have changed my printer settings to use the bypass tray and
  > for the life of me I can't work out how to get it to go back to auto
  >
  > I tried setting it in spadmin but the LO apps ignore it
  > I tried removed ~/.config/libreoffice and that doesn't work
  
  LibreOffice typically does this in the page styles.
  Format > Page opens the settings for the page style used in the current 
  page. On the tab called Page there is that setting.
  
  I would know of no way (apart from automating) to change the setting for 
  all documents and such.
  
  When the setting is changed for all your new documents, then you may 
  have to set/change the default template.
  
  HTH,
  Cor
  
  
  -- 
- Cor
- http://nl.libreoffice.org
- www.librelex.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
  

-- 
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] 4.0.3 64-bit DEB removed my extensions, but Windows version did notI

[Joel Madero]

On 05/10/2013 07:05 AM, Kracked_P_P---webmaster wrote:


YES, it works for you but I am not using Unity.
How many users with MATE are having the same issues?
Do anyone using KDE or the other desktop have any issues.


Honestly in this case it's unlikely that the DE is the issue as this is 
really just an installation bug and the front end of Linux (DE) 
shouldn't affect this one bit. There was work done for Unity for Unity 
integration but this wouldn't affect installation at all.


This being said, what I would recommend is reporting a bug as this would 
indeed be a bug, over at https://www.libreoffice.org/get-help/bug/. Make 
sure to include exact steps (even if they seem basic), what you 
observed, and what you expected. Include your system info (including 
distro, DE, etc...) and LibreOffice versions. Also include the 
extensions you had installed and which ones (or all) disappeared.


This way someone from QA (possibly myself) will look into the bug. I 
have a debian based machine but it uses Enlightenment, I suspect that 
this wouldn't cause any difference for installation issues so -- I 
should be able to test.



Best,
Joel

--
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] Base data-loss and other problems

[Ian Whitfield]

Hi All

Tom says ...

I'm fairly sure that quite a few people have had troubles with the internal 
back-end that were solved by 'just' moving to an external back-end.  I vaguely 
remember someone even suffering data-loss using the embedded/internal back-end. 
 Was there a bug-report?  Should people be encouraged to stick with the 
internal/embedded back-end or warned off from it?

And Hank replied ...

My experience with the embedded database in Base has convinced me to move
to an external back-end. I have had several instances of data loss
particularly during sessions of heavy data input.
While I'm in the process of moving my database to an external  H2 database,
I still use the embedded database carefully, however. I backup the embedded
database before adding data, sparingly or working with the Report Writer.
Both of these activitie have resulted in data loss in the past. I still
like Base as a front end, however.


I have to agree with you 200% Tom - and if some people don't like it - 
too bad!!


IT'S TRUE!! - The 'Embedded engine/Base Front End' combination is a 
disaster!! I have been using Base for about 7 years now and had nothing 
but problems. It's slow, crashes all the time, freezes etc etc and 
FREQUENTLY takes the data file with it when it crashes. The only 
recourse is to back-up all the time, (several times each session), so 
that you can get back at your data and be prepared to enter stuff more 
than once during a busy session.


Because of this I HAVE LOST and/or had to re-enter data time and time 
again!!

This is supported by Hank above I see, (and I'm sure many others)!!

Late last year I converted to MySQL as the Backend and Base as the Front 
End. WHAT A DIFFERENCE As I said to people it's like getting out of 
your old broken-down, unreliable Beetle and driving around in the latest 
Rolls Royce!! Solid, fast, never crashes and is just fantastic!!


I'm currently running BOTH set-ups, on two different machines 
side-by-side, for cross checking purposes and the difference is 
startling when you do this. The one is slow and plodding, (and still 
crashes), and the other "just works" - and fast!!


IMHO the current engine in Base should be dropped, (or fixed), and a 
change made to make stand-alone Base of any serious use.
I saw recently a mention of wanting to do this and change top Firebird!! 
(??)


For now I'm VERY happy with my 'MySQL/Base combination!!

Best wishes

IanW
Pretoria RSA


--
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] Printer settings

[Kracked_P_P---webmaster]

On 05/10/2013 09:07 AM, Cor Nouws wrote:

Malcolm Moore wrote (10-05-13 09:41)

Somehow I have changed my printer settings to use the bypass tray and
for the life of me I can't work out how to get it to go back to auto

I tried setting it in spadmin but the LO apps ignore it
I tried removed ~/.config/libreoffice and that doesn't work


LibreOffice typically does this in the page styles.
Format > Page opens the settings for the page style used in the 
current page. On the tab called Page there is that setting.


I would know of no way (apart from automating) to change the setting 
for all documents and such.


When the setting is changed for all your new documents, then you may 
have to set/change the default template.


HTH,
Cor




How did you "change you printer settings"?

Did you set the "Properties > Paper > Paper Tray" or did you set it 
through the openSUSE's version of Ubuntu's "System > Administration> 
Printing"and sent the printer's options there?




--
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: Italics and bold in BASE

[Tom Davies]

Hi :)
Please use "Reply to all" and make sure Antonio is included.  He is not 
subscribed properly yet.  

Antonio, please send a blank email to 
users+subscr...@global.libreoffice.org
and try to make sure you are properly subscribed.  At the moment the moderators 
are having to forwards your messages to the list.  

Btw your Nabble 'attachments' seem to be working well!  Nicely done!
Regards from 
Tom :)  





>
> From: acanela 
>To: users@global.libreoffice.org 
>Sent: Friday, 10 May 2013, 11:29
>Subject: [libreoffice-users] Re: Italics and bold in BASE
> 
>
>Thanks to everybody.
>
>I'm sending a print screen about my question. This is what I´d like to do,
>and I'm doing it with Writer without problems. It have regular, bold and
>italics:
>
> 
>
>When I copy and paste it in BASE this is the result:
>
> 
>
>And I can´t do it directly in BASE anyway... What could I do to use it?
>
>Thanks,
>Antonio Canela.
>
>
>
>--
>View this message in context: 
>http://nabble.documentfoundation.org/Italics-and-bold-in-BASE-tp4054663p4055117.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
>
>
>
-- 
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] 4.0.3 64-bit DEB removed my extensions, but Windows version did notI

[Kracked_P_P---webmaster]

YES, it works for you but I am not using Unity.
How many users with MATE are having the same issues?
Do anyone using KDE or the other desktop have any issues.

I know that there has been work done to make the DEB install work 
properly with Unity.
Has there been any work to make sure it works as well with the other 
desktops?


That might be the issue here.
MATE and Cinnamon are the desktops for people who liked GNOME 2.x style 
of desktop and did not want to switch to Unity, GNOME 3.x, KDE or the 
others.  I hate Unity and GNOME 3.x.  The same reasons I hate Win8's 
desktop.  If you read the articles, you will find many users went to 
Mint Linux and other distros to get away from Unity.  Mint having both 
MATE and Cinnamon desktop versions, got a lot of users from Ubuntu.  I 
stuck with Ubuntu, but chose MATE desktop environment.


SO
it may be a MATE issue, or may not.
So I ask if any MATE or Cinnamon desktop users are having the same issues.



On 05/09/2013 10:25 PM, Don Myers wrote:
I installed LO 4.0.3.3 tonight on a third computer, also with Ubuntu 
13.04 and with Unity. No problems there either.



On 05/09/2013 08:19 PM, Kracked_P_P---webmaster wrote:


I extract them to the /home folder
then rename it to Lib
then I
cd Lib
cd DEBS
then
sudo dpkg -i *.deb

I tend to not run an command on a folder that I am not in.
I learned that in my mainframe days as a safety feature.

So far, I have installed it on Ubuntu 12.04 and 13.04 with MATE 
desktop.  I HATE Unity and GNOME 3.x.
Been using Ubuntu since 9.04 or 9.10 for a few months till 10.04 LTS 
came out.  I skipped 11.xx and when to 12.04 and 13.04.


13.04 gave me errors when I tried the desktop-integration install.  
Kept giving me errors stating it was not matching the "core" install.


The only fix I came up with, for it on 13.04 was to remove the 
current version of LO then install the new one over again.


On 05/09/2013 06:55 PM, Don Myers wrote:

Hi,

I installed LO 4.0.3.3 on two machines running Ubuntu 13.04 with 
Unity today. I always download LO from the LO site, extract it to 
the desktop, and then run the following commands in the terminal:

1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.3-3_all.deb


Everything was fine with both.

I've used this method since Ubuntu 9.04 in the days of OpenOffice, 
and I've never had a problem with anything missing or failing.


Don


On 05/09/2013 06:00 PM, Kracked_P_P---webmaster wrote:

On 05/09/2013 05:16 PM, Dan Lewis wrote:

On 05/09/2013 03:40 PM, Kracked_P_P---webmaster wrote:


I just installed 4.0.3 on two systems

The 64-bit DEB install removed my extensions and the persona I 
has setup.

The Windows install did not do this.

Any idea way the 64-bit DEB install in Ubuntu 12.04 would remove 
my added items, but Windows did not?


I do not know if it is a bug, or not.  If other have seen this, 
than it might be.
 It is a little difficult to say since you did not say what 
version of LibreOffice you had installed on the two systems. That 
is likely to be important. Also from where did you download 
LibreOffice 4.0.3?
 I have installed 4.0.3.3 (Debian 64 Bit) that I downloaded 
from the LibreOffice website. I did not notice any problems. But 
this might have been because I already had 4.0.3.2 installed.


--Dan



Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539)

I downloaded it today from the LO site, after it was announced. I 
try not to download RCversions.


I had a different problem with the 13.04 Ubuntu I have on my 
laptop, which is an issue with 13.04 [I think since it effects more 
than LO].  I run Ubuntu with MATE desktop environment.


But on my Ubuntu 12.04 desktop, I had the problem withthe loss of 
the extensions and persona. On 13.04 I did not have that issue, but 
an install problem until I removed all of the LO files with the 
Package Manager.  But it kept the extensions and persona.














--
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] Table of Contents woes

[Tom Davies]

Hi :)
Brilliant!  That is probably a LOT faster than my way.  And it's more elegant.
Regards from 
Tom :)  





>
> From: Cor Nouws 
>To: Carl Paulsen  
>Cc: Carl Paulsen ; "users@global.libreoffice.org" 
> 
>Sent: Friday, 10 May 2013, 14:03
>Subject: Re: [libreoffice-users] Table of Contents woes
> 
>
>Hi Carl,
>
>Carl Paulsen wrote (09-05-13 20:21)
>
>> I have a draft document in which I've used heading styles for sections.
>> I now want to create a Table of Contents (ToC), but I'm having trouble
>> getting it to work right.  I'm using the styles almost as they came with
>> the software (I added one style for a "Draft" watermark that I'm also
>> using in this document).
>
>Did you have a look at Tools > Outline numbering?
>There you can link the levels to the styles of your choise.
>(As remarked by others, Heading 1, ..2, ..3 are default. But that's not 
>mandatory.)
>
>And make sure that the individual paragraph styles that you use have no 
>settings on the Numbering tab!
>
>All works like this for as long as I know LibreOffice ;-)
>
>Cheers,
>
>
>-- 
>  - Cor
>  - http://nl.libreoffice.org
>  - www.librelex.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
>
>
>
-- 
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: [tdf-discuss] Re: [libreoffice-users] [4.0.3.3 non fixed bug] Link with a space Pdf export error (%20 characters - space ones - exported as %2520 ones)

[Tom Davies]

Hi :)
It might be good to keep the discussion to this thread on the Users List for 
now.  Lets see what other people say and what bug-reports you find about this.  
Perhaps move it up the "chain of command" after that.  I've just noticed that 
we have been cross-posting all this time.  it's better to stick to 1 list at a 
time for most things.  

"- so I don't see the reason to recursively (!!!) substitute the "%" 
character when an URL is input in LibreOffice because "%" itself is 
already an accepted one;"  

A big +1 to that!  I don't know why it's being done either.  It makes no sense 
that it happens that way.  
Regards from 
Tom :)  






>
> From: Carlo Strata 
>To: Tom Davies  
>Cc: Florian Reisinger ; "TDF, discuss" 
>; "LibreOffice, users" 
> 
>Sent: Friday, 10 May 2013, 9:03
>Subject: Re: [tdf-discuss] Re: [libreoffice-users] [4.0.3.3 non fixed bug] 
>Link with a space Pdf export error (%20 characters - space ones - exported as 
>%2520 ones)
> 
>
>Hi Everyone,
>
>as I told yesterday in my first mail I will look for an already created 
>issue and if not I will create it. When I make this? Now! ;-)
>In any case I will make you know what I do.
>
>@Tom:
>
>I think that:
>- on URLs, browsers - but maybe a behaviour stated on  a well determined 
>W3 Standard or similar open Consortium - substitute spaces with %20 hex 
>character code;
>- %20 (!!!): that means that "%", "2" and "0" are all (!) well admitted 
>characters, all (!!!);
>- so I don't see the reason to recursively (!!!) substitute the "%" 
>character when an URL is input in LibreOffice because "%" it self is 
>already an accepted one;
>- another low probability hypotheses in my head was that LibreOffice 
>translate the space on a full 16 bit space character coding, but your 
>explain about %25 representing the "%" hex code, rapidly make me clear 
>what was happened;
>- in any case (!), if you open the with-space link directly from a 
>Writer document (ctrl+click for friends o chaps ;-) )  you will get the 
>right page: in other words the link behave correctly! So the problem on 
>pdf link behaviour has to be fixed in LibreOffice too!!! :-) But I do 
>not think is a too hard to do, is not it?
>
>Now I will go to open or vote an existing issue and come back here soon. 
>I think we could also to maintain only one discuss: I will suggest the 
>tdf-discuss one, what do you think about?
>
>Have All a sunny day,
>
>Carlo
>
>I
>
>ing. Carlo Strata
>-
>via Botticelli 1/4
>30031 Dolo - VE
>Italia - Italy
>-
>tel./fax +39.041.822.0665
>cell. +39.347.85.69.824
>Skype carlo.strata
>Google carlo.strata.69
>-
>carlo.str...@tiscali.it
>PEC: carlo.str...@ingpec.eu
>
>Il 10/05/2013 08.28, Tom Davies ha scritto:
>> Hi :)
>> I don't know if there is one for LibreOffice yet.
>>
>> People have tried to show me how to look things up in the bug-report place 
>> but for some reason i can never quite manage it myself.
>>
>> Also i'm not sure if just solving the problem in LibreOffice would make the 
>> problem go away.  It seems to be further "upstream" with fairly major 
>> projects having to deal with it separately. is it possible to post a 
>> bug-report against "the internet"?
>> Apols and regards form
>> Tom :)
>>
>>
>>
>>
>>
>>> 
>>> From: Florian Reisinger 
>>> To: Tom Davies 
>>> Cc: Carlo Strata ; "TDF, discuss" 
>>> ; "LibreOffice, users" 
>>> 
>>> Sent: Thursday, 9 May 2013, 16:37
>>> Subject: Re: [tdf-discuss] Re: [libreoffice-users] [4.0.3.3 non fixed bug] 
>>> Link with a space Pdf export error (%20 characters - space ones - exported 
>>> as %2520 ones)
>>>
>>>
>>> Hi,
>>>
>>> Does a bug report exist yet?
>>>
>>> Liebe Grüße, / Yours,
>>> Florian Reisinger
>>>
>>> Am 09.05.2013 um 14:10 schrieb Tom Davies :
>>>
 Hi :)
 %25 is the code for a % symbol so the 'wrong' link is not really wrong 
 after all.  It's just a bit odd and unnecessary.  In the 'wrong' link 
 replace all the %25s with % so that %2520 becomes %20 and then the 
 apparently 'wrong' link looks right.  It's a good reason for avoiding 
 spaces and non-standard characters in Urls.  CamelCase is much less prone 
 to these sorts of problems.

 Seems a few other organisations are having trouble with %25 replacing %
 http://social.microsoft.com/Forums/en-US/technicalqueries/thread/6f20c6a9-0ed9-4e96-a0f7-cc1abbdf58a8
 https://discussions.apple.com/thread/1648880?start=0&tstart=0
 https://github.com/pipwerks/PDFObject/issues/23
 http://drupal.org/node/1335942
 http://stackoverflow.com/questions/3549747/apache-25-in-url-400-bad-request

 Welcome back chap!  Lets hope they can fix it!
 Regards from
 Tom :)






> 
> From: Carlo Strata 
> To: "TDF, discuss" ; "LibreOffice, users" 
> 
> Sent: Thursday, 9 May 2013, 12:29
> Subject: [libreoffice-users] [4.0.3.3 non fixed bug] Link with a 

Re: [libreoffice-users] Printer settings

[Cor Nouws]

Malcolm Moore wrote (10-05-13 09:41)

Somehow I have changed my printer settings to use the bypass tray and
for the life of me I can't work out how to get it to go back to auto

I tried setting it in spadmin but the LO apps ignore it
I tried removed ~/.config/libreoffice and that doesn't work


LibreOffice typically does this in the page styles.
Format > Page opens the settings for the page style used in the current 
page. On the tab called Page there is that setting.


I would know of no way (apart from automating) to change the setting for 
all documents and such.


When the setting is changed for all your new documents, then you may 
have to set/change the default template.


HTH,
Cor


--
 - Cor
 - http://nl.libreoffice.org
 - www.librelex.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] Table of Contents woes

[Cor Nouws]

Hi Carl,

Carl Paulsen wrote (09-05-13 20:21)


I have a draft document in which I've used heading styles for sections.
I now want to create a Table of Contents (ToC), but I'm having trouble
getting it to work right.  I'm using the styles almost as they came with
the software (I added one style for a "Draft" watermark that I'm also
using in this document).


Did you have a look at Tools > Outline numbering?
There you can link the levels to the styles of your choise.
(As remarked by others, Heading 1, ..2, ..3 are default. But that's not 
mandatory.)


And make sure that the individual paragraph styles that you use have no 
settings on the Numbering tab!


All works like this for as long as I know LibreOffice ;-)

Cheers,


--
 - Cor
 - http://nl.libreoffice.org
 - www.librelex.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] Re: Italics and bold in BASE

[acanela]

Thanks to everybody.

I'm sending a print screen about my question. This is what I´d like to do,
and I'm doing it with Writer without problems. It have regular, bold and
italics:

 

When I copy and paste it in BASE this is the result:

 

And I can´t do it directly in BASE anyway... What could I do to use it?

Thanks,
Antonio Canela.



--
View this message in context: 
http://nabble.documentfoundation.org/Italics-and-bold-in-BASE-tp4054663p4055117.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] Table of Contents woes

[Tom Davies]

Hi :)
Heading 1a is non-standard so it is something that someone has added.  Probably 
you while you were learning about styles by experimentation (which is a valid 
way to learn but dipping into the chapter at the same time makes it more 
optimal).  

>From what little i understand various styles should be linked in some way so 
>that if you change the font (or something) of 1 then that change ripples 
>through all the other relevant styles.  However i think you are meant to 
>modify the standard styles rather than re-invent your own.  Obviously it's 
>smart to create your own for testing purposes so that you can experiment 
>without breaking anything but then apply what you learned to the main existing 
>styles.  

Having said all that it might well be best to upgrade to the 4.0.3 first.  The 
x.x.3 is the equivalent of Service Pack 3 and is usually the point where a 
branch becomes suddenly much more stable.  The 4.0.x has been more stable than 
earlier releases for me and i upgraded early because of it but normally i would 
wait for the x.x.3.  After that putting the time into fixing the problem is 
more likely to mean it stays fixed.  

Somewhere on the icon-bar is a backwards P which does show formatting marks but 
that doesn't show styles.  It does tend to give hints about where things might 
have gone wrong but the napalm option is probably the fastest way to fix this.  

Regards from 
Tom :)  







>
> From: Carl Paulsen 
>To: "users@global.libreoffice.org"  
>Sent: Friday, 10 May 2013, 12:43
>Subject: Re: [libreoffice-users] Table of Contents woes
> 
>
>Thanks, Tom.  It does seem like there's more than one style applied, but 
>I don't know how to check that.  Is there a way to display hidden 
>characters (would that show styles?) or other way I could see what's 
>going on?  The napalm approach would be to remove all styles for the 
>document and then re-apply them.  Maybe I'll try that on a portion of a 
>copy.
>
>Does anyone know what the Heading 1a style is for?  Is it possible I 
>created it a year ago when I started this document?  I don't recall 
>doing that.  I'll take a look at the styles section of the manual as 
>it's about time I really learned how to use them.  A PITA to learn but I 
>can see it's the best way to go.
>
>Here's a little more info:
>Heading 1a is level 1 in this document (not indented even thought this 
>section header IS in fact indented)
>Heading 1a is linked with Contents 2 (which is supposed to be level 2 I 
>think)
>
>So two questions.  First, could this be part of the trouble? Second, I 
>was considering upgrading to LO 4, and in case my styles got scrogged, 
>is there a way to upgrade while removing any styles I may have created?  
>I'm sure I can re-apply the Draft style watermark which is the only 
>custom style I intentionally use.
>
>Thanks,
>Carl
>
>
>
>On 5/10/13 2:16 AM, Tom Davies wrote:
>> Hi :)
>> Have you been able to manually edit it?
>>
>> It does look as though something is very wrong.  It looks like 2 
>> styles have been applied to each heading.  First as a sub-heading and 
>> then as a main heading.  Sometimes the fastest way to fix something is 
>> an inelegant approach such as mine rather than trouble-shooting down 
>> to the exact cause.
>>
>> If it was all the sub-headings that you wanted to get rid of then it's 
>> fairly easy to set the ToC to only show main headings but that would 
>> not help this case.  There is some documentation on Styles in Chapter 
>> 3 of the Getting Started Guide
>> https://wiki.documentfoundation.org/Documentation/Publications#Getting_Started_with_LibreOffice
>>
>> Hopefully someone else can give a better answer (or even better if i 
>> missed a better answer)
>> Apols and regards from
>> Tom :)
>>
>>
>>
>>     
>>     *From:* Carl Paulsen 
>>     *To:* "users@global.libreoffice.org" 
>>     *Sent:* Thursday, 9 May 2013, 19:21
>>     *Subject:* [libreoffice-users] Table of Contents woes
>>
>>     LibreOffice 3.5.6.2
>>     Build ID: e0fbe70-dcba98b-297ab39-994e618-0f858f0
>>     On an Intel Mac on 10.6.8
>>
>>     I have a draft document in which I've used heading styles for
>>     sections.
>>     I now want to create a Table of Contents (ToC), but I'm having
>>     trouble
>>     getting it to work right.  I'm using the styles almost as they
>>     came with
>>     the software (I added one style for a "Draft" watermark that I'm also
>>     using in this document).
>>
>>     The problem is that sections to which I've applied the Heading 1a
>>     style
>>     end up with 2 or 3 entries in the ToC, at different levels. So, for
>>     example, I have one Heading 1 section, "Fundraising History,"
>>     followed
>>     by a subsection called "Annual Fund" set to Heading 1a.  There are
>>     other
>>     subsections with Heading 1a applied, then other sections with
>>     Heading 1
>>     applied.  The ToC reads

Re: [libreoffice-users] Currency format always gets lost/screwed up

[Tom Davies]

Hi :)
Can you start with a fresh new document created in 4.0.2?  Then copy&paste in 
the contents and formatting from the old document.  See if that works.  Ideally 
it would be great to start a fresh document and do all the formatting from 
scratch to avoid pulling in some old problems but the copy&paste might be 
enough to leave behind any old unwanted stuff.  

I found that with documents that had originally been in MS formats i kept on 
bumping into weird problems.  Then again going from 3.3.x to 3.4.x but since 
then i've not had any problems.  
Regards from 
Tom :)  





>
> From: Mathias Koerber 
>To: users@global.libreoffice.org 
>Sent: Friday, 10 May 2013, 9:32
>Subject: [libreoffice-users] Currency format always gets lost/screwed up
> 
>
>I am using Libreoffice to write invoices.
>
>I have a table with several fields that need to be formatted
>as currency (SGD).
>
>I basically re-use an older document to save as a new one.
>Then I change the values.
>
>Most of the time one of the following happens:
>
>a) when I change just the numerical digits of the value,
>   the cell is no longer detected as numerical (and thus
>   counts as 0, detectable by the wrong sum in a SUM field
>   further down). It seems that it converts the old 'S$'
>   prefix found in the cell as text now.
>
>b) the 'S$' prefix gets lost and the value stands naked.
>
>Trying to correct this by selecting the value and
>applying
>    Table/Number format/selecting 'SGD' and
>  pressing ENTER often does nothing.
>
>Neither does selecting a different cell that still has the
>correct format applied, selecting the brush and trying
>to brush the format back into the cell that was screwed u.
>
>It takes me usually several minutes to clean out the cells
>and try to correct everything.
>
>It gets worse when I need to add or delete a row from the
>table and thus reapply the format to the new row or such.
>
>Is there no way to 'fix' the format for those cells, so that
>editing cannot screw up the format?
>
>Currency formatting in LO seems to be really broken :(
>
>I'm using
>Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)
>TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time:
>2013-03-26_15:52:16
>
>
>-- 
>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] Currency format always gets lost/screwed up

[Dan Lewis]

On 05/10/2013 04:32 AM, Mathias Koerber wrote:

I am using Libreoffice to write invoices.

I have a table with several fields that need to be formatted
as currency (SGD).

I basically re-use an older document to save as a new one.
Then I change the values.

Most of the time one of the following happens:

a) when I change just the numerical digits of the value,
the cell is no longer detected as numerical (and thus
counts as 0, detectable by the wrong sum in a SUM field
further down). It seems that it converts the old 'S$'
prefix found in the cell as text now.

b) the 'S$' prefix gets lost and the value stands naked.

Trying to correct this by selecting the value and
applying
Table/Number format/selecting 'SGD' and
   pressing ENTER often does nothing.

Neither does selecting a different cell that still has the
correct format applied, selecting the brush and trying
to brush the format back into the cell that was screwed u.

It takes me usually several minutes to clean out the cells
and try to correct everything.

It gets worse when I need to add or delete a row from the
table and thus reapply the format to the new row or such.

Is there no way to 'fix' the format for those cells, so that
editing cannot screw up the format?

Currency formatting in LO seems to be really broken :(

I'm using
Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)
TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time:
2013-03-26_15:52:16

   Suggestion:
1) Open the document in Writer.
2) Format the cells that will contain currency amounts. (Right click 
such a cell. Select Number Format from the context
menu. Select Currency in the Category list. In the Format list, 
select the format you want to use. Click OK.)

3) Save the document as a template (File > Save Templates).

 Now when you want to write an invoice, open this template, enter 
the data the invoice should have, and save the invoice.


--Dan

--
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] Table of Contents woes

[Carl Paulsen]

Thanks, Tom.  It does seem like there's more than one style applied, but 
I don't know how to check that.  Is there a way to display hidden 
characters (would that show styles?) or other way I could see what's 
going on?  The napalm approach would be to remove all styles for the 
document and then re-apply them.  Maybe I'll try that on a portion of a 
copy.


Does anyone know what the Heading 1a style is for?  Is it possible I 
created it a year ago when I started this document?  I don't recall 
doing that.  I'll take a look at the styles section of the manual as 
it's about time I really learned how to use them.  A PITA to learn but I 
can see it's the best way to go.


Here's a little more info:
Heading 1a is level 1 in this documnt (not indented even thought this 
section header IS in fact indented)
Heading 1a is linked with Contents 2 (which is supposed to be level 2 I 
think)


So two questions.  First, could this be part of the trouble? Second, I 
was considering upgrading to LO 4, and in case my styles got scrogged, 
is there a way to upgrade while removing any styles I may have created?  
I'm sure I can re-apply the Draft style watermark which is the only 
custom style I intentionally use.


Thanks,
Carl



On 5/10/13 2:16 AM, Tom Davies wrote:

Hi :)
Have you been able to manually edit it?

It does look as though something is very wrong.  It looks like 2 
styles have been applied to each heading.  First as a sub-heading and 
then as a main heading.  Sometimes the fastest way to fix something is 
an inelegant approach such as mine rather than trouble-shooting down 
to the exact cause.


If it was all the sub-headings that you wanted to get rid of then it's 
fairly easy to set the ToC to only show main headings but that would 
not help this case.  There is some documentation on Styles in Chapter 
3 of the Getting Started Guide

https://wiki.documentfoundation.org/Documentation/Publications#Getting_Started_with_LibreOffice

Hopefully someone else can give a better answer (or even better if i 
missed a better answer)

Apols and regards from
Tom :)




*From:* Carl Paulsen 
*To:* "users@global.libreoffice.org" 
*Sent:* Thursday, 9 May 2013, 19:21
*Subject:* [libreoffice-users] Table of Contents woes

LibreOffice 3.5.6.2
Build ID: e0fbe70-dcba98b-297ab39-994e618-0f858f0
On an Intel Mac on 10.6.8

I have a draft document in which I've used heading styles for
sections.
I now want to create a Table of Contents (ToC), but I'm having
trouble
getting it to work right.  I'm using the styles almost as they
came with
the software (I added one style for a "Draft" watermark that I'm also
using in this document).

The problem is that sections to which I've applied the Heading 1a
style
end up with 2 or 3 entries in the ToC, at different levels. So, for
example, I have one Heading 1 section, "Fundraising History,"
followed
by a subsection called "Annual Fund" set to Heading 1a.  There are
other
subsections with Heading 1a applied, then other sections with
Heading 1
applied.  The ToC reads:

Fundraising History
Annual Fund
Annual Fund
Auction
Auction

Etc.

The ToC should read:

Fundraising History
Annual Fund
Auction

Etc.

ToC screen grab
(I've inserted a screen-shot image here but not sure it'll get
through
to the group.)

Any idea what's going on and how I can fix it?  Thanks so much.

-- 


Carl Paulsen

Dover, NH


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




--

Carl Paulsen

8 Hamilton Street

Dover, NH 03820

(603) 749-2310


--
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] Table of Contents woes

[Dan Lewis]

On 05/09/2013 02:21 PM, Carl Paulsen wrote:

LibreOffice 3.5.6.2
Build ID: e0fbe70-dcba98b-297ab39-994e618-0f858f0
On an Intel Mac on 10.6.8

I have a draft document in which I've used heading styles for 
sections.  I now want to create a Table of Contents (ToC), but I'm 
having trouble getting it to work right.  I'm using the styles almost 
as they came with the software (I added one style for a "Draft" 
watermark that I'm also using in this document).


The problem is that sections to which I've applied the Heading 1a 
style end up with 2 or 3 entries in the ToC, at different levels. So, 
for example, I have one Heading 1 section, "Fundraising History," 
followed by a subsection called "Annual Fund" set to Heading 1a.  
There are other subsections with Heading 1a applied, then other 
sections with Heading 1 applied.  The ToC reads:


Fundraising History
Annual Fund
Annual Fund
Auction
Auction

Etc.

The ToC should read:

Fundraising History
Annual Fund
Auction

Etc.

ToC screen grab
(I've inserted a screen-shot image here but not sure it'll get through 
to the group.)


Any idea what's going on and how I can fix it?  Thanks so much.
  The problem seems to be in your heading styles. You would 
probably be better off using Heading 1, Heading 2, Etc. The Writer Guide 
contains instructions for how to create a ToC. I suggest you download 
the Guide and follow its directions.

https://wiki.documentfoundation.org/Documentation/Publications

--Dan

--
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] Seeking for list moderators

[e-letter]

On 08/05/2013, Sigrid Carrera  wrote:
> Hi,
>
>
> On 8 May 2013 08:41, e-letter  wrote:
>
>> On 04/05/2013, Sigrid Carrera  wrote:
>> > Hi Tom,
>> >
>> >
>> > On 4 May 2013 18:47, Tom Davies  wrote:
>> >
>> >> Hi :)
>> >> That is a very generous offer but i suspect you would have more fun
>> >> and
>> be
>> >> more useful in other areas of the project!!
>> >>
>> >[...]
>>
>
>>
>
>> Would you please "moderate" their posts particularly? ;) Please mark
>> "top-post spam: delete"
>>

A deliberate addition to see who would bite the bait and prefer not to
discuss the original topic; it worked ;)

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

[Vieri]

Thanks Fernand.

I'm currently using Java (HttpURLConnection) to do the HTTP stuff (easier).
For things that are simpler to do with Basic, I run other macros from within my 
Java macro (with XScript).

Thanks for your suggestion.

Vieri

--- On Fri, 5/10/13, Fernand Vanrie  wrote:

> From: Fernand Vanrie 
> Subject: Re: [libreoffice-users] gettextfields
> To: users@global.libreoffice.org
> Date: Friday, May 10, 2013, 4:48 AM
> On 9/05/2013 9:13, Vieri wrote:
> > 
> > --- On Thu, 5/9/13, mcmurchy1917-libreoff...@yahoo.co.uk
> 
> wrote:
> > 
> >> Hi Vieri
> >> 
> >> The form you've created contains a set of controls
> of which
> >> one or more of
> >> them are of the "Text box" variety.
> >> 
> >> 
> >> You may also have other controls on the form such
> as a
> >> "Check Box", "Label" or
> >> "Push Button" these latter controls don't have the
> ability
> >> to hold text or
> >> edit text so don't have the .Text property. So for
> these
> >> controls the code
> >> x.Text will fail.
> >> 
> >> 
> >> Try this
> >> 
> >> Sub EnumerateFields
> >> 
> >>      oDoc = ThisComponent
> >>      oDrawPage = oDoc.DrawPage
> >>      oForm =
> oDrawPage.Forms.GetByIndex(0)
> >>        For i = 0 To
> oForm.getCount()-1
> >>           x =
> >> oForm.getByIndex(i)
> >>           if
> >>
> x.supportsService("com.sun.star.form.component.TextField")
> >> then
> >>             
>     Print x.getName() & " : " & x.Text
> >>           
>    End If
> >>        Next
> >>    End Sub
> > Thanks Iain.
> > Your help is much appreciated. The macro works.
> > Now I'm trying to send HTTPS POST requests to my web
> server (not succeeding but that's another story).
> i use a "create a Windows" object to do the posting
> "WinHttp.WinHttpRequest.5.1"
> 
> hope it helps
> greetz
> Fernand
> 
> 
> Function MicrosoftTranslate(sLanguageFrom As String,
> sLanguageTo As String, sText As String) As String
> 
>   '  On Error Goto err_catch0
> 
>     Dim ID As String
>     Dim sURL As String
>     Dim oH As object
>     Dim sToken As String
> 
>     ID = ""
>     sURL = 
> "http://api.microsofttranslator.com/V2/Ajax.svc/Translate?oncomplete=&appId=";
> & ID & "&from=" & sLanguageFrom &
> "&to=" & sLanguageTo & "&text=" &
> JSencodeURLpart(sText)
>     sToken = GetAccessToken()
>     oH =
> CreateObject("WinHttp.WinHttpRequest.5.1")
>     oH.Open "POST", sURL, False
>     oH.setRequestHeader "Authorization", "Bearer "
> & sToken
>     oH.send
>     t = oH.ResponseText
> 
>     MicrosoftTranslate = mid(t,3,len(t)-3)
> 
>     Set oH = Nothing
> 
> exit_sub:
>     Exit Function
> 
> err_catch0:
>   msgbox("err_catch0 " & Err & Error &
> Erl,48)
> 
>     Resume exit_sub
> End Function
> 
> Function GetAccessToken() As String
> 
>     On Error Goto err_catch2
> 
> 
>     Dim mtToken As String
>     webRequest =
> CreateObject("WinHttp.WinHttpRequest.5.1")
>     Dim URI As String
>     Dim txtToken As String
> 
>     URI = "https://datamarket.accesscontrol.windows.net/v2/OAuth2-13";
> 
>     'Client ID from https://datamarket.azure.com/developer/applications
>     Dim clientId As String
>     clientId = "myclientid"
> 
>     'Client secret from https://datamarket.azure.com/developer/applications
>     Dim clientSecret As String
>     clientSecret =
> "JTEGDEb1OViegnPz0kzkvRWhOSeNRJpmPgjqauyeV8k="
> 
>     Dim sRequest As String
>     sRequest = "grant_type=client_credentials"
> & _
>     "&client_id=" &
> JSencodeURLpart(clientId, false) & _
>     "&client_secret=" &
> JSencodeURLpart(clientSecret, False) & _
>     "&scope=http://api.microsofttranslator.com";
> 
>     webRequest.Open("POST",URI, False)
>     webRequest.setRequestHeader "Content-Type",
> "application/x-www-form-urlencoded"
>     webRequest.send (srequest)
>     mttoken = WebRequest.ResponseText
> 
> 
>    Dim arr As Variant, header As String
> 
>     header = """access_token"":"""
> '"&HMACSHA256="
>     footer = """,""expires_in"":"""
>   headerpos = instr(mttoken, header)+len(header)
>   footerpos = instr(mttoken, footer)
>   tokenl = footerpos-headerpos
>     txtToken = mid(mttoken ,headerpos , tokenl)
> '    xray txttoken
> '    If txtToken = "_request" Then Resume
> err_catch:
> 
>     GetAccessToken = txtToken
> 
> 
> exit_sub:
>      Exit Function
> 
> err_catch2:
> beep
>     msgbox("err_catch2 " & Err & Error
> & Erl, 48)
>     Resume exit_sub
> End Function
> 
> 
> Function URLEncode(StringToEncode As String,
> UsePlusRatherThanHexForSpace As Boolean ) As String
> 
>     On Error Goto err_catch3
> 
>     Dim TempAns As String
>     Dim CurChr As Integer
> 
>     CurChr = 1
>     Do Until CurChr - 1 = Len(StringToEncode)
>          Select Case
> Asc(Mid(StringToEncode, CurChr, 1))
>         Case 48 To 57, 65 To 90, 97 To
> 122
>             TempAns = TempAns
> & Mid(StringToEncode, CurChr, 1)
>         Case 32
>             If
> UsePlusRatherThanHexForSpace = True Then
>                
> TempAns = TempAns & "+"
>             Else
>                
> TempAns = TempAns & "%" & Hex(32)
> 

Re: [tdf-discuss] Re: [libreoffice-users] [4.0.3.3 non fixed bug] Link with a space Pdf export error (%20 characters - space ones - exported as %2520 ones)

[Florian Reisinger]

Hi,

Am 10.05.2013 08:28, schrieb Tom Davies:

Hi :)
I don't know if there is one for LibreOffice yet.


Please have a look and file one (https://www.libreoffice.org/get-help/bug/)



People have tried to show me how to look things up in the bug-report 
place but for some reason i can never quite manage it myself.


Feel free to ask at the IRC channel libreoffice-qa




Also i'm not sure if just solving the problem in LibreOffice would 
make the problem go away.  It seems to be further "upstream" with 
fairly major projects having to deal with it separately. is it 
possible to post a bug-report against "the internet"?

Apols and regards form
Tom :)


Nope not possible, at least how far I know :)




[Cutting the unnecessary things away]

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

[Fernand Vanrie]

On 9/05/2013 9:13, Vieri wrote:


--- On Thu, 5/9/13, mcmurchy1917-libreoff...@yahoo.co.uk 
 wrote:


Hi Vieri

The form you've created contains a set of controls of which
one or more of
them are of the "Text box" variety.


You may also have other controls on the form such as a
"Check Box", "Label" or
"Push Button" these latter controls don't have the ability
to hold text or
edit text so don't have the .Text property. So for these
controls the code
x.Text will fail.


Try this

Sub EnumerateFields

 oDoc = ThisComponent
 oDrawPage = oDoc.DrawPage
 oForm = oDrawPage.Forms.GetByIndex(0)
   For i = 0 To oForm.getCount()-1
  x =
oForm.getByIndex(i)
  if
x.supportsService("com.sun.star.form.component.TextField")
then
  
   
Print x.getName() & " : " & x.Text
  
End If

   Next
   
End Sub

Thanks Iain.
Your help is much appreciated. The macro works.
Now I'm trying to send HTTPS POST requests to my web server (not succeeding but 
that's another story).
i use a "create a Windows" object to do the posting 
"WinHttp.WinHttpRequest.5.1"


hope it helps
greetz
Fernand


Function MicrosoftTranslate(sLanguageFrom As String, sLanguageTo As 
String, sText As String) As String


  '  On Error Goto err_catch0

Dim ID As String
Dim sURL As String
Dim oH As object
Dim sToken As String

ID = ""
sURL = 
"http://api.microsofttranslator.com/V2/Ajax.svc/Translate?oncomplete=&appId="; 
& ID & "&from=" & sLanguageFrom & "&to=" & sLanguageTo & "&text=" & 
JSencodeURLpart(sText)

sToken = GetAccessToken()
oH = CreateObject("WinHttp.WinHttpRequest.5.1")
oH.Open "POST", sURL, False
oH.setRequestHeader "Authorization", "Bearer " & sToken
oH.send
t = oH.ResponseText

MicrosoftTranslate = mid(t,3,len(t)-3)

Set oH = Nothing

exit_sub:
Exit Function

err_catch0:
  msgbox("err_catch0 " & Err & Error & Erl,48)

Resume exit_sub
End Function

Function GetAccessToken() As String

On Error Goto err_catch2


Dim mtToken As String
webRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
Dim URI As String
Dim txtToken As String

URI = "https://datamarket.accesscontrol.windows.net/v2/OAuth2-13";

'Client ID from https://datamarket.azure.com/developer/applications
Dim clientId As String
clientId = "myclientid"

'Client secret from https://datamarket.azure.com/developer/applications
Dim clientSecret As String
clientSecret = "JTEGDEb1OViegnPz0kzkvRWhOSeNRJpmPgjqauyeV8k="

Dim sRequest As String
sRequest = "grant_type=client_credentials" & _
"&client_id=" & JSencodeURLpart(clientId, false) & _
"&client_secret=" & JSencodeURLpart(clientSecret, False) & _
"&scope=http://api.microsofttranslator.com";

webRequest.Open("POST",URI, False)
webRequest.setRequestHeader "Content-Type", 
"application/x-www-form-urlencoded"

webRequest.send (srequest)
mttoken = WebRequest.ResponseText


   Dim arr As Variant, header As String

header = """access_token"":""" '"&HMACSHA256="
footer = """,""expires_in"":"""
  headerpos = instr(mttoken, header)+len(header)
  footerpos = instr(mttoken, footer)
  tokenl = footerpos-headerpos
txtToken = mid(mttoken ,headerpos , tokenl)
'xray txttoken
'If txtToken = "_request" Then Resume err_catch:

GetAccessToken = txtToken


exit_sub:
 Exit Function

err_catch2:
beep
msgbox("err_catch2 " & Err & Error & Erl, 48)
Resume exit_sub
End Function


Function URLEncode(StringToEncode As String, 
UsePlusRatherThanHexForSpace As Boolean ) As String


On Error Goto err_catch3

Dim TempAns As String
Dim CurChr As Integer

CurChr = 1
Do Until CurChr - 1 = Len(StringToEncode)
 Select Case Asc(Mid(StringToEncode, CurChr, 1))
Case 48 To 57, 65 To 90, 97 To 122
TempAns = TempAns & Mid(StringToEncode, CurChr, 1)
Case 32
If UsePlusRatherThanHexForSpace = True Then
TempAns = TempAns & "+"
Else
TempAns = TempAns & "%" & Hex(32)
End If
Case Else
TempAns = TempAns & "%" & _
Right("0" & Hex(Asc(Mid(StringToEncode, _
CurChr, 1))), 2)
End Select

CurChr = CurChr + 1
Loop
URLEncode = TempAns

exit_sub:
Exit Function

err_catch3:
beep
   msgbox("err_catch3 " & Err & Error & Erl ,48)
Resume exit_sub

End Function



Thanks again!

Vieri






--
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] Currency format always gets lost/screwed up

[Mathias Koerber]

I am using Libreoffice to write invoices.

I have a table with several fields that need to be formatted
as currency (SGD).

I basically re-use an older document to save as a new one.
Then I change the values.

Most of the time one of the following happens:

a) when I change just the numerical digits of the value,
   the cell is no longer detected as numerical (and thus
   counts as 0, detectable by the wrong sum in a SUM field
   further down). It seems that it converts the old 'S$'
   prefix found in the cell as text now.

b) the 'S$' prefix gets lost and the value stands naked.

Trying to correct this by selecting the value and
applying
Table/Number format/selecting 'SGD' and
  pressing ENTER often does nothing.

Neither does selecting a different cell that still has the
correct format applied, selecting the brush and trying
to brush the format back into the cell that was screwed u.

It takes me usually several minutes to clean out the cells
and try to correct everything.

It gets worse when I need to add or delete a row from the
table and thus reapply the format to the new row or such.

Is there no way to 'fix' the format for those cells, so that
editing cannot screw up the format?

Currency formatting in LO seems to be really broken :(

I'm using
Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)
TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time:
2013-03-26_15:52:16


-- 
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: [tdf-discuss] Re: [libreoffice-users] [4.0.3.3 non fixed bug] Link with a space Pdf export error (%20 characters - space ones - exported as %2520 ones)

[Carlo Strata]

Hi Everyone,

as I told yesterday in my first mail I will look for an already created 
issue and if not I will create it. When I make this? Now! ;-)

In any case I will make you know what I do.

@Tom:

I think that:
- on URLs, browsers - but maybe a behaviour stated on  a well determined 
W3 Standard or similar open Consortium - substitute spaces with %20 hex 
character code;
- %20 (!!!): that means that "%", "2" and "0" are all (!) well admitted 
characters, all (!!!);
- so I don't see the reason to recursively (!!!) substitute the "%" 
character when an URL is input in LibreOffice because "%" it self is 
already an accepted one;
- another low probability hypotheses in my head was that LibreOffice 
translate the space on a full 16 bit space character coding, but your 
explain about %25 representing the "%" hex code, rapidly make me clear 
what was happened;
- in any case (!), if you open the with-space link directly from a 
Writer document (ctrl+click for friends o chaps ;-) )  you will get the 
right page: in other words the link behave correctly! So the problem on 
pdf link behaviour has to be fixed in LibreOffice too!!! :-) But I do 
not think is a too hard to do, is not it?


Now I will go to open or vote an existing issue and come back here soon. 
I think we could also to maintain only one discuss: I will suggest the 
tdf-discuss one, what do you think about?


Have All a sunny day,

Carlo

I

ing. Carlo Strata
-
via Botticelli 1/4
30031 Dolo - VE
Italia - Italy
-
tel./fax +39.041.822.0665
cell. +39.347.85.69.824
Skype carlo.strata
Google carlo.strata.69
-
carlo.str...@tiscali.it
PEC: carlo.str...@ingpec.eu

Il 10/05/2013 08.28, Tom Davies ha scritto:

Hi :)
I don't know if there is one for LibreOffice yet.

People have tried to show me how to look things up in the bug-report place but 
for some reason i can never quite manage it myself.

Also i'm not sure if just solving the problem in LibreOffice would make the problem go away.  It 
seems to be further "upstream" with fairly major projects having to deal with it 
separately. is it possible to post a bug-report against "the internet"?
Apols and regards form
Tom :)







From: Florian Reisinger 
To: Tom Davies 
Cc: Carlo Strata ; "TDF, discuss" ; 
"LibreOffice, users" 
Sent: Thursday, 9 May 2013, 16:37
Subject: Re: [tdf-discuss] Re: [libreoffice-users] [4.0.3.3 non fixed bug] Link 
with a space Pdf export error (%20 characters - space ones - exported as %2520 
ones)


Hi,

Does a bug report exist yet?

Liebe Grüße, / Yours,
Florian Reisinger

Am 09.05.2013 um 14:10 schrieb Tom Davies :


Hi :)
%25 is the code for a % symbol so the 'wrong' link is not really wrong after 
all.  It's just a bit odd and unnecessary.  In the 'wrong' link replace all the 
%25s with % so that %2520 becomes %20 and then the apparently 'wrong' link 
looks right.  It's a good reason for avoiding spaces and non-standard 
characters in Urls.  CamelCase is much less prone to these sorts of problems.

Seems a few other organisations are having trouble with %25 replacing %
http://social.microsoft.com/Forums/en-US/technicalqueries/thread/6f20c6a9-0ed9-4e96-a0f7-cc1abbdf58a8
https://discussions.apple.com/thread/1648880?start=0&tstart=0
https://github.com/pipwerks/PDFObject/issues/23
http://drupal.org/node/1335942
http://stackoverflow.com/questions/3549747/apache-25-in-url-400-bad-request

Welcome back chap!  Lets hope they can fix it!
Regards from
Tom :)








From: Carlo Strata 
To: "TDF, discuss" ; "LibreOffice, users" 

Sent: Thursday, 9 May 2013, 12:29
Subject: [libreoffice-users] [4.0.3.3 non fixed bug] Link with a space Pdf 
export error (%20 characters - space ones - exported as %2520 ones)


Hi Everyone and sorry for my long silence!

I have not read the mailing list for a long, but I am always here to
use, test, update and spread LibreOffice! ;-)

Since 4.x versions - but maybe since before:

1. if you create a new writer document and copy in it a with-space-link
like this:
http://support.mozilla.org/it/kb/Informazioni%20su%20Firefox%20Sync
2. save the document;
3. export the document in pdf with the default settings;
4. open the exported pdf;
5. click on the clickable link;
6. you will get this wrong link instead:
http://support.mozilla.org/it/kb/Informazioni%2520su%2520Firefox%2520Sync
7. if you open that link from the odt (as usual with a ctrl+click) you
get instead the right link and the browser open correctly!
8. if you leave your mouse cursor on the link both on the pdf and the
odt documents you will get a correct title yellow lable ("tooltip") too!
9. I finally think there is a bug on the pdf export module.
10. This is the same if you create the above document with the Insert ->
Hypertext link menu function.

I have tested this on each new testing release, but only today I have
found the mental time to write this mail.
I am also going to search if there is a related issue yet and if not, as
I used in 

[libreoffice-users] Printer settings

[Malcolm Moore]

Somehow I have changed my printer settings to use the bypass tray and
for the life of me I can't work out how to get it to go back to auto

I tried setting it in spadmin but the LO apps ignore it
I tried removed ~/.config/libreoffice and that doesn't work

???

BTW LO 4.0.3 on openSuse 12.3 

Ta


Mal

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