[libreoffice-users] Re: about unicode txt documents:

[CVAlkan]

Hi Nasrin:

Your comment, the "encoding is unicode," is rather meaningless, since
Unicode simply provides a long and unique number for most every glyph used
to write something down. The actual "encoding" you care about is the
specific method used to represent these unique numbers, which is typically
UTF-8 for most uses, but can be UTF-16 or UTF-32 for special cases.

If you go to BUG #92655
(https://bugs.documentfoundation.org/show_bug.cgi?id=92655), and then to the
second comment (marked as Comment #1) and download the attachment (117160)
listed there, you'll find a 32 page pdf document I created some time back
titled "Exploring Complex Text Layout." This document covers a lot of what
you need to understand to use other scripts in LibreOffice Writer,
particularly if you are using more than one script/language in the same
document.

Since you are presumably writing Farsi, a language which uses the Arabic
script, you'll be interested (maybe) that this script, along with Thai,
Hindi, and Hebrew, is used in some of the examples in my pdf.

Unfortunately, I am unfamiliar with Farsi, so my Arabic script examples are
in the Arabic language (well, one flavor of that), but I'm sure you'll find
the discussion informative, as it covers a lot of the niceties such as
contextual alteration of the character forms, kashideh justification, issues
with using right-to-left scripts in Writer, and so forth.

Beginning on page 33 of the document, there is an explanation of how Unicode
values may be converted into one, two, three, or four bytes in standard
UTF-8 encoding, and why these options are all needed. While UTF-32
characters are always 32 bits (4 bytes) long, UTF-8 character sizes can vary
depending on what character set is in use *for any given individual
character*. While the  غ or ي characters are each two bytes in length, a
space or a carriage return are still only one byte in length. Although it
seems on the surface to be a complicated way of doing things, it's actually
a really cool way of achieving a rather difficult objective.

There is also a section in the pdf about various ways of entering
characters; having a keyboard mapped to another language is great until you
need to switch back and forth on a regular basis.

The bottom line is that the font that is in use must contain the characters
from Unicode block 0600-06ff in order to reproduce Persian/Farsi, which is
why I suggested the fonts that I did, as I know that those include these
characters.

You are stepping into a very interesting area, particularly as LibreOffice
is not particularly good with right-to-left languages if you attempt some
things that are trivial in English (e.g. rotating text in a table cell among
other things). If you are interested in things to look out for with Writer,
go back to the same bug referenced above and download the first attachment
#117159 for a tour of the issues you might face.

I hope this helps you get an idea of what you are stepping into.

Good Luck,

Frank




--
View this message in context: 
http://nabble.documentfoundation.org/about-unicode-txt-documents-tp4178249p4178872.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] Save/Store files

[Regina Henschel]

Hello Heinrich,

Heinrich Stoellinger schrieb:

Hello,
I am using LO 5.1.1 (latest development version). Since version 5 I notice
that in writer the tab "Speichern" (German for store/save) is not grayed,
even though NOTHING has changed in the file. Is this intentional?
Regards
H. Stoellinger
Salzburg



Yes, that is intended. It is no longer a single icon, but has a 
drop-down list. If it were disabled, this list could not be reached. The 
next version will have a colored asterix on the icon, if something has 
changed, so that you can easily see, that you need to save the document.


Kind regards
Regina

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

[libreoffice-users] Re: shrinking an LO window

[V Stuart Foote]

@John, *

What OS and Desktop Environment.  On Windows builds, there is a nice large
target, at least 10 px, that triggers the corner "resize" grab. Have no
problem resizing this OS.

Stuart



--
View this message in context: 
http://nabble.documentfoundation.org/shrinking-an-LO-window-tp4178759p4178761.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Python

[Mark Stanton]

Does the Python macro interface work?
Does it work well if it does work?

Mark

-- 
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] New Hyperlinks Not Underlined

[Tim---Kracked_P_P---webmaster]

On 03/16/2016 05:44 PM, Dale H. Cook wrote:

At 03:25 PM 3/16/2016, Tim wrote:


I have a question.
Where is the color for the hyperlinks defined?
In the document or in a CSS file?

This is in a Writer .odt document, and the link colors are defined in 
LibreOffice - Tools | Options | LibreOffice | Application Colors - Unvisited 
Links / Visited Links.

Dale H. Cook, Member, NEHGS and MA Society of Mayflower Descendants;
Plymouth Co. MA Coordinator for the USGenWeb Project
Administrator of http://plymouthcolony.net


Thanks.
For some reason I missed those two color options listed there.
I never looked adding such a linked text within a .odt file.
I have seen some in a PDF file with some but not .odt files.


--
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: Calc F2 cursor trail between brackets of function [Was: ]

[libreoffice-ml . mbourne]

nasrin khaksar wrote:

hi mark.
thanks for your reply about question about calc.


I assume you're referring to the thread "Calc F2 cursor trail between 
brackets of function". It's easier to follow if you reply-all to the 
message you're responding to.



how about openGL in version 4.4.6?
is it enabled by default or not?


From , it looks like OpenGL 
has been available since 4.3 but only enabled by default since 5.0.2. 
Presumably for versions between those you'd have to explicitly enable it 
in the options.



i read in the link that you sent, its enable by default since version
5.0.2 and we should copy one file to registry to desable it in case of
crash on openning program.
in other side, i read somewhere that recognizes the problem by default
and if crashes in the first time, its desable in the second time
automaticly.
is it possible? and which one is true?


I would think it possible that LibreOffice could automatically disable 
OpenGL if it detects a crash on first start, but I don't know if it's 
actually done that way. It might not be desirable to do that in case the 
crash is for some other reason not related to OpenGL. Not knowing where 
you saw that I can't really comment further.


--
Mark.


--
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: Calc as a Flat File Database

[Ian "Witty" Whitfield]

Thanks all - appreciated!!

My background is 30 years in the Computer Business - Training, 
installations, support etc etc.

Since retiring I left Windows behind and changed to Linux.
What I'm not is a Programmer - except with BASIC about 20 years ago!!!

My needs are to have a SOLID, RELIABLE simple Members Database that does 
not crash all the time and take the data with it as well.
I don't even need a RDB as I have one table, one Form and a few queries, 
it is single user on a single machine. My Form only uses Text Boxes, 
Drop-Down Boxes, Check Boxes and Photos and Graphics. End of story!! i 
don't want to become a DB expert just a basic layout person and every 
day user.


I did not think this would be a big problem in Linux - how wrong I was. 
I have battled with Base for several years and after my last crash in 
January, (Data lost, as is common, even with MySQL. The file is still 
there but it can not be accessed).


I thank Jarasow for his help with Kexi but after 10 crashes in 2 weeks 
and some missing features and no help to try and get Drop-boxes to work 
I had to give up on it. It does look very promising but has a way to go 
yet I fear.


So Alexander has told me how to save my Form (that helps a lot) and I 
decided to get back into Base as it seems to be the only way to go for 
me. But MySQL is giving me up-hill. It does not seem to want to save an 
empty Table for me to import my CSV into and gives me this error ...


"#1064 - You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near 'varchar(10), `NULL` varchar(10), `NULL` varchar(10), `NULL` 
varchar(21), `NULL` ' at line 1"


I seem to remember this from when I first set it up last year. It's not 
MY SQL - this is what the program did!! Also my first line of the CSV is 
the column names only and it works OK with Calc and did so as well with 
Kexi!! So where is the problem??!!

So I'm unable to populate the DB in MySQL for Base to link to it!!

Thanks all.

--
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] Calc F2 cursor trail between brackets of function

[libreoffice-ml . mbourne]

Canonical / Ubuntu might maintain a repository of patches applied to the 
upstream version, or have the issue on their own bug tracker indicating 
what the fix was. Otherwise I've no idea; perhaps someone else here 
might know more.


Mark.


Bruce Hohl wrote:

I did disable both OpenCL options and that made no difference.  Thinking
this might be related to my hardware I rebooted with a Linux Mint  17.3
live USB which includes the Ubuntu version of LO 5.0.3.2 ... and ... no
cursor trail !!!  My current install is the DEB packages of LO 5.1.1.3
downloaded from LibreOffice.org.  It seems that Canonical / Ubuntu may have
added some tweak to fix this problem.  So now my question is does anyone
know where to find the Ubuntu adjustments to LO.  Apparently one of those
adjustments is the fix to bug 67787.

On Tue, Mar 15, 2016 at 4:35 PM, 
wrote:


Bruce Hohl wrote:


When in Calc while editing a formula (within the cell via F2) with
characters between brackets like: =SUMIFS*(*
$TB_data.C$8:C$32,$TB_data.D$8:D$32,A36*)* or =*(*A1+A2+A3*)*.

If the arrow keys are used to moved left and right, while moving past the
character within brackets a cursor trail is displayed like this:

  
SUMIFS($|T|B|_|d|a|t|a|.|C|$|8|:|C|$|3|2|,|$|T|B|_|d|a|t|a|.|D|$|8|:|D|$|3|2|,|A|3|6).
The first use of F2 editing is OK but subsequent uses display this
behavior.

When you get to the closing bracket the cursor trail disappears.  Or if
you
minimize then restore the window the cursor trail disappears.

It seems to happen only within brackets, seems to be a failure to refresh
while within brackets, impacts Linux & Windows versions, and this display
error was not always present.  This behavior is described in bug 67787
from
2013-08-05.

I believe it may be related to the bracket matching (high lighting)
feature
that was introduced a few years back.  Does anyone recall which version
added that feature or know anything about this feature?

I find this super annoying and would like to improve the bug report.  If
related to bracket matching I'd rather that be disabled versus a cursor
trail rendering F2 in cell editing useless. It also makes LO look
unpolished.



I wonder if this may be related to using OpenGL for rendering, which has
apparently been enabled by default from version 5.0.2 onwards. It should be
possible to disable via Tools > Options > LibreOffice > View. It may need a
restart of LibreOffice (including the Quickstarter if you use that) to take
effect.

If that resolves the problem, it's probably worth noting on the bug
report, along with the info about your graphics card as described at <
https://wiki.documentfoundation.org/OpenGL>. Some of these rendering
problems only occur with OpenGL, and only with certain graphics cards.

Mark.



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

[Joshua Kramer]

Paul, I sent you an example off-list.  The easiest way I've been able
to get this to work is by embedding the script into the ODS or ODT
file itself.  Try this: unzip an ODS file.  Create a directory called
Scripts, and then a directory called python under Scripts.  (Note the
capitalization!)  Put your Python script in the Scripts/python
directory.  Next, edit the manifest.xml file under META-INF and add a
section containing the text shown below, in the place shown below.
Finally, zip it all back up and open it with Calc.  You should be able
to run your macro now, if your security is set properly.

This is probably not what you want to do, if your script will need to
touch lots of different ODT/ODS files.  The file I sent contains a
macro that is intended to run only on that file.

(The file in question is a budget spreadsheet; the Python macro
calculates all of your pay weeks and adds a sheet to the workbook for
each pay week.  It then ties a cell on any given sheet to a different
cell on the previous sheet, so you can track how much extra money you
accumulate over time.  Anyone else who wants it let me know and I'll
send it off-list.)



...several different manifest entries appear here, add the following lines:

 
 


On Fri, Mar 18, 2016 at 10:36 PM, Paul Hammant  wrote:
> I have tried all the security levels, with re-launches of LibreOffice in
> between.  Yes I can run the sample Python macros.
>
> - Paul
>
> On Fri, Mar 18, 2016 at 9:52 PM, Jim Byrnes  wrote:
>
>> On 03/18/2016 03:55 PM, Paul Hammant wrote:
>>
>>> I have not worked out how to activate it :-(
>>> Ref  http://listarchives.libreoffice.org/global/users/msg47885.html
>>>
>>> -ph
>>>
>>
>> I see from the link you are on a Mac. I am on linux but the last part of
>> your path to the script seems to be about the same as mine would be.
>>
>> Have you set the macro security to a level that will allow you to run
>> macros? I've been tripped up by this a couple of times on new installs.
>>
>> Can you run any of the sample python macros that come with LO? If you can
>> maybe that indicates a path issue after all.
>>
>> Regards,  Jim
>>
>>
>> On Fri, Mar 18, 2016 at 10:44 AM, Mark Stanton 
>>> wrote:
>>>
>>> Does the Python macro interface work?
 Does it work well if it does work?

 Mark

 --
 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
>>
>
> --
> 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] Re: Calc as a Flat File Database

[jorge]

Hi Alexander and all:

Thank you for your clear explanation. If I understood you well, this
happen when we predefined the table in Base that we think that we will
need. But when I have needed do it, I didn't make the table, I only use
connect option (when start BASE), with a .db (spreadsheet -.ods-) that I
have in my file directory. I think that in this way BASE create the
table with the characteristic of the origin (.ods file).

Regards,

Jorge Rodríguez


El jue, 17-03-2016 a las 16:35 +0100, Alexander Thurgood escribió:
> Le 17/03/2016 16:08, jorge a écrit :
> 
> 
> Hi Jorge,
> 
> > I suggest to you to open the .CSV file with CALC. Then save it as .ODS.
> > Finally, import from BASE the .ODS file.
> > 
> 
> The import wizard from Calc to Base is not perfect, so unless one is
> absolutely sure that the data in your CSV or Calc file exactly matches
> the definition of the fields in the table, then one should expect either
> import errors or failure. Particular things to watch out for :
> 
> - date / time / datetime representations
> - text values over integers
> - null fields
> - values intended to be used in an autoincrement field
> - boolean values
> - memo fields
> - unsigned INT field values
> - zero-fill values
> 
> etc, etc
> 
> 
> Alex
> 
> 
> 

-- 
Atentamente,

Jorge Rodríguez


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

[libreoffice-users] "Control Point" in Position&Size dialog

[Regina Henschel]

Hi all,

the Position&Size dialog has got the entries "Control Point 1" and 
"Control Point 2". But I see no way to use them. The fields x and y are 
always disabled and they show totally wrong values. I have tried it with 
"Advanced feature" enabled and without; I have tried it with custom 
shapes and with a primitive Sector shape; I have tried it with point 
modus on and off. Nothing works.


Any idea about it?

Kind regards
Regina

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

Re: [libreoffice-users] New Hyperlinks Not Underlined

[Tim---Kracked_P_P---webmaster]

I have a question.
Where is the color for the hyperlinks defined?
In the document or in a CSS file?

I tend to use these CSS style sheets to have a set of predefined text 
color and size options, including the colors of the defined hyperlink 
options.  So I just have to refer to the style sheet file and use the 
defined link styles and the commands like "#n10link" type of command in 
the "style" tag to define the fonts, color, and size, of the text in the 
web page.


I am now using 5.1.1.3 on my Ubuntu 64-bit laptop. Do you remember which 
version of LO your link colors worked correctly with?


I cannot find the info for adding a color in the add hyperlink option - 
such as defining the colors for link, visited, and hover color options 
shown in the CSS sample I have included in this document.  To be honest, 
because I use CSS files I never tried looking for the color options you 
needed.  Also, I do not use Writer/Web for web page editing.


I was using Kompozer for a long time, till Ubuntu changed the GUI and 
became unsupported using Ubuntu 14.XX or later.  I do have it on my 
Windows partition though.  I currently use Bluefish on Linux for the 
basic file editing.  I do not think I would want to use that for new 
page creation though.  Maybe I will see into using Writer/Web for some 
of the work, at some later time.


This is a small sample of my standardized style sheet file.



On 03/16/2016 02:22 PM, Dale H. Cook wrote:

I don't know what happened to my LibreOffice 5.1.0.1 installation, but in 
Writer new hyperlinks began behaving oddly. The colors for visited and 
unvisited links defaulted to the original automatic colors, and that was easily 
fixed. New hyperlinks (both internet and document), however, are now no longer 
underlined. Any clues?

Dale H. Cook, Member, NEHGS and MA Society of Mayflower Descendants;
Plymouth Co. MA Coordinator for the USGenWeb Project
Administrator of http://plymouthcolony.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

[libreoffice-users] Re: about unicode txt documents:

[CVAlkan]

Nasrin:

Just in case: your default font is one that has the Persian characters,
right?

If you try "Insert | Special Character ..." and don't see any of the
characters you need when you scroll down, you'll need to change the font for
your Default Style. Free-* and Liberation-* fonts might not be to your
liking, but they have all the characters you'll need to test.





--
View this message in context: 
http://nabble.documentfoundation.org/about-unicode-txt-documents-tp4178249p4178787.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] Re: about unicode txt documents:

[nasrin khaksar]

hi.
yes. my documents are in persian language and the encoding is unicode.

On 3/17/16, CVAlkan  wrote:
> Nasrin:
>
> Just in case: your default font is one that has the Persian characters,
> right?
>
> If you try "Insert | Special Character ..." and don't see any of the
> characters you need when you scroll down, you'll need to change the font
> for
> your Default Style. Free-* and Liberation-* fonts might not be to your
> liking, but they have all the characters you'll need to test.
>
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/about-unicode-txt-documents-tp4178249p4178787.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
>
>


-- 
Those who follow the Messenger-Prophet, the Ummi, whom they find
written down with them in the Taurat and the Injeel [who] enjoins them
good and forbids them evil, and makes lawful to them the good things
and makes unlawful to them impure things, and removes from them their
burden and the shackles which were upon them; so [as for] those who
believe in him and honor him and help him, and follow the light which
has been sent down with him, these it is that are the successful.
holy quran, chapter 7, verse 157.
best website for studying islamic book in different languages
al-islam.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] shrinking an LO window

[John R. Sowden]

In order to reduce the size of an LO window, the mouse is used to grab 
the lower right corner and bring it up/left.  The problem is that it 
seems that the point of the mouse pointer must be on the corner pixel of 
the window.  This is very tedious and time consuming.  My first thought 
was this is a window manager issue, but I tried it on other programs, 
and found that others have an arrow that can be easily grabbed to change 
the window size.  Can this be done in LO?


John




--
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] Slide transition, Impress in LO 5.1.1.3 on Linux/Fedora

[Remy Gauthier]

Hello,

I really like the new display of slide transitions (transitions, not
animations) in Impress 5.1. However, I have not figured out how to
remove  transition that was already applied to a slide. This is what I
did:

1) In an existing presentation, I created a slide that had no pre-set
transition
2) In the transition selectors, I clicked on the "Dissolve" transition
for that new slide
3) Then I realized that I had applied the transition to the wrong slide
4) Tried clicking on the "No Transition" icon to remove the transition;
I get a light grey box around the "No Transition", but when I scroll
down, I can see the "Dissolve" transition is still active (and there is
the little icon in the bottom left of the slide miniatures). And the
transition is still applied to the slide.
5) At that point, I can select any other transition I want, except the
"No Transition"

My current workaround is to create a new slide, copy the content of the
slide containing the information I want, and then delete the slide that
had the transition. Does anyone have a more convenient workaround? I
understand this is probably a bug that will get fixed in an upcoming
release but until then something a bit more straightforward would be
helpful.

Thank you in advance.

Rémy Gauthier.
-- 
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: Python

[Mark Stanton]

On Friday 18 March 2016 10:39:07 Jim Byrnes wrote:
> On 03/18/2016 09:44 AM, Mark Stanton wrote:
> > Does the Python macro interface work?
> 
> Yes

Gr8!  Many thanks

-- 
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] anyone knows how to find/replace not-printable glyphs?

[Felmon Davis]

On Tue, 15 Mar 2016, Remy Gauthier wrote:


If you need to search and replace paragraph marks and others, you can
use AltSearch (http://extensions.libreoffice.org/extension-center/alter
native-dialog-find-replace-for-writer). If have it installed on LO5.1
and it works fine. You look for two end of paragraph characters (select
from the drop-down or type in \p\p)
and replace with just one; repeat until there no more replacements.
Cheers!
Rémy Gauthier.


I wonder about simply using search/replace and remove all end of 
paragraph marks ('\n\), replacing them with a mark of one's own like 
'#' (as long as it doesn't occur elsewhere in the text); then remove 
all consecutive "##' and replace with '\r' or '\r\r'?


f.

--
Felmon Davis

He knows not how to know who knows not also how to unknow.
-- Sir Richard Burton

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

Re: [libreoffice-users] Writer's A4 page pixel dimensions

[libreoffice-ml . mbourne]

Dave Koelmeyer wrote:

Hi All,

I'm creating full A4-sized page background images in GIMP to insert into
A4-format Writer documents. I've noticed that when these images are
added to Writer and anchored to page, things are not perfectly flush as
I would expect.

After a bit of tinkering I believe this is because Writer doesn't treat
an A4-format page as having exactly 2480x3508 pixel dimensions (at 300 DPI).

For example, my GIMP working files use the A4 300 DPI preset, which is
2480x3508 pixels. If I create a new blank Writer document using A4 page
size, then export this blank document as a PNG and set the export DPI
setting to 300, Writer instead displays this as 2481x3507 pixels. I see
similar ever-so-slightly different results when attempting to import an
A4 PDF exported from Writer into GIMP at 300 DPI, again off by a matter
of pixels.

Everything I've read points to 2480x3508 definitely being the dimensions
for A4 (e.g. http://www.a4papersize.org/a4-paper-size-in-pixels.php).
Can someone please help me understand why there is a difference in Writer?


Probably differences in rounding. An A4 page isn't exactly 2480 x 3508 
pixels at 300 dpi. A4 is 210mm x 297mm.

  210mm / 25.4mm/in * 300dpi ~= 2480.3 pixels
  297mm / 25.4mm/in * 300dpi ~= 3507.9 pixels
Rounding that to 2481 x 3507 does seem a bit odd, but it looks like 
there may be some intermediate rounding in the calculation:

  210mm / 25.4mm/in ~=  8.27in;  8.27in * 300dpi = 2481 pixels
  297mm / 25.4mm/in ~= 11.69in; 11.69in * 300dpi = 3507 pixels

How are you determining the pixel sizes that LibreOffice is using for 
your image anyway? Image sizes are specified in terms of the printed 
size (mm, inches, etc.) rather than in pixels. Unless your display is 
300dpi, the image on screen will be scaled anyway.


If you're finding that the size in the image properties can't be set to 
210mm x 297mm because of the slight difference in pixel aspect ratio, 
you could try unticking the "keep ratio" box so that the size can be set 
to 210mm x 297mm.


If you've got LibreOffice set to work in inches, you might setting it to 
cm or mm when using ISO paper sizes avoids the intermediate rounding. 
Tools > Options > LibreOffice Writer > General > Measurement unit.


Mark.


--
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] Calc: create a Macro to add a pie chart

[lilly8428]

dati.ods   
Hy, i'm a new users and i ask for help to register in a calc sheet, a macro
that inserts the values of two or more cells in a pie chart. I used the
function " records macro" of Libre Office 5.0 and although the recording of
the macro has selected the chart type (pie), the execution of the macro
gives me a column chart.
 Enclose Example and  the macro named "B"
Thank you all
sub B
rem --
rem define variables
dim document   as object
dim dispatcher as object
rem --
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem --
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ToPoint"
args1(0).Value = "$B$2"

dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())

rem --
dim args2(0) as new com.sun.star.beans.PropertyValue
args2(0).Name = "By"
args2(0).Value = 1

dispatcher.executeDispatch(document, ".uno:GoDownSel", "", 0, args2())

rem --
dispatcher.executeDispatch(document, ".uno:InsertObjectChart", "", 0,
Array())


end sub




--
View this message in context: 
http://nabble.documentfoundation.org/Calc-create-a-Macro-to-add-a-pie-chart-tp4179030.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] Python

[Paul Hammant]

I have not worked out how to activate it :-(
Ref  http://listarchives.libreoffice.org/global/users/msg47885.html

-ph

On Fri, Mar 18, 2016 at 10:44 AM, Mark Stanton 
wrote:

> Does the Python macro interface work?
> Does it work well if it does work?
>
> Mark
>
> --
> 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: Calc as a Flat File Database

[Alexander Thurgood]

Le 16/03/2016 13:27, Alexander Thurgood a écrit :

You could plausibly also design your form from the ground up using a
Calc sheet, inserting form controls onto it, and linking that form to
your datasource, and then binding your form controls to the data fields.


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

Re: [libreoffice-users] Disabling Tool Tips / Balloon Tips

[nasrin khaksar]

hi.
go to tools menu and then options.
in the option menu uncheck tips and extended tips in libreoffice, general.

On 3/17/16, Brian Barker  wrote:
> At 11:31 17/03/2016 -0400, Dale H. Cook wrote:
>>Is there any way to disable Tool Tips / Balloon Tips in LibreOffice?
>>When I am working with an .odt document containing hyperlinks I
>>don't need a balloon telling me "Click to follow link: ..." every
>>time the pointer passes over a hyperlink, and the balloon often
>>obscures something that I need to see.
>
> Remove the tick from Tools | Options... | LibreOffice | General | Help |
> Tips.
>
> I trust this helps.
>
> Brian Barker
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>


-- 
Those who follow the Messenger-Prophet, the Ummi, whom they find
written down with them in the Taurat and the Injeel [who] enjoins them
good and forbids them evil, and makes lawful to them the good things
and makes unlawful to them impure things, and removes from them their
burden and the shackles which were upon them; so [as for] those who
believe in him and honor him and help him, and follow the light which
has been sent down with him, these it is that are the successful.
holy quran, chapter 7, verse 157.
best website for studying islamic book in different languages
al-islam.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: Calc as a Flat File Database

[Ian Whitfield]

Hi Alexander

On 03/17/2016 05:59 PM, Alexander Thurgood wrote:

So Alexander has told me how to save my Form (that helps a lot) and I
>decided to get back into Base as it seems to be the only way to go for
>me. But MySQL is giving me up-hill. It does not seem to want to save an
>empty Table for me to import my CSV into and gives me this error ...

Again, I don't understand why you are attempting to use LO and a CSV
file to import your data into your mysql database.


I have managed - after a 2 day battle - to get all my CSV data back into 
MySQL as a Table.

I needed to do this as that was the only source of my original data.
I have also successfully linked Base to this Table. And can view it all 
in Base.


But I now have the problem of bringing in the Form you told me how to save.
I have it as an ODT file but can not find a way of coping it into Base!!

Can you assist me with this please??

Thanks a lot.


--
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: Calc as a Flat File Database

[jorge]

Hi Ian and all:

Excuse me if I understood bad your problem.

I understood that you need import a .CSV file to BASE with BASE. And
You can't do it.

I suggest to you to open the .CSV file with CALC. Then save it as .ODS.
Finally, import from BASE the .ODS file.

I hope this help.

Regards,

Jorge Rodríguez



El mié, 16-03-2016 a las 22:19 +0200, Ian "Witty" Whitfield escribió:
> Thanks all - appreciated!!
> 
> My background is 30 years in the Computer Business - Training, 
> installations, support etc etc.
> Since retiring I left Windows behind and changed to Linux.
> What I'm not is a Programmer - except with BASIC about 20 years ago!!!
> 
> My needs are to have a SOLID, RELIABLE simple Members Database that does 
> not crash all the time and take the data with it as well.
> I don't even need a RDB as I have one table, one Form and a few queries, 
> it is single user on a single machine. My Form only uses Text Boxes, 
> Drop-Down Boxes, Check Boxes and Photos and Graphics. End of story!! i 
> don't want to become a DB expert just a basic layout person and every 
> day user.
> 
> I did not think this would be a big problem in Linux - how wrong I was. 
> I have battled with Base for several years and after my last crash in 
> January, (Data lost, as is common, even with MySQL. The file is still 
> there but it can not be accessed).
> 
> I thank Jarasow for his help with Kexi but after 10 crashes in 2 weeks 
> and some missing features and no help to try and get Drop-boxes to work 
> I had to give up on it. It does look very promising but has a way to go 
> yet I fear.
> 
> So Alexander has told me how to save my Form (that helps a lot) and I 
> decided to get back into Base as it seems to be the only way to go for 
> me. But MySQL is giving me up-hill. It does not seem to want to save an 
> empty Table for me to import my CSV into and gives me this error ...
> 
> "#1064 - You have an error in your SQL syntax; check the manual that 
> corresponds to your MySQL server version for the right syntax to use 
> near 'varchar(10), `NULL` varchar(10), `NULL` varchar(10), `NULL` 
> varchar(21), `NULL` ' at line 1"
> 
> I seem to remember this from when I first set it up last year. It's not 
> MY SQL - this is what the program did!! Also my first line of the CSV is 
> the column names only and it works OK with Calc and did so as well with 
> Kexi!! So where is the problem??!!
> So I'm unable to populate the DB in MySQL for Base to link to it!!
> 
> Thanks all.
> 

-- 
Atentamente,

Jorge Rodríguez


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

Re: [libreoffice-users] Disabling Tool Tips / Balloon Tips

[tonybsa]

> On 18/03/2016, at 13:00, Remy Gauthier  wrote:
> 
> I can disable tips by going in Tools -> LibreOffice -> Options ->
> Advanced Options -> Advanced configuration. Seach for the keyword "Tip"
> (not case sensitive), then searching for org.openoffice.Office.Common,
> Help -> Tip and setting it to False.


Who decides on all the unnecessary idiotic changes for no apparent good reason?

Adding new options can be put into any menu / sub-menu that the development 
team thinks is appropriate, but moving existing options from one place to 
another is VERY counter productive. Not to say annoying.


--
Tony Bray
tony...@mac.me
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.2
LibreOffice 4.4.5
Scribus 1.4
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4







-- 
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: shrinking an LO window

[John R. Sowden]

sorry xubuntu  gnome (not unity)

On 03/16/2016 01:35 PM, V Stuart Foote wrote:

@John, *

What OS and Desktop Environment.  On Windows builds, there is a nice large
target, at least 10 px, that triggers the corner "resize" grab. Have no
problem resizing this OS.

Stuart



--
View this message in context: 
http://nabble.documentfoundation.org/shrinking-an-LO-window-tp4178759p4178761.html
Sent from the Users mailing list archive at Nabble.com.




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

[libreoffice-users] Disabling Tool Tips / Balloon Tips

[Dale H. Cook]

Is there any way to disable Tool Tips / Balloon Tips in LibreOffice? When I am 
working with an .odt document containing hyperlinks I don't need a balloon 
telling me "Click to follow link: ..." every time the pointer passes over a 
hyperlink, and the balloon often obscures something that I need to see.


-- 
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] New Hyperlinks Not Underlined

[Dale H. Cook]

I don't know what happened to my LibreOffice 5.1.0.1 installation, but in 
Writer new hyperlinks began behaving oddly. The colors for visited and 
unvisited links defaulted to the original automatic colors, and that was easily 
fixed. New hyperlinks (both internet and document), however, are now no longer 
underlined. Any clues?

Dale H. Cook, Member, NEHGS and MA Society of Mayflower Descendants;
Plymouth Co. MA Coordinator for the USGenWeb Project
Administrator of http://plymouthcolony.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

Re: [libreoffice-users] Re: shrinking an LO window

[Bruce Hohl]

Find your program on the task bar, right click and select "Resize".  This
will position the pointer on the bottom right corner of the window so you
can easily resize.

On Wed, Mar 16, 2016 at 4:46 PM, John R. Sowden 
wrote:

> sorry xubuntu  gnome (not unity)
>
>
> On 03/16/2016 01:35 PM, V Stuart Foote wrote:
>
>> @John, *
>>
>> What OS and Desktop Environment.  On Windows builds, there is a nice large
>> target, at least 10 px, that triggers the corner "resize" grab. Have no
>> problem resizing this OS.
>>
>> Stuart
>>
>>
>>
>> --
>> View this message in context:
>> http://nabble.documentfoundation.org/shrinking-an-LO-window-tp4178759p4178761.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] Save/Store files

[Piet van Oostrum]

Heinrich Stoellinger wrote:

 > Hello,
 > I am using LO 5.1.1 (latest development version). Since version 5 I notice
 > that in writer the tab "Speichern" (German for store/save) is not grayed,
 > even though NOTHING has changed in the file. Is this intentional?
 > Regards
 > H. Stoellinger
 > Salzburg

I remember that there had been a discussion in the recent past to always enable 
File > Save regardless of the document change status. Some people had been 
complaining about the function being disabled on a non-modified file. I can't 
find this in the release notes, however.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


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

[libreoffice-users] Writer's A4 page pixel dimensions

[Dave Koelmeyer]

Hi All,

I'm creating full A4-sized page background images in GIMP to insert into
A4-format Writer documents. I've noticed that when these images are
added to Writer and anchored to page, things are not perfectly flush as
I would expect.

After a bit of tinkering I believe this is because Writer doesn't treat
an A4-format page as having exactly 2480x3508 pixel dimensions (at 300 DPI).

For example, my GIMP working files use the A4 300 DPI preset, which is
2480x3508 pixels. If I create a new blank Writer document using A4 page
size, then export this blank document as a PNG and set the export DPI
setting to 300, Writer instead displays this as 2481x3507 pixels. I see
similar ever-so-slightly different results when attempting to import an
A4 PDF exported from Writer into GIMP at 300 DPI, again off by a matter
of pixels.

Everything I've read points to 2480x3508 definitely being the dimensions
for A4 (e.g. http://www.a4papersize.org/a4-paper-size-in-pixels.php).
Can someone please help me understand why there is a difference in Writer?

Cheers,
Dave

-- 
Dave Koelmeyer
http://blog.davekoelmeyer.co.nz
GPG Key ID: 0x238BFF87


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

[Jim Byrnes]

On 03/18/2016 09:44 AM, Mark Stanton wrote:

Does the Python macro interface work?


Yes


Does it work well if it does work?


I'm not sure what you mean by well, but it worked well enough for me to 
write a number of python macros a number of years ago. Haven't written 
any for a while now.


All of mine were written when I was using the 3.xx branch.  At that time 
there was no ide like there was for basic. I don't know if that has changed.


Regards,  Jim




--
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] LibreOffice headless still needs "Windows Interactive Session" for background conversion

[Martin Bayreuther]

Hello all,

here is my scenario: I am running Apache web server on Windows. The web 
server will invoke "soffice --headless --convert-to pdf somefile" to 
convert it into a PDF-file. This does not work when the Apache web 
server is running as a service. The effect is well described: in modern 
versions of Windows (starting with Vista) services live in an isolated 
session 0.

Microsoft has documented this here:
 https://msdn.microsoft.com/de-de/library/windows/desktop/ms683502(v=vs.85).aspx
and
 
https://msdn.microsoft.com/en-us/library/windows/hardware/dn653293(v=vs.85).aspx

My question is, why "soffice --headless" (and I have tried --invisible, 
--nologo, ... in addition) still requires an interactive desktop to be 
present. This kills all background automation use cases that are 
triggered via web calls.


Regards
maba

--
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: Calc as a Flat File Database

[Alexander Thurgood]

Le 18/03/2016 12:31, Ian Whitfield a écrit :

Hi Ian,
> 
> But I now have the problem of bringing in the Form you told me how to save.
> I have it as an ODT file but can not find a way of coping it into Base!!
> 
> Can you assist me with this please??

The whole point of saving the form as an ODT outside of an ODB is that
it becomes standalone, providing you link it to the declared datasource
as I mentioned in my previous mail. You can not simply slide the ODT
file back into the ODB file - why would you want to do that if your
original aim was to get the form out ? If you create the form in the
ODB, it stays in the ODB, you don't have to bring it in again.

I, imagine, although I have never tried this, that it would
theoretically be possible to unzip the ODB file and copy the contents of
an equally unzipped ODT file into the appropriate subfolder (e.g.
/forms/Obj11/) within the unzipped ODB, re-zip it again, and thereby
access it anew from within the ODB. When I look in the forms folder of
an ODB file, I see a subfolder called ObjXX, where XX are digits. In
this Obj folder I see 4 files, plus another subfolder /Configurations2.

The 4 files of the ObjXX folder are :
content.xml
manifest.rdf
settings.xml
styles.xml

These files are required to represent the form's content, style and
settings, and you can probably find them in your ODT file once unzipped.
The Configurations2 subfolder should be optional, but from what I
understand it is sometimes required, depending on the options that
appear in settings.xml. The Configurations2 subfolder contains all of
the xml files for various UI parts of the UI space that a form can use.


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

Re: [libreoffice-users] Disabling Tool Tips / Balloon Tips

[Brian Barker]

At 11:31 17/03/2016 -0400, Dale H. Cook wrote:
Is there any way to disable Tool Tips / Balloon Tips in LibreOffice? 
When I am working with an .odt document containing hyperlinks I 
don't need a balloon telling me "Click to follow link: ..." every 
time the pointer passes over a hyperlink, and the balloon often 
obscures something that I need to see.


Remove the tick from Tools | Options... | LibreOffice | General | Help | Tips.

I trust this helps.

Brian Barker


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

Re: [libreoffice-users] Disabling Tool Tips / Balloon Tips

[Dale H. Cook]

At 08:00 PM 3/17/2016, Remy Gauthier wrote:

>I can disable tips by going in Tools -> LibreOffice -> Options -> Advanced 
>Options -> Advanced configuration. Seach for the keyword "Tip" (not case 
>sensitive), then searching for org.openoffice.Office.Common, Help -> Tip and 
>setting it to False.

Thanks - that did it!

Dale H. Cook, Radio Contract Engineer, Roanoke/Lynchburg, VA
http://plymouthcolony.net/starcityeng/index.html 


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