Issue 68834 - pattern field does not work in a grid control
Summary: pattern field does not work in a grid control
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: OOo 2.2
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
: 61479 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-08-21 15:34 UTC by marc.neumann
Modified: 2007-04-18 15:34 UTC (History)
2 users (show)

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

Attachments
bugdoc (9.36 KB, application/vnd.sun.xml.base)
2006-08-21 15:35 UTC, marc.neumann 		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 marc.neumann 2006-08-21 15:34:14 UTC 
1. open the attached bugdoc
2. open the form in the database
3. insert a new record in the grid table
==>> not possible to insert anything in the patternfield in the gridcontrol.
Comment 1 marc.neumann 2006-08-21 15:35:32 UTC 
Created attachment 38676 [details]
bugdoc
Comment 2 drewjensen.inbox 2006-08-21 17:58:02 UTC 
If you open your form and set the property 'Strict Format' to NO for the
forrmatted field in the grid you will be able to enter data into it.

The edit mask is will not be visible, but this I suppose is a seperate issue.
Comment 3 Frank Schönheit 2006-12-07 14:04:35 UTC 
fixed in CWS dba22b

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=SRC680%2Fdba22b
Comment 4 Frank Schönheit 2006-12-07 14:12:43 UTC 
note:
In the bug doc, the pattern field is bound to a date column, and the masks are
setp up as if they it should take a DD.MM.YY date. This is conceptually
impossible to work properly: All what the pattern field knows is
- it is bound to a date column
- it has an edit mask NNLNNLLL
it has a literal mask __.__.06

With this information, it cannot decide how to convert a given string into a
date, or vice versa. It could guess (but that would be quite some kind of magic
already) that the dots are separators, and the __ resp. the 06 should denote
day, month, and year. But which one is which? No chance to know this.

So, now that this bug is fixed:
- You can input data, it displays the edit mask, and it displays the same texts
as the normal (non-grid) pattern field.
- But it is still *unable* to properly do date<->string conversion, so neither
the display of existent dates nor the input of new dates will yield the results
you might expect.
Comment 5 Frank Schönheit 2006-12-11 09:00:54 UTC 
*** Issue 61479 has been marked as a duplicate of this issue. ***
Comment 6 Frank Schönheit 2007-01-04 10:20:51 UTC 
fs-> msc: please verify in CWS dba22b
Comment 7 Frank Schönheit 2007-01-04 12:48:33 UTC 
targeting to 2.2, since the fix is part of a CWS aiming for this release
Comment 8 marc.neumann 2007-01-08 10:47:46 UTC 
verified in cws dba22b and wrote issue 73237 for the datevalue fault fs mention.

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=SRC680%2Fdba22b
Comment 9 kpalagin 2007-04-18 15:34:34 UTC 
Was broken in b8990.
Checked with 2.2m14 - fixed.
Closing.