<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: Formatting of queries should be saved by base"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=86315#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: Formatting of queries should be saved by base"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=86315">bug 86315</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>(In reply to Robert Großkopf from <a href="show_bug.cgi?id=86315#c9">comment #9</a>)
<span class="quote">> (In reply to Drew Jensen from <a href="show_bug.cgi?id=86315#c7">comment #7</a>)
> > 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.</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>