[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from r4z...@openoffice.org Mon Oct 18 08:37:55 + 2010 --- The strange thing is that, the IF(ISNUMBER( works with integer field types only in linux version (I tested on ubuntu), not with decimal type. On win7 IF(ISNUMBER( not help even in integer fields, it shows NaN in finished reports. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from o...@openoffice.org Mon Oct 18 07:51:06 + 2010 --- The conditional print expression has to be checked I guess. When I fill this IF(ISNUMBER([Szam_tiny]);[Szam_tiny]) in the data field I at least get rid of the NAN values. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from r4z...@openoffice.org Fri Oct 15 12:25:42 + 2010 --- May be it solved in some way, but if I run the report in OOo 3.2.1 the places where no numbers in table, not print anything. If I open it in OOO330m10, then in both version in decimal values I get printed N,aN. In Integer fields, I get NaN. How to remove it to get empty results set in reports, instead of NaN? I tried conditional print expression, no positive results. It not removes with NOT(ISBLANK([field])). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Fri Sep 3 08:07:56 + 2010 --- verified in CWS dba33h find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33h - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User oj changed the following: What|Old value |New value Assigned to|mst |msc --- Additional comments from o...@openoffice.org Wed Sep 1 07:12:54 + 2010 --- Please verify. - Open bug doc - Execute report - SaveAs in writer doc and store it - Reload => The NaN should still be valid and not converted to zero - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User mst changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from m...@openoffice.org Fri Aug 27 10:46:10 + 2010 --- fixed in cws dba33h non-conforming NaN/INF representation in OOo: http://hg.services.openoffice.org/hg/cws/dba33h/rev/a120c06f7b59 http://hg.services.openoffice.org/hg/cws/dba33h/rev/5dc8dc01f4d7 non-conforming NaN/INF representation in SRB: http://hg.services.openoffice.org/hg/cws/dba33h/rev/232bb0265ae7 SwTblBoxValue pool item ASSERT with NaN: http://hg.services.openoffice.org/hg/cws/dba33h/rev/d987c5b56a33 SwXCell converting NaN to 0: http://hg.services.openoffice.org/hg/cws/dba33h/rev/ab516f27dd84 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from m...@openoffice.org Thu Aug 26 13:24:20 + 2010 --- ok, now i've found out where the NaNs become zeroes: in SwXCell::getValue(): if( ::rtl::math::isNan( fRet ) ) fRet = 0.0; after removing that the NaNs aren't stored as 0 anymore. furthermore i've fixed the SwTblBoxValue pool item, which implemented its operator== by comparing two doubles with ==, which doesn't work on NaNs. i guess for the purpose of pooling two items with NaN should be equal. the formatting issue does not seem to affect loading/storing the document, so i think it can be fixed separately (not for 3.3). filed issue 114125. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from e...@openoffice.org Thu Aug 26 12:57:03 + 2010 --- @mst: > for some reason the writer renders the value as "1#N,AN" in some cases This may happen if the number formatter is involved and a format other than "General" is used, e.g. 0.00 (or German 0,00 as it might be the case here). The number formatter is not prepared to handle NANs correctly. For this you may create a new issue and assign it to me. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from m...@openoffice.org Wed Aug 25 14:15:48 + 2010 --- creating the report with OOO 3.2.1 yields cells like this: this is invalid because the office:value-type attribute does not have a corresponding office:value attribute. creating the report with DEV300m86 yields cells like this: now there is a value attribute, but its value is invalid. for some reason the writer renders the value as "1#N,AN" in some cases, which looks wrong. with the fix to ::rtl::math, the cells still look the same, but the import converts the string to "NaN" or "N,aN" in some cases. after a further fix to the reportbuilder itself, it generates proper cells: but there is still the problem that the value is sometimes displayed as "N,aN". this actually also occurs if the document type is changed to spreadsheet; i.e. Calc also displays "N,aN" for these values. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User mst changed the following: What|Old value |New value CC|'er,mib,mst,od,oj'|'er,iha,mib,mst,od,oj,sb' --- Additional comments from m...@openoffice.org Wed Aug 25 10:47:30 + 2010 --- i've now implemented the change to ::rtl::math functions suggested by er. iha reported that this causes a problem in chart: when a chart contains deleted values, these are represented as NaN; saving such a chart with the fix and then reading with an un-fixed OOo version converts these NaNs to zeros. but i don't see a way to prevent this kind of problem. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from e...@openoffice.org Tue Aug 24 09:51:46 + 2010 --- My 2 cents: don't work around in upper layers, change the underlying code instead. Change rtl::math::stringToDouble() to recognize both, the 1.#* and NaN/INF notation. Find out where rtl::math::doubleToString() is used to write NANs and INFs, Chart could be a candidate for this. If this is not used in code that writes persistent document files, change it to write the the XMLSchema-2 NaN/INF values instead. If it is used for persistent documents, judge the impact of the change if an older version would encounter the new NaN/INF values. I'd still opt for a change though to get this right. Btw, the 1.#* notation came from the MSC representation from times where XMLSchema didn't even exist. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User mst changed the following: What|Old value |New value CC|'mst,od' |'er,mib,mst,od,oj' Keywords|regression|odf_validation, regression Priority|P3|P2 --- Additional comments from m...@openoffice.org Tue Aug 24 09:08:58 + 2010 --- indeed, the SvXMLUnitConverter::convertDouble() writes these weird values: 1.#NAN -1.#NAN 1.#INF -1.#INF instead of the XMLSchema-2 conformant values: NaN INF -INF the weird values are produced by functions from . to fix this i'd like to change the conversion functions in SvXMLUnitConverter to check for special values NaN/INF. - always write the XMLSchema-2 conformant values - when reading, check for XMLSchema-2 conformant values first, fall back to rtl::Math code for backward compatibility. @er, mib: is that ok for you? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User oj changed the following: What|Old value |New value Assigned to|oj|mst --- Additional comments from o...@openoffice.org Tue Aug 24 06:08:46 + 2010 --- The problem here is not the import of the document, the problem is when saving it the NaN is gone. It doesn't matter if 1.#NAN is written or Nan. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from o...@openoffice.org Mon Aug 23 12:50:51 + 2010 --- @mst: Even NaN doesn't solve the problem. The value shown in the table is 0 which is wrong when it is a Nan. When writing 1.#NAN the value is correctly read but not written when doing so. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User ul changed the following: What|Old value |New value OtherIssuesDependingOnTh| |12 is| | - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User mst changed the following: What|Old value |New value CC|'od' |'mst,od' Assigned to|mst |oj --- Additional comments from m...@openoffice.org Thu Jul 29 17:27:45 + 2010 --- when generating the report in the attached bugdoc, the Writer ODF import filter is invoked on a temporary document file:///var/tmp/svi78.tmp/Table1.odt. this document is apparently not written by Writer (at least a breakpoint in obvious place didn't fire). this document contains table cells with value attributes like so: the ODF 1.2 schema says: float the value "1.#NAN" is not in the lexical space of "double" according to XMLSchema-2: http://www.w3.org/TR/xmlschema-2/#double The special values positive and negative infinity and not-a-number have lexical representations INF, -INF and NaN, respectively. so whatever is writing these value attributes should be writing "NaN" if it wants to say not-a-number. because the file is not valid, i don't see an urgent need to improve the Writer ODF import here, although a diagnostic to inform the user about the invalid input could be helpful. assigning back to oj. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User oj changed the following: What|Old value |New value CC|''|'od' Assigned to|oj|mst --- Additional comments from o...@openoffice.org Wed Jul 7 11:21:35 + 2010 --- I did the test also with calc and there it still works. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User r4zoli changed the following: What|Old value |New value OS/Version|Windows 7 |All --- Additional comments from r4z...@openoffice.org Tue Jun 29 08:07:28 + 2010 --- I tested on ubuntu 10.04 32bit version, same results. Change OS. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 User r4zoli changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Keywords| |regression Summary|ORB: report builder not ha|ORB: report builder not ha |ndle correctly NULL values|ndle correctly NULL values | | Target milestone|--- |OOo 3.3 --- Additional comments from r4z...@openoffice.org Thu Jun 24 11:47:42 + 2010 --- Assign developer, set target. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 --- Additional comments from r4z...@openoffice.org Thu Jun 24 11:46:22 + 2010 --- Created an attachment (id=70191) bugdoc with test data - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 112652] ORB: report builder not h andle correctly NULL values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112652 Issue #|112652 Summary|ORB: report builder not handle correctly NULL values Component|Database access Version|DEV300m83 Platform|Unknown URL| OS/Version|Windows 7 Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|dbaneedsconfirm Reported by|r4zoli --- Additional comments from r4z...@openoffice.org Thu Jun 24 11:45:12 + 2010 --- I tested it on DEV300_m83 with ORB 1.2.1_m82 and cws-srb1. Works same with both version. In decimal, and integer type field, when their content is NULL, in finished report shows: 1#N,AN, on decimal fields and 1,#NAN on integer fields. After saving to file system, and reopening, the report shows zeros instead of 1#NAN, and 1#N,AN. It not happens with text, or boolean fields, which I tested. This not happens with OOo 3.2.1 and ORB 1.2.1, where the example file was created, with report wizard. It seems to me as regression. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org