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 2020/02/22 18:31:43 UTC

[Issue 128300] New: Date formatting problem with MMMM

https://bz.apache.org/ooo/show_bug.cgi?id=128300

          Issue ID: 128300
        Issue Type: DEFECT
           Summary: Date formatting problem with MMMM
           Product: Base
           Version: 4.0.1
          Hardware: All
                OS: Windows 10
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: billforder@fastmail.com
  Target Milestone: ---

When using the MMMM date format the data input gets changed to random date
formats

ie- different months all ending up as the same month or a ddmmyy format  i'm
trying to create an MMMM formatted list box in a form. the list box is based on
a small table just for the months of the year.  Its really annoying  or am i
doing something wrong?

Cheers  Bill Forder

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

[Issue 128300] Date formatting problem with MMMM

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

--- Comment #3 from billforder@fastmail.com ---
screen shots will be illegible if I have to shrink them that small

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

[Issue 128300] Date formatting problem with MMMM

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

billforder@fastmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |billforder@fastmail.com

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

[Issue 128300] Date formatting problem with MMMM

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

billforder@fastmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|NOT_AN_OOO_ISSUE            |---

--- Comment #2 from billforder@fastmail.com ---
Hi
I am running version 4.1.7 Base on windows 10 Home version 1909

My aim is to create a "MonthList table" for use as  a list box in a form that
has 6  MMMM formatted fields in its corresponding table. I have tried setting a
primary key to the Month field (MMMM format)  in the table - and setting a
separate ID field primary key (integer format) with auto entry. both ways end
up producing "December" when I attempt to input the Month names whatever month
I enter into the Month field in data entry mode. 

On the surface of it it looks as tho the example given in the date format
options box has somehow become a fixed default and can't be overwritten.
Causing December to always appear after moving the focus. 

The only way I am able to get a workable form is to not employ the Date format
and use  text VARCHAR instead   which presumably means that I will not be able
to use date based queries.

Please find attached Photos

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

[Issue 128300] Date formatting problem with MMMM

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

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |IRREPRODUCIBLE
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #5 from oooforum (fr) <oo...@free.fr> ---
None attached files
In the absence of a document, it is difficult to reproduce what you describe.

Set temporarily as irreproducible.
Feel free to reopen once you provide required information.

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

[Issue 128300] Date formatting problem with MMMM

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

Peter <pe...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |petko@apache.org

--- Comment #4 from Peter <pe...@apache.org> ---
How about uploading the base file with test data?

Which formats do your Screenshots have?

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

[Issue 128300] Date formatting problem with MMMM

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

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oooforum@free.fr
         Resolution|---                         |NOT_AN_OOO_ISSUE
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
Your bug report is being closed as NOT_AN_ISSUE due to a lack of information
which is needed in order to accurately reproduce and confirm the problem. We
encourage you to retest your bug against the latest release. If the issue is
still present in the latest stable release, we need the following information:

a) Provide details of your system including your operating system and the
latest version of AOO that you have confirmed the bug to be present

b) Provide a step-by-step procedure to reproduce (the simpler will be the
better)

c) Provide any test case(s) which will help us confirm the problem (like a
sample document)

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED and we will
attempt to reproduce the issue.

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

[Issue 128300] Date formatting problem with MMMM

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

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

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