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 2023/01/14 04:53:53 UTC

[Issue 128554] New: Office 2003 SpreadsheetML: fractional seconds are silently ignored during import

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

          Issue ID: 128554
        Issue Type: DEFECT
           Summary: Office 2003 SpreadsheetML: fractional seconds are
                    silently ignored during import
           Product: Calc
           Version: 4.2.0-dev
          Hardware: All
                OS: All
            Status: CONFIRMED
          Severity: Minor
          Priority: P5 (lowest)
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: damjan@apache.org
  Target Milestone: ---

After fixing bug 82849, a datetime value's year, month, date, hour, minute and
second are correctly imported, but any fractional seconds are silently ignored.

For example:

2023-01-14 02:03:05.67

would be imported as:

2023-01-14 02:03:05

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

[Issue 128554] Office 2003 SpreadsheetML: fractional seconds are silently ignored during import

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

Matthias Seidel <ms...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|4.2.0                       |4.1.14
              Flags|4.1.14_release_blocker?     |

--- Comment #5 from Matthias Seidel <ms...@apache.org> ---
Thanks!

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

[Issue 128554] Office 2003 SpreadsheetML: fractional seconds are silently ignored during import

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

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|---                         |4.2.0
              Flags|                            |4.1.14_release_blocker?

--- Comment #2 from damjan@apache.org ---
Cherry-picked for AOO41X in commit ffb2f9cdf269eb2185fa8deb2236b68a23ca6fb7.

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

[Issue 128554] Office 2003 SpreadsheetML: fractional seconds are silently ignored during import

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

--- Comment #6 from Matthias Seidel <ms...@apache.org> ---
The same problems arise with

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

and

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

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

[Issue 128554] Office 2003 SpreadsheetML: fractional seconds are silently ignored during import

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

Matthias Seidel <ms...@apache.org> changed:

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

--- Comment #3 from Matthias Seidel <ms...@apache.org> ---
I have conflicts when cherry-picking to AOO42X from

195282cf3d8bfaa9e1cec43b093251d9df87f4ba (trunk)

but not when I cherry-pick from

195282cf3d8bfaa9e1cec43b093251d9df87f4ba (AOO41X)

Is there a difference?

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

[Issue 128554] Office 2003 SpreadsheetML: fractional seconds are silently ignored during import

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

--- Comment #4 from damjan@apache.org ---
(In reply to Matthias Seidel from comment #3)
> I have conflicts when cherry-picking to AOO42X from
> 
> 195282cf3d8bfaa9e1cec43b093251d9df87f4ba (trunk)
> 
> but not when I cherry-pick from
> 
> 195282cf3d8bfaa9e1cec43b093251d9df87f4ba (AOO41X)
> 
> Is there a difference?

Yes, the document test file
test/testuno/source/fvt/uno/sc/formula/TestFormulaDocs.java was changed by
7d8592c79cfa104063570593e943fed55296950b in 2022, so fixes that added test
documents after that won't apply to earlier branches.

I've now cherry-picked both for AOO42X.

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

[Issue 128554] Office 2003 SpreadsheetML: fractional seconds are silently ignored during import

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

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Latest|---                         |4.2.0-dev
    Confirmation in|                            |
             Status|CONFIRMED                   |RESOLVED
          Developer|---                         |Easy
         Difficulty|                            |
         Resolution|---                         |FIXED

--- Comment #1 from damjan@apache.org ---
Fixed by below commit, resolving FIXED.

commit 195282cf3d8bfaa9e1cec43b093251d9df87f4ba
Author: Damjan Jovanovic
Date:   Sat Jan 14 06:58:10 2023 +0200

When importing SpreadsheetML ss:DateTime, import the entire value, not only the
first 19 characters.

Add a test file for this bug.

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