Bug #3482

setVersion(8) views fine in Excel 2004 but not Mailmerge

Details

Submitted	2005-02-15 14:18 UTC
From	rcaskey at uga dot edu
Assigned	xnoguer
Status	Closed
Package	Spreadsheet_Excel_Writer
PHP Version	4.3.2
OS	Linux
Roadmaps	(Not assigned)

Comments

[2005-02-15 14:18 UTC] rcaskey at uga dot edu

Description:
------------
Using setVersion(8) causes merge fields to go wacky.
Without it, things look fine but my fields get truncated
to the 255 character limit. With it, it looks fine in
Excel but when importing it into Word 2004 for Mac, the
fields names show up as "AutoMergeField"
"AutoMergeField1" "AutoMergeField2" etc. Shorter fields
look okay, although they have the wrong name.

Simply opening the file in Excel 2004 and clicking Save
before doing the mailmerge fixes the problem.

Longer
fields spit out pages of jibberish per field per record
and appear to include some kind of hash table because I
get bits that look like this :

_____?
_____?
_____?
_____?
_____?
_____?
_____?
_____?
_____?
_ _ _?
_
_
_?
_____?
_____?
___?
_____?
_____?
_____?
_____?
_____?
_____?
_____?
_____?
_____?______???
_____?
_____?
_____?
_____?
_____?
_____?
_____?
_____?
_ ___?
_
_ _?
___!_?
___"_?
__#_?
___$_?____?????
___%_?
_____?
_____?
_____?
_____?
___&_?______???
___'_?
___(_?
___)_?
___*_?
___+_?
___,_?______???
___-_?
_ _._?
_
_/_?
___0_?
___1_?
__2_?
___3_?_____????
___4_?
___+_?
___,_?______???
___5_?______???
___6_?
___7_?
___8_?______???______???
___9_?______???
___:_?
_ _;_?
_
_<_?
___=_?
___>_?
__?_?
___@_?
___A_?
___B_?
___B_?
___C_?______???
___D_?______???
___E_?
___F_?
___G_?
___H_?
___I_?
___J_?______???
___K_?
_ _L_?
_
_M_?
___N_?
___O_?
__P_?
___Q_?
___R_?
___S_?
___I_?
___J_?______???
___T_?_______??
___U_?
___V_?
___W_?
___X_?
___+_?
___,_?______???
___Y_?
_ _Z_?
_
_[_?
___\_?
___]_?
__^_?
_____?_____????
___`_?
___X_?
___+_?
___,_?______???
___a_?______???
___b_?
___c_?
___d_?
___e_?
___f_?
___g_?________?
___h_?
_ _i_?
_
_j_?
___k_?
__l_?
___m_?
___n_?
___o_?
___p_?
___q_?________?
___r_?______???
___s_?
___t_?
___u_?
___v_?
___w_?
___x_?______???
___y_?
_ _z_?
_
_{_?
___|_?
___}_?
__~_?
____?
___€_?
___?_?
___‚_?
___x_?______???
___ƒ_)____?(____?'____?&____?„__ƒ_____??__?_?
__@__________?___?
________________________________________________________
________________________________________________________
__

Thanks,
--Rob

[2005-11-07 22:17 UTC] xnoguer at php dot net

that is precisely the reason why setVersion() is considered experimental.