[Libreoffice-bugs] [Bug 136701] resultset Text Document not equal to resultset Spreadsheet Document

2021-06-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

--- Comment #8 from Dreamquartz  ---
@Alex

Maybe the title of the bug report is misleading, but that is what the bug is
about.

The resultset from the odt-format is different from the csv-format due to issue
of parameters.
The User is unable to simply take the Query as base for the Report Builder, to
create a resultset that should be the same.

The Report Builder is processing both variants for the resultset differently.

If a 'issue' causing parameter is renamed by the User the Report Builder seems
to be working according to the specs.

However, in most cases the User is not the Designer, and therefore it cannot be
expected from the User to modify the Query, or that the Designer has modify one
Query, but not the other to get a resultset, just to 'please' the Report
Builder.

Hope this clarifies 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 136701] resultset Text Document not equal to resultset Spreadsheet Document

2021-06-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

--- Comment #7 from Robert Großkopf  ---
(In reply to Dreamquartz from comment #6)
> If there is an issue with Queries being processed by the Report Builder, the
> option of allowing a Query as a base to create a report should be NOT made
> available to the User.

Please open another bug for queries with parameter processed with the report
builder. This is not the bug you have described here. When I read the title it
is about different content in Writer or Calc. And this I can't confirm.

-- 
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 136701] resultset Text Document not equal to resultset Spreadsheet Document

2021-06-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

--- Comment #6 from Dreamquartz  ---
Due to the fact the Report Builder allows a Query as input, there should NOT be
an issue for parameters.

It can not be so that the User must be made aware of the change in names for
parameters.

the Query !qProject runs and produces the correct resultset, but using the
exact same Query in the Report Builder as input, provides an incorrect
resultset.

If there is an issue with Queries being processed by the Report Builder, the
option of allowing a Query as a base to create a report should be NOT made
available to the User.

Dream

-- 
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 136701] resultset Text Document not equal to resultset Spreadsheet Document

2021-06-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

Robert Großkopf  changed:

   What|Removed |Added

 CC||rob...@familiegrosskopf.de

--- Comment #5 from Robert Großkopf  ---
Have tested this with the attachment.

Have set as values for the parameter '123' - for Calc-file twice as reported.
The content of both reports is the same. The numbers in Calc are formatted in a
special way for numbers with 10 digits.

ReportBuilder has problems to see a difference between the field name
"ProjektNumber" and the parameter "ProjectNumber" - so the content of both
documents is wrong here. I changed the name for the parameter a little bit and
it works as expected.

-- 
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 136701] resultset Text Document not equal to resultset Spreadsheet Document

2021-03-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

--- Comment #4 from QA Administrators  ---
[Automated Action] NeedInfo-To-Unconfirmed

-- 
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 136701] resultset Text Document not equal to resultset Spreadsheet Document

2021-03-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
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 136701] resultset Text Document not equal to resultset Spreadsheet Document

2021-03-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

--- Comment #3 from Dreamquartz  ---
Created attachment 170556
  --> https://bugs.documentfoundation.org/attachment.cgi?id=170556&action=edit
Example of running the Report based on a Query

The report is created directly from the Query qProject via the Report Builder
Wizard.
The resultset of the report is generated, based on the information required by
the Query qProject.
The resultset can only be created as a csv-file format if the information is
entered twice.
If the entry is based on ProjectNumber or ExternalProjectCode, the resultset
shows a random result for ProjectNumber

-- 
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 136701] resultset Text Document not equal to resultset Spreadsheet Document

2021-03-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

--- Comment #2 from QA Administrators  ---
Dear Dreamquartz,

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 mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 136701] resultset Text Document not equal to resultset Spreadsheet Document

2020-09-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=136701

Alex Thurgood  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #1 from Alex Thurgood  ---
@Dreamquartz : 

Please provide a test file with Query/Report and incdicate detailed steps so
that we can try and reproduce.

Please also indicate which OS and version you are using, and the Java version
too.

-- 
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