Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • P PHP_XLSXWriter
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 101
    • Issues 101
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 24
    • Merge requests 24
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Infrastructure Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • mk-j
  • PHP_XLSXWriter
  • Merge requests
  • !206

Allow non-numeric/date value into number/date formatted cell

  • Review changes

  • Download
  • Email patches
  • Plain diff
Open hnx8 requested to merge github/fork/hnx8/master into master Jul 04, 2018
  • Overview 0
  • Commits 3
  • Pipelines 1
  • Changes 1
  1. Partly related to #189 : When specifying fraction '# ??? / ???' by format specification, it is not a source code implementation that determines cell type as 'n_numeric'. (Strictly, '#' '?' is not described to recognize it as a numeric type, but regex '/$/ absolutely determines as 'n_numeric')
  2. When assign a non-numeric value to the number formatted cell (In case I want to set a fixed text message for some reason), opening it with Excel will result in an error stating that the file has been corrupted.
  3. When assign a non-date value to the date/datetime formatted cell (In case I want to set a fixed text message for some reason), The value of the cell becomes "1900/01/01".

In order to avoid 2, 3, added processing to check the data type when setting the value in the cell.

Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: github/fork/hnx8/master