cannot update a view "table" in base

[Rolf Leggewie]

This is either an upstream bug already fixed in the version in wily or a regression introduced in Ubuntu. I run trusty.

https://bugs.documentfoundation.org/show_bug.cgi?id=92986

I would assume to be able to actually update when I right-click and "edit" a view. But apparently I can only save the changed view with a different name, delete the original and then rename it. That's unintuitive and cumbersome. This test was done against the embedded HSQLDB engine.

Verifications for releases later than trusty welcome.

[Libreoffice-4 (libreoffice-4)]

I would assume to be able to actually update when I right-click and "edit" a view. But apparently I can only save the changed view with a different name, delete the original and then rename it. That's unintuitive and cumbersome.

[Iplaw67-h (iplaw67-h)]

@Rolf : which database engine are you using ?

[Libreoffice-4 (libreoffice-4)]

Alex, thank you for picking this up.

In this case I was using the default embedded HSQLDB engine.

[Nv4y-robert (nv4y-robert)]

You are using a outdated version of LO. The editing of a view had been a little bit buggy at the begin of LO 4.3 - so could be also for 4.2.8.2.

Please update your version, for example to LO 4.4.4.3, and try again.

With this version there is no problem to edit a view and save this view. I could not save a view if there is another view, which is linked to this view. Saving a view is deleting a view first and than save it with the new content.

My system: OpenSUSE 13.2 64bit rpm Linux, different LO-versions.

[Iplaw67-h (iplaw67-h)]

@Rolf :as Robert has suggested, the version of LO you are using is outdated, and at least with regard to TDF (but not Ubuntu) end of life since Jan 6th, 2015.

Please try with a current TDF release and report back here, or else file a bug against the Ubuntu version on Launchpad.

NEEDINFO

[Libreoffice-4 (libreoffice-4)]

I will have better internet connection tomorrow to do the big download of the latest LO.

If you have a pointer how to run the latest LO alongside the one supplied by the Distro I'd be grateful if you shared it.

[Libreoffice-4 (libreoffice-4)]

I thought I remembered reading something about it and inded, I found it in my browser history: https://wiki.documentfoundation.org/Installing_in_parallel

[Iplaw67-h (iplaw67-h)]

https://wiki.documentfoundation.org/Installing_in_parallel/Linux

[Libreoffice-4 (libreoffice-4)]

Yes, saving a view in 4.4.5 works fine indeed.

[Lo-2 (lo-2)]

Since we don't have any commit fixing anything Worksforme is the correct state.

[Marcus Tomlinson (marcustomlinson)]

This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know.

[Marcus Tomlinson (marcustomlinson)]

You have acknowledged this to be fixed in the upstream report.

[Rolf Leggewie (r0lf)]

To be more exact, I confirmed that upstream did not exhibit the problem. I went back to the bionic version and confirmed it is indeed fixed there. Something you should have done before setting states prematurely. It is still quite possible for Ubuntu to have broken this.