[Libreoffice-bugs] [Bug 87964] FILEOPEN: xls chart displayed incorrectly (formatting; values) in LO 4.2.7.2

[b***@bugs.documentfoundation.org]

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

--- Comment #6 from QA Administrators <qa-***@libreoffice.org> ---
Dear Bug Submitter,

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
INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located
here:
https://wiki.documentfoundation.org/QA/FDO/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

This NEEDINFO message was generated on: 2015-07-18

[b***@bugs.documentfoundation.org]

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

Libomark <***@f2s.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0

--- Comment #7 from Libomark <***@f2s.com> ---
I find the bug persists using 4.4.2.2 in Win7.

[b***@bugs.documentfoundation.org]

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

Libomark <***@f2s.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Priority|medium |high
Severity|normal |major

[b***@bugs.documentfoundation.org]

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

raal <***@post.cz> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Summary|FILEOPEN: xls chart |FILEOPEN: xls chart
|displayed incorrectly |displayed incorrectly
|(formatting; values) in LO |(formatting; values). Line
|4.2.7.2 |type- Stepped
Ever confirmed|0 |1
OS|Linux (All) |All

--- Comment #8 from raal <***@post.cz> ---
I can confirm with Version: 5.1.0.0.alpha1+
Build ID: 6b7354ae66db40246a09e00aa876443057655a43
TinderBox: Linux-rpm_deb-***@70-TDF, Branch:master, Time:
2015-08-19_01:05:16

Steps to reproduce>
open file
edit chart / Chart type / change "Line type" to "Stepped"
save, close, reopen

Actual results:
Line type = Smooth

[b***@bugs.documentfoundation.org]

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

Hannes <commerce-***@gmx.at> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |UNCONFIRMED
Ever confirmed|1 |0

--- Comment #9 from Hannes <commerce-***@gmx.at> ---
Hello,
I stopped waiting for new version of LO via MintUpdate and installed LO
5.0.1.2; Build-ID 81898c9f5c0d43f3473ba111d7b351050be20261 manually last week.
The problem persists. (I dont know if this info is helpful as 'raal' already
posted on 2015-08-20, using a higher version of LO.).

[b***@bugs.documentfoundation.org]

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

raal <***@post.cz> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1

--- Comment #10 from raal <***@post.cz> ---
Correct status, problem persists => NEW

[b***@bugs.documentfoundation.org]

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

--- Comment #11 from Hannes <commerce-***@gmx.at> ---
Hello,
I did some testing - maybe this is not a bug of LO, just a limitation of
selected file format (xls, also xlsx) that causes that, and LO just cannot
interprete what is stored in that format for full 100% when opening in LO. I
also discovered that the Y-axis text labels change when using another than ODF
(ods) file format. I encountered no problems so far using the ods file format.
Suggestion: we consider it solved and LO displays a more strictly warning of
unwanted changes when saving in other file formats than ODF.

[b***@bugs.documentfoundation.org]

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

Robinson Tryon (qubit) <***@runcibility.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Keywords| |filter:xls
Whiteboard|filter:xls |

--- Comment #12 from Robinson Tryon (qubit) <***@runcibility.com> ---
Migrating Whiteboard tags to Keywords: (filter:xls)

[b***@bugs.documentfoundation.org]

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

--- Comment #13 from QA Administrators <qa-***@libreoffice.org> ---
** Please read this message in its entirety before responding **

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 on a currently supported version of
LibreOffice
(5.1.6 or 5.2.3 https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System

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)

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:
http://webchat.freenode.net/?channels=libreoffice-qa

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

Warm Regards,
QA Team

MassPing-UntouchedBug-20170103

[b***@bugs.documentfoundation.org]

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

--- Comment #14 from Libomark <***@f2s.com> ---
Bug still persists using Version: 5.2.0.4
Build ID: 066b007f5ebcc236395c7d282ba488bca6720265 under Win 7 Pro 64 bit.

[b***@bugs.documentfoundation.org]

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

--- Comment #15 from QA Administrators <qa-***@libreoffice.org> ---
** Please read this message in its entirety before responding **

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

[b***@bugs.documentfoundation.org]

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

--- Comment #16 from Denis Lisov <***@gmail.com> ---
This bug is still present in Libreoffice 6.0.3.2 on Gentoo Linux (distribution
package).

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |109072, 90486


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=90486
[Bug 90486] [META] Chart bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=109072
[Bug 109072] [META] XLS (binary) format bug tracker

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Severity|major |normal
Priority|high |medium

[b***@bugs.documentfoundation.org]

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

Timur <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|FILEOPEN: xls chart |FILESAVE: Line type -
|displayed incorrectly |Stepped in Chart saved in
|(formatting; values). Line |XLS / XLSX as Smooth
|type- Stepped |

[b***@bugs.documentfoundation.org]

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

Timur <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|FILESAVE: Line type - |FILESAVE: Line type -
|Stepped in Chart saved in |Stepped in Chart saved in
|XLS / XLSX as Smooth |XLS / XLSX as Smooth
| |(comment 17)
Hardware|x86 (IA32) |All
Version|4.2.7.2 release |4.1.0.4 release
Keywords| |implementationError

[b***@bugs.documentfoundation.org]

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

--- Comment #17 from Timur <***@gmail.com> ---
Created attachment 145609
--> https://bugs.documentfoundation.org/attachment.cgi?id=145609&action=edit
ODS file with stepped line type chart

This bug is not fileopen, but "FILESAVE: Line type - Stepped in Chart saved in
XLS / XLSX as Smooth".
Started in 4.1 when stepped line type was added. Implementation error. Repro
with 6.2+.

[b***@bugs.documentfoundation.org]

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

Gabor Kelemen <***@ubuntu.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@ubuntu.com

--- Comment #18 from Gabor Kelemen <***@ubuntu.com> ---
Created attachment 147432
--> https://bugs.documentfoundation.org/attachment.cgi?id=147432&action=edit
Line chart options in Excel13

It might be that Excel does not even has this chart type, at least I don't see
it in the new line chart dialog options.