[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 liuping doneyours...@gmail.com changed: What|Removed |Added Status|RESOLVED|VERIFIED --- Comment #16 from liuping doneyours...@gmail.com --- verify AOO410m1(Build:9750) - Rev. 1570848 Rev.1570848 on windows7 ,Pass -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added CC|o...@apache.org | --- Comment #15 from Oliver-Rainer Wittmann o...@apache.org --- @Clarence: Thx for the info. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added CC||o...@apache.org Target Milestone|--- |4.1.0 --- Comment #13 from Oliver-Rainer Wittmann o...@apache.org --- @Clarence: Is this issue solved already? -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Clarence GUO clarence.guo...@gmail.com changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |FIXED --- Comment #14 from Clarence GUO clarence.guo...@gmail.com --- @Oliver Yes, I verified against snapshot build AOO410m1(Build:9750) - Rev. 1560773, it's resolved. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 --- Comment #12 from SVN Robot svn...@dev.null.org --- orw committed SVN revision 1554790 into trunk: 123910: removing duplicate code -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 h...@apache.org h...@apache.org changed: What|Removed |Added Status|RESOLVED|REOPENED CC||h...@apache.org Resolution|FIXED |--- --- Comment #9 from h...@apache.org h...@apache.org --- 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' -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Andrea Pescetti pesce...@apache.org changed: What|Removed |Added CC||pesce...@apache.org -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
review canceled: [Bug 123910] The reference in validation condition change to #REF! in exported xls file : [Attachment 82165] fix patch
Clarence GUO clarence.guo...@gmail.com has canceled Clarence GUO clarence.guo...@gmail.com's request for review: Bug 123910: The reference in validation condition change to #REF! in exported xls file https://issues.apache.org/ooo/show_bug.cgi?id=123910 Attachment 82165: fix patch https://issues.apache.org/ooo/attachment.cgi?id=82165action=edit
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Clarence GUO clarence.guo...@gmail.com changed: What|Removed |Added Attachment #82165|0 |1 is patch|| Attachment #82165|0 |1 is obsolete|| Attachment #82165|review? | Flags|| -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
review requested: [Bug 123910] The reference in validation condition change to #REF! in exported xls file : [Attachment 82187] Fix patch
Clarence GUO clarence.guo...@gmail.com has asked for review: Bug 123910: The reference in validation condition change to #REF! in exported xls file https://issues.apache.org/ooo/show_bug.cgi?id=123910 Attachment 82187: Fix patch https://issues.apache.org/ooo/attachment.cgi?id=82187action=edit --- Additional Comments from Clarence GUO clarence.guo...@gmail.com Add a new patch of fix the build break
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Clarence GUO clarence.guo...@gmail.com changed: What|Removed |Added Attachment #82187||review? Flags|| --- Comment #10 from Clarence GUO clarence.guo...@gmail.com --- Created attachment 82187 -- https://issues.apache.org/ooo/attachment.cgi?id=82187action=edit Fix patch Add a new patch of fix the build break -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 --- Comment #11 from SVN Robot svn...@dev.null.org --- steve_y committed SVN revision 1554147 into trunk: Bug 123910 - The reference in validation condition change to #REF! in exporte... -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Steve Yin steve.yin@gmail.com changed: What|Removed |Added Status|CONFIRMED |RESOLVED CC||steve.yin@gmail.com Resolution|--- |FIXED --- Comment #8 from Steve Yin steve.yin@gmail.com --- Integrated the patch from Clarence to trunk -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 --- Comment #7 from SVN Robot svn...@dev.null.org --- steve_y committed SVN revision 1553626 into trunk: Bug 123910 - The reference in validation condition change to #REF! in exporte... -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Clarence GUO clarence.guo...@gmail.com changed: What|Removed |Added Attachment #82165||review? Flags|| --- Comment #6 from Clarence GUO clarence.guo...@gmail.com --- Comment on attachment 82165 -- https://issues.apache.org/ooo/attachment.cgi?id=82165 fix patch The root cause is when OOX parse the validation conditions, the source cell has not been set to the condition. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
review requested: [Bug 123910] The reference in validation condition change to #REF! in exported xls file : [Attachment 82165] fix patch
Clarence GUO clarence.guo...@gmail.com has asked for review: Bug 123910: The reference in validation condition change to #REF! in exported xls file https://issues.apache.org/ooo/show_bug.cgi?id=123910 Attachment 82165: fix patch https://issues.apache.org/ooo/attachment.cgi?id=82165action=edit --- Additional Comments from Clarence GUO clarence.guo...@gmail.com The root cause is when OOX parse the validation conditions, the source cell has not been set to the condition.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 --- Comment #5 from Clarence GUO clarence.guo...@gmail.com --- Created attachment 82165 -- https://issues.apache.org/ooo/attachment.cgi?id=82165action=edit fix patch -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Edwin Sharp el...@apache.org changed: What|Removed |Added Keywords|needmoreinfo| Status|UNCONFIRMED |CONFIRMED Latest|--- |4.1-dev Confirmation on|| Ever confirmed|0 |1 --- Comment #4 from Edwin Sharp el...@apache.org --- 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 -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 Edwin Sharp el...@apache.org changed: What|Removed |Added Keywords||needmoreinfo CC||el...@apache.org --- Comment #1 from Edwin Sharp el...@apache.org --- Steps to reproduce? -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 --- Comment #2 from Clarence GUO clarence.guo...@gmail.com --- Created attachment 82155 -- https://issues.apache.org/ooo/attachment.cgi?id=82155action=edit sample -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 123910] The reference in validation condition change to #REF! in exported xls file
https://issues.apache.org/ooo/show_bug.cgi?id=123910 --- Comment #3 from Clarence GUO clarence.guo...@gmail.com --- 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!) -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.