Most Powerful Open Source ERP

1 - 15 of 21 records
Title Author Responses Latest Post Modification Date
Adding 10000 rows in a table Unknown User 1 Unknown User Link To Post 2019/10/08   09:53
Unprotect the excel sheet with password pro-grammatically using officejs. Unknown User 1 Unknown User Link To Post 2019/01/31   14:49
Protect an office online add-on Unknown User 1 Unknown User Link To Post 2018/11/23   02:06
Open Office JS Template in same Excel File Unknown User 1 Unknown User Link To Post 2018/08/02   16:51
Access Token using Identityserver4 in office.js Unknown User 2 Unknown User Link To Post 2018/06/28   14:54
[Web Texts] Synchronization not possible Lukasz Nowak 2 Romain Courteaud Link To Post 2017/07/21   13:56
Task Manager JS does not work Unknown User 2 Romain Courteaud Link To Post 2017/07/20   10:09
Save callback handler from 'Ctrl +S ' in office.js add-in Unknown User 1 Unknown User Link To Post 2017/06/20   05:01
Jabber password bug Unknown User 2 Unknown User Link To Post 2017/06/02   11:01
declareService vs declareJob Unknown User 4 Cédric Le Ninivin Link To Post 2017/03/08   10:47
Font problem in http://renderjs.org/ Unknown User 3 Unknown User Link To Post 2017/03/08   01:23
Where is renderjs documentation ? http://renderjs.org/ or https://www.erp5.com/P-RJS.Homepage which is latest doc ? Unknown User 2 Cédric Le Ninivin Link To Post 2017/03/07   14:03
Dead link in http://renderjs.org/ Unknown User 2 Cédric Le Ninivin Link To Post 2017/03/07   14:02
Unhandled Exception with Bookmarks App Unknown User 4 Sebastian Kreisel Link To Post 2017/02/16   15:30
[Release][PDF Reader] First release of PDF Reader Cédric Le Ninivin 1 Cédric Le Ninivin Link To Post 2016/12/21   17:35

Latest News

24-01 2020

Please upgrade re6st to version 0.551

Re6st must be upgraded to version 0.551 as soon as possible. Soon, the network will be upgraded to remove all machines running an older version.
30-12 2019

Using an /e/ phone as a desktop or laptop

Not so much work remains to be done to turn /e/ into a desktop operating system. Using an /e/ smartphone as a desktop PC with an external screen, keyboard and mouse is already possible with good usability. Using an /e/ smartphone as a laptop is also possible with scrcpy although some minor improvements are still required for usability.
24-12 2019

How does Rapid.Space and SlapOS compare to AWS?

75% of cloud services provided by Amazon AWS could actually be implemented with Nexedi Free Software stack and Rapid.Space low cost, high performance cloud. With the addition of a few third party Free Software, 85% of AWS services could be replaced by sovereign alternatives.
07-10 2019

Free Software Publisher Spotlight

Nexedi is part of the initial selection of European Free Software Publishers presenting at the Spotlight on Free Software Publishers event hosted by Cap Digital, the Libre Endowment Fund and the National Council of Libre Software.

08-10 2019

Adding 10000 rows in a table by Unknown User

Hello, I am trying to create a table containing 82 columns and 10000 rows (11028 to be exact) in a sheet. I tried to add the lines one by one and then to do a Sync but the table is not created. I thought it was a lot of data at one time so I tried adding lines in packets of 1000. This time, I get the table but only the first 1000 rows are filled. In the log, I see all the packets go by.   In the code below : - "values" is the json formatted data i try to add  - "tableName" speaks for itself. The steps before 5 are inscriptions of some data in other sheets but these works.   function CreateODataQuerySheetStep5_List(values, tableName) {     let n = values.length;     if (n > 0) {         CreateODataQuerySheetStep5_ListTableHeader(values, tableName);           } else {         Excel.run(function (context) {             let headers = [["No data"]];             let sheet = context.workbook.worksheets.getItem(newQueryName);             let table = sheet.tables.add("A1", true);             table.name = tableName;             table.getHeaderRowRange().values = headers;             sheet.activate();             window.location.href = "Home.html";             return context.sync();         }).catch(function (error) {             logging(sessionStorage.getItem("Token"), error);         });             } } function CreateODataQuerySheetStep5_ListTableHeader(values, tableName) {     console.log("Creating header");     Excel.run(function (context) {         console.log("Get Sheet");         let sheet = context.workbook.worksheets.getItem(newQueryName);         console.log("Define table horizontal length");         let line = values[0];         let keys = Object.keys(line);         let address = "A1:" + ColumnToLetter(keys.length) + "1";         console.log("Computing header columns");         let headers = [];         for (let j = 0; j < keys.length; j++) {             let key = keys[j];             headers.push(key);         }         console.log("Adding table");         let table = sheet.tables.add(address, true);         table.name = tableName;         let temp = [];         temp.push(headers);         console.log("Putting header");         table.getHeaderRowRange().values = temp;         return context.sync().then(function () {             console.log("Header created")             CreateODataQuerySheetStep5_List1000(values, 0, tableName, headers);         }).catch(function (error) {             logging(sessionStorage.getItem("Token"), error);         });     }).catch(function (error) {         logging(sessionStorage.getItem("Token"), error);     }); } function CreateODataQuerySheetStep5_List1000(values, start, tableName, headers) {     console.log("Adding 1000 rows");     Excel.run(function (context) {         console.log("Get Sheet");         let sheet = context.workbook.worksheets.getItem(newQueryName);         console.log("Get Table");         let table = sheet.tables.getItem(tableName);         console.log("Computing max between 1000 and remaining lines");         let x = values.length - start;         let n = Math.min(1000, x);         console.log("Adding rows from " + start.toString() + " to " + (start + n).toString());         for (let i = start; i < n; i++) {             let line = values[i];             let keys = Object.keys(line);             let row = [];             for (let jj = 0; jj < headers.length; jj++) {                 let prop = headers[jj];                 let value = line[prop];                 if ($.type(value).toLowerCase() === 'string') {                     value = "'" + value;                 }                 row.push(value);             }             table.rows.add(null, [row]);         }         console.log("Rows added");              let y = start + 1000;         if (y < values.length)         {             console.log("Rows are remaining");             return context.sync().then(function () {                 console.log("Recursive Call");                 CreateODataQuerySheetStep5_List1000(values, y, tableName, headers);             }).catch(function (error) {                 logging(sessionStorage.getItem("Token"), error);             });         }         else         {             //if (Office.context.requirements.isSetSupported("ExcelApi", 1.2)) {             //    sheet.getUsedRange().format.autofitColumns();             //    sheet.getUsedRange().format.autofitRows();             //}             console.log("Sheet activation");             sheet.activate();             return context.sync().then(function () {                 console.log("return to home");                 window.location.href = "Home.html";             });         }              }).catch(function (error) {         logging(sessionStorage.getItem("Token"), error);     });      }
31-01 2019

Unprotect the excel sheet with password pro-grammatically using officejs. by Unknown User

await Excel.run(async function(context) {   const sheet = context.workbook.worksheets.getActiveWorksheet(); // const workBook = context.workbook. console.log(sheet.protection); sheet.protection.unprotect("abc") const range = sheet.getUsedRange(); range.load("values"); range.load("address"); return context.sync().then(function () { console.log(range.address); }) }).catch(function(error) { console.log("Error: " + error);   });   Giving Error: Uncaught (in promise): InvalidArgument: The argument is invalid or missing or has an incorrect format.