Untitled Application MyApp Author name 1.0 False 1100 750 False False False False WebApp False C:\Users\sinli\OneDrive\Documentos\VisualNeoWeb\Libraries\img\default-icon.png en standalone Offline page #000000 / [AndroidOS,iOS,WindowsPhoneOS] normal True True False True True False False True False False SetVar [resp] [eventObj] If [resp.event] == "onchange" ConsoleLog "Cell changed: [resp.c], [resp.d] New value: [resp.f]" EndIf [eventObj]|OBJECT| 30px 20px 470px 50px neoSheet Sample App 25px 75px 1045px 75px <strong>neoSheet is a powerful plugin for VisualNEO Web</strong> that lets you add interactive spreadsheet tables to your apps, similar to Excel or Google Sheets. It’s based on the open-source Jspreadsheet CE library and supports features like multiple sheets, live editing, row/column management, formulas, import/export, and event handling.<br>With neoSheet, you can easily create editable data tables, connect them to your app logic, and trigger actions when users make changes, all without writing complex code. Perfect for inventory managers, forms with calculations, or any app that needs structured data input. 25px 175px 110px 40px 1. Initialize neoSheetAddDataRow [data] "Crayons (Crayola)|2|5.00|=B1*C1" neoSheetAddDataRow [data] "Colored Pencils|3|4.50|=B2*C2" neoSheetAddDataRow [data] "Markers|4|3.00|=B3*C3" neoSheetAddDataRow [data] "Index Cards|10|1.20|=B4*C4" neoSheetAddDataRow [data] "TOTAL|=SUM(B1:B4)||=SUM(D1:D4)" neoSheetDefineColumn [columns] "Product" "text" "250" "" "" neoSheetDefineColumn [columns] "Qty" "numeric" "80" "0" "" neoSheetDefineColumn [columns] "Price" "numeric" "100" "$ #.##0,00" "" neoSheetDefineColumn [columns] "Total" "numeric" "120" "$ #.##0,00" "" neoSheetDestroy "Container1" . Use the new simplified init or full init neoSheetInit "Container1" 4 10 true true true 0 [data] [columns] true true true true true true true true true "" neoSheetSetCellStyle "Container1" 0 "A5" "font-weight:bold;background-color:#f0f0f0" neoSheetSetCellStyle "Container1" 0 "D5" "font-weight:bold;background-color:#e0f0e0" 145px 175px 100px 40px Save Data neoSheetGetConfig "Container1" [config] StringifyJSON [config] [json] VarToLocalFile [json] "neoSheet_data.json" 255px 175px 100px 40px file LocalFileToVar "FileInput1" [json] Wait 200 ParseJSON "[json]" [config] neoSheetSetConfig "Container1" [config] EndWait Load Data .json 365px 175px 100px 40px Read Only neoSheetSetRangeReadOnly "Container1" 0 "A1:D10" true 475px 175px 100px 40px Set Style neoSheetSetCellStyle "Container1" 0 "A1" "color:white;background-color:blue;font-weight:bold" 585px 175px 100px 40px Insert Row neoSheetInsertRow "Container1" 0 1 1 true 695px 175px 100px 40px Delete Row neoSheetDeleteRow "Container1" 0 0 1 25px 225px 110px 40px Insert Col neoSheetInsertColumn "Container1" 0 1 1 true 145px 225px 100px 40px Delete Col neoSheetDeleteColumn "Container1" 0 0 1 255px 225px 100px 40px Get Value neoSheetGetCellValue "Container1" 0 "A1" false [val] jsAlert "Value in A1: [val]" 365px 225px 100px 40px Hide Index neoSheetHideIndex "Container1" 0 475px 225px 100px 40px Show Index neoSheetShowIndex "Container1" 0 585px 225px 100px 40px Clear neoSheetClear "Container1" 0 695px 225px 100px 40px Download neoSheetDownload "Container1" 0 25px 275px 110px 40px Search "Crayons" neoSheetSearch "Container1" 0 "Crayons" 145px 275px 100px 40px Select A1:B2 neoSheetSelectRange "Container1" 0 "A1:B2" 255px 275px 100px 40px Get Selection neoSheetGetSelection "Container1" 0 [sel] jsAlert "Selected Range: [sel]" 365px 275px 100px 40px Hide Col 1 neoSheetHideColumn "Container1" 0 0 475px 275px 100px 40px Show Col 1 neoSheetShowColumn "Container1" 0 0 585px 275px 100px 40px Hide Row 1 neoSheetHideRow "Container1" 0 0 695px 275px 100px 40px Show Row 1 neoSheetShowRow "Container1" 0 0 25px 325px 150px 40px Add Named Sheet . Create a new worksheet with a custom name neoSheetCreateWorksheet "Container1" 4 10 "" "" "" "My Data" 185px 325px 150px 40px Rename Sheet 1 . Rename the first worksheet tab neoSheetRenameWorksheet "Container1" 0 "Products" 25px 385px 1050px 385px 0px 0px 768px 1024px False custom