URGENT : Help to resolve SP3 issues !

[Deb]

Hi John,

We were using WriteExcel for doing certain data formatting in
spreadsheets and things were working fine until we had an upgrade to
SP3.

All of a sudden data transformation have gone missing.

For eg : In the input file csv file we had 'ZZZZZZ' in a cell and we
were using Perl to replace the word 'ZZZZZZ' with the word 'Total'

But with this SP3, this transformation is not happening and the word
'ZZZZZ' is appearing in the spreadsheet as-is.

Also, as we open the spreadhseet we get the following error :

"File Error: data may have been lost".

Please let us know if you have work-arounds or patches to address
these issues.


Thanks,
Deb

[jmcnamara]

On May 21, 10:26 pm, Deb <debangshu.chowdh...@gmail.com> wrote:
>
> For eg : In the input file csv file we had 'ZZZZZZ' in a cell and we
> were using Perl to replace the word 'ZZZZZZ' with the word 'Total'
>
> But with this SP3, this transformation is not happening and the word
> 'ZZZZZ' is appearing in the spreadsheet as-is.
>
> Also, as we open the spreadhseet we get the following error :
>
> "File Error: data may have been lost".
>

Hi,

Excel changed in SP3. It now issues a warning if duplicate data is
present in a cell (i.e., if you have written to a cell more than once)
and it only displays the data that was written first.

Therefore, you will have to change your program to avoid writing
duplicate data. I would suggest converting 'ZZZZZ' to 'Total' as you
read the CSV data and before you write it with WriteExcel.

As of version 2.21 Spreadsheet::WriteExcel will remove duplicate data
when compatibility_mode() is enabled:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pm#compatibility_mode()

Note however that this can incur a speed and memory overhead for large
files.

John.
--