Item13719: EditRowPlugin and SSP can be misleading when editing single cells

I am raising this issue because I often hear that many of you love to have tables handled in the browser in JS instead of HTML level

And in general that is a great thing. But when it also has its problems

Note a test case like TestCases/TestCaseEditTableWithTable

This is a typical use case where a company uses a page to plan resources. In the cases where we use it changing a number the right place cost 50000 dollars.

In EditTablePlugin I changed the plugin to show the string CALC instead of a bogus number because the old number calculated results are not valid until you save and refresh the table.

And showing the formulas raw is horrible because a CALC is sometime a very long monster string.

When you use EditRowPlugin you can now edit single cells. And when you save the new value it is saved but the page is not updated.

The users now sees calculated values that do not match the values in the table until he refreshes the table.

It would be pretty hard to duplicate the all the possible math in JS so I do not expect the JS to handle this. And having an HTML refresh each time you save is also destroying some of the user experience.

I may be best not to know the cells with CALCs the minute you save a cell but have not yet refreshed the page.

Low priority bug. But important for you all to think about when you praise ERP for being much better than ETP. In this case the ETP behavior is my preferred. I have many tables without CALC where I will love the single cell edit feature

-- KennethLavrsen - 17 Sep 2015

Sorry, but this is not a bug report. It may be a request for an enhancement, but if so it is far beyond the scope of the ERP. A hybrid of the existing tools just isn't going to cut it; you probably need a fully-featured javascript spreadsheet (a la Google Docs) to do what you want. Some of MichaelDaum's plugins are heading this way.

I'm closing this "No action". If you want to pursue it, may I suggest you open a feature request?

-- Main.CrawfordCurrie - 28 Sep 2015 - 08:36

Commenting is disabled while not logged in