Bug 92721 - Recent breakages in spreadsheets
Summary: Recent breakages in spreadsheets
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.4.3 release
Hardware: Other macOS (All)
: medium blocker
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-07-14 07:27 UTC by Sugam
Modified: 2015-07-15 05:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
check the column width and Line chart behaviour in LIBO and EXCEL (6.75 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-07-14 07:27 UTC, Sugam
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Sugam 2015-07-14 07:27:30 UTC
Created attachment 117224 [details]
check the column width and Line chart behaviour in LIBO and EXCEL

Issue 1: Create a new spreadsheet, Insert double Line charts and save as xlsx. Open the same in EXCEL and it shows the up/down bar in line chart. The older versions were file.

Issue 2: Create a new spreadsheet, change the width of some columns and save as xlsx, Open the same in EXCEL and column width is the default width. The older versions were fine, I guess!!  

PS: Test file is attached.
Comment 1 Alex Thurgood 2015-07-14 15:14:51 UTC
Please do not put serveral bugs under one report. Please open separate reports for each buggy behaviour.
Comment 2 Alex Thurgood 2015-07-14 15:19:32 UTC
Issue 1
I opened your XLSX in Excel 15.10.1 for OSX, it shows a two line graphs and a block graph.

I opened the same file in 

Version: 5.1.0.0.alpha1+
Build ID: 7f0161d88e3a496361e2209d31cc7e9ef42a677e
Locale: fr-FR (fr.UTF-8)

OSX 10.10.4

and I see two line graphs.

I am assuming that you made the graphs in Calc, then exported to XLSX.

Confirming
Comment 3 Alex Thurgood 2015-07-14 15:34:11 UTC
However, if I alter the value of B5 and enter '4' for example, then resave the file as XLSX, and re-open in Excel, I get the correct two line graph representation, so this is a problem that occurs in the version you reported against, but which is fixed in master. As we don't know which fix was responsible, setting to wfm.

Also fixed in 

Version: 5.0.0.2
Build ID: a26d58f11b99b6aeddf7f7884effea188cc6e512
Locale: fr-FR (fr.UTF-8)


Closing WFM
Comment 4 Sugam 2015-07-15 05:08:53 UTC
@Alex Thurgood : Sorry for filing two bugs together. Yes, I made the graphs in LIBO 4.4.4.3 saved the file as xlsx and opening it on Excel for MAC 2011 version 14.1.0. I'll try the same with 5.0 Thanks.
Comment 5 Sugam 2015-07-15 05:59:51 UTC
only Version 5.0.0.3 is available to download, is thats what i need to download?
http://download.documentfoundation.org/libreoffice/testing/5.0.0/mac/x86_64/