Re: [libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread Peter
Base is installed and for my financial database the only problem I have 
is reports. I followed the advice and installed the packages. This made 
no difference. When I open the data base and select a previously defined 
report the data bases crashes. If  I use the report creation facility 
when I select the report wizard again the data base crashes.


Does base log these failures and if so where can I look at it?

My fishing data base opens but I cannot open fofms , tables , queries etc.

This problem with Base has occurred in the last 12 months.

Any suggestions on what to do next will be gratefully received.


Peter




On 28/11/17 09:20, Keith Bates wrote:
I use Ubuntu 17.04 also, including the Libreoffice packages installed 
directly from Ubuntu. The default install excludes Base, and if you 
can't open a database, it seems like you don't have Base installed. 
sudo apt install libreoffice-base should fix that,


For reports the packages you need are libreoffice-report-builder and 
libreoffice-report-builder-bin. Use sudo apt install 
libreoffice-report-builder* and they should install.



Keith


On 28/11/17 08:45, Peter wrote:
I reinstalled Libre Office  Base from the Ubuntu repository. I 
assumed that this wouls automatically install all necessary packages. 
a=There is nothing that I can find in the__Ubuntu Software Repository 
that appears to relate to reports for LibreBase.  How can i find out 
what packages I have installed and what packages are required 
forreports to work.  I have an old data base which has not been uses 
since January 2015 which I tried to open today. This will no longer 
open for any thing , no forms or views or tables can be opened.


Peter

On 28/11/17 04:50, Robert Großkopf wrote:

Hi Peter,


Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it
but the problem with reportsremained the  same.

This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert








--
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/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread Keith Bates
I use Ubuntu 17.04 also, including the Libreoffice packages installed 
directly from Ubuntu. The default install excludes Base, and if you 
can't open a database, it seems like you don't have Base installed. sudo 
apt install libreoffice-base should fix that,


For reports the packages you need are libreoffice-report-builder and 
libreoffice-report-builder-bin. Use sudo apt install 
libreoffice-report-builder* and they should install.



Keith


On 28/11/17 08:45, Peter wrote:
I reinstalled Libre Office  Base from the Ubuntu repository. I assumed 
that this wouls automatically install all necessary packages. a=There 
is nothing that I can find in the__Ubuntu Software Repository that 
appears to relate to reports for LibreBase.  How can i find out what 
packages I have installed and what packages are required forreports to 
work.  I have an old data base which has not been uses since January 
2015 which I tried to open today. This will no longer open for any 
thing , no forms or views or tables can be opened.


Peter

On 28/11/17 04:50, Robert Großkopf wrote:

Hi Peter,


Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it
but the problem with reportsremained the  same.

This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert





--
*Keith Bates**

**Senior Pastor

*p: 02 67924890

s: 4 Mooloobar St
    Narrabri, NSW 2390

e: chu...@new-life.org.au 

w: www.new-life.org.au 

*
*


--
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/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread Girvin Herr

Peter,

I don't know about *buntu, but I download, repackage and install the 
standard Linux LibreOffice from the LO website for my Slackware Linux 
system and it includes the report builder already bundled into it. There 
is no separate report builder plugin package to install. I am using the 
LO 5.3.4.2 report builder and it works fine out of the box. For the 
record, OpenOffice does not bundle the report builder and still uses a 
3rd-party plugin for that function. If that plugin is not installed, OO 
will pop up a message about it not being available. That said, I am 
pretty sure that the LO report builder uses Java. Could your problem be 
a Java (JRE) issue?


Did you "register" the old database in the new LO?
Use Tools > LibreOffice Base > Databases and "New" to register it if it 
is not in the list.
You may also have to setup your new Base, especially if you are using an 
external database server (aka "back-end"). I assume you are using the 
internal database engine, which I cannot help with. I am using the 
external Mariadb (MySQL) server.


Girvin Herr


On 11/27/2017 01:45 PM, Peter wrote:
I reinstalled Libre Office  Base from the Ubuntu repository. I assumed 
that this wouls automatically install all necessary packages. a=There 
is nothing that I can find in the__Ubuntu Software Repository that 
appears to relate to reports for LibreBase.  How can i find out what 
packages I have installed and what packages are required forreports to 
work.  I have an old data base which has not been uses since January 
2015 which I tried to open today. This will no longer open for any 
thing , no forms or views or tables can be opened.


Peter

On 28/11/17 04:50, Robert Großkopf wrote:

Hi Peter,


Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it
but the problem with reportsremained the  same.

This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert






--
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/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Trouble in Calc with button hyperlink

2017-11-27 Thread Ryan T. Morgan
Forgive me if this has been discussed; I searched the archive but didn't 
find anything...


I have a large spreadsheet, and I'm trying to create a row of buttons 
near the top that, when clicked, will take me down to specific sections 
(via a named range).  Here's how to reproduce:


1. start with blank spreadsheet
2. page down a couple times, and then Sheet -> Named Ranges and 
Expressions -> Define...

3. Name: FOO, click Add, go back up top to row 1.
4. Ctrl+K (insert hyperlink), Document, Target: FOO (URL becomes #FOO), 
Form: Button, Text: Jump To Foo, click OK
5. Make sure Design Mode is off, click button, and you should jump down 
to the row where you created the named range.


So far so good, right?  Ok, now save the document and close LibreOffice. 
 Re-open the document, and the button no longer works.


Does anyone have any ideas?  I've gotta be doing something wrong.

My setup:
  Windows 7 x64
  Java 1.8.0_121
  LibreOffice:
Version: 5.4.2.2
Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU threads: 8; OS: Windows 6.1; UI render: default;
Locale: en-US (en_US); Calc: CL

Thanks!
--
ryan

--
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/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread Peter
I reinstalled Libre Office  Base from the Ubuntu repository. I assumed 
that this wouls automatically install all necessary packages. a=There is 
nothing that I can find in the__Ubuntu Software Repository that appears 
to relate to reports for LibreBase.  How can i find out what packages I 
have installed and what packages are required forreports to work.  I 
have an old data base which has not been uses since January 2015 which I 
tried to open today. This will no longer open for any thing , no forms 
or views or tables can be opened.


Peter

On 28/11/17 04:50, Robert Großkopf wrote:

Hi Peter,


Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it
but the problem with reportsremained the  same.

This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert



--
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/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread Robert Großkopf
Hi Peter,

> Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2
> 
> Ubuntu 16.4
> 
> When I first found the problem I removed LibreBase and reinstalled it
> but the problem with reportsremained the  same.

This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread leleu
Some weeks ago, under Ubuntu 17.10 I struggled with an old report, I had 
eventually to kill.


There is two possibilities to build reports (as proposed by the query 
contextual menu)


Report Builder



Assistant Rapport



There was also an old device


 Oracle Report Builder


   Message d'avertissement

This extension was not updated recently. It might not work with latest 
versions of OpenOffice.
I attributed my difficulties to the previous build with Oracle which 
was, if I remember well, an extension. It seems to be no longer 
installed on my computer




Je la 27/11/2017 16:04, Peter skribis :

Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it 
but the problem with reportsremained the  same.



Peter

On 28/11/17 01:33, Alexander Thurgood wrote:

Le 27/11/2017 à 10:58, Peter a écrit :

Hi Peter,

It might help us more to know which version of LibreOffice you are using
and on which version of Ubuntu or Ubuntu-based distribution.


Alex











--
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/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread Peter

Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it 
but the problem with reportsremained the  same.



Peter

On 28/11/17 01:33, Alexander Thurgood wrote:

Le 27/11/2017 à 10:58, Peter a écrit :

Hi Peter,

It might help us more to know which version of LibreOffice you are using
and on which version of Ubuntu or Ubuntu-based distribution.


Alex









--
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/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread Alexander Thurgood
Le 27/11/2017 à 10:58, Peter a écrit :

Hi Peter,

It might help us more to know which version of LibreOffice you are using
and on which version of Ubuntu or Ubuntu-based distribution.


Alex






-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Reports Libre Base

2017-11-27 Thread Tony Arnold
Peter,

May be a daft question, but did you rely on the package 
libreoffice-report-builder, and is that still installed?

Regards,
Tony.

On Mon, 2017-11-27 at 20:58 +1100, Peter wrote:

I run Libre Office on Ubuntu. I store all of my financial data in a
LibreBase data base.  When this was first set up I defined a number of
reports. These worked properly until this year. Now if I run areport or
try to define one the data base crashes. While it recovers without loss
of data. I cannot get any of the reports to work. Some thing is
obviously missing of broken. Apart from reports the database works
normally.  I assume the database produces an error report when I try to
work with reporting. Where do I look for this?

Any help greatly appreciated.

Regards

Peter Goggin




--

Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT 
Services | G64, Kilburn Building | The University of Manchester | Manchester 
M13 9PL | T: +44 161 275 6093 | M: +44 773 330 0039

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Reports Libre Base

2017-11-27 Thread Peter
I run Libre Office on Ubuntu. I store all of my financial data in a 
LibreBase data base.  When this was first set up I defined a number of 
reports. These worked properly until this year. Now if I run areport or 
try to define one the data base crashes. While it recovers without loss 
of data. I cannot get any of the reports to work. Some thing is 
obviously missing of broken. Apart from reports the database works 
normally.  I assume the database produces an error report when I try to 
work with reporting. Where do I look for this?


Any help greatly appreciated.

Regards

Peter Goggin


--
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/
All messages sent to this list will be publicly archived and cannot be deleted