Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.858.071 Times

Sheetnode 6.x-1.4

  Date Added: June 20, 2013  |  Visits: 238

Sheetnode

Report Broken Link
Printer Friendly Version


Product Homepage
Download (20 downloads)



Sheetnode integrates the javascript spreadsheet engine SocialCalc as a new node type in Drupal. SocialCalc was written by Dan Bricklin, co-author of the original VisiCalc spreadsheet app in 1979, and is used in the OLPC XO laptop and the SocialText Collaboration Platform.Need a new feature for your business? Please drop me a line.Contributors/co-maintainers wanted! Please drop me a line.TABLE OF CONTENTS * News * What can you do with it? * Quick How-To: Spreadsheet View * Installation * Credits and Sponsorship * RoadmapNEWS * No more Java required!! I've finally gotten around to using PHPExcel to import/export XLS, XLSX, OOCalc, etc., so no more struggling against PHP/Java Bridge and other Java fiends. For best results, delete the complete sheetnode folder and install the latest 1.5 release (still in beta as of this writing). * No more patching required! I've forked the original SocialCalc code on GitHub, so make sure to update to the latest code as per the instructions below.WHAT CAN YOU DO WITH IT? * Create nodes that are spreadsheets, complete with formulas and formatting * Refer to cells in other spreadsheet nodes * Use the standard Drupal search to find content inside cells * Save sheets as templates that can be reused when creating new spreadsheets * Import from Microsoft Excel (.xls and .xlsx) and OpenOffice.org Calc (.ods) files * Import from Google Docs spreadsheets * Export to Microsoft Excel (.xls and .xlsx), Adobe Acrobat, and more * Create views that show results in spreadsheets, complete with formulas, formatting and result expansion * Create views that let you export their data to Microsoft Excel and other supported format Check the Roadmap below for upcoming features. QUICK HOWTO: SPREADSHEET VIEW * Install Views and this module (only Sheetnode module needed) * Create a new view of type Node (for example) * In Basic settings > Style, select "Spreadsheet" * Click "Update default display" to use the default Spreadsheet settings * Select a few fields to display in the view * Create a Page display to render the view on a page, and give it a URL * Save the view * Navigate to the chosen URL * Enjoy your first Spreadsheet view! * Later on, you can edit the view to specify a spreadsheet template instead of the default * If you enable the Sheetnode PHPExcel, you can also create Feed displays in the view that are attached to the Page display and that allow you to export the resulting spreadsheet to XLS and other output formats.INSTALLATIONSheetnode module * Go to the sheetnode folder. * Delete the existing socialcalc folder if it exists. * Download the latest SocialCalc tarball from the GitHub repo (you can use this link directly). * Extract the downloaded tarball and rename the extracted folder to socialcalc.Sheetnode Google Spreadsheets import/export module * Upgrade your PHP installation to 5.2.4 or later as this is the minimum requirement for the Zend Framework. * Download Zend Gdata Framework 1.9.x or higher. * Extract to a folder of your choice. * Configure Sheetnode Google Spreadsheets settings by entering the full path of the Zend Gdata folder that contains the subfolder named 'Zend' (typically /path/to/ZendGdata-x.y.z/library).Sheetnode PHPExcel import/export module * Download PHPExcel 1.7.4 or later. * Extract to a folder of your choice. * Configure Sheetnode PHPExcel settings by entering the full path of the PHPExcel folder root. * Check the Drupal status report to ensure that PHPExcel is found by the module.CREDITS AND SPONSORSHIPThe following organizations have provided financial support for Sheetnode: * Corebox.net * 10jumps * BEA Enterprises, Inc. * OpenCraftThank you all for your generous support.If you feel this module is useful to your business, please consider the following: * Contact me directly for paid work. * Buy me a book.Thanks!ROADMAPFunctionality * Support Google Spreadsheets formatting info * Export to Google Spreadsheets * Integrate with PHPExcel (done) * On-page controls to insert/remove rows/cols, format cells, etc. (done) * Export/import from CSV, XLS (done), ODS (in progress), Google Docs (in progress), etc. * Template system to save and reuse spreadsheet layouts (done) * User-defined functions including Ajax functions for backend processing (done for CCK fields) * Cell references to other sheetnodes (done: syntax is "Node title"!CellRef or "nid"!CellRef) * Fullscreen mode (done: click on the SocialCalc icon in the bottom-right corner of the sheet) * Charts * SUMPRODUCT function (done) * Collaboration featuresDrupal integration * Passing arguments and exposed filter values to views in cell references * Referencing node fields (done) * Packaging as CCK field (done) * Integration with theming system * Integration with Search module (done) * Cell-level permissions (done) * Revision history with user information (done) * Create a book and place all imported sheets inside it (done) * Packaging as Views style plugin (done) * Export Views to XLS, ODS (done)Issues & limitations * ajax_ui.module interferes with Sheetnode and prevents it from saving the spreadsheet data. * No import of charts or images * No export of HTML or Wiki text cells * Only one sheet can be displayed on a single page at any time (in progress)

Requirements: No special requirements
Platforms: PHP
Keyword: Cells Create Default Display Export Fields Folder Google Importexport Latest Microsoft Module Phpexcel Settings Sheetnode Socialcalc Spreadsheet Spreadsheets
Users rating: 0/10

License: Freeware Size: 51.2 KB
USER REVIEWS
More Reviews or Write Review


SHEETNODE RELATED
Modules  -  Ubercart Sub-Product 6.x-1.0-rc1
AboutThis module allows you to create a 'super' or 'parent' product node-type and then display a list of 'child' products in a table with a single add to cart button to add multiple products to the cart in one go.Features * Integrates with...
20.48 KB  
Modules  -  CCK GMap Address 5.x-1.0-beta11
Create your own address fields via CCK. Addresses are validated via Google Maps and can be displayed in several ways. * Address * Longitude * Latitude * Gmap - Single * GMap - All in One * Route Link - Single * Route Link - Allfeatures *...
10 KB  
Form Processors  -  Form Dependency Manager 1.1
This is a form dependency script for shuttling the display of fields within a complex form, where the visibility of a form field should depend on the value and/or state of another. It's not meant to replace server side scripting for dictating what...
102.4 KB  
Modules  -  Custom Comment Fields 0.1.1
Create additional custom comment fields per post type, including built in post types. Install : 1. Upload custom-comment-fields and its contents to the /wp-content/plugins/ directory 2. Activate the plugin through the 'Plugins' menu in WordPress...
51.2 KB  
Modules  -  Formatter Reference 7.x-1.x-de
Provides a "Formatter Reference" field type for being able to display other fields differently on a per-entity basis. For example, suppose instead of picking an image size (like "large") as the format for the Image field on the Article node type,...
10 KB  
Libraries  -  fields::aliased 1.05
fields::aliased is a Perl module that can create aliases for object fields. SYNOPSIS package MyPackage; use strict; use fields qw($scalar @array %hash); sub new { my $class = shift; my $self = fields::new($class); return $self; }...
8.19 KB  
Web Browser Tools  -  GButts 1.4.7.1
GButts is an extension used to display all of your Google Services as buttons just next to your addressbar or anywhere you like. Display all of your Google Services as buttons just next to your addressbar or anywhere you like it! You can go to...
35.84 KB  
Database Tools  -  myDBR for Scripts 1.4
This database reporting tool can automatically create and display reports for both MySQL and MsSQL databases, but can also display them in regular browsers and mobile devices.Here are some key features of "myDBR":dlTE Automated layout creation,...
3.02 MB  
Database Tools  -  Pork.Generator for Scripts 1.0.1
Pork.Generator is a webbased tool to inspect your databases and generate Pork.dbObject based code.The generator analyzes the relations in your database, by trying to match primary keys to fields of other tables. If you have created your table...
2.1 MB  
Modules  -  Show Required Label 6.x-1.2
This module adds an explanation label to the bottom, top, or both, of forms that have required fields explaining the * next to the labels.It defaults to *Required Fields but can be set in the settings to display what ever text you'd like. You can...
10 KB  
NEW DOWNLOADS IN SCRIPTS, MODULES
Scripts  -  Free Ecommerce website creator 1.2
Free Ecommerce website creator is a free PHP shop creating script. This allows you to put a online shop on your own website. Create your own free ecommerce website for Your Business. Create an online shop using easyGUI online shop creator. The...
1.44 KB  
Scripts  -  MochiGames PHP Script ZDR 1.00
MochiGames PHP Script ZDR is web site, ready for use, for flash games. These flash games are downloaded automatically by "MochiGames PHP Script ZDR" from MochiGames media. The use of the games is free, you can use your own Mochi Publisher ID and...
368.54 KB  
Scripts  -  Php Chat 2.0
Add a free php site, single sign-on and multiple skins, 100% free 1. Server Modes: The chat server has paid mode and free mode. If the free chat mode, a free chat room will be assigned to your website with your domain as the room name. 2....
938.87 KB  
Scripts  -  Nibbleblog 3.0.1
Nibbleblog it's a powerful engine for creation and manipulation of BLOG's completely free. Very simple to install and configure (Only 1 step). The database used is based on XML files and this way it is not necessary to use MySQL or similar DBMS....
371.09 KB  
Scripts  -  PHP File Manager | CloudOsys 2.9b8
CloudOsys is a PHP file manager, a tool that allows your visitors upload files such as media content directly to your website. Your visitors will upload files directly to your website, where they can share and comment on them. Through cloud...
1.41 MB  
Modules  -  TinyMCE Node Picker 6.x-2.1
This module will de discontinued and replaced with Node Picker as soon as a stable release is available.TinyMCE Node Picker provides a button in TinyMCE that displays a list of links to content. Choosing a link inserts it into the editor.The...
20.48 KB  
Modules  -  Fapilicious 5.x-1.x-de
Fapilicious is a collection of FormAPI goodies.I hope to make it a repository of reusable FormAPI trickery and short cuts. Currently it has small collection of powerful FormAPI element validators.Please submit your favorite tricks as patches so we...
10 KB  
Modules  -  Donation Goals 6.x-1.x-de
The Donation Goals module lets you create nodes of the type "Donation Goal." These goals allow you to set an amount of money you'll need for whatever you're saving up for. Visitors of the site can then donate money through PayPal. Once the target...
20.48 KB  
Modules  -  Plica Twitter 1.0.1
Plica TwitterInstallation : * Download, unzip, and install plugin dir in /wp-content/plugins * Activate * All right now
10 KB  
Modules  -  Page Array 5.x-1.x-de
The pagearray module is a small (single function) helper module that can be used whenever there is a need to load the output of any Drupal path in data form. Based on the code in index.php, Page Array bypasses the theme('page') call, instead...
10 KB