Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • gnumeric gnumeric
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 378
    • Issues 378
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 3
    • Merge requests 3
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • GNOME
  • gnumericgnumeric
  • Issues
  • #98

Closed
Open
Created Apr 22, 2008 by Bugzilla@bugzilla-migration💬Reporter

Import Drops Unrecognized Date Format String

Submitted by Steven Lai

Link to original bug (#529362)

Description

Please describe the problem:

After importing an xls spreadsheet, certain date format string that is not recognized by gnumeric is lost.

Steps to reproduce:

In Excel, set A1 = "3/1/2007 12:00:00 AM" set A1 number format to 上午/下午h"時"mm"分"

It is displayed as "上午12時00分" in Excel

Actual results: Open in gnumeric, A1 becomes 39142, and the number format of the cell is dropped

Expected results: number format string kept, even it doesn't recognize the format string

Does this happen every time? yes, for this case but it appears that not every unrecognized case hits this problem

Other information:

Version: 1.8.x

Assignee
Assign to
Time tracking