code pointer for reading from xls files
newbie nullzwei via gnumeric-list <[email protected]> Sat, 29 Jan 2022 13:47:26 +0100
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <trinity-de941008-4702-46ff-8ab8-9c359fb31d1d-1643460446696@3c-app-gmx-bap50> |
--===============3142251073622731823==
Content-Type: text/html; charset=UTF-8
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div style="font-family: Verdana;font-size: 12.0px;">
<div style="font-family: Verdana;font-size: 12.0px;">
<div style="font-family: Verdana;font-size: 12.0px;">
<div style="font-family: Verdana;font-size: 12.0px;">
<div style="font-family: Verdana;font-size: 12.0px;">
<div style="font-family: Verdana;font-size: 12.0px;">
<div style="font-family: Verdana;font-size: 12.0px;">
<div style="font-family: Verdana;font-size: 12.0px;">
<div> <br/>
hello @all, <br/>
<br/>
doe's somebody know about and can help me with a code pointer?<br/>
<br/>
( I'm quite sure MW can, but as well think he has lot's of other more important stuff to do. )<br/>
<br/>
I want to - try to - get the tests (make check) passing with a long double version, and for that<br/>
purpose need to - try to - pimp up the values read from the files. E.g. 'statfuns.xls' has values<br/>
like 0.1, 0.4, 0.2, 0.3 ... stored for PROB, when loading the file a gnumeric 'long' version converts that to:<br/>
'=prob({0;1;2;3};{0,10000000000000000555;0,4000000000000000222;0,2000000000000000111;0,2999999999999999889};2)'<br/>
and in consequence calculates bullshit or #NUM!.<br/>
<br/>
I have an idea for a meaningful conversion and would like to chek it out, but I'm not sure which function in which 'c' file doe's the read in.<br/>
<br/>
I tried intercepting ms-excel-read.c at 'val = value_new_float (gsf_le_get_double (val_dat));', but alas that didn't work out.<br/>
<br/>
I think I need two points, one where a value is read and the cell assigned a value, and one where a formula is read and parsed and contains values.<br/>
<br/>
I am aware that I won't get text as from xml files, but a bin value, will try to deal with it ...<br/>
<br/>
Best Regards,<br/>
<br/>
<br/>
<br/>
b.</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></body></html>
--===============3142251073622731823==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
--===============3142251073622731823==--