Limitation on dimensions/size of spreadsheet?
Alan Hale - August 15, 2009 - 12:54
| Project: | Sheetnode |
| Version: | 6.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | kratib |
| Status: | closed |
Jump to:
Description
Hi - I'm (still!) trying to import from Google spreadsheets but find that there is a limit on the size I can import. I'm sure where that limit is, but I find a 5 column x 60 row sheet will import, but not a 5 x 600. If it's to big I sometimes get a "DOMDocument cannot parse XML: " error, or just a white page.
Is there any documentation on size limits?
#1
Thanks for your report!
According to this post, there seem to be 2 conflicting DOM libraries in PHP: http://framework.zend.com/issues/browse/ZF-3933. Can you please check your
phpinfo()and report on the name and version of your DOM extension?Also, if you can make public the Google Spreadsheet you're trying to import, I can try it here to see how the import goes.
#2
Hi and thanks for the reply. Here is what phpinfo() tells me:
dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.26
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled
I don't really want to make the spreadsheet public - I've shared it with you (you should have the invitation) - will that work?
I's pretty big 1050 rows x 18 cols - maybe that's asking too much anyway. But 600 x 5 should work, surely?
Many thanks
#3
I was able to reproduce the error with the sheet you shared with me. I'll be working on it and reporting my progress here.
#4
It turns out that the Zend Gdata library is memory-hungry. I am planning to rewrite the Google import code using another library instead of Zend Gdata, but I still don't know how long it will take me.
#5
Ah - ok. Thanks for looking into it. I'll keep an eye out for the new version. Let me know if there's anything I an do to help.
#6
Please try the latest dev release (12 hours from now) and let me know if you're able to open the sheet. It now opens for me.
#7
Automatically closed -- issue fixed for 2 weeks with no activity.