Bugs: Browse | Submit New | Admin

[#23287] Excel will not work properly with files created with 0.6.2 or 0.6.2.1

Date:
2008-12-19 14:35
Priority:
3
Submitted By:
Spencer Turner (spencer)
Assigned To:
Nobody (None)
Category:
biffwriter
State:
Closed
Summary:
Excel will not work properly with files created with 0.6.2 or 0.6.2.1

Detailed description
Hi,

First of all, thanks for this gem, and your hard work.

I can successfully write a file which can be read, in Excel, however, when you highlight cells and try and print them,
Excel (OfficeXP on Windows XP) says it cannot find any data.

If I save the created file again in OpenOffice, it is then useable in Excel, which leads me to thing it isn't the data.

Looking at the file created in a Raw Text editor, I don't see any BIFF text added. Once I save again from OpenOffice,
this is there.

I'd hoped the 0.6.2.1 release was the same issue (and fix) but having installed it, I still have the problem.

I can generate a file if it'll help (I haven't attached one as the actual file contains customer data, so I'd need to
create some dummy data if you need it)

Thanks in advance
Spencer

Add A Comment: Notepad

Please login


Followup

Message
Date: 2009-01-16 10:44
Sender: Hannes Wyss

Excel needed a WINDOW2 record with at least one 'active' Worksheet.
When printing, Excel will collect data from all active worksheets
(in a file with more than one worksheet, you can 'activate' several
of them by shift-clicking). Without any active Worksheets, Excel
was not going to print anything.

There is also a 'selected' flag, and frankly I have no idea what
the difference is, although it's possible that the selected Worksheet
is the one which is currently being shown.

best,
Hannes
Date: 2009-01-16 09:57
Sender: Spencer Turner

Hi Hannes,

Confirmed working. Thanks. (=

Out of  interest, what was the fix? (I tried to track it down
myself, but
couldn't)

Thanks again.
Best Regards
Spencer
Date: 2009-01-14 16:47
Sender: Hannes Wyss

Spencer

thanks again for your report - I've finally managed to find the
problem. Please try version 0.6.3 and let me know if it works
for you.

Thanks, 
Hannes
Date: 2008-12-19 15:47
Sender: Spencer Turner

File attached as requested.
Best Regards
Spencer
Date: 2008-12-19 14:48
Sender: Hannes Wyss

Spencer,

yes, please do attach a file with dummy data.

Thanks,
Hannes

Attached Files:

Name Description Download
TEST_SG_NEW.xls Sample Data Output As requested Download

Changes:

Field Old Value Date By
close_date2009-01-16 10:442009-01-16 10:44hwyss
close_date2009-01-16 09:572009-01-16 09:57spencer
status_idOpen2009-01-14 16:47hwyss
close_date2009-01-14 16:472009-01-14 16:47hwyss
File Added4235: TEST_SG_NEW.xls2008-12-19 15:24spencer