You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/07/14 22:50:26 UTC

[Bug 120278] New: Database field NEXT RECORD fails in default configuration

https://issues.apache.org/ooo/show_bug.cgi?id=120278

          Priority: P3
            Bug ID: 120278
          Assignee: ooo-issues@incubator.apache.org
           Summary: Database field NEXT RECORD fails in default
                    configuration
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: jes@martnet.com
          Hardware: All
            Status: UNCONFIRMED
           Version: AOO 3.4.0
         Component: ui
           Product: word processor

Created attachment 78644
  --> https://issues.apache.org/ooo/attachment.cgi?id=78644&action=edit
sample document for testing

In previous versions of OOo, the NEXT RECORD field advanced to the next record
by default. The field's default configuration provided a condition of TRUE; as
long as the user didn't change the default, the field would cause a record
advance.

With AOO 3.4, the field's default condition is sal_TRUE, which does not
evaluate to a true condition and the default action of the field is _no_ record
advance.

If the user modifies the condition for the field to some value accepted as
logically true--for example the old default value, TRUE--then the field works
as before.

You can test this with the attached document, or with a simple test that
includes the NEXT RECORD field (Insert > Fields > Other > Database > Type: Next
Record. Use the "Data to Fields" function to copy data from the database into
the fields.

Expected results: NEXT RECORD skips to the next data record

Actual results: The same data record is processed--the NEXT RECORD field has no
effect.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120278] Database field NEXT RECORD is set to sal_True instead of TRUE

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

--- Comment #13 from Joe Smith <je...@martnet.com> ---
Testing
OpenOffice.org 3.4.1  341m1(Build:9593)
on Fedora Linux 17

Confirmed ok.

Note: Documents create by 3.4, including the test document attached still show
problem because the problem is recorded in the document. New documents, created
by following steps from description above work correctly.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

3.4.1_release_blocker requested: [Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
Ariel Constenla-Haile <ar...@apache.org> has asked  for
3.4.1_release_blocker:
Bug 120278: Database field NEXT RECORD fails in default configuration
https://issues.apache.org/ooo/show_bug.cgi?id=120278


------- Additional Comments from Ariel Constenla-Haile <ar...@apache.org>
Requesting release blocker status, so that the fix can be included in AOO 3.4.1


The fix is trivial and low risk.

[Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

--- Comment #7 from SVN Robot <sv...@dev.null.org> ---
"arielch" committed SVN revision 1362030 into branches/AOO34:
#i120278# - Merge fix from trunk into AOO34 branch

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD is set to sal_True instead of TRUE

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

Li Feng Wang <ph...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|VERIFIED                    |CLOSED

--- Comment #11 from Li Feng Wang <ph...@gmail.com> ---
Verify pass on AOO341 branch r1364591.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD is set to sal_True instead of TRUE

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

--- Comment #9 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #8)
> The NEXT RECORD field still has no effect with AOo trunk r1362376 on Windows
> XP.

How are you performing your tests?
With the document attached in this bug?

Please note that the field condition is stored inside the ODT file, and the fix
for this bug is not intended to fix already stored documents.

Please try with a new document:

- File - New - Text Document
- Table - Insert - Table...
- in the "Insert Table" dialog select 3 rows and 3 columns
- open the fields dialog: Insert - Fields - Other
  This dialog is modal, so that you can move the cursor to position it in the
table cells while this dialog is open
- In the Fields dialog select the "Database" tab

Adding record number in first column:
- on the "Type" list, select "Record number"; on the "Database selection"
select "Bibliography" - "biblio"
- position the cursor in cell A1 and press the button "Insert" in the "Fields"
dialog to insert the field in that cell. Repeat the same procedure for cells A2
and A3

Adding Title in second column:
- on the "Type" list, select "Mail merge fields"; on the "Database selection",
select "Bibliography" - "biblio" - "Title"
- position the cursor in cell B1, and press the "Insert" button in the "Fields"
dialog to insert the field in that cell. Repeat the same procedure for cells B2
and B3

Adding the "Next record" field in the third column:
- on the "Fields" dialog, select from the "Type" list, "Next record"
  With the fix for the current bug, you should see in the "Condition" edit
control the value TRUE instead of sal_True
- position the cursor in cell C1, and press the button "Insert" to insert the
field in that cell. Repeat the same procedure for cells C2 and C3.


Filling the fields with data from the Bibliographic database:
- select menu "View" - "Data Sources"
- on the Data Source Browser, select from the tree list on the left:
Bibliography - Tables - Biblio
- on the database table, select the first three records (the first three rows
on the database table)
- select the icon "Data to fields" on the Data Source Browser toolbar

Result:

You have three different rows in the text table:

1 A Conceptual Guide to OpenOffice.org 2 for Windows and Linux
2 Practical OpenOffice.org (Practical Series)
3 Getting Started with OpenOffice.org 2.x

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

--- Comment #1 from Joe Smith <je...@martnet.com> ---
PS: Tested on Fedora Linux 13; originally reported by XP user on the forum,
here:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=55094

This looks like a regression to me.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120278] Database field NEXT RECORD is set to sal_True instead of TRUE

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

Li Feng Wang <ph...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |phoenix.wanglf@gmail.com

--- Comment #8 from Li Feng Wang <ph...@gmail.com> ---
The NEXT RECORD field still has no effect with AOo trunk r1362376 on Windows
XP.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

--- Comment #6 from Joe Smith <je...@martnet.com> ---
Wow! Thanks so much for such quick attention to this. Great work!

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD is set to sal_True instead of TRUE

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

Li Feng Wang <ph...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |VERIFIED

--- Comment #10 from Li Feng Wang <ph...@gmail.com> ---
Yes, I used the document attached in this bug. I don't know the field condition
is stored inside the ODT file. I think it can auto change to default value.

I use the steps in last comment, then NEXT RECORD have expected effects on
trunk.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |RESOLVED
         Resolution|---                         |FIXED

--- Comment #3 from Ariel Constenla-Haile <ar...@apache.org> ---
Fixed in revision 1361594

-- 
You are receiving this mail because:
You are on the CC list for the bug.

3.4.1_release_blocker granted: [Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
jsc@apache.org has granted Ariel Constenla-Haile <ar...@apache.org>'s request
for 3.4.1_release_blocker:
Bug 120278: Database field NEXT RECORD fails in default configuration
https://issues.apache.org/ooo/show_bug.cgi?id=120278


------- Additional Comments from jsc@apache.org
set release blocker flag to 3.4.1, regression

[Bug 120278] Database field NEXT RECORD is set to sal_True instead of TRUE

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Database field NEXT RECORD  |Database field NEXT RECORD
                   |fails in default            |is set to sal_True instead
                   |configuration               |of TRUE

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

jsc@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jsc@apache.org
              Flags|3.4.1_release_blocker?      |3.4.1_release_blocker+

--- Comment #5 from jsc@apache.org ---
set release blocker flag to 3.4.1, regression

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
              Flags|                            |3.4.1_release_blocker?

--- Comment #4 from Ariel Constenla-Haile <ar...@apache.org> ---
Requesting release blocker status, so that the fix can be included in AOO 3.4.1

The fix is trivial and low risk.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD is set to sal_True instead of TRUE

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

jsc@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|---                         |AOO 3.4.1

--- Comment #12 from jsc@apache.org ---
set target milestone AOO 3.4.1

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 120278] Database field NEXT RECORD fails in default configuration

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120278

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |arielch@apache.org,
                   |                            |ooo-issues@incubator.apache
                   |                            |.org
           Assignee|ooo-issues@incubator.apache |arielch@apache.org
                   |.org                        |
     Ever confirmed|0                           |1

--- Comment #2 from Ariel Constenla-Haile <ar...@apache.org> ---
Bug introduced in removetooltypes01: #i112600# Remove tools types from sw
changeset 275032    c36a2e2560dd
parent 275031     e0677c0ff137
child 275033     f1a32d9e6a49

See
http://svn.apache.org/viewvc/incubator/ooo/trunk/main/sw/source/ui/fldui/flddb.cxx?revision=1198305&view=markup#l420

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.