Issue 31965 - Biblio refs in conditional text not evaluated properly
Summary: Biblio refs in conditional text not evaluated properly
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: eric.savary
QA Contact: issues@sw
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-07-22 23:56 UTC by skelem
Modified: 2013-08-07 14:38 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Test case that demonstrates the spreadsheet reference problem (5.58 KB, application/vnd.sun.xml.writer)
2004-07-22 23:57 UTC, skelem 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description skelem 2004-07-22 23:56:31 UTC 
Attached is a test case that uses the standard Bibliography.biblio.
It contains several field references (which evaluate properly), and two
Conditional Text expressions, which don't evaluate correctly.
The last line of the document contains the two Conditional Text expressions.
I couldn't find clear documentation that tells whether I should use
Bibliography.biblio.Pages (which is the case for the Field references, or
Bibliography.Tables.biblio.Pages.
In either case, they don't evaluate properly.

Example 1:
Open the document and the Data Sources. Select the first Id, BOR02a, then click
on Data to Fields.
The 1st expression (Pages > 500) evaluates properly, the 2nd does not.
If I change the 1st expression to Bibliography.Tables.biblio.Pages G 500,
it always evaluates to false, no matter which record I select and then hit Data
to Fields.
If I change the 1st expression to Bibliography.biblio.Pages G 500, it always
evaluates to true.

(I have also tried <Pages>, <Bibliography.biblio.Pages>,
<Bibliography.Tables.biblio.Pages>, and I have tried using ">" in place of "G",
even though the Operators section of Help says to use "G".  There doesn't seem
to be a way to drag a spreadsheet reference into the Condition, Then, or Else boxes.

Please Help!!!
Comment 1 skelem 2004-07-22 23:57:34 UTC 
Created attachment 16693 [details]
Test case that demonstrates the spreadsheet reference problem
Comment 2 michael.ruess 2004-07-23 07:26:43 UTC 
MRU->ES: please have a look, what's the problem here.
Comment 3 eric.savary 2004-10-24 22:09:36 UTC 
It comes from the fact that the "Pages" field is not format as number but as text.
Thus the condition returns internally "error" which fallsback on the first part
of the condition (bigger than).
Right click on the table in the tree view, choose "Edit table".
Change the format of "Pages" from "Text" to "Decimal"
The condition will work.
Comment 4 eric.savary 2004-10-24 22:09:51 UTC 
closed