[Libreoffice-bugs] [Bug 86315] EDITING: Formatting of queries should be saved by base

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Robert Großkopf from comment #9)
> (In reply to Drew Jensen from comment #7)
> > Checked this with the latest 6.1 daily build.
> > 
> > The sql direct flag is being stored properly and when that is set all the
> > formatting and commenting is retained.
> > 
> > I would say this works.
> 
> Isn't a bug about code, which will be stored with direct SQL. It's about
> formatting, comments ...
> If you save a Base-file you will save all the formatting of the tables, also
> the hiding of columns, for example. This does work for tables, but doesen't
> work for queries.
> If you type code with comments its will work in GUI. You could input data in
> the query. If you close and reopen such a edited query the comments are
> lost, the breaks are lost ...
> You could change to direct SQL, but there is no possibility to
> - input data in query
> - also to format columns
> - also to hide columns.

Right, I understand now.

So, this would be something that should be part of an ODF specification update,
right?

Granted if LibreOffice just did it as a LO extended flavor of ODF 1.2 it's
doubtful too many folks would howl but standards are standards so maybe they
should (softly). 

No idea how one moves to do that, to request an ODF specification like that. I
suppose it might open up some thought as what could be done with that kind of
data when a query is used as the data source to other objects in the ODF spec,
such as dataforms, perhaps treat the settings as a default (template) for
consumer controls attached to the dataform.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190425/2b4a6f51/attachment-0001.html>