Import ignores some cells content [#2644798]

In the attached spreadsheet you will see two tabs. General Ledger on web site is the result from my site after import (xlsx). The other tab is the original. As you can see several cells' content is missing.

I am using Acquia Dev Desktop on Win 7. If you need further details please let me know.

The only error message in the Drupal log that might be useful is "Warning: Illegal string offset 'first' in socialcalc_save_edit() (line 486 of C:\Users\Sam\Sites\devdesktop\bluehostclone\sites\all\modules\sheetnode\socialcalc.inc)."

Comment	File	Size	Author
	sheetnode problem.xls	34.5 KB	samstamport

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

5 January 2016 at 21:52

samstamport created an issue. See original summary.

Comment #2

willhallonline

English

Cambridge, UK

CreditAttribution: willhallonline as a volunteer commented 3 March 2016 at 20:50

Is this when importing using PHPExcel? How are you creating the sheetnode?

Comment #3

samstamport CreditAttribution: samstamport commented 3 March 2016 at 21:41

To be honest it's been quite some time since I worked with sheetnode, but I'm pretty sure I used PHPExcel since the original spreadsheet on my Win 7 computer is in Excel.

Comment #4

willhallonline

English

Cambridge, UK

CreditAttribution: willhallonline as a volunteer commented 4 March 2016 at 10:57

What version of PHPExcel are you using? I think that it only works with PHPExcel 1.7.8 https://github.com/PHPOffice/PHPExcel/tree/PHPExcel_1.7.8

Comment #5

samstamport CreditAttribution: samstamport commented 4 March 2016 at 14:43

I actually decided to not use sheetnode at this time. I removed the module, but thanks for checking into this. I know you guys are busy, but I couldn't wait for a reply to this problem. (I don't need to change my spreadsheet often.)