Hello Paul When you paste something coming from an excel, a new line is added When you paste something coming from something else, no new line is added I have teste with a text file, a word file and a javascript. One coming from notepad ++, one from word and one from netbeans it seems that only data coming from excel add a new line

Hello. Is there any way of hide a column? When I use $('column').hide(), I loose all my CSS configuration, so could be very nice to have an implementation of an event to hide a column by it's index.

I'm upgrading from v2 to v3 to test v3 and have run into an issue when attempting to set a cell value of type text. Am getting a JS error on the lines below, referencing cell[i] as undefined:

            if (keys.length > 0) {
                for (var i = 0; i < keys.length; i++) {
                    var x = cell[i].getAttribute('data-x');
                    var y = cell[i].getAttribute('data-y');

                    // Update cell
                    records.push(obj.updateCell(x, y, value));

I've debugged into the code and cell is an element already and, for example, NOT a jQuery object, so cell.getAttribute would work but cell[i] is undefined.

I would like to be able to capture formulas, and return the value without needing to set a constant JS function for each.

I am trying to figure out how to do the following:

• To use beforeChange to capture the Value & Formula of the cell.
• If the formula is present in my list of predefined formulas, do some actions (send the formula and the values referenced off with gRPC to another service)
• When my calculated value is returned, update the cell with value (but keep the formula there)

I have in particular been struggling on how to set a value & formula and bypass the current formula executor.

p.s. Thank you for this incredible library!

Hi Paul, Hope you are doing great !!1

Actually I have to show the columns A-G and 8 rows by default unless data is in 2 rows and 2 columns. If data is in 2 rows and two columns then I want to show the rest cells blank but look like an excel. Please provide the solution for that

Thanks

Hi,

Don't know if this was already reported here or not, I tried to search for similar problems but could not find it. When pasting a "large" volume of rows, it is not responsive. It seems that the copy paste gets stuck as if something which is iterative is running in the backend and it takes a lot of time.

Any way you could please look at this?

Thanks!

How to get data from remote database, once user start typing into cell? I saw dropdown with autocomplete but it is not what I need, because database have thousands of records. Additional, cell need to be edited once it receive value from database. How to do that, please?

Hello Paul,

The truth is that I am very interested in the functionality of multiple tabs in the same spreadsheet.

Is this functionality free ?? If not, how much does it cost? I have not found the prices for any site on the web.

Now I can insert a row in my 1-tab spreadsheet this way:

var mySpreadsheet = jexcel(document.getElementById('spreadsheet1'), {
			data: data1,
			csvFileName: 'filename',
		        csvHeaders:true,
			colHeaders: ['a', 'b'],
			columns: [{ type:'text', width:100 },
				  { type:'text', width:270 }],
			ondeleterow: functionOnDeleteRow
		});

mySpreadsheet.insertRow();

Even I can update some column value (for example, total money) if I delete/insert rows().

How would it be if I have two tabs?? How would be the way to add a row or update it for the current sheet? Could you give an example?

Thank you in advance!!

Thank you very much!

Hello! I am starting out with jexcel and I love it! I am wondering is there any support to load data into the table as json? If this is not the correct place for this please let me know!

I have tried the following code:

$('#my').jexcel({
    url:'http://localhost:8080/partners.json',
    colHeaders: ['a' ,'b', 'c', 'd', 'e']
  });

and it seems to only show the amount of json objects that are located at that url. I have dug into your example of programmatically-changes specifically this example:

setData: Update the table data
@Param json newData - New json data, null will reload what is in memory.
@Param boolean ignoreSpare - ignore configuration of minimal spareColumn/spareRows

In the console I dug down and see that button is tied to this:

$('#setDataButton').click(function () {
    data2 = [
        ['My car', 2001, 2000, '2006-01-01'],
        ['Test', 2010, 5000, '2005-01-01']
    ];
    $('#my').jexcel('setData', data2);
});

Which isn't json.

In the end I really like this plugin but curious as to if it is possible to load JSON data into the table?

If I paste a date into a cell of type "calendar", the fields (day,month,year) get mixed up. What should be DD-MM-YYYY (as defined in my options->format property), it shows as YYYY-MM-DD.

For example, if I paste the data "19-10-1998", it appears as "1998-10-19" in the cell. And when I bring up the calendar picker it shows the month of Oct and Year of 19.

It works correctly if I type a date in manually.

Here is my code

$('#my').jexcel({ minDimensions:[8,15], colHeaders: ['Last Name','First Name','Middle Name','Birth Date','Grade','Gender','SPED','ELL'], colWidths: [180,180,180,100,80,80,80,80], columns: [ { type: 'text'}, { type: 'text'}, { type: 'text'}, { type: 'calendar', options: { format:'DD-MM-YYYY' }}, { type: 'dropdown',source:['K',1,2,3,4,5,6]}, { type: 'dropdown',source:['m', 'f'] }, { type: 'dropdown',source:['y', 'n'] }, { type: 'dropdown',source:['y', 'n'] } ] });

Hi, I'm trying to follow Vue integration guide: https://bossanova.uk/jexcel/v3/examples/vue

I'm using webpack to bundle liblaries in .vue components instead of hardcoding .js/.css imports from cdn/bossanova.uk One problem I have is that japp.js is not included in your npm bundle and the link to https://bossanova.uk/jexcel/v3/japp.js does not work - file might not exist? Would be nice if japp.js was included in npm module for jexcel or at least had it's own npm. When used with Vue/React/Angular, libraries can be code spitted and imported only when needed in components/views rather than being declared for download upfront.

Thank you for taking time to make a version without jQuery! ^^

Hi, I want call an API immediately after dragging some cells. How do I get the information about the cells I dragged ? I couldn't find any ondragAfter or ondragCompleted events for this.

The problem is that

document.addEventListener("keydown", jexcel.keyDownControls);

Remains active even when jspreadsheet object no longer exists.

And if you initialize jspreadsheet again on the same page, this keyDownControls event will fire twice, thrice, ... (depends on how many times you have initialized jspreadsheet).

This isn't good.

I think there should be added some instance ID to jspreadsheet html element, and if there is no html element on page, event must be unregistered.

And imagine you have 2 jspreadsheet objects. You press Del, and it fires on both jspreadsheet objects, as keyDownControls doesn't know on which jspreadsheet object it was triggered...

Is there a rationale for setting innerText rather than textContent in the setData function?

They do behave a bit differently -- I think textContent allows for more whitespace in some scenarios. However, it also appears to be faster than innerText which may be a nice added bonus to an already fast spreadsheet library.

Context: I had to dig pretty deep to understand why my tests were failing -- they rely on jsdom which is the go-to headless engine for jest. Turns out that jsdom doesn't support innerText due to its reliance on a layout engine. So for me, mocking innerText's setter and getter to be textContent helped make my tests pass. The workaround mentioned in the jsdom issue solved my problems, so I'd call this a suggestion rather than a request. But it could help users who write react applications and end up using a testing suite such as Jest that relies on jsdom.

If a cell is set as readonly, it can be changed if the column type is 'checkbox' by clicking with the mouse on the checkbox. By keyboard the checkbox state can not be changed. In such a case the events "onbeforechange", "onchange" are not fired.

I've noticed that masks on footer columns seems to be broken due to an issue with this line:

https://github.com/jspreadsheet/ce/blob/fbcc95aaf18e96b831e0770717b05210be4a297c/dist/index.js#L9366

I'm not sure what the reason for this might be +obj.records.length in +obj.records.length + i but it will cause an issue further down when gettings the options for that column here:

https://github.com/jspreadsheet/ce/blob/fbcc95aaf18e96b831e0770717b05210be4a297c/dist/index.js#L7109

And will only get the right column when obj.records.length is 0.