SpreadJS will enable precision scrolling by pixel when scrollByPixel is true.
In addition, you can also define the number of pixels that are scrolled at a time when scrollByPixel is true.
The final scrolling pixels are the result of scrolling delta multiplied by scrollPixel.
For example, the scrolling delta is 3, and the scrollPixel is 5, the final scrolling pixels are 15.
The Worksheet class provides a scroll method to scroll the sheet by specified pixels.
The scroll method has 2 number parameters, vPixels and hPixels.
The vPixels represents the pixels to scroll in vertical direction.
The hPixels represents the pixels to scroll in horizontal direction.
When vPixels is positive, worksheet will scroll down; when vPixels is negative, worksheet will scroll up; when vPixels is 0, worksheet won't scroll in vertical direction.
When hPixels is positive, worksheet will scroll right; when hPixels is negative, worksheet will scroll left; when hPixels is 0, worksheet won't scroll in horizontal direction.
When the Workbook’s scrollByPixel option is set to true, the worksheet will scroll to the new top row/left column index and the new top row/left column offset.
When Workbook's option scrollByPixel is false, worksheet will scroll to new top row/left column index, and new top row/left column offset will be always 0.
in TopRowChanged / LeftColumnChanged event, you can use offset attributes to get info of current position in cell.
if you want to use the oldOffset/newOffset attributes, you can do like this:
import { Component, NgModule, enableProdMode } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { SpreadSheetsModule } from '@mescius/spread-sheets-angular';
import GC from '@mescius/spread-sheets';
import { getData } from './app.data';
import './styles.css';
@Component({
selector: 'app-component',
templateUrl: 'src/app.component.html'
})
export class AppComponent {
autoGenerateColumns = false;
scrollPixel = 5;
vPixels = 1;
hPixels = 0;
interval = 20;
intervalID = 0;
dataSource: any[];
spread: GC.Spread.Sheets.Workbook;
hostStyle = {
width: 'calc(100% - 280px)',
height: '100%',
overflow: 'hidden',
float: 'left'
};
constructor() {
}
initSpread($event: any) {
this.spread = $event.spread;
let spread = this.spread;
spread.suspendPaint();
spread.options.scrollByPixel = true;
var sheet = spread.getActiveSheet();
//change cells dimensions
sheet.setColumnWidth(0, 150);
sheet.setColumnWidth(4, 100);
sheet.setColumnWidth(5, 430);
sheet.setRowHeight(0, 50);
sheet.setRowHeight(3, 10);
sheet.setRowHeight(10, 100);
sheet.setRowHeight(12, 475);
spread.resumePaint();
}
setScrollByPixel(e: any) {
let spread = this.spread;
spread.options.scrollByPixel = e.target.checked;
}
changeScrollPixel(e: any) {
this.scrollPixel = parseInt(e.target.value);
}
setScrollPixel(e: any) {
let spread = this.spread;
spread.options.scrollPixel = this.scrollPixel;
}
changeVPixels(e: any) {
this.vPixels = parseFloat(e.target.value);
}
changeHPixels(e: any) {
this.hPixels = parseFloat(e.target.value);
}
scroll(e: any) {
let spread = this.spread;
let vPixels = this.vPixels;
let hPixels = this.hPixels;
let sheet = spread.getActiveSheet();
sheet.scroll(vPixels, hPixels);
}
changeInterval(e: any) {
this.interval = parseInt(e.target.value);
}
autoScroll(e: any) {
if (this.intervalID) {
window.clearInterval(this.intervalID);
this.intervalID = null;
}
let spread = this.spread;
let vPixels = this.vPixels;
let hPixels = this.hPixels;
let interval = this.interval;
this.intervalID = setInterval(function () {
let sheet = spread.getActiveSheet();
sheet.scroll(vPixels, hPixels);
}, interval);
}
stopScroll(e: any) {
if (this.intervalID) {
window.clearInterval(this.intervalID);
this.intervalID = null;
}
}
}
@NgModule({
imports: [BrowserModule, SpreadSheetsModule],
declarations: [AppComponent],
exports: [AppComponent],
bootstrap: [AppComponent]
})
export class AppModule {}
enableProdMode();
// Bootstrap application with hash style navigation and global services.
platformBrowserDynamic().bootstrapModule(AppModule);
<!doctype html>
<html style="height:100%;font-size:14px;">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="stylesheet" type="text/css" href="$DEMOROOT$/en/angular/node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2013white.css">
<!-- Polyfills -->
<script src="$DEMOROOT$/en/angular/node_modules/core-js/client/shim.min.js"></script>
<script src="$DEMOROOT$/en/angular/node_modules/zone.js/fesm2015/zone.min.js"></script>
<!-- SystemJS -->
<script src="$DEMOROOT$/en/angular/node_modules/systemjs/dist/system.js"></script>
<script src="systemjs.config.js"></script>
<script>
// workaround to load 'rxjs/operators' from the rxjs bundle
System.import('rxjs').then(function (m) {
System.import('@angular/compiler');
System.set(SystemJS.resolveSync('rxjs/operators'), System.newModule(m.operators));
System.import('$DEMOROOT$/en/lib/angular/license.ts');
System.import('./src/app.component');
});
</script>
</head>
<body>
<app-component></app-component>
</body>
</html>
<div class="sample-tutorial">
<gc-spread-sheets [hostStyle]="hostStyle" (workbookInitialized)="initSpread($event)">
<gc-worksheet></gc-worksheet>
</gc-spread-sheets>
<div class="options-container">
<div class="option-row">
<p>Scroll the spreadsheet to view the pixel scrolling feature. </p>
<p>You can also change the number of pixels scrolled below by entering the number and press Set Scroll Pixel.</p>
<p>To disable this feature, uncheck the option.</p>
<input type="checkbox" id="scrollByPixel" checked="checked" (change)="setScrollByPixel($event)"/>
<label for="scrollByPixel">Scroll By Pixel</label>
</div>
<div class="option-row">
<input type="number" id="scrollPixel" value="5" (change)="changeScrollPixel($event)"/>
<input type="button" id="setScrollPixel" value="Set Scroll Pixel" (click)="setScrollPixel($event)"/>
</div>
<div class="option-row">
<p>You can also scroll the sheet by specified pixels.</p>
<label>
<input type="number" id="vPixels" value="1" (change)="changeVPixels($event)">
vPixels
</label>
<label>
<input type="number" id="hPixels" value="0" (change)="changeHPixels($event)">
hPixels
</label>
<input type="button" id="scroll" value="Scroll" (click)="scroll($event)">
</div>
<div class="option-row">
<p>If you invoke the scroll method in a timer, the sheet can be scrolled automatically.</p>
<label>
<input type="number" id="interval" value="20" (change)="changeInterval($event)">
interval(ms)
</label>
<input type="button" id="autoScroll" value="Automatically Scroll" (click)="autoScroll($event)">
<input type="button" id="stopScroll" value="Stop Scroll" (click)="stopScroll($event)">
</div>
</div>
</div>
export function getData() {
return [{
"Country": "United Kingdom",
"State": "England",
"City": "Basildon",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "London",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "Manchester",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "London",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "Newbury",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "Kemble",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "Headley",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "Southampton",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "Cheltenham",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United Kingdom",
"State": "England",
"City": "Bournemouth",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United Kingdom",
"State": "Northern Ireland",
"City": "Helens Bay",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United States",
"State": "MO",
"City": "Parkville",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "United States",
"State": "OR",
"City": "Astoria",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "AL",
"City": "Cahaba Heights",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "NJ",
"City": "Mickleton",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "NJ",
"City": "Riverside",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United States",
"State": "NJ",
"City": "Clinton",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "United States",
"State": "IL",
"City": "Peoria",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United States",
"State": "IL",
"City": "Morton",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "United States",
"State": "IL",
"City": "Flossmoor",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "United States",
"State": "IL",
"City": "Genoa",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "TN",
"City": "Martin",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United States",
"State": "TN",
"City": "Memphis",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "United States",
"State": "NY",
"City": "New York",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "United States",
"State": "NY",
"City": "New York",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "NY",
"City": "New York",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "United States",
"State": "NY",
"City": "Brooklyn",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "United States",
"State": "NY",
"City": "New Rochelle",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United States",
"State": "NY",
"City": "Staten Island",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United States",
"State": "TX",
"City": "Shavano Park",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "TX",
"City": "Sugar Land",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "TX",
"City": "Houston",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United States",
"State": "TX",
"City": "Houston",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United States",
"State": "TX",
"City": "Lakewood Village",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United States",
"State": "ID",
"City": "Eagle",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United States",
"State": "UT",
"City": "Salt Lake City",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "CA",
"City": "Chula Vista",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "United States",
"State": "CA",
"City": "Los Gatos",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United States",
"State": "CA",
"City": "Santa Monica",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United States",
"State": "CA",
"City": "Irvine",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "CA",
"City": "San Francisco",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "United States",
"State": "FL",
"City": "Miami",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "United States",
"State": "FL",
"City": "Delray Beach",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United States",
"State": "FL",
"City": "Fort Lauderdale",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "United States",
"State": "FL",
"City": "Amelia Island",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "FL",
"City": "Coral Gables",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "United States",
"State": "FL",
"City": "Miami",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United States",
"State": "FL",
"City": "Parkland",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United States",
"State": "VA",
"City": "Reston",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "VA",
"City": "Keller",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United States",
"State": "VA",
"City": "Keller",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "AZ",
"City": "Phoenix",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United States",
"State": "VT",
"City": "Pittsfield",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United States",
"State": "VT",
"City": "Pittsfield",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "United States",
"State": "GA",
"City": "Ball Ground",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "United States",
"State": "GA",
"City": "Sandy Springs",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United States",
"State": "IA",
"City": "Ankeny",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "NC",
"City": "Pittsboro",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "OH",
"City": "Beachwood",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "OH",
"City": "Cincinnati",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "NH",
"City": "W Lebanon",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "United States",
"State": "MD",
"City": "Woodsboro",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United States",
"State": "Michigan",
"City": "Farmington",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "United States",
"State": "HI",
"City": "Honolulu",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "United States",
"State": "CO",
"City": "Englewood",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "United States",
"State": "KY",
"City": "Owensboro",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "Australia",
"State": "Victoria",
"City": "Echuca",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "Australia",
"State": "Victoria",
"City": "Melbourne",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "Australia",
"State": "Queensland",
"City": "Burpengary",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Australia",
"State": "Queensland",
"City": "Gold Coast",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "Israel",
"State": "Tel Aviv",
"City": "Tel Aviv",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "France",
"State": "Ile-de-France",
"City": "Chatou",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "France",
"State": "Upper Normandy",
"City": "Rouen",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "Netherlands",
"State": "Noord-Brabant",
"City": "Eindhoven",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "Netherlands",
"State": "Noord-Holland",
"City": "Badhoevedorp",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "Ireland",
"State": "Meath",
"City": "Julianstown",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "Ireland",
"State": "Cork",
"City": "Ballynora",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Ireland",
"State": "Dublin",
"City": "Kinsaley",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "Ireland",
"State": "Dublin",
"City": "Rathgar",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "Canada",
"State": "Ontario",
"City": "Ottawa",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "Canada",
"State": "Ontario",
"City": "Belleville",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "Canada",
"State": "Ontario",
"City": "Alliston",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "Canada",
"State": "British Columbia",
"City": "Maple Ridge District Municipality",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Canada",
"State": "British Columbia",
"City": "Comox",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "Canada",
"State": "British Columbia",
"City": "Vancouver",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "Canada",
"State": "British Columbia",
"City": "Vancouver",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "Canada",
"State": "British Columbia",
"City": "Tsawwassen",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "Canada",
"State": "Saskatchewan",
"City": "Prince Albert",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Canada",
"State": "Alberta",
"City": "Red Deer",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Canada",
"State": "Alberta",
"City": "Calgary",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "Canada",
"State": "Alberta",
"City": "Calgary",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "Canada",
"State": "Alberta",
"City": "Okotoks",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "India",
"State": "Andhra Pradesh",
"City": "Hyderabad",
"Product": "Teddy Grahams Crackers",
"Detail": "Honey 10-Ounce Boxes 6-Pack"
}, {
"Country": "South Africa",
"State": "Gauteng",
"City": "Roodepoort",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "Finland",
"State": "Ita-Suomen Laani",
"City": "Kuopio",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "Switzerland",
"State": "Geneve",
"City": "Vesenaz",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "Switzerland",
"State": "Vaud",
"City": "Lausanne",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Switzerland",
"State": "Vaud",
"City": "Morges",
"Product": "Kraft Real Mayo",
"Detail": "30 Ounces"
}, {
"Country": "Denmark",
"State": "Frederiksborg",
"City": "Helsingor",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "Denmark",
"State": "Kobenhavn",
"City": "Kobenhavn",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "Denmark",
"State": "Storstrom",
"City": "Nakskov",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "Belgium",
"State": "Brussels (Bruxelles)",
"City": "Brussels",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "Sweden",
"State": "Stockholm",
"City": "Saltsjobaden",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "Norway",
"State": "Rogaland",
"City": "Stavanger",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Norway",
"State": "Oslo",
"City": "Oslo",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "Luxembourg",
"State": "Luxembourg",
"City": "Gasperich",
"Product": "Planters Deluxe Whole Cashew",
"Detail": "18.25 Ounce"
}, {
"Country": "Italy",
"State": "Lombardy",
"City": "Milan",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Germany",
"State": "Nordrhein-Westfalen",
"City": "Telgte",
"Product": "Jaybee's Gourmet Nuts Gift Pack (3 Lb)",
"Detail": "Premium Quality Nuts Elegant Design Vegetarian Friendly & Kosher"
}, {
"Country": "Moldova",
"State": "Chisinau",
"City": "Bubuieci",
"Product": "Smartfood Popcorn",
"Detail": "White Cheddar 9 Ounce"
}, {
"Country": "Spain",
"State": "Murcia",
"City": "La Alberca",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}, {
"Country": "United Arab Emirates",
"State": "Dubayy",
"City": "Jumeira",
"Product": "KIND Bars Almond & Coconut Gluten Free",
"Detail": "1.4 Ounce Bars 12 Count"
}, {
"Country": "Bahrain",
"State": "Al Manamah",
"City": "Al 'Adliyah",
"Product": "Kraft Grated Parmesan Cheese",
"Detail": "24 oz"
}];
}
.sample-tutorial {
position: relative;
height: 100%;
overflow: hidden;
}
.sample-spreadsheets {
width: calc(100% - 280px);
height: 100%;
overflow: hidden;
float: left;
}
.options-container {
float: right;
width: 280px;
padding: 12px;
height: 100%;
box-sizing: border-box;
background: #fbfbfb;
overflow: auto;
}
.option-row {
font-size: 14px;
padding: 5px;
margin-top: 10px;
}
label {
margin-bottom: 6px;
}
input {
padding: 3px;
margin: 3px;
}
input[type=number] {
width: 40px;
}
hr {
border-color: #fff;
opacity: .2;
margin-top: 20px;
}
body {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
}
(function (global) {
System.config({
transpiler: 'ts',
typescriptOptions: {
tsconfig: true
},
meta: {
'typescript': {
"exports": "ts"
},
'*.css': { loader: 'css' }
},
paths: {
// paths serve as alias
'npm:': 'node_modules/'
},
// map tells the System loader where to look for things
map: {
'core-js': 'npm:core-js/client/shim.min.js',
'zone': 'npm:zone.js/fesm2015/zone.min.js',
'rxjs': 'npm:rxjs/dist/bundles/rxjs.umd.min.js',
'@angular/core': 'npm:@angular/core/fesm2022',
'@angular/common': 'npm:@angular/common/fesm2022/common.mjs',
'@angular/compiler': 'npm:@angular/compiler/fesm2022/compiler.mjs',
'@angular/platform-browser': 'npm:@angular/platform-browser/fesm2022/platform-browser.mjs',
'@angular/platform-browser-dynamic': 'npm:@angular/platform-browser-dynamic/fesm2022/platform-browser-dynamic.mjs',
'@angular/common/http': 'npm:@angular/common/fesm2022/http.mjs',
'@angular/router': 'npm:@angular/router/fesm2022/router.mjs',
'@angular/forms': 'npm:@angular/forms/fesm2022/forms.mjs',
'jszip': 'npm:jszip/dist/jszip.min.js',
'typescript': 'npm:typescript/lib/typescript.js',
'ts': './plugin.js',
'tslib':'npm:tslib/tslib.js',
'css': 'npm:systemjs-plugin-css/css.js',
'plugin-babel': 'npm:systemjs-plugin-babel/plugin-babel.js',
'systemjs-babel-build':'npm:systemjs-plugin-babel/systemjs-babel-browser.js',
'@mescius/spread-sheets': 'npm:@mescius/spread-sheets/index.js',
'@mescius/spread-sheets-angular': 'npm:@mescius/spread-sheets-angular/fesm2020/mescius-spread-sheets-angular.mjs',
'@grapecity/jsob-test-dependency-package/react-components': 'npm:@grapecity/jsob-test-dependency-package/react-components/index.js'
},
// packages tells the System loader how to load when no filename and/or no extension
packages: {
src: {
defaultExtension: 'ts'
},
rxjs: {
defaultExtension: 'js'
},
"node_modules": {
defaultExtension: 'js'
},
"node_modules/@angular": {
defaultExtension: 'mjs'
},
"@mescius/spread-sheets-angular": {
defaultExtension: 'mjs'
},
'@angular/core': {
defaultExtension: 'mjs',
main: 'core.mjs'
}
}
});
})(this);
