Ask Your Question

Query `Column Format` option missing. (Provides for `Format` and `Alignment`)? [closed]

asked 2016-12-13 09:51:17 +0200

EasyTrieve gravatar image

updated 2020-09-16 15:48:56 +0200

Alex Kemp gravatar image

I see Column width & Delete options, but Column Format is missing, i.e. open a query in edit mode, and right click on any field (column).

See: Introduction to LibreOffice Base (LOB) (5): Selection Queries-2: Bottom of page 7

Does anyone know is there a way to turn these on, or are they gone due to an older version?

(These sort of things work in MS Access and I have found them very helpful.)

I'm running Debian x64, LO

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-16 15:49:05.537288

1 Answer

Sort by » oldest newest most voted

answered 2016-12-13 10:31:16 +0200

pierre-yves samyn gravatar image


Column Format is enabled in the "run view" of the design mode,

image description

But the format you choose is not saved (on re-open). If you want to save your format you can save your query as a view: Right click the query▸Create As View.


edit flag offensive delete link more


So you enter this design specification by right clicking NOT on the design grid, but rather on the results grid. That seems backwards, and it's also not the way MS Access does it which doubly confused me. Thanks very much for the help.

EasyTrieve gravatar imageEasyTrieve ( 2016-12-13 17:55:09 +0200 )edit

To save it do you mean from the main outer menu right click on the a query, and select Create As View? I did this, but still don't see this formatting being saved. Could you provide more explicit steps to save this formatting? Thanks.

EasyTrieve gravatar imageEasyTrieve ( 2016-12-13 18:18:12 +0200 )edit

I finally figured this out, but I find this part of LO Base really messed up and confusing, in particular: putting a view in with tables is nuts. When you edit a view it looks like a query, it edits like a query, and runs like a query. Views are not tables. Why would they be put with tables? <head shaking=""> Sorry for my rant.

Similar Q here

EasyTrieve gravatar imageEasyTrieve ( 2016-12-13 18:39:03 +0200 )edit

I submitted this as a bug/suggestion here.

EasyTrieve gravatar imageEasyTrieve ( 2016-12-13 19:37:44 +0200 )edit

Question Tools

1 follower


Asked: 2016-12-13 09:51:17 +0200

Seen: 473 times

Last updated: Dec 13 '16