Recent changes to bugs-excel-add-in

#976 ODS to XLS Excel 2003 SP3 fails

2017-04-19T22:13:07.187000Z

Sorry, I added the wrong file first time round. This zip file contains the ods file that will not load

ODS to XLS Excel 2003 SP3 fails

2017-04-19T22:06:56.714000Z

Application version: Excel 2003 (11.8404.8405) SP3
Part of MS Office Professional Edition
OS version: Windows 7 Home Premium 6.1.7601 SP1 Build 7601
Add-In Version: OdfAddInForOfficeSetup-en_4.0.5309
Is this a roundtrip conversion? No
Is the error reproducible (Y/N)? Yes
Degree of occurence (rarely/casually/systematic): Everytime
Severity (Would be Nice/Irritating/No GO): No GO
and severely disruptive to a (actually more than one!) tax repayment claim. :-(
Type of bug (Install/Localisation/Crash/Conversion/Ergonomy/Other): Conversion fails
What was the problem? The file does not open in Excel
Where is the problem (sheet/page/header/footer/etc...)? On file load - other than that I cannot tell.
Step-by-step procedure to generate the error?
1 Right click the file in Windows Explorer>
2 Open with Microsoft Excel
What is the expected Result? That
1 the file will open
2 I shall be able to edit it
3 I shall be able to save it as an ods file
Please provide the document that caused the error (if any)! Document attached:
gift_aid_schedule_version_3.ods
This file has been provided by the UK Inland Revenue. The original download site is here:
https://www.gov.uk/government/publications/gift-aid-schedule-spreadsheets-to-claim-back-tax-on-donations

(optional) Additional information

When attempting to open the file the first warning is:

Excel supports only 256 chars in header/footer strings(with formatting). Any characters above 256 will be lost

This is not entirely unexpected and is accepted.
The second message is an error:
The converter failed to open the file
An unexpected error occurred. Please feel free to fill a bug report on the project website () with your file attached.

ODS not a valid oasis file

2012-03-16T09:25:06Z

Attach small ods file which will not open in MS Excel 2010 or 2007; on OS platform Windows7 of WindowsXP. Both Office suites already include add-in but we installed odfAddInforOfficeSetup v 4.0.5309. No repeat, only file we have. Error message permanent. Occurs always with this file. Conversion error. Will lose all date (40 hours research if we cannot resolve issue. (sorry, new to this, don't know what roundtrip means!)

Can\'t open file with Excel

2011-01-02T20:16:09Z

Inside a file there is a quite big amount of data (very long table). When I try to open it in Excel it says that unknown error occurred and the file cannot be opened.
I\'m using Excel 2007, Windows XP SP3.
Link to the file (upload limit exceeded)
http://www.sendspace.com/file/qocg6m

ODS - Conversion Times between 2..10min

2010-06-17T15:44:40Z

r5309

00:02:07 CEP2006N.ods

XLSX Roundtrip - Conversion canceled after 10 minutes

2010-06-17T15:38:50Z

061031_-_Pilotage_ADELE.CONFIDENTIAL.xlsx

XLSX Roundtrip - Conversion Times between 2..10min

2010-06-17T15:34:04Z

r5309

00:09:00 _fedict - Xls 007.CONFIDENTI.ods
00:05:36 _fedict - Réactifs (un-shared).CONFIDENTIAL.ods
00:02:56 _TestSuite - DB_Shipwreck.ods
00:02:36 _TestSuite - EU_ESTAT_BIG.EN.ods
00:02:26 _TestSuite - DB_Wireless.ods
00:02:13 _TestSuite - ECTSrechner2-06_Probex.ods

ODS: Validation errors in produced files

2010-06-11T15:46:41Z

The attached spreadsheet lists files which still produce validation errors in the generated IS 29500 output.

XLSX Borders, text alignment and background color lost

2010-06-09T12:45:34Z

r5305
Office 2007
XLSX->ODS
File: Pilot_Temperatures.xlsx
Sheets: Detailed Count High Temps and Regionalized High Temps

There are many changed in the pivot table at these sheets:
The cells B6:AY112 were "Alignmnet Center Horrizontally", now they have no alignment.
In the same range the borders are disapeared.
In column AZ the background color is lost.

This was no problem in version r 5293.

Xlsx--Data validity-- number not retained correctly

2010-06-04T13:04:45Z

Add-In Version = V4.0_M3_5293
OS version(s) used = Win XP
Office Version = Off 2007
Where is the problem ? ( Feature ) = Data validity-- number not retained correctly
Input File = Data_Validation_2010.xlsx

Xlsx: Data validity-- number not retained correctly