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
  • #45

Closed
Open
Created Nov 22, 2005 by Bugzilla@bugzilla-migration💬Reporter

CTRL+Shift+Enter functions don't convert

Submitted by Titus Winters

Link to original bug (#322096)

Description

Please describe the problem: It looks like there is some incompatibility between Excel and Gnumeric when using (at least some forms of) the CTRL+Shift+Enter functions. Such functions will work properly in Gnumeric, but when converting / exporting back to Excel they will only show up as #VALUE. Re-accepting the equation by selecting the cell(s) in Excel and hitting CTRL+Shift+Enter again fixes it.

Fairly minor, but some gnumeric related applications I've been developing would definitely benefit if this didn't happen.

Steps to reproduce:

  1. Download http://www.cs.ucr.edu/~titus/matrix_test.xls
  2. View in Excel, notice cells are properly formatted.
  3. Convert to and from gnumeric (ssconvert to gnumeric, ssconvert to xls)
  4. View in Excel, notice cells are improperly displayed.

Actual results: These matrix formula cells render only as #VALUE.

Expected results: The correct value should still be displayed.

Does this happen every time? Yes.

Other information:

Version: git master

Assignee
Assign to
Time tracking