[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

--- Comment #13 from QA Administrators  ---
Dear Ted Lee,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |INSUFFICIENTDATA

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

--- Comment #12 from QA Administrators  ---
Dear Ted Lee,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #11 from Timur  ---
I couldn't reproduce this. So either it works or there is some detail missing. 
Sample attachment 140454 is not proper, it's a result, not source. 
I set Needinfo for sample source with fields that come from in-built
Bibliography database.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

--- Comment #10 from QA Administrators  ---
Dear Ted Lee,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 CC||jleemcc...@gmail.com

--- Comment #9 from Timur  ---
*** Bug 129521 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||9521

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

--- Comment #8 from QA Administrators  ---
Dear Ted Lee,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

Ted Lee  changed:

   What|Removed |Added

   Severity|enhancement |minor

--- Comment #7 from Ted Lee  ---
FYI, I did figure out how to create a field in a view that is just a constant
character string.  (It was trivial, ultimately.) So that is indeed a relatively
easy workaround for the problem.  (All the unused labels at the end of the last
page now come out blank.)  I changed the importance from "enhancement" to
"trivial".  I believe that whenever a program does not work the way a
reasonable person expects it should, that's a bug, minor though it may be.  Why
it's not been reported before I don't know, of course, but perhaps the label
feature isn't used very much.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

--- Comment #6 from Ted Lee  ---
I'm afraid I can't say "WORKSFORME" because it doesn't!  My "bug", if you are
willing to call it that, is that the label function does not work the way a
user expects it to: If I have only 25 records in my database, only 25 labels
should be printed! -- but, say, the page has room for 30 labels, the function
will print any static data in the master label in the remaining 5 labels.  In
principle I don't understand why it should be so hard to make it work the way
it should, but I do sense that the label function was added after mail merge
and used that in the simplest way possible to accomplish the task and somehow
the present behavior is a side-effect of that implementation.  The strange
floating "synchronize" window that shows up to implement labels is an
indication that it is a strange, albeit I am sure clever, design.

Yes, it would be relatively easy to add a static column containing a comma (or
other static text like a To: or From:) in a small database.  But if it were one
that had thousands of records it wouldn't be.  I do believe, however, one could
easily create a view of the database that added an extra computed field that
simply was a constant, and use that view to drive the label engine, but I
wasn't quickly able to figure out how to do that.  The built-in help for
databases isn't very helpful when it comes to creating views and I was too lazy
to dig around the net for a better tutorial or description on how do to it.  (I
am sure you can create a view that, say, creates a field C that is the sum of
fields A and B, but I couldn't figure out how to do that. But if you can do
that, you ought to be able to create a field that is just a constant value.) 
Still not something you ought to have to do to get the label feature to work
right, but it isn't much more burdensome than what you have to do to suppress
printing blank lines.  So I'm willing to tag the bug as WorkAroundAvailable (or
however that is marked) and of course would recommend the help text for labels
has something on the topic (as well as how to suppress blank lines.)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

--- Comment #5 from Jan-Marek Glogowski  ---
Since you didn't write about the data source: if it's a Calc sheet you can
construct the required string in an additional column.

And even if it is not it would probably be easier to generate a Calc sheet from
the data. Then you can manipulate the data in a way suitable for mail merge.

There is no way mail merge will ever remove commas between fields.
The only properties mail merge works with are fields and section visibility.
Anything more advanced has to be handled by some view in a database, where you
can use SQL to manipulate strings, or Calc functions to construct an additional
Calc sheet column.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

--- Comment #4 from Heiko Tietze  ---
(In reply to Ted Lee from comment #3)
> Thinking about your response I did realize one way to accomplish what I
> want. 

If you succeed please close the ticket as WORKSFORME. I doubt that we have an
easy solution and IMHO it's not worth all the effort.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

--- Comment #3 from Ted Lee  ---
At one point I tried using hidden sections to suppress blank lines, as
suggested somewhere on-line, but as I recall I had trouble making it work. But
I did find that turning every line into a paragraph and then using hidden
paragraphs worked fine to suppress blank lines.  In the case of a line that had
no data fields (because it was in a label after the last record) I could not
use that to suppress the line (paragraph) containing just static data (such as
the comma between city and state) -- presumably because that label was never
actually processed.

Thinking about your response I did realize one way to accomplish what I want. 
Rather than putting static data (such as that comma between city and state) in
the master label, all I would need do is put a field for the comma in my
database, populating it with a comma in every record.  I'm not sure if that
would be easier than simply editing the last page of the label document before
printing it, but at least I wouldn't have to remember to do it!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

Jan-Marek Glogowski  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #2 from Jan-Marek Glogowski  ---
What should work is marking the content of the master label as a section and
set the sections hide condition based on a value in the dataset.

Just be aware, that there always has to be a visible section or line to place
the cursor in a frame. But it should be possible to use two sections, one with
content and one empty, which you just show or hide, so at least one of them is
visible. Or just have an empty line after the new section.


A better UX for hidden labels
-

I'm not sure there is an straight forward way to implement this for
synchronized labels.

Just hiding the whole label would be nice, but that would change behavior, so
it won't be implemented.

For synchronized labels we already use sections, but it's a single one, so it
can't be hidden. You can hide the section, but it'll stay visible, as there has
to be a place for a cursor. That limit won't change.
But if we create the labels with two sections and set the second sections hide
condition to the negated / inverted condition of the first, just one of them is
visible at a time. In addition add a button to the synchronize dialog to switch
them. This way the 2nd section might even have different content.

All this is probably larger work - I don't know the label generation code at
all, just the processing mail merge code - might even be a GSoC project. And it
has to stay compatible with existing label documents, which is probably harder
to realize.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

   Keywords|needsUXEval |
 CC|libreoffice-ux-advise@lists |glo...@fbihome.de,
   |.freedesktop.org|tietze.he...@gmail.com

--- Comment #1 from Heiko Tietze  ---
Don't see need for input from UX. Adding Jan-Marek since he worked a lot around
mail merge.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116278] MAILMERGE (Labels): Unused labels at end of last page should be completely blank

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

   Keywords||needsUXEval
 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org
   Severity|normal  |enhancement

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs