Bubble chart in spreadsheet

Disclaimer: You are free to reuse it “as-is”, on your own responsibility and without any guarantee whatsoever. No rights can be derived from, successfully or unsuccessfully, completing the steps outlined below.

Steps

Part 1:

Create a new spreadsheet
Insert values 1, 2, 3 into first column
Insert values 10, 20, 30 into second column
Insert values 15, 5, 30 into third column
Add a bubble chart: 1st column is X-axis, 2nd is Y, 3rd is bubble
Change bubble color into red
Save and validate the file

Part 2:

Open it using another implementation
Check if the chart is displayed
Add value 4 in column A, 40 in B, 10 in C
Update the chart
Change bubble color into green
Save the file and reopen in another program

Files

Please follow the file name convention outlined in the faq. Note that the PDF files can be included as a previewing aid, but uploading the ODF files is much more important.

Original

ODF File	PDF preview
Gnumeric 1.10.16 (Win7)
MS-Office 2010 Pro
LibreOffice 3.3.1 (Linux)
MS Office 2010 SP1
EuroOffice 2010

Reopened /modified

ODF File	PDF preview
Gnumeric, edited with LibreOffice	Gnumeric, edited with LibreOffice
	Gnumeric, edited with EuroOffice
	MsOffice 2010, edited with EuroOffice

Tracker

A list of known issues. Implementations not listed here may or may not work as expected. Results may vary depending on user settings and computer environment. Use at your own risk.

Nr	Status	Write	Read	Comment
001a	Open	Gnumeric 1.10.16	MS-Office 2010	Error message “Excel found unreadable content…”. The spreadsheet can be opened and the values are shown + chart axis, but the bubbles are not shown. This is believed to be fixed in Gnumeric 1.10.17
001b	Open	Gnumeric 1.10.16	MS-Office 2010 SP1	Error message “Excel found unreadable content…”. The spreadsheet can be opened and the values are shown + chart axis, but the bubbles are not shown. This is believed to be fixed in Gnumeric 1.10.17
002	OK	Gnumeric 1.10.16	LibreOffice 3.4.1	OK
003	OK	MS-Office 2010	Gnumeric 1.10.16	OK