Hello Neil. apologies for long delay.
as you know, the plugin is just a wrapper to the code posted on Code Project (BasicExcel) by Yap Chun Wei. http://www.codeproject.com/Articles/13852/BasicExcel-A-Class-to-Read-and-Write-to-Microsoft to be honest, I have absolutely no idea at all what goes on inside the plugin... having said that. the code seems to first test if the double value can be stored as an RKVALUE. if yes, the double value is converted to an RKVALUE which is ULONG. otherwise, the raw double value is printed. 17832.75 converts to 1094399465 by GetRKValueFromDouble() but maybe there is a fault in this conversion? there was a similar question posted here: https://social.msdn.microsoft.com/Forums/en-US/cb760710-e4f0-47f1-a5e8-9ad1a2fc57cb/basicexcel-cant-return-a-double-value-from-an-excel-spreadsheet?forum=vclanguage anyway, I guess the quick and dirty workaround would be to always use the raw double value. https://github.com/miyako/4d-plugin-xls-basic-excel > 2016/10/10 19:20、Neil Rupert Pagulayan <npagula...@calvos.com> のメール： > Real numbers/amounts in it, and save it, then some of those amounts are > changing in the decimal part (e.g. 17,832.75 becomes 17,832.72). 宮古 啓介 セールス・エンジニア 株式会社フォーディー・ジャパン 〒150-0043 東京都渋谷区道玄坂1-10-2 渋谷THビル6F Tel: 03-6427-8441 Fax: 03-6427-8449 keisuke.miy...@4d.com www.4D.com/JP ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
