Open The attachment https://bugs.freedesktop.org/attachment.cgi?id=71964 Open one of the queries. Up to LO 3.6.5.2 there were values shown for "Balance". In LO 4.0.0.3 these fields appear all empty. This query works with a correlating subquery for "Balance".
Long story: I opened this database with LO 4.0.0.3. Then I opened either query in SQL view. After looking at the SQL I wondered what it would look like in Design view, so I clicked Design View On/Off icon. But when I clicked this again to return to SQL View, I got an error message "SQL syntax error". When I ran the query, the Balance column was empty. Later I closed the query and reopened it in SQL view. Then I clicked the icon labeled "run SQL command directly". Then when I ran the query, the Balance column had the values that it should have.
Confirming on Linux 32 bit master : Version 4.1.0.0.alpha0+ (Build ID: 779f6188d9ee2f3db2514ea6db72663d35a064c) Alex
Adding Lionel to CC
Work-around: set a numeric format on that column instead of text format. This is caused by a copy-paste/error in the handling of numeric values by a text format. (Not sure why this column was getting text format instead of numeric format.)
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=966ab5cd805d403f1dec73bb1a452b9ed38348d5 fdo#61166 text format: correctly chain the formatter->getOutputString calls The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8a203e4996979fd9be3eba835fb84dd005ac3f69&h=libreoffice-4-0 fdo#61166 text format: correctly chain the formatter->getOutputString calls It will be available in LibreOffice 4.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Have downloaded LO 4.0.2.1 rc . Well done, Lionel. All values in subqueries were shown. Robert