Apache OpenOffice (AOO) Bugzilla – Issue 123910
The reference in validation condition change to #REF! in exported xls file
Last modified: 2017-05-20 10:35:33 UTC
This defect is migrated from Symphony defect as below: Sym3_5489 [L3][Concord 21394]the reference in validation condition change to #REF! in exported xls file
Steps to reproduce?
Created attachment 82155 [details] sample
Save the xlsx as ods, reopen ods, save ods as xls, check the validation condition of cell E5, it is changed from =SUM(A1:C3) to =SUM(#REF!)
Thank you. Greater than SUM(A1:C3) turns into greater than SUM(#REF!#REF!:#REF!#REF!) when save as ods. AOO410m1(Build:9750) - Rev. 1551264 2013-12-17_04:10:52 - Rev. 1551455 Debian
Created attachment 82165 [details] fix patch
Comment on attachment 82165 [details] fix patch The root cause is when OOX parse the validation conditions, the source cell has not been set to the condition.
"steve_y" committed SVN revision 1553626 into trunk: Bug 123910 - The reference in validation condition change to #REF! in exporte...
Integrated the patch from Clarence to trunk
The change above breaks the build. All buildbots report: main/oox/source/xls/worksheethelper.cxx:1079: error: 'const struct oox::xls::ValidationModel' has no member named 'msRef'
Created attachment 82187 [details] Fix patch Add a new patch of fix the build break
"steve_y" committed SVN revision 1554147 into trunk: Bug 123910 - The reference in validation condition change to #REF! in exporte...
"orw" committed SVN revision 1554790 into trunk: 123910: removing duplicate code
@Clarence: Is this issue solved already?
@Oliver Yes, I verified against snapshot build AOO410m1(Build:9750) - Rev. 1560773, it's resolved.
@Clarence: Thx for the info.
verify AOO410m1(Build:9750) - Rev. 1570848 Rev.1570848 on windows7 ,Pass