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:
- Download http://www.cs.ucr.edu/~titus/matrix_test.xls
- View in Excel, notice cells are properly formatted.
- Convert to and from gnumeric (ssconvert to gnumeric, ssconvert to xls)
- 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