@jspreadsheet/autowidth - npm Package Compare versions

Comparing version 2.1.4 to 2.2.0

index.js

 /**
  * Plugin for auto width cols
- * 
- * @version 2.1.4
+ *
+ * @version 2.2.0
  * @author Guillaume Bonnaire <[e-mail]>
@@ -9,3 +9,3 @@ * @website https://repo.gbonnaire.fr
  * - autosize all columns without width property
- * 
+ *
  * @license This plugin is distribute under MIT License
@@ -19,4 +19,4 @@ */
     typeof exports === 'object' && typeof module !== 'undefined' ? module.exports = factory() :
-    typeof define === 'function' && define.amd ? define(factory) :
-    global.jss_autoWidth = factory();
+        typeof define === 'function' && define.amd ? define(factory) :
+            global.jss_autoWidth = factory();
 }(this, (function () {
@@ -29,22 +29,24 @@ return (function(spreadsheet, options, spreadsheetConfig) {
         }
-        
+
         // Plugin object
-        var plugin = {};
-         // Set options
+        const plugin = {};
+        // Set options
         plugin.options = Object.assign({},options);
-        
-        var oldValue_styleTable = "";
-        
-        var columnsToResize = [];
-        
+
+        let oldValue_styleTable = "";
+
+        let columnsToResize = [];
+        let saveIgnore={};
+
         // Options
-        var defaultOptions = {
+        const defaultOptions = {
             fullsizeTable: false,
-        }
+            parseAllData: true,
+        };
 
         // Set default value
         if(plugin.options==null) {
-           plugin.options = {};
+            plugin.options = {};
         }
-        for(var property in defaultOptions) {
+        for(let property in defaultOptions) {
             if (!plugin.options.hasOwnProperty(property) || plugin.options[property]==null ) {
@@ -59,13 +61,13 @@ plugin.options[property] = defaultOptions[property];
         plugin.onevent = function(event, worksheet) {
-            if(event=="onresizecolumn") {      
+            if(event === "onresizecolumn") {
                 plugin.beforeinit(worksheet);
                 run(worksheet);
-            } 
-        }
-        
+            }
+        };
+
         plugin.beforeinit = function(worksheet) {
             columnsToResize = [];
-            for(var ite_col=0; ite_col<worksheet.options.columns.length; ite_col++) {
-                var column = worksheet.options.columns[ite_col];
-                if(column.width==null || column.width=='' || column.width=='auto') {
+            for(let ite_col=0; ite_col<worksheet.options.columns.length; ite_col++) {
+                const column = worksheet.options.columns[ite_col];
+                if(column.width == null || column.width === '' || column.width === 'auto') {
                     columnsToResize.push(ite_col);
@@ -75,8 +77,8 @@ worksheet.options.columns[ite_col].width = 100;
             }
-        }
-        
-        plugin.init = function(worksheet) { 
-            run(worksheet);             
-        }
+        };
 
+        plugin.init = function(worksheet) {
+            run(worksheet);
+        };
+
         /**
@@ -86,10 +88,10 @@ * run calculate width of columns and apply
          */
-        var run = function(worksheet) {
+        const run = function(worksheet) {
             saveStyle(worksheet);
             setLayoutAuto(worksheet);
-            var colsWidth = getWidthColumns(worksheet);
+            const colsWidth = getWidthColumns(worksheet);
             removeLayoutAuto(worksheet);
             setWidthColumn(colsWidth, worksheet);
-        }
-        
+        };
+
         /**
@@ -100,6 +102,6 @@ * save old style before change
          */
-        function saveStyle(worksheet) {
+        const saveStyle = function(worksheet) {
             oldValue_styleTable = worksheet.table.style.cssText;
-        }
-        
+        };
+
         /**
@@ -110,6 +112,6 @@ * set style table layout
          */
-        function setLayoutAuto(worksheet) {
+        const setLayoutAuto = function(worksheet) {
             worksheet.table.style.tableLayout="auto";
-        }
-        
+        };
+
         /**
@@ -120,6 +122,6 @@ * remove style table layout
          */
-        function removeLayoutAuto(worksheet) {
+        const removeLayoutAuto = function(worksheet) {
             worksheet.table.style.cssText = oldValue_styleTable;
-        }
-        
+        };
+
         /**
@@ -130,20 +132,34 @@ * get Width offset of columns
          */
-        function getWidthColumns(worksheet) {
-            var cols = [];
-            if(worksheet.rows.length == 0) {
+        const getWidthColumns = function(worksheet) {
+            const cols = [];
+            if(worksheet.rows.length === 0) {
                 return cols;
             }
-            var tr = worksheet.rows[0].element;
+            const tr = worksheet.rows[0].element;
             if(tr) {
-                for(var ite_td=0; ite_td < tr.children.length; ite_td++) {
-                    if(ite_td == 0) { // Skip index
-                        continue; 
+                for(let ite_td=0; ite_td < tr.children.length; ite_td++) {
+                    if(ite_td === 0) { // Skip index
+                        continue;
                     }
-                    var td = tr.children[ite_td];
-                    cols.push(td.offsetWidth);
+                    const td = tr.children[ite_td];
+                    let width = td.offsetWidth;
+                    if(plugin.options.parseAllData) {
+                        let maxLength = tr.children[0].innerText.length;
+                        let widthInit = width;
+                        for(let ite_row=0; ite_row<worksheet.rows.length; ite_row++) {
+                            const valueRow = worksheet.getValueFromCoords(ite_td-1, ite_row, true);
+                            if(worksheet.rows[ite_row].element == null) {
+                                width = Math.max(Math.ceil((valueRow.length / maxLength) * widthInit), width);
+                            } else {
+                                maxLength = Math.max(valueRow.length, maxLength);
+                            }
+                        }
+
+                    }
+                    cols.push(width);
                 }
-            }     
+            }
             return cols;
-        }
-        
+        };
+
         /**
@@ -155,46 +171,66 @@ * defined new columns width
          */
-        function setWidthColumn(colsWidth, worksheet) {
-            
-            // Autorize changement colsWidth
-            var editable = worksheet.options.editable;
+        const setWidthColumn = function(colsWidth, worksheet) {
+
+            // Authorize edit colsWidth
+            let editable = worksheet.options.editable;
             worksheet.options.editable = true;
             enableIgnoreDispatch(worksheet.parent);
-            
-            if(worksheet.options.defaultColWidth==null || worksheet.options.defaultColWidth=="" || worksheet.options.defaultColWidth=="auto") {
+
+            if(worksheet.options.defaultColWidth == null || worksheet.options.defaultColWidth === "" || worksheet.options.defaultColWidth === "auto") {
                 worksheet.options.defaultColWidth = 50;
             } else if(typeof worksheet.options.defaultColWidth == "string") {
-                worksheet.options.defaultColWidth = parseInt(worksheet.options.defaultColWidth);                
+                worksheet.options.defaultColWidth = parseInt(worksheet.options.defaultColWidth);
             }
-            
+
             // Parse cols - calculate good size
-            var width_table = 0;
-            var cols_size_total = 0;
-            
+            let width_table = 0;
+            let cols_size_total = 0;
+
             // Manage Option fullsizeTable
             if(plugin.options.fullsizeTable) {
-                width_table = worksheet.table.parentNode.parentNode.offsetWidth - 50 - 5;
-                cols_size_total = colsWidth.reduce(function(acc,v) { return acc+v;});
-                for(var ite_col=0; ite_col<worksheet.options.columns.length; ite_col++) {
-                    var column = worksheet.options.columns[ite_col];
+                width_table = worksheet.table.parentNode.parentNode.offsetWidth - 26;
+
+                if(!worksheet.table.classList.contains("jss_hidden_index")) {
+                    width_table -= 50;
+                }
+
+                cols_size_total = colsWidth.reduce(function(accVal,val, index) {
+                    if(columnsToResize.indexOf(index) > -1) {
+                        if(index === 1 && columnsToResize.indexOf(0) === -1) {
+                            return val;
+                        } else {
+                            return accVal+val;
+                        }
+                    } else {
+                        if(index === 1 && columnsToResize.indexOf(0) === -1) {
+                            return 0;
+                        } else {
+                            return accVal;
+                        }
+                    }
+                });
+
+                for(let ite_col=0; ite_col<worksheet.options.columns.length; ite_col++) {
+                    const column = worksheet.options.columns[ite_col];
                     // Exclude hidden column
-                    if(column.type == "hidden") {
+                    if(column.type === "hidden") {
                         continue;
                     }
-                    
-                    if(columnsToResize.indexOf(ite_col) == -1) {
+
+                    if(columnsToResize.indexOf(ite_col) === -1) {
                         width_table = Math.max(0, width_table - parseFloat(column.width));
-                        cols_size_total = Math.max(0, cols_size_total - colsWidth[ite_col]);
                     } else if(colsWidth[ite_col]<100) {
                         cols_size_total = Math.max(0, cols_size_total + (100-colsWidth[ite_col]));
-                    } 
+                    }
                 }
             }
-            
+
             width_table = width_table - 7;
-            
+
             // Parse cols - set width
-            for(var ite_col=0; ite_col<worksheet.options.columns.length; ite_col++) {
-                var column = worksheet.options.columns[ite_col];
+            for(let ite_col=0; ite_col<worksheet.options.columns.length; ite_col++) {
+                const column = worksheet.options.columns[ite_col];
+                let newWidth;
                 // Exclude hidden column
-                if(column.type == "hidden") {
+                if(column.type === "hidden") {
                     continue;
@@ -204,5 +240,5 @@ }
                     if(colsWidth[ite_col]) {
-                        var newWidth = Math.max(worksheet.options.defaultColWidth, colsWidth[ite_col]);
+                        newWidth = Math.max(worksheet.options.defaultColWidth, colsWidth[ite_col]);
                     } else {
-                        var newWidth = worksheet.options.defaultColWidth;
+                        newWidth = worksheet.options.defaultColWidth;
                     }
@@ -215,28 +251,33 @@ if(plugin.options.fullsizeTable && cols_size_total < width_table) {
             }
-            
+
             // Resize old value
             disableIgnoreDispatch(worksheet.parent);
             worksheet.options.editable = editable;
-        }
-        
-        var saveIgnore={};
-        function enableIgnoreDispatch(inst) {
-            if(saveIgnore["ignoreEvents"]==null) {saveIgnore["ignoreEvents"] = inst.ignoreEvents;}
+        };
+
+        /**
+         * enableIgnoreDispatch
+         * @param {object} inst
+         */
+        const enableIgnoreDispatch = function(inst) {
+            if(saveIgnore.ignoreEvents==null) {saveIgnore.ignoreEvents = inst.ignoreEvents;}
             inst.ignoreEvents = true;
-            if(saveIgnore["ignoreCloud"]==null) {saveIgnore["ignoreCloud"] = inst.ignoreCloud;}
-            //inst.ignoreCloud = true;
-            if(saveIgnore["ignoreHistory"]==null) {saveIgnore["ignoreHistory"] = inst.ignoreHistory;}
+            if(saveIgnore.ignoreCloud==null) {saveIgnore.ignoreCloud = inst.ignoreCloud;}
+            if(saveIgnore.ignoreHistory==null) {saveIgnore.ignoreHistory = inst.ignoreHistory;}
             inst.ignoreHistory = true;
-            if(saveIgnore["ignorePersistence"]==null) {saveIgnore["ignorePersistence"] = inst.ignorePersistence;}
+            if(saveIgnore.ignorePersistence==null) {saveIgnore.ignorePersistence = inst.ignorePersistence;}
             inst.ignorePersistence = true;
-        }
-        
-        function disableIgnoreDispatch(inst) {
-            inst.ignoreEvents = saveIgnore["ignoreEvents"];
-            //inst.ignoreCloud = saveIgnore["ignoreCloud"];;
-            inst.ignoreHistory = saveIgnore["ignoreHistory"];;
-            inst.ignorePersistence = saveIgnore["ignorePersistence"];
+        };
+
+        /**
+         * disableIgnoreDispatch
+         * @param {object} inst
+         */
+        const disableIgnoreDispatch = function(inst) {
+            inst.ignoreEvents = saveIgnore.ignoreEvents;
+            inst.ignoreHistory = saveIgnore.ignoreHistory;
+            inst.ignorePersistence = saveIgnore.ignorePersistence;
             saveIgnore = {};
-        }
-        
+        };
+
         return plugin;
@@ -243,0 +284,0 @@ });

package.json

@@ -31,3 +31,3 @@ {
     "main": "index.js",
-    "version": "2.1.4"
+    "version": "2.2.0"
 }

README.md

@@ -10,4 +10,4 @@ ## jspreadsheet Plugin : auto Width
 
-- Auto width columns without width property or property:"auto" on intialization
-- the min width is egal to defaultColWidth
+- Auto width columns without width property or property:"auto" on initialization
+- the min width is equiv to defaultColWidth
 - can setWidth with "auto" value
@@ -27,4 +27,33 @@
 - [jSpreadsheet Pro v8](https://www.jspreadsheet.com/v8) 
+-   or
+- [jSpreadsheet Pro v9](https://www.jspreadsheet.com/v9)
 
 if you have a lot a plugins, add on the top autoWidth
+
+### Options of plugin
+<table>
+	<thead>
+		<tr>
+			<th>Option name</th>
+			<th>Description</th>
+			<th>Type</th>
+			<th>Default Value</th>
+		</tr>
+	</thead>
+	<tbody>
+		<tr>
+			<td><code>fullsizeTable</code></td>
+			<td>Calculate size column auto to use fullsize of screen</td>
+			<td><code>Boolean</code></td>
+			<td><code>false</code></td>
+		</tr>
+		<tr>
+			<td><code>parseAllData</code></td>
+			<td>Calculate size column auto with all data of columns (not only data showed)</td>
+			<td><code>Boolean</code></td>
+			<td><code>true</code></td>
+		</tr>
+	</tbody>
+</table>
+
 ### Get started
@@ -31,0 +60,0 @@

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

14024

increased by16.91%

Lines of code

241

increased by18.14%

Number of lines in readme file

100

increased by40.85%

No dependency changes