Subject: | chartsheet fix doesn't account for changed order or deleted sheets |
Perl version 5.8.7
xlsx release .11
solaris
.xlsx File attached - loop over last worksheet incorrectly.
worksheet named by sheetId (8 in this case) is incorrect after deleted
sheets - would be correctly named x1/worksheets/sheet4.xml
worksheet description mentions 4 sheets...
(apply the sample program to dump the workbook will fail on the last
sheet, but get the name correct! since it can not find the data)
Moving the sheet order in excel and 're-saving' produces varied results.
(name no longer matches data)
From workbook.xml
[code]
- <sheets>
<sheet name="Project List" sheetId="1" r:id="rId1" />
<sheet name="Service Areas" sheetId="2" r:id="rId2" />
<sheet name="Communities Chosen" sheetId="3" r:id="rId3" />
<sheet name="CBs" sheetId="8" r:id="rId4" />
</sheets>
[/code]
Added r:id code back in - the computer guy in me doesn't like the
elseif without catching the 'else' !! :)
[code]
if ($k eq 'name') {
$sheet -> {Name} = $v;
$sheet -> {Name} = $converter -> convert ($sheet ->
{Name}) if $converter;
}
elsif ($k eq 'sheetId') {
($sheet -> {Id}) = $v;
} elsif ($k eq 'r:id') {
($sheet -> {Id}) = $v =~ m{rId(\d+)};
};
[/code]
Subject: | Broadband Intitative Review Input Template (Assign Training).xlsx |
Download Broadband Intitative Review Input Template (Assign Training).xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 850.8k
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 850.8k
Message body not shown because it is not plain text.