Extension talk:Spreadsheet
This page used the Structured Discussions extension to give structured discussions. It has since been converted to wikitext, so the content and history here are only an approximation of what was actually displayed at the time these comments were made. |
not loading excel pages
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
- Hi, first off i wanted to say this extension seems fantastic.
- I'm having one problem with it, i have everything installed correctly on MW 1.21, and whenever i try to open a page with the <spreadsheet> tag in it it just sits at "Please wait, spreadsheet is loading." 207.69.174.7 18:56, 10 June 2013 (UTC)
- Did you ever solve this problem? I have same issue and have tried to resolve several ways. No luck.
- cld 108.242.213.183 15:39, 12 September 2013 (UTC)
- I have the same issue, "Please wait, spreadsheet is loading." and I am running MW 1.21.2, PHP 5.4.14, MySQL 5.5.25, Pear 1.9.4. I think I have all the dependencies installed correctly. Added PHPExcel (running first) and the require_once "$IP/extensions/Spreadsheet/Spreadsheet.php"; and
- $wgUseAjax = true; to Localsettings.php. Even upped the PHP memory_limit to 512M just to be safe. Spreadsheet (Version 0.1) is shown. Looks like a great extension, any ideas anyone? 67.137.149.122 23:41, 8 October 2013 (UTC)
- Hi,
- Is there any solution to this issue? Even I am facing the same problem. 202.67.4.113 06:07, 19 November 2013 (UTC)
- Can someone please help me? I dont understand much about PHP and AJAX, but I dont think the page is waiting for any data from excel sheet after displaying the progressbar. Only code I can see in HTML is:
<script type="text/javascript">
- < !--
- if(window.spreadsheet === undefined){
- window.spreadsheet = {};
- }
- window.spreadsheet['2fe1700645c8a08b'] = {"adapter":"phpexcel","file":"file.xlsx","sheet":"0"};
- -- >
- </script>
- <diiv id="2fe1700645c8a08b" class="spreadsheet-container" style="height: 600px;">
- <diiv class="progressbar"></diiv>
- <diiv class="progress-label">Please wait, spreadsheet is loading.</diiv>
- </diiv>
- </diiv>
- Note: div is changed to diiv just to put in the post... 59.182.131.11 07:16, 22 November 2013 (UTC)
- It's been a while since I've worked on this, but ill try to help. But i need some more information.
- Any exceptions in the mediawiki debug log? (https://www.mediawiki.org/wiki/Manual:How_to_debug#Setting_up_a_debug_log_file)
- Any javascript errors in the browsers js console?
- The speadsheet extension first loads the page, and then through javascript asynchronous method it calls an api to convert xls file through PHPExcel to a json format readable by the spreadsheet-js library. What you guys are describing is that it fails somewhere in between the call to the API and before a json result is returned.
- So either this is a javascript error, or there is something going on within the php code, or PHPExcel itself. netbrain (talk) 09:07, 3 March 2014 (UTC)
- Remember to run git submodule --init --recursive after installation.
- https://github.com/netbrain/spreadsheet-js/issues/2 netbrain (talk) 21:00, 4 March 2014 (UTC)
- Where do you run the git submodule --init --recursive ?
- Do you run it in the command prompt or do I need to modify an extension page or localsettings.php ?
- Currently have the following:
- MW 1.24.2, PHP 5.6.7, MySQL 5.6.24 I think I have all the dependencies installed correctly. Added PHPExcel (running first) and the require_once "$IP/extensions/Spreadsheet/Spreadsheet.php"; and $wgUseAjax = true; to Localsettings.php. Even upped the PHP memory_limit to 512M just to be safe. Spreadsheet (Version 0.2.0) is shown. 216.2.50.97 21:26, 8 June 2015 (UTC)
- I got the Error " Unexpected Token '<' " in the Javascript Console. 77.180.194.109 (talk) 08:26, 24 February 2016 (UTC)
- It is so sad to see such a good purpose extension abandoned :.( Does anyone knows any other way to insert excel sheets on MW? For no I'm converting it to PDF instead. Osodarck (talk) 13:17, 4 February 2017 (UTC)
Data viewing works in MediaWiki 1.19.7
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
Installed on a mediawiki 1.19.7 with PHPExcel 1.7.8. It doesn't show on the version page, but seems to be installed anyway. It successfully loads an xlsx spreadsheet, tables are visible. I can double click fields to edit things. Not sure if there's a way to save changes made, looks like only viewing for now. No formattting, it seems. Not sure if parts are missing because of the version of MediaWiki or because it isn't implemented in the extension yet, but very pleased I can view data at least. 13:51, 19 July 2013 (UTC)
Did some further testing, functions work, I'm able to add up ranges of numbers and perform other functions normally. From Spreadsheet-js, it looks like there are a fair number of functions working ( though I found 343 incidences of functions that just return "Not Implemented ). Here are the ones that have something, haven't tested them all:
"AND" "AVERAGE" "AVERAGEA" "CHIDIST" "COUNT" "COUNTIF" "ERF" "EXP" "FALSE" "GAUSS" "IF" "LN" "LOGINV" "LOGNORM.DIST" "LOGNORM.INV" "LOGNORMDIST" "NORM.DIST" "NORM.INV" "NORM.S.DIST" "NORMDIST" "NORMINV" "NORMSDIST" "NORMSINV" "PERCENTILE" "PERCENTILE.INC" "PI" "POWER" "RANDBETWEEN" "ROUND" "SQRT" "SQRTPI" "STDEV" "STDEV.S" "SUM" "TRUE" "ISBLANK" "ISERR" "ISERROR" "ISLOGICAL" "ISNUMBER" "ISREF" "ISTEXT"
ZombieWatercrest (talk) 19:23, 19 July 2013 (UTC)
Fatal error
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
I frequently get this error: Fatal error: Call to a member function exists() on a non-object in /data/19/3/152/103/3478918/user/3876691/htdocs/extensions/Spreadsheet/Spreadsheet.hooks.php on line 14 182.73.165.26 04:04, 22 April 2014 (UTC)
A stable release
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
This is a great solution for excel embedding in Media wiki.
When do you plan on releasing a stable version of this extension? Noti1234 (talk) 09:28, 14 May 2014 (UTC)
edit table
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
- did anybody manage to actually edit the spreadsheet? mine appears OK, seems editable, but changes aren't saved. 76.88.81.141 05:09, 30 September 2014 (UTC)
- Any news on this feature? 2.238.222.15 15:22, 31 March 2015 (UTC)
- +1 143.161.248.25 (talk) 16:32, 14 February 2018 (UTC)
creating a spreadsheet
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
I successfully installed this extension and it is shown on the special:version page, however, im not sure if I am posting the actual spreadsheets correctly.
Currently I have it set as : "<spreadsheet sheet=0" file="/var/www/mediawiki/Excel/WIKITEST.xlsx"/>" the excel folder is something I created in the mediawiki folder but I am curious if there is a specific folder I should be putting the spreadsheets. Currently all I get is "file does not exist" any suggestions or assistance would be greatly appreciated 155.165.220.228 (talk) 13:28, 17 July 2015 (UTC)
- Do not put /var/www/mediawiki/Excel/ in the name. Just put WIKITEST.xlsx
- <spreadsheet sheet=0" file="WIKITEST.xlsx"/> on a page and save it and it should work. 209.159.235.12 (talk) 18:55, 29 November 2017 (UTC)
Mediawiki 1.28 und Excel files - Viewing possible, no write back to file
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
Hi, old thread, but interesting extension-unfortunately neccessary to avoid a MS Sharpoint ;-)
Thanks for development.
What I did so far:
OS Ubuntu 16.04
PHP7
Install Mediawiki1.28.0
Downloaded and installed PHPExcel-Library. Example works fine.
Uploaded 01sample.xlsx to wiki.
Downloaded PHPExcel and spreadsheet extensions and spreadsheet-js library.
Created a sample page:
<spreadsheet sheet="0" file="01simple.xlsx" />
No image. After activating debug infos, I replaced deprecated function in parser (getRandomString) with wfRandomString( 16 ) in Spreadsheets.hooks.php.
Still no image. Debugging said missing libraries.
Downloaded missing library files
efp highcharts slickgrid
from github.
Now excel files are visible and editable. But changes are not saved.
More deprecated files (jquery...)
Are there any experiences in that direction or are there any alternatives ? Sonargucker (talk) 13:41, 1 March 2017 (UTC)
- May I ask where to download and how to install efp highcharts and slickgrid 203.82.44.154 (talk) 05:36, 10 May 2017 (UTC)
- git submodule update --recursive --init
- That is listed on the page, I looked and that installede highcharts slickgrid and excel-formula-parser (assuming that is efp) 209.159.235.12 (talk) 18:54, 29 November 2017 (UTC)
Links into excel spreadsheets
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
Hi there,
I'm using this awesome extension but I would like to know if possible to get the links that are in my excel files (to website or internal documents), does this extensions provides this functionality? Now it copies the name without the hyperlinks..
Thanks a lot! 194.74.11.94 (talk) 12:14, 26 January 2018 (UTC)
Proposal to archive this extension
RESOLVED | |
The extension has been archived. |
The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
A proposal to archive this extension has been lodged as https://phabricator.wikimedia.org/T196790. Regards. —MarcoAurelio (talk) 10:43, 21 June 2018 (UTC)
- The extension has been archived. —MarcoAurelio (talk) 10:03, 30 June 2018 (UTC)