[libreoffice-users] CALC: Fit a cell around an inserted picture

[Rafnews]

Hi,

i'm new to LibreOffice and to Calc but i would like to do a list of 
players with their pics inside.
All pics should have the same size (54px * 54px) and i was wondering if 
it is possible to just insert an image in a cell and that automatically 
the cell (so the row) will adjust his height/width to the image ?


thx.

A.

--
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: repeat first line to each page

[Rafnews]

Hi,

i would like to know if there is an option like under MS Excel, to 
repeat first line or 2 first lines of the document on each printing page 
(or PDF page) ?


thx.

A.

--
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: repeat first line to each page

[Nino Novak]

Am 28.03.2014 10:11, schrieb Rafnews:
> Hi,
> 
> i would like to know if there is an option like under MS Excel, to
> repeat first line or 2 first lines of the document on each printing page
> (or PDF page) ?

see http://ask.libreoffice.org/en/question/21473

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] Re: CALC: repeat first line to each page

[Rafnews]

Thx a lot.

On 28.03.2014 10:35, Nino Novak wrote:

Am 28.03.2014 10:11, schrieb Rafnews:

Hi,

i would like to know if there is an option like under MS Excel, to
repeat first line or 2 first lines of the document on each printing page
(or PDF page) ?

see http://ask.libreoffice.org/en/question/21473

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] shutdown glitch

[Cley Faye]

2014-03-27 23:52 GMT+01:00 rmg :

> ​​
> if HasUnoInterfaces(doc, "com.sun.star.util.Xcloseable")
> doc.close(TRUE)
> else
> doc.dispose()
> End if
>
>  as I said lifted straight from the macro examples; the Libreoffice API
> reference seems to say that's right.
>


​I'm not very fluent in LO API, but according to the documentation (
http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1util_1_1XCloseable.html)​
XCloseable.close() must be called before XComponent.dispose(), so maybe you
can try this:


​
if HasUnoInterfaces(doc, "com.sun.star.util.XCloseable")
doc.close(TRUE)
End if
doc.dispose()


​Also note that it's XCloseable with a capital C. I don't know however if
it's case-sensitive (the doc seems to say it's not) but it wouldn't hurt to
check this too :)​​

-- 
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] direct formatting and styles

[James Knott]

Virgil Arrington wrote:
> At the risk of beating a horse to death, today I stumbled on an online
> rant against MS-Word.

The first word processor I used, as opposed to line oriented text
editors, was the one that came with VAX VMS on the VAX 11/780.  Later, I
used PC-Write, on DOS, and then Describe, on OS/2, at home and Wordstar
2000 at work.  Fortunately, I've never been in a position at work where
I couldn't install OpenOffice or LibreOffice, to avoid using Word.  When
I was at IBM, I also used Lotus Smart Suite.  I have also used Word
Perfect 5.2, but preferred Wordstar 2000.

When I set up computers these days, I always install OpenOffice and/or
LibreOffice.  On Windows systems, I also include the Microsoft viewers. 
I haven't installed Microsoft Office anywhere, since the days of Word 6.

I have long paid attention to the dirty tricks MS has used to force
market share.  As a result, I always try to promote alternatives.  I run
Linux on my home computers, previously OS/2.  I only have one computer,
my notebook, that has Windows installed, but that's only because it came
with it.  It spends most of it's time running Linux.


-- 
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] Errors in LO 4.1 but not in LO 3.5

[Marion & Noel Lodge]

Hi,

I have an accounting system that runs fine under LO v3.5.6.2, but under LO
v4.1.5.3 it throws the error "Basic runtime error.  Incorrect property
value".  I've tracked it down to a macro that is attempting to read from a
Date object on the Form.  The object is a
com.sun.star.comp.forms.OdateModel and has a field called "Current Value".
However this field is stored differently between the two LO versions -
*v3.5*
Current Value   20140221   Variant/Long
*v4.1*
Current Value   com.sun.star.util.Date
  - Day   21  UShort
  - Month   2UShort
  - Year  2014  Integer

My macro is expecting a single value, but under v4.1 it has three values,
so it's obvious why it is throwing the error.

In both cases I have used the Java version 1.6.0_29, so I cannot work out
why there is this difference in the way the OdateModel object is storing
its Current Value.  I could test for the Current Value's Type each time and
extract the date with appropriate code.  But this doesn't seem to be the
right way to go.  And there could be other variances between the LO
versions that I haven't come across yet.

I am running an H2 Database on Windows 7 64 bit.  Can anyone spot what I
might be doing wrong with my Java settings in LO v4.1?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.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] Errors in LO 4.1 but not in LO 3.5

[Cley Faye]

2014-03-28 13:34 GMT+01:00 Marion & Noel Lodge :

> My macro is expecting a single value, but under v4.1 it has three values,
> so it's obvious why it is throwing the error.
>
> In both cases I have used the Java version 1.6.0_29, so I cannot work out
> why there is this difference in the way the OdateModel object is storing
> its Current Value.  I could test for the Current Value's Type each time and
> extract the date with appropriate code.  But this doesn't seem to be the
> right way to go.  And there could be other variances between the LO
> versions that I haven't come across yet.
>
> I am running an H2 Database on Windows 7 64 bit.  Can anyone spot what I
> might be doing wrong with my Java settings in LO v4.1?
>

There ​was a change in date objects:
 (look for "Changes
to UNO APIs")

​This looks like the culprit in your case. The best course of action is
likely to update your code to follow these changes (either a quick fix to
"reproduce" the old value, or more long-term fix in the code around it).​

-- 
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] Font in Default Character Style

[Mark Bourne]

Virgil Arrington wrote:

Another off the wall question.

How does one change the font in the "Default Style" in character styles?

Right now, the font in my default character styles is "Century 731BT."
This is a font I used years ago, but haven't for quite some time. It
does not correspond to the "Basic Fonts" set in Options, nor does it
correspond to the font set in my default paragraph style.


That's odd... for me, using the default character style picks up the 
font from the current paragraph style - so changing the paragraph style 
should work. Perhaps you have a default template where the paragraph 
style is initially set to something else, or the font is set by direct 
formatting? So try ensuring the current paragraph style is set to 
"Default Style", and do Format > Clear Direct Formatting.


Once you've fixed it, you can save the template (File > Save as 
Template) and set it as default (File > New > Templates, select the 
template, and click "Set as default").


If you can't fix the default template, or if it's easier to start again 
from scratch, you should be able to reset it by going to File > New > 
Templates > (cog icon) > Reset Default Template > Text Document.



If I right click on Default Style in character styles, my only option is
"New." Is the default character style font hard-coded somewhere? I've
not been able to find any way to change it.

I'm using LO 4.1.5 on Windows 7.

Virgil


--
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] shutdown glitch

[rmg]

On 28/03/14 11:39, Cley Faye wrote:

2014-03-27 23:52 GMT+01:00 rmg :


​​
if HasUnoInterfaces(doc, "com.sun.star.util.Xcloseable")
 doc.close(TRUE)
else
 doc.dispose()
End if

  as I said lifted straight from the macro examples; the Libreoffice API
reference seems to say that's right.



​I'm not very fluent in LO API, but according to the documentation (
http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1util_1_1XCloseable.html)​
XCloseable.close() must be called before XComponent.dispose(), so maybe you
can try this:


​
if HasUnoInterfaces(doc, "com.sun.star.util.XCloseable")
 doc.close(TRUE)
End if
doc.dispose()
Had a fiddle with that. doc.close and doc.dispose are alternatives, 
calling doc.dispose after doc.close gives an error.


To reduce the possible unknowns I simplified the [Goodbye] routine to do 
just


   doc=thiscomponent
   doc.close(TRUE)
end sub

without testing for hasunointerfaces - because we know this one has. 
Still gives './soffice not responding'.


Which I think definitely ties the problem to the doc.close(). I'm being 
forced to the conclusion it's a 'feature' and you get to live with it.

​Also note that it's XCloseable with a capital C. I don't know however if
it's case-sensitive (the doc seems to say it's not) but it wouldn't hurt to
check this too :)​​

Yes, the book also says it's not case sensitive and I have to admit I've 
played fast and loose with case elsewhere without ill effect. And anyway 
the minimalist Goodbye without that still gives the problem.


--
Dick Georgeson


--
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] Font in Default Character Style

[Virgil Arrington]

Mark,

Thank you. On further examination, I don't think the problem is with my 
default character style. I think what has happened is my default 
template is on its third or fourth generation, being inherited from the 
OOo days. Over the years, I customized it so much that I think I'm just 
now finding the "fruits" of all my past labors. Time to clean things up 
a bit, I think.


Virgil


On 3/28/2014 1:33 PM, Mark Bourne wrote:

Virgil Arrington wrote:

Another off the wall question.

How does one change the font in the "Default Style" in character styles?

Right now, the font in my default character styles is "Century 731BT."
This is a font I used years ago, but haven't for quite some time. It
does not correspond to the "Basic Fonts" set in Options, nor does it
correspond to the font set in my default paragraph style.


That's odd... for me, using the default character style picks up the 
font from the current paragraph style - so changing the paragraph 
style should work. Perhaps you have a default template where the 
paragraph style is initially set to something else, or the font is set 
by direct formatting? So try ensuring the current paragraph style is 
set to "Default Style", and do Format > Clear Direct Formatting.


Once you've fixed it, you can save the template (File > Save as 
Template) and set it as default (File > New > Templates, select the 
template, and click "Set as default").


If you can't fix the default template, or if it's easier to start 
again from scratch, you should be able to reset it by going to File > 
New > Templates > (cog icon) > Reset Default Template > Text Document.



If I right click on Default Style in character styles, my only option is
"New." Is the default character style font hard-coded somewhere? I've
not been able to find any way to change it.

I'm using LO 4.1.5 on Windows 7.

Virgil





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