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.
@Rolf : which database engine are you using ?
Alex, thank you for picking this up. In this case I was using the default embedded HSQLDB engine.
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.
@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
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.
I thought I remembered reading something about it and inded, I found it in my browser history: https://wiki.documentfoundation.org/Installing_in_parallel
https://wiki.documentfoundation.org/Installing_in_parallel/Linux
Yes, saving a view in 4.4.5 works fine indeed.
Since we don't have any commit fixing anything Worksforme is the correct state.