Re: [libreoffice-users] vertical placement of charts while saving to pdf is wrong

2018-10-22 Thread Frédéric
> Did you try saving as pdf in both linux and windows to see if there is
> any difference?
>

It is similar on Windows and Linux but different on OSX. I would like to
say that it is probably not related to PDF because the print preview shows
the same issue.

>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-users] vertical placement of charts while saving to pdf is wrong

2018-10-22 Thread Frédéric
Which version and what software are you using.

Draw, Calc, Writer?


It's in Calc, version 6.0 on Linux, 5.3 on Windows.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-users] vertical placement of charts while saving to pdf is wrong

2018-10-21 Thread Frédéric
Hi,

My graphs move vertically when I save my sheets to pdf. I spent hours
searching why but cannot find any clue. All properties look fine
(FrameRect, OriginalSize, BoundRect, VisibleArea, Position, Size). I
do not know where to search. No help on internet either.

Am I the only one?

I tried to make an simple example but cannot reproduce exactly what I
have on my big file. One think I noticed is the following, when I
click on the chart, I can see the 8 blue handles and also the coutour
of the chart as dashed line and the dashed contour is not superimposed
with the blue handles but shifted by a few lines up (see attached
image). Normally they match.

I have the impression that the charts are shifted when I duplicate a
worksheet...

Kind regards,

F

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-users] Re: Cannot open an encrypted basic library -> 100% CPU

2017-10-18 Thread Frédéric Bron
> Not sure this is your problem, but it sounds familiar. I have learned that
> there is a possibility that at least some LO macros are Java-based. If that
> is so, then your Linux kernel update may have broken LO

That's interesting because of course when I switched to Fedora 26, I
probably change the java runtime version.

> 1. Switch to 64-bit Linux, which does not seem to have this problem.

I am already using 64bits linux so I guess it's a different problem.
However, Java may be the right direction. I will add the version to
the bug tracker.

These are the versions on F25 where the macros work:
- kernel: x86_64, 4.12.14.200.fc25
- java-1.8.0-openjdk: x86_64, 1.8.0.144.7.b01.fc25
- libreoffice: x86_64, 5.2.7.2.12.fc25

Versions on F26 where the macros do no work:
- kernel: x86_64, 4.12.14.300.fc26
- java-1.8.0-openjdk: x86_64, 1.8.0.144.7.b01.fc26
- libreoffice: x86_64, 5.3.6.1.6.fc26

So apparently, only the libreoffice version is different.

Frédéric

-- 
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: Cannot open an encrypted basic library -> 100% CPU

2017-10-16 Thread Frédéric Bron
>> I have changed from Fedora 25 to Fedora 26 and I want to reinstall my
>> LibreOffice Basic libraries. It works fine with the unencrypted ones.
>
> This is wrong: in fact, I import but the modules are empty.
>
> apparently, this is not due to linux update but to LibreOffice update.
> Macros working well with 5.2 version do not work with 5.3 version
> (tested on linux F26 and Windows).
> What's wrong with 5.3?

I have updated the bug report with a minimal example that alwyas fails
on my machine:
https://bugs.documentfoundation.org/show_bug.cgi?id=112466

-- 
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: Cannot open an encrypted basic library -> 100% CPU

2017-09-12 Thread Frédéric Bron
> I have changed from Fedora 25 to Fedora 26 and I want to reinstall my
> LibreOffice Basic libraries. It works fine with the unencrypted ones.

This is wrong: in fact, I import but the modules are empty.

> But it fails for the encrypted one.
>
> Here is what I do:
> Menu Tools/Macros/Manage Macros/LibreOffice Basic/Manage/Libraries/Import.../
> Then I select the script.xlb of the encrypted macro.
> I click on Open and then I can see the Library name with a tick in
> front of it. I do not check Insert as reference or Replace existing
> libraries. I just click on OK.
> I enter the password.
> Then nothing happens and soffice.bin is using 100% CPU.
> I have to kill it.
>
> Here is the output in the terminal:
> $ libreoffice --calc
> (soffice:8103): Gtk-CRITICAL **: gtk_container_foreach: assertion
> 'GTK_IS_CONTAINER (container)' failed
> (soffice:8103): Gtk-WARNING **: Failed to measure available space:
> L'emplacement indiqué n'est pas pris en charge

apparently, this is not due to linux update but to LibreOffice update.
Macros working well with 5.2 version do not work with 5.3 version
(tested on linux F26 and Windows).
What's wrong with 5.3?

Frédéric

-- 
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] Cannot open an encrypted basic library -> 100% CPU

2017-09-06 Thread Frédéric Bron
I have changed from Fedora 25 to Fedora 26 and I want to reinstall my
LibreOffice Basic libraries. It works fine with the unencrypted ones.
But it fails for the encrypted one.

Here is what I do:
Menu Tools/Macros/Manage Macros/LibreOffice Basic/Manage/Libraries/Import.../
Then I select the script.xlb of the encrypted macro.
I click on Open and then I can see the Library name with a tick in
front of it. I do not check Insert as reference or Replace existing
libraries. I just click on OK.
I enter the password.
Then nothing happens and soffice.bin is using 100% CPU.
I have to kill it.

Here is the output in the terminal:
$ libreoffice --calc
(soffice:8103): Gtk-CRITICAL **: gtk_container_foreach: assertion
'GTK_IS_CONTAINER (container)' failed
(soffice:8103): Gtk-WARNING **: Failed to measure available space:
L'emplacement indiqué n'est pas pris en charge

Frédéric

-- 
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] [5.2.6] calc charts do not update

2017-03-30 Thread Frédéric Bron
> I'm guessing, but have you tried Tools | Cell Content > | Recalculate (or
> F9) or Ctrl+Shift+F9 (Recalculate Hard)?

This doesn't help.

A colleague found that that hiding then unhiding the rows that are
below the charts solves the issue. Note that these rows are not the
ones that contain the data to be plotted. Let's see if this strange
method works for more than 1 night!

Frédéric

-- 
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] [5.2.6] calc charts do not update

2017-03-30 Thread Frédéric Bron
It is a real nightmare: I cannot find why sometimes charts
automatically update and sometimes they don't.
In particular, I have a series that sometimes has some points,
sometimes not and very often, when later I add some new values to an
empty series, the chart do not show the new point. That's very
disturbing. I would be happy to have a macro function to apply to the
graphs so that I can update them but I cannot find any "refresh"
command.
I noticed that if I print the sheet in a pdf doc, the point appear but
not before! Previewing is not enough.

Regards,

Frédéric

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