example-with-angular's People
example-with-angular's Issues
how use custom formula in angular
example:
`var COLORIZE = function(v) {
v = '' + v.toUpperCase() + '';
return v;
}
var data1 = [
[ 'red', '=COLORIZE(A1)' ],
[ 'green', '=COLORIZE(A2)' ],
[ 'blue', '=COLORIZE(A3)' ],
];
jexcel(document.getElementById('spreadsheet1'), {
data:data1,
columns: [
{ type: 'text', width:'300' },
{ type: 'text', width:'200' },
]
});`
Calendar keyboard input broken
https://codesandbox.io/s/jexcel-and-angular-powh0?file=/src/app/app.component.ts
When a calendar type is set with readonly:0
, pressing any key will double the keystrokes in the input field. 2
becomes 22
. Maybe two functions binding to the same keypress events?
Another thing I noticed is when editing a calendar field in this way, paste cannot be used.
Using the picker works and pasting over a date when the field is not being edited does work okay.
Validator extension with Angular not working
I'm trying to use the validation extension with an angular project. I've updated my license key to include Validations. I include the validation npm package and set the extension but when I go to execute the code, it says the worksheet object is valid but setValidations is undefined.
The runtime error is: ERROR TypeError: worksheet.setValidations is not a function.
I see in the index.d.ts file, setValidations should be on the worksheetInstance object.
How do I get Validations to work with jSpreadsheet in Angular?
Thanks, Greg
Sample code below
import { validations } from '@jspreadsheet/validations';
import * as jspreadsheet from 'jspreadsheet';
jspreadsheet.setLicense('xxxxxx');
// Set the extensions
jspreadsheet.setExtensions({ validations });
this.jss= jspreadsheet(nativeElement, { ... });
function onBeforePaste(worksheet, data, x, y, style, processedData) {
// if some condition - call setValidators(worksheet);
function setValidators(worksheet: jspreadsheet.worksheetInstance) {
// if some condition is met
worksheet.setValidations([{
index: 0,
value: {
range: 'A3',
action: 'warning',
criteria: '!=',
type: 'text',
allowBlank: false,
value: ['xxxxRandomStringyyyy'],
text: 'You have an error!'
}
}]);
}
}
Limit number of columns to display
Hello
I was trying to load Jexcel sheet with a url which provides array of objects. I do not want to display all the available keys on the object as columns, just one or two columns enough. Currently all the keys available in the object are displayed as columns
Regards,
Jithin
Few common functions like setValue() does not work in Angular.
Thanks to JExcelTeam for great tool.
I am unable to use setValue() function in Angular. It would be great if you could provide an example(preferably in online editor) to that.
Note : Please not that getData(), getColumnNameFromId() etc. works perfectly fine in Angular.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.