enhancement request: 'shortest roundtripping' representation of values for file export - with patch proposal



 
hello @all, 
 
sorry for insisting on an old issue, IMHO it's quite important. 
 
setting the export length for double values for e.g. odf / ods files to fixed 17 digits ( 21 for long? ) produces compatibility problems, see attached sheet. Sorry if any display format issues, '4k' seems not fully compatible yet. 
 
as: 
 
A) it is 'not good' as it is, and 
B) it is easy to improve, see small patch proposed in sheet, 
 
I'd like it changed. 
 
If it is not wanted / accepted I'd be happy with a code pointer where the 'write length' is adjusted for export to *.xls and *.xlsx files to construct a private patched version for the most common files. I have an assumption, see in the sheet, but not yet tried. 
 
Best Regards, 
 
 
 
b. 
 
reference: https://gitlab.gnome.org/GNOME/gnumeric/-/issues/598 
         compatibility problem reg. precision when storing double values. (long doubles also affected) 
 
P.S. Please be forgiving if I make mistakes, I am not a 'pro' but peek, poke and try around, sometimes this yields new insights and improvements :-)  ... alas only sometimes ... :-( . 
 
P.S. II my test mileage: 135 ok, 2 skipped, 18 failed, anyone got these well? 
( to perform the tests just run 'make check' in the ~/test directory ) 
FAIL: t5900-sc.pl 
FAIL: t5901-qpro.pl 
FAIL: t5902-applix.pl 
FAIL: t5903-sylk.pl 
FAIL: t5904-mps.pl 
FAIL: t5906-dif.pl 
SKIP: t6050-vba-roundtrip.pl 
SKIP: t6152-xlsx-syntax.pl 
FAIL: t7121-solver-Hahn1.pl 
FAIL: t7141-solver-Thurber.pl 
FAIL: t8000-valgrind.pl 
FAIL: t8001-valgrind-xls.pl 
FAIL: t8002-valgrind-gnumeric.pl 
FAIL: t8003-valgrind-pdf.pl 
FAIL: t8004-valgrind-xls-macro.pl 
FAIL: t8005-valgrind-chart-fit.pl 
FAIL: t8006-valgrind-ods-no-styles.pl 
FAIL: t8010-valgrind-ods.pl 
FAIL: t8011-valgrind-xlsx.pl 
FAIL: t8050-valgrind-sstest.pl 

Attachment: deco-math_issue_I0004_patch_P0001_file_value_compatibility_G.ods
Description: application/vnd.oasis.opendocument.spreadsheet



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]