Adjusted header height for medium font size

-The size pushed the lower end of the row-wrapper
 outside of the parent container, which was caused
 by the heights not adding up.

Issue: DEB-163

.circleci/config.yml

@@ -20,7 +20,7 @@ jobs:
           command: npm install
       - run:
           name: BlackDuck scan
-          command: curl -s https://detect.synopsys.com/detect.sh | bash -s -- \
+          command: curl -s https://blackducksoftware.github.io/hub-detect/hub-detect.sh | bash -s -- \
             --blackduck.url="https://qliktech.blackducksoftware.com" \
             --blackduck.trust.cert=true \
             --blackduck.username="svc-blackduck" \

.eslintrc.js

@@ -3,15 +3,15 @@ module.exports = {
     ecmaVersion: 6,
     ecmaFeatures: {
       jsx: true,
-      modules: true,
+      modules: true
     },
-    sourceType: "module",
+    sourceType: "module"
   },
   parser: "babel-eslint",
   env: {
     browser: true,
     es6: true,
-    node: true,
+    node: true
   },
   globals: {
     angular: false,
@@ -21,63 +21,49 @@ module.exports = {
     document: false,
     expect: false,
     it: false,
-    require: false,
+    require: false
   },
   rules: {
-    indent: ["warn", 2, { SwitchCase: 1 }],
+    "indent": ["error", 2, { "SwitchCase": 1 }],
     "linebreak-style": ["error", "unix"],
     "object-curly-spacing": ["error", "always"],
     "max-lines": ["warn", 300],
-    "max-len": [
-      "warn",
-      { code: 120, ignoreComments: true, ignoreTrailingComments: false },
-    ],
+    "max-len": ["warn", { "code": 120, "ignoreComments": true, "ignoreTrailingComments": false }],
     "no-console": ["warn"],
-    "no-mixed-operators": [
-      "warn",
-      {
-        groups: [
-          ["==", "!=", "===", "!==", ">", ">=", "<", "<="],
-          ["&&", "||"],
-          ["in", "instanceof"],
-        ],
-        allowSamePrecedence: true,
-      },
-    ],
-    "comma-dangle": ["off"],
-    "space-before-function-paren": ["off"],
+    "no-mixed-operators": ["warn", {
+      "groups": [
+        ["==", "!=", "===", "!==", ">", ">=", "<", "<="],
+        ["&&", "||"],
+        ["in", "instanceof"]
+      ],
+      "allowSamePrecedence": true
+    }],
     "no-multi-spaces": ["error"],
     "no-cond-assign": ["warn"],
     "no-fallthrough": ["warn"],
     "no-undef": ["error"],
     "no-unused-vars": ["error"],
-    "no-use-before-define": [
-      "error",
-      { functions: false, classes: false, variables: false },
-    ],
+    "no-use-before-define": ["error", { "functions": false, "classes": false, "variables": false }],
     "no-useless-escape": ["warn"],
     "no-useless-return": ["warn"],
-    "no-underscore-dangle": ["warn", { allow: ["_id"] }],
+    "no-underscore-dangle": ["warn", { "allow": ["_id"] }],
     "no-redeclare": ["error"],
     "no-restricted-syntax": ["warn"],
     "operator-linebreak": ["warn", "before"],
     "prefer-promise-reject-errors": ["warn"],
-    "padded-blocks": [
-      "warn",
-      { blocks: "never", switches: "never", classes: "never" },
-    ],
-    semi: ["error", "always"],
+    "padded-blocks": ["warn", { "blocks": "never", "switches": "never", "classes": "never" }],
+    "semi": ["error", "always"],
     "valid-typeof": ["warn"],
     "no-eval": ["error"],
     "no-implied-eval": ["error"],
     "no-debugger": ["warn"],
     "no-unreachable": ["warn"],
-    quotes: ["warn", "single", { avoidEscape: true }],
+    "quotes": ["warn", "single", { "avoidEscape": true }],
     "sort-imports": ["off"],
     "max-lines-per-function": ["off"], // marks the entire functions, a bit too noisy
-    complexity: ["warn"],
-    camelcase: ["warn"],
-    "max-statements": ["off"], // marks the entire functions, a bit too noisy
+    "complexity": ["warn"],
+    "camelcase": ["warn"],
+    "max-statements": ["off"],  // marks the entire functions, a bit too noisy
     "sort-vars": ["off"], // not much value for the work
     "init-declarations": ["off"],
     "capitalized-comments": ["off"],
@@ -113,13 +99,13 @@ module.exports = {
     "array-bracket-newline": ["warn"],
     "array-element-newline": ["warn"],
     "object-shorthand": ["warn"],
-    eqeqeq: ["warn"],
+    "eqeqeq": ["warn"],
     "no-empty-function": ["off"],
     "function-paren-newline": ["warn"],
     "no-invalid-this": ["warn"],
     "newline-per-chained-call": ["warn"],
     "no-unused-expressions": ["warn"],
-    strict: ["warn"],
+    "strict": ["warn"],
     "no-ternary": ["off"],
     "multiline-ternary": ["off"],
     "no-param-reassign": ["error"],
@@ -129,9 +115,9 @@ module.exports = {
     "default-case": ["warn"],
     "no-alert": ["warn"],
     "max-params": ["warn"],
-    "brace-style": ["warn", "1tbs", { allowSingleLine: true }],
+    "brace-style": ["warn", "1tbs", { "allowSingleLine": true }],
     "prefer-const": ["warn"],
-    "class-methods-use-this": ["warn"],
+    "class-methods-use-this":["warn"],
     // plugin:react
     "react/jsx-indent": ["warn", 2],
     "react/jsx-indent-props": ["warn", 2],
@@ -145,7 +131,10 @@ module.exports = {
     "react/jsx-max-depth": ["off"], // rule throws exception in single-dimension-measure
     "react/jsx-filename-extension": ["warn"],
     "react/prefer-stateless-function": ["warn"],
-    "react/no-set-state": ["warn"],
+    "react/no-set-state": ["warn"]
   },
-  extends: ["eslint:all", "plugin:react/all"],
-};
+  extends: [
+    "eslint:all",
+    "plugin:react/all"
+  ]
+}

.vscode/settings.json

@@ -1,3 +0,0 @@
-{
-    "json.format.enable": false
-}

README.md

@@ -1,22 +1,52 @@
 # P&L Smart Pivot, a Qlik Sense Extension for Financial reporting
-This extension is part of the extension bundles for Qlik Sense. The repository is maintained and moderated by Qlik RD.
+[![CircleCI](https://circleci.com/gh/qlik-oss/PLSmartPivot.svg?style=svg)](https://circleci.com/gh/qlik-oss/PLSmartPivot)
 
-Feel free to fork and suggest pull requests for improvements and bug fixes. Changes will be moderated and reviewed before inclusion in future bundle versions. Please note that emphasis is on backward compatibility, i.e. breaking changes will most likely not be approved.
+This extension is useful to create reports where the look&feel is rellevantand and pivot a second dimension is needed. Based on P&L Smart.
+
+It's specifically focused on financial reports, trying to solve some common needs of this area:
+- smart export to excel
+- easy creation of reports
+- custom corporate reporting (bold, italic, background color, letter size, headers,...)
+- selections inside the reports
+- custom external templates
+- analytical reports
+
+
+# Manual
+You'll find a manual [Qlik Sense P&LSmart Pivot Extension Manual.pdf](resources/Qlik Sense P&LSmart Pivot Extension Manual.pdf) and one app example [P&LSmartPivot_demo.qvf](resources/P&LSmartPivot_demo.qvf).
+
+
+# Installation
+
+1. Download the extension zip, `qlik-smart-pivot_<version>.zip`, from the latest release(https://github.com/qlik-oss/PLSmartPivot/releases/latest)
+2. Install the extension:
+
+   a. **Qlik Sense Desktop**: unzip to a directory under [My Documents]/Qlik/Sense/Extensions.
+
+   b. **Qlik Sense Server**: import the zip file in the QMC.
 
-Usage documentation for the extension is available at https://help.qlik.com.
 
 # Developing the extension
+
 If you want to do code changes to the extension follow these simple steps to get going.
 
 1. Get Qlik Sense Desktop
-1. Create a new app and add P&L pivot to a sheet.
+1. Create a new app and add the extension to a sheet.
 2. Clone the repository
 3. Run `npm install`
-4. Run `npm run build` - to build a dev-version to the /dist folder.
-5. Move the content of the /dist folder to the extension directory. Usually in `C:/Users/<user>/Documents/Qlik/Sense/Extensions/qlik-smart-pivot`.
+4. Set the environment variable `BUILD_PATH` to your extensions directory. It will be something like `C:/Users/<user>/Documents/Qlik/Sense/Extensions/<extension_name>`.
+5. You now have two options. Either run the watch task or the build task. They are explained below. Both of them default to development mode but can be run in production by setting `NODE_ENV=production` before running the npm task.
+
+   a. **Watch**: `npm run watch`. This will start a watcher which will rebuild the extension and output all needed files to the `buildFolder` for each code change you make. See your changes directly in your Qlik Sense app.
+
+   b. **Build**: `npm run build`. If you want to build the extension package. The output zip-file can be found in the `buildFolder`.
+
 
 # Original authors
+
 [github.com/iviasensio](https://github.com/iviasensio)
 
+
 # License
-Released under the [MIT License](LICENSE).
+
+Released under the [MIT License](LICENSE).

gulpfile.js

@@ -15,7 +15,7 @@ gulp.task('qext', function () {
 		type: 'visualization',
 		description: pkg.description + '\nVersion: ' + VERSION,
 		version: VERSION,
-		icon: 'pivot-table',
+		icon: 'table',
 		preview: 'qlik-smart-pivot.png',
 		keywords: 'qlik-sense, visualization',
 		author: pkg.author,

src/data-table/data-cell.jsx

@@ -1,92 +1,90 @@
-/* eslint-disable react/sort-prop-types */
-/* eslint-disable space-before-function-paren */
 import React from 'react';
 import PropTypes from 'prop-types';
+import { ApplyPreMask } from '../masking';
+import { addSeparators } from '../utilities';
 import Tooltip from '../tooltip/index.jsx';
 
 class DataCell extends React.PureComponent {
-  constructor(props) {
+  constructor (props) {
     super(props);
     this.handleSelect = this.handleSelect.bind(this);
   }
 
-  handleSelect() {
-    const {
-      data: {
-        meta: {
-          dimensionCount
-        }
-      },
-      general: {
-        allowFilteringByClick
-      },
-      measurement,
-      component
-    } = this.props;
-
+  handleSelect () {
+    const { data: { meta: { dimensionCount } }, general: { allowFilteringByClick }, measurement, qlik } = this.props;
     const hasSecondDimension = dimensionCount > 1;
     if (!allowFilteringByClick) {
       return;
     }
-    // fixes the console error on selection made from data cells
-    component.selectValues(0, [measurement.parents.dimension1.elementNumber], false);
+
+    qlik.backendApi.selectValues(0, [measurement.parents.dimension1.elementNumber], true);
+
     if (hasSecondDimension) {
-      component.selectValues(1, [measurement.parents.dimension2.elementNumber], false);
+      qlik.backendApi.selectValues(1, [measurement.parents.dimension2.elementNumber], true);
     }
   }
 
-  render() {
+  render () {
     const {
-      cellWidth,
+      data,
+      general,
       measurement,
       styleBuilder,
       styling
     } = this.props;
 
-    const textAlignment = styling.options.textAlignment || 'Right';
+    let textAlignment = styling.options.textAlignment || 'Right';
 
-    const cellStyle = {
+    let cellStyle = {
       fontFamily: styling.options.fontFamily,
       ...styleBuilder.getStyle(),
       paddingLeft: '5px',
-      textAlign: textAlignment,
-      minWidth: cellWidth,
-      maxWidth: cellWidth
+      textAlign: textAlignment
     };
 
     const isEmptyCell = measurement.displayValue === '';
+    const isColumnPercentageBased = (/%/).test(measurement.format);
     let formattedMeasurementValue;
-    if (isEmptyCell || styleBuilder.hasComments()) {
+    if (isEmptyCell) {
       formattedMeasurementValue = '';
       cellStyle.cursor = 'default';
+    } else if (styleBuilder.hasComments()) {
+      formattedMeasurementValue = '.';
     } else {
       formattedMeasurementValue = formatMeasurementValue(measurement, styling);
     }
 
-    const { conditionalColoring } = styling;
-    if (conditionalColoring.enabled) {
-      const isValidConditionalColoringValue = !styleBuilder.hasComments() && !isNaN(measurement.value);
-      const isSpecifiedRow
-        = conditionalColoring.rows.indexOf(measurement.parents.dimension1.header) !== -1;
-      const isSpecifiedMeasure
-        = conditionalColoring.measures.indexOf(measurement.parents.measurement.index) !== -1;
-      const shouldHaveConditionalColoring = (conditionalColoring.colorAllRows || isSpecifiedRow)
-        && (conditionalColoring.colorAllMeasures || isSpecifiedMeasure);
-      if (isValidConditionalColoringValue && shouldHaveConditionalColoring) {
-        const { color, textColor } = getConditionalColor(measurement, conditionalColoring);
-        cellStyle.backgroundColor = color.color;
-        cellStyle.color = textColor.color;
-      }
+    const { semaphoreColors, semaphoreColors: { fieldsToApplyTo } } = styling;
+    const isValidSemaphoreValue = !styleBuilder.hasComments() && !isNaN(measurement.value);
+    const dimension1Row = measurement.parents.dimension1.elementNumber;
+    const isSpecifiedMetricField = fieldsToApplyTo.metricsSpecificFields.indexOf(dimension1Row) !== -1;
+    const shouldHaveSemaphoreColors = (fieldsToApplyTo.applyToMetric || isSpecifiedMetricField);
+    if (isValidSemaphoreValue && shouldHaveSemaphoreColors) {
+      const { backgroundColor, color } = getSemaphoreColors(measurement, semaphoreColors);
+      cellStyle = {
+        ...styleBuilder.getStyle(),
+        backgroundColor,
+        color,
+        fontFamily: styling.options.fontFamily,
+        paddingLeft: '5px',
+        textAlign: textAlignment
+      };
+    }
+
+    let cellClass = 'grid-cells';
+    const hasTwoDimensions = data.headers.dimension2 && data.headers.dimension2.length > 0;
+    const shouldUseSmallCells = isColumnPercentageBased && data.headers.measurements.length > 1 && hasTwoDimensions;
+    if (shouldUseSmallCells) {
+      cellClass = 'grid-cells-small';
     }
 
     return (
       <td
-        className="grid-cells"
+        className={`${cellClass}${general.cellSuffix}`}
         onClick={isEmptyCell ? null : this.handleSelect}
         style={cellStyle}
       >
         <Tooltip
-          styling={styling}
           tooltipText={formattedMeasurementValue}
         >
           {formattedMeasurementValue}
@@ -97,24 +95,22 @@ class DataCell extends React.PureComponent {
 }
 
 DataCell.propTypes = {
-  cellWidth: PropTypes.string.isRequired,
   data: PropTypes.shape({
     headers: PropTypes.shape({
       measurements: PropTypes.array.isRequired
-    }).isRequired,
-    meta: PropTypes.shape({
-      dimensionCount: PropTypes.number.isRequired
     }).isRequired
   }).isRequired,
-  general: PropTypes.shape({}).isRequired,
+  general: PropTypes.shape({
+    cellSuffix: PropTypes.string.isRequired
+  }).isRequired,
   measurement: PropTypes.shape({
     format: PropTypes.string,
     name: PropTypes.string,
     value: PropTypes.any
   }).isRequired,
-  component: PropTypes.shape({
+  qlik: PropTypes.shape({
     backendApi: PropTypes.shape({
-      selectValues (props, propName) {
+      selectValues: function (props, propName) {
         if (props.isSnapshot || typeof props[propName] === 'function') {
           return null;
         }
@@ -132,20 +128,60 @@ DataCell.propTypes = {
 
 export default DataCell;
 
-function formatMeasurementValue(measurement, styling) {
-  if (isNaN(measurement.value)) {
-    return styling.symbolForNulls;
+function formatMeasurementValue (measurement, styling) {
+  const isColumnPercentageBased = (/%/).test(measurement.format);
+  let formattedMeasurementValue = '';
+  if (isColumnPercentageBased) {
+    if (isNaN(measurement.value)) {
+      formattedMeasurementValue = styling.symbolForNulls;
+    } else {
+      formattedMeasurementValue = ApplyPreMask('0,00%', measurement.value);
+    }
+  } else {
+    let magnitudeDivider;
+    switch (measurement.magnitude.toLowerCase()) {
+      case 'k':
+        magnitudeDivider = 1000;
+        break;
+      case 'm':
+        magnitudeDivider = 1000000;
+        break;
+      default:
+        magnitudeDivider = 1;
+    }
+    const formattingStringWithoutMagnitude = measurement.format.replace(/k|K|m|M/gi, '');
+    if (isNaN(measurement.value)) {
+      formattedMeasurementValue = styling.symbolForNulls;
+    } else {
+      let preFormatValue = measurement.value;
+      if (isColumnPercentageBased) {
+        preFormatValue *= 100;
+      }
+      switch (formattingStringWithoutMagnitude) {
+        case '#.##0':
+          formattedMeasurementValue = addSeparators((preFormatValue / magnitudeDivider), '.', ',', 0);
+          break;
+        case '#,##0':
+          formattedMeasurementValue = addSeparators((preFormatValue / magnitudeDivider), ',', '.', 0);
+          break;
+        default:
+          formattedMeasurementValue = ApplyPreMask(
+            formattingStringWithoutMagnitude,
+            (preFormatValue / magnitudeDivider)
+          );
+          break;
+      }
+    }
   }
-
-  return measurement.displayValue;
+  return formattedMeasurementValue;
 }
 
-function getConditionalColor(measurement, conditionalColoring) {
-  if (measurement.value < conditionalColoring.threshold.poor) {
-    return conditionalColoring.colors.poor;
+function getSemaphoreColors (measurement, semaphoreColors) {
+  if (measurement.value < semaphoreColors.status.critical) {
+    return semaphoreColors.statusColors.critical;
   }
-  if (measurement.value < conditionalColoring.threshold.fair) {
-    return conditionalColoring.colors.fair;
+  if (measurement.value < semaphoreColors.status.medium) {
+    return semaphoreColors.statusColors.medium;
   }
-  return conditionalColoring.colors.good;
+  return semaphoreColors.statusColors.normal;
 }

src/data-table/index.jsx

@@ -5,177 +5,99 @@ import DataCell from './data-cell.jsx';
 import RowHeader from './row-header.jsx';
 import { injectSeparators } from '../utilities';
 
-// eslint-disable-next-line react/prefer-stateless-function
-class DataTable extends React.PureComponent {
-  render () {
-    const {
-      cellWidth,
-      columnSeparatorWidth,
-      component,
-      data,
-      general,
-      renderData,
-      styling
-    } = this.props;
+const DataTable = ({ data, general, qlik, renderData, styling }) => {
+  const {
+    headers: {
+      dimension1,
+      measurements
+    },
+    matrix
+  } = data;
 
-    const {
-      headers: {
-        dimension1,
-        dimension2,
-        measurements
-      },
-      matrix
-    } = data;
-
-    const separatorStyle = {
-      minWidth: columnSeparatorWidth,
-      maxWidth: columnSeparatorWidth
-    };
-
-    const renderMeasurementData = (dimIndex, atEvery) => {
-      if (dimension2.length <= 0) {
-        return injectSeparators(
-          matrix[dimIndex],
-          columnSeparatorWidth,
-          atEvery
-        );
-      }
-      const measurementDataRow = [];
-      let index = 0,
-        match;
-      dimension2.forEach(dim2 => {
-        measurements.forEach((measure, mesInd) => {
-          for (index = 0; index < matrix[dimIndex].length; index++) {
-            match = false;
-            if (
-              matrix[dimIndex][index].parents &&
-              dimension1[dimIndex].displayValue ===
-                matrix[dimIndex][index].parents.dimension1.header
-            ) {
-              if (
-                dim2.displayValue ===
-                matrix[dimIndex][index].parents.dimension2.header
-              ) {
-                if (
-                  measure.name ===
-                  matrix[dimIndex][index].parents.measurement.header
-                ) {
-                  measurementDataRow.push(matrix[dimIndex][index]);
-                  match = true;
-                  break;
-                }
-              }
+  return (
+    <div className="row-wrapper">
+      <table>
+        <tbody>
+          {dimension1.map((dimensionEntry, dimensionIndex) => {
+            const rowHeaderText = dimensionEntry.displayValue || '';
+            if (rowHeaderText === '-') {
+              return null;
             }
-          }
-          if (!match) {
-            measurementDataRow.push({
-              displayValue: "",
-              parents: {
-                dimension1: {
-                  elementNumber: dimension1[dimIndex].elementNumber,
-                  header: dimension1[dimIndex].displayValue
-                },
-                dimension2: {
-                  elementNumber: dim2.elementNumber,
-                  header: dim2.displayValue
-                },
-                measurement: {
-                  header: measure.name,
-                  index: mesInd
-                }
-              }
-            });
-          }
-        });
-      });
-      return injectSeparators(
-        measurementDataRow,
-        columnSeparatorWidth,
-        atEvery
-      );
-    };
+            const styleBuilder = new StyleBuilder(styling);
+            if (styling.hasCustomFileStyle) {
+              styleBuilder.parseCustomFileStyle(rowHeaderText);
+            } else {
+              styleBuilder.applyStandardAttributes(dimensionIndex);
+              styleBuilder.applyCustomStyle({
+                fontSize: `${14 + styling.options.fontSizeAdjustment}px`
+              });
+            }
+            const rowStyle = {
+              fontFamily: styling.options.fontFamily,
+              width: '230px',
+              ...styleBuilder.getStyle()
+            };
 
+            return (
+              <tr key={dimensionEntry.displayValue}>
+                <RowHeader
+                  entry={dimensionEntry}
+                  qlik={qlik}
+                  rowStyle={rowStyle}
+                  styleBuilder={styleBuilder}
+                  styling={styling}
+                />
+                {renderData && injectSeparators(
+                  matrix[dimensionIndex],
+                  styling.useSeparatorColumns,
+                  { atEvery: measurements.length }
+                ).map((measurementData, index) => {
+                  if (measurementData.isSeparator) {
+                    const separatorStyle = {
+                      color: 'white',
+                      fontFamily: styling.options.fontFamily,
+                      fontSize: `${12 + styling.options.fontSizeAdjustment}px`
+                    };
 
-    return (
-      <div className="row-wrapper">
-        <table>
-          <tbody>
-            {dimension1.map((dimensionEntry, dimensionIndex) => {
-              const rowHeaderText = dimensionEntry.displayValue || '';
-              if (rowHeaderText === '-') {
-                return null;
-              }
-              const styleBuilder = new StyleBuilder(styling);
-              if (styling.hasCustomFileStyle) {
-                styleBuilder.parseCustomFileStyle(rowHeaderText);
-              } else {
-                styleBuilder.applyStandardAttributes(dimensionIndex);
-                styleBuilder.applyCustomStyle({
-                  fontSize: `${14 + styling.options.fontSizeAdjustment}px`
-                });
-              }
-              const rowStyle = {
-                fontFamily: styling.options.fontFamily,
-                width: '230px',
-                ...styleBuilder.getStyle()
-              };
+                    return (
+                      <td
+                        className="empty"
+                        key={`${dimensionEntry.displayValue}-${index}-separator`}
+                        style={separatorStyle}
+                      >
+                        *
+                      </td>
+                    );
+                  }
 
-              return (
-                <tr key={`${dimensionEntry.displayValue}-${dimensionIndex}-separator`}>
-                  {!renderData ?
-                    <RowHeader
-                      component={component}
-                      entry={dimensionEntry}
-                      rowStyle={rowStyle}
+                  const { dimension1: dimension1Info, dimension2, measurement } = measurementData.parents;
+                  const id = `${dimension1Info.elementNumber}-${dimension2 && dimension2.elementNumber}-${measurement.header}`;
+                  return (
+                    <DataCell
+                      data={data}
+                      general={general}
+                      key={`${dimensionEntry.displayValue}-${id}`}
+                      measurement={measurementData}
+                      qlik={qlik}
                       styleBuilder={styleBuilder}
                       styling={styling}
-                    /> : null
-                  }
-                  {renderData && renderMeasurementData(dimensionIndex, { atEvery: measurements.length }).map((measurementData, index) => {
-                    if (measurementData.isSeparator) {
-                      return (
-                        <td
-                          className="empty"
-                          key={`${dimensionEntry.displayValue}-${index}-separator`}
-                          style={separatorStyle}
-                        />
-                      );
-                    }
-
-                    // eslint-disable-next-line no-shadow
-                    const { dimension1: dimension1Info, dimension2, measurement } = measurementData.parents;
-                    const id = `${dimension1Info.elementNumber}-${dimension2 && dimension2.elementNumber}-${measurement.header}-${measurement.index}`;
-                    return (
-                      <DataCell
-                        cellWidth={cellWidth}
-                        component={component}
-                        data={data}
-                        general={general}
-                        key={`${dimensionEntry.displayValue}-${id}`}
-                        measurement={measurementData}
-                        styleBuilder={styleBuilder}
-                        styling={styling}
-                      />
-                    );
-                  })}
-                </tr>
-              );
-            })}
-          </tbody>
-        </table>
-      </div>
-    );
-  }
-}
+                    />
+                  );
+                })}
+              </tr>
+            );
+          })}
+        </tbody>
+      </table>
+    </div>
+  );
+};
 
 DataTable.defaultProps = {
   renderData: true
 };
 
 DataTable.propTypes = {
-  cellWidth: PropTypes.string.isRequired,
-  columnSeparatorWidth: PropTypes.string.isRequired,
-  component: PropTypes.shape({}).isRequired,
   data: PropTypes.shape({
     headers: PropTypes.shape({
       dimension1: PropTypes.array.isRequired
@@ -183,6 +105,7 @@ DataTable.propTypes = {
     matrix: PropTypes.arrayOf(PropTypes.array.isRequired).isRequired
   }).isRequired,
   general: PropTypes.shape({}).isRequired,
+  qlik: PropTypes.shape({}).isRequired,
   renderData: PropTypes.bool,
   styling: PropTypes.shape({
     hasCustomFileStyle: PropTypes.bool.isRequired

src/data-table/row-header.jsx

@@ -10,15 +10,14 @@ class RowHeader extends React.PureComponent {
     this.handleSelect = this.handleSelect.bind(this);
   }
 
-  // fixes the console error on row selected values
   handleSelect () {
-    const { component, entry } = this.props;
-    component.selectValues(0, [entry.elementNumber], false);
+    const { entry, qlik } = this.props;
+    qlik.backendApi.selectValues(0, [entry.elementNumber], true);
   }
 
   render () {
-    const { entry, rowStyle, styleBuilder, styling, component } = this.props;
-    const inEditState = component.inEditState();
+    const { entry, rowStyle, styleBuilder, styling, qlik } = this.props;
+    const inEditState = qlik.inEditState();
 
     return (
       <td
@@ -28,7 +27,6 @@ class RowHeader extends React.PureComponent {
       >
         <Tooltip
           isTooltipActive={!inEditState}
-          styling={styling}
           tooltipText={entry.displayValue}
         >
           <HeaderPadding
@@ -43,9 +41,12 @@ class RowHeader extends React.PureComponent {
 }
 
 RowHeader.propTypes = {
-  component: PropTypes.shape({
+  entry: PropTypes.shape({
+    displayValue: PropTypes.string.isRequired
+  }).isRequired,
+  qlik: PropTypes.shape({
     backendApi: PropTypes.shape({
-      selectValues (props, propName) {
+      selectValues: function (props, propName) {
         if (props.isSnapshot || typeof props[propName] === 'function') {
           return null;
         }
@@ -53,10 +54,6 @@ RowHeader.propTypes = {
       }
     }).isRequired
   }).isRequired,
-  entry: PropTypes.shape({
-    displayValue: PropTypes.string.isRequired,
-    elementNumber: PropTypes.number.isRequired
-  }).isRequired,
   rowStyle: PropTypes.shape({}).isRequired,
   styleBuilder: PropTypes.shape({}).isRequired,
   styling: PropTypes.shape({}).isRequired

src/dataset.js

@@ -6,86 +6,86 @@ function createCube (definition, app) {
   });
 }
 
-async function buildDataCube (originCubeDefinition, originCube, app, requestPage) {
+async function buildDataCube (originCubeDefinition, dimensionIndexes, app) {
   const cubeDefinition = {
     ...originCubeDefinition,
     qInitialDataFetch: [
       {
-        // eslint-disable-next-line no-undefined
-        qTop: requestPage === undefined ? 0 : requestPage[0].qTop,
-        qLeft: 0,
         qHeight: 1000,
-        qWidth: originCube.qSize.qcx
+        qWidth: 10
       }
     ],
-    qDimensions: [originCubeDefinition.qDimensions[0]],
+    qDimensions: [originCubeDefinition.qDimensions[dimensionIndexes.dimension1]],
     qMeasures: originCubeDefinition.qMeasures
   };
-  if (originCube.qDimensionInfo.length === 2) {
-    cubeDefinition.qDimensions.push(originCubeDefinition.qDimensions[1]);
+  if (dimensionIndexes.dimension2) {
+    cubeDefinition.qDimensions.push(originCubeDefinition.qDimensions[dimensionIndexes.dimension2]);
   }
   const cube = await createCube(cubeDefinition, app);
-  const cubeMatrix = cube.qHyperCube.qDataPages[0].qMatrix;
-  app.destroySessionObject(cube.qInfo.qId);
-  return cubeMatrix;
+
+  return cube.qHyperCube.qDataPages[0].qMatrix;
 }
 
-export async function initializeDataCube (component, layout) {
-
-  if (component.backendApi.isSnapshot) {
-    return layout.snapshotData.dataCube;
-  }
-  const app = qlik.currApp(component);
-  const properties = (await component.backendApi.getProperties());
-  const rowCount = component.backendApi.getRowCount();
-  const cellCount = rowCount * layout.qHyperCube.qSize.qcx;
-  const maxLoops = layout.maxloops;
-
-  // If this is a master object, fetch the hyperCubeDef of the original object
-  let hyperCubeDef = properties.qExtendsId
-    ? (await app.getObjectProperties(properties.qExtendsId)).properties.qHyperCubeDef
-    : properties.qHyperCubeDef;
-  hyperCubeDef = JSON.parse(JSON.stringify(hyperCubeDef));
-  hyperCubeDef.qStateName = layout.qStateName;
-  const pagedCube = {};
-  let lastRow = 0;
-  if (cellCount < (maxLoops * 10000)) {
-    for (let index = 0; cellCount > lastRow; index += 1) {
-      const requestPage = [
-        {
-          qHeight: 1000,
-          qLeft: 0,
-          qTop: lastRow,
-          qWidth: 10 // should be # of columns
-        }
-      ];
-      // eslint-disable-next-line no-await-in-loop
-      pagedCube[index] = await buildDataCube(hyperCubeDef, layout.qHyperCube, app, requestPage);
-      lastRow = lastRow + 1000;
-    }
-    return pagedCube;
-  }
-  return null;
-}
-
-export function initializeDesignList (component, layout) {
-  if (component.backendApi.isSnapshot) {
-    return layout.snapshotData.designList;
-  }
-
-  if (!layout.stylingfield) {
+async function buildDesignCube (originCubeDefinition, dimensionIndexes, app) {
+  if (!dimensionIndexes.design) {
     return null;
   }
+  const cube = await createCube({
+    qInitialDataFetch: [
+      {
+        qHeight: 1000,
+        qWidth: 1
+      }
+    ],
+    qDimensions: [originCubeDefinition.qDimensions[dimensionIndexes.design]]
+  }, app);
 
-  return new Promise(resolve => {
-    const app = qlik.currApp(component);
-    const stylingField = app.field(layout.stylingfield);
-    const listener = function () {
-      const data = stylingField.rows.map(row => row.qText);
-      stylingField.OnData.unbind(listener);
-      resolve(data);
-    };
-    stylingField.OnData.bind(listener);
-    stylingField.getData({ rows: 5000 });
-  });
+  return cube.qHyperCube.qDataPages[0].qMatrix;
+}
+
+const STYLE_SEPARATOR_COUNT = 7;
+function findDesignDimension (qMatrix) {
+  return qMatrix[0].map(entry => (entry.qText.match(/;/g) || []).length).indexOf(STYLE_SEPARATOR_COUNT);
+}
+
+function getDimensionIndexes (dimensionsInformation, designDimensionIndex) {
+  const hasDesign = designDimensionIndex !== -1;
+  const nonDesignDimensionCount = hasDesign ? dimensionsInformation.length - 1 : dimensionsInformation.length;
+  const dimension1 = designDimensionIndex === 0 ? 1 : 0;
+  let dimension2 = false;
+  if (nonDesignDimensionCount === 2) {
+    dimension2 = hasDesign && designDimensionIndex < 2 ? 2 : 1;
+  }
+  const design = hasDesign && designDimensionIndex;
+  const firstMeasurementIndex = dimensionsInformation.length;
+  return {
+    design,
+    dimension1,
+    dimension2,
+    firstMeasurementIndex
+  };
+}
+
+export async function initializeCubes ({ component, layout }) {
+  const app = qlik.currApp(component);
+  const designDimensionIndex = findDesignDimension(layout.qHyperCube.qDataPages[0].qMatrix);
+  const dimensionsInformation = layout.qHyperCube.qDimensionInfo;
+  const dimensionIndexes = getDimensionIndexes(dimensionsInformation, designDimensionIndex);
+
+  let properties;
+  if (component.backendApi.isSnapshot) {
+    // Fetch properties of source
+    properties = (await app.getObjectProperties(layout.sourceObjectId)).properties;
+  } else {
+    properties = await component.backendApi.getProperties();
+  }
+
+  const originCubeDefinition = properties.qHyperCubeDef;
+  const designCube = await buildDesignCube(originCubeDefinition, dimensionIndexes, app);
+  const dataCube = await buildDataCube(originCubeDefinition, dimensionIndexes, app);
+
+  return {
+    design: designCube,
+    data: dataCube
+  };
 }

src/definition/concept-semaphores.js

@@ -0,0 +1,96 @@
+const conceptSemaphores = {
+  items: {
+    AllConcepts: {
+      component: 'switch',
+      defaultValue: true,
+      label: 'All concepts affected',
+      options: [
+        {
+          label: 'On',
+          value: true
+        },
+        {
+          label: 'Off',
+          value: false
+        }
+      ],
+      ref: 'allsemaphores',
+      type: 'boolean'
+    },
+    ConceptsAffected1: {
+      defaultValue: '',
+      ref: 'conceptsemaphore1',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 1',
+      type: 'string'
+    },
+    ConceptsAffected2: {
+      defaultValue: '',
+      ref: 'conceptsemaphore2',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 2',
+      type: 'string'
+    },
+    ConceptsAffected3: {
+      defaultValue: '',
+      ref: 'conceptsemaphore3',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 3',
+      type: 'string'
+    },
+    ConceptsAffected4: {
+      defaultValue: '',
+      ref: 'conceptsemaphore4',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 4',
+      type: 'string'
+    },
+    ConceptsAffected5: {
+      defaultValue: '',
+      ref: 'conceptsemaphore5',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 5',
+      type: 'string'
+    },
+    ConceptsAffected6: {
+      defaultValue: '',
+      ref: 'conceptsemaphore6',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 6',
+      type: 'string'
+    },
+    ConceptsAffected7: {
+      defaultValue: '',
+      ref: 'conceptsemaphore7',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 7',
+      type: 'string'
+    },
+    ConceptsAffected8: {
+      defaultValue: '',
+      ref: 'conceptsemaphore8',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 8',
+      type: 'string'
+    },
+    ConceptsAffected9: {
+      defaultValue: '',
+      ref: 'conceptsemaphore9',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 9',
+      type: 'string'
+    },
+    // eslint-disable-next-line sort-keys
+    ConceptsAffected10: {
+      defaultValue: '',
+      ref: 'conceptsemaphore10',
+      show: data => !data.allsemaphores,
+      translation: 'Concept 10',
+      type: 'string'
+    }
+  },
+  label: 'Concept Semaphores',
+  type: 'items'
+};
+
+export default conceptSemaphores;

src/definition/conditional-coloring.js

@@ -1,199 +0,0 @@
-const conditionalColoring = {
-  type: 'items',
-  label: 'Color by performance',
-  items: {
-    Enabled: {
-      ref: 'conditionalcoloring.enabled',
-      type: 'boolean',
-      label: 'Enabled',
-      component: 'switch',
-      defaultValue: false,
-      options: [
-        {
-          value: true,
-          label: 'On'
-        },
-        {
-          value: false,
-          label: 'Off'
-        }
-      ]
-    },
-    ColorAllRows: {
-      ref: 'conditionalcoloring.colorall',
-      type: 'boolean',
-      label: 'Color all rows',
-      component: 'switch',
-      defaultValue: true,
-      options: [
-        {
-          value: true,
-          label: 'All rows'
-        },
-        {
-          value: false,
-          label: 'Specified rows'
-        }
-      ],
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    Rows: {
-      type: 'array',
-      ref: 'conditionalcoloring.rows',
-      label: 'Rows to color',
-      itemTitleRef: function (data) {
-        return data.rowname;
-      },
-      allowAdd: true,
-      allowRemove: true,
-      addTranslation: 'Add row to color',
-      items: {
-        Row: {
-          ref: 'rowname',
-          label: 'Name of row',
-          type: 'string',
-          defaultValue: ''
-        }
-      },
-      show (data) {
-        return data.conditionalcoloring.enabled && !data.conditionalcoloring.colorall;
-      }
-    },
-    ColorAllMeasures: {
-      ref: 'conditionalcoloring.colorallmeasures',
-      type: 'boolean',
-      label: 'Color all measures',
-      component: 'switch',
-      defaultValue: true,
-      options: [
-        {
-          value: true,
-          label: 'All measures'
-        },
-        {
-          value: false,
-          label: 'Specified measures'
-        }
-      ],
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    Measures: {
-      ref: 'conditionalcoloring.measures',
-      translation: 'Measures by index (ex: 0,3)',
-      type: 'string',
-      defaultValue: '',
-      show (data) {
-        return data.conditionalcoloring.enabled
-          && data.conditionalcoloring.colorallmeasures === false;
-      }
-    },
-    ThresholdPoor: {
-      ref: 'conditionalcoloring.threshold_poor',
-      translation: 'Poor range limit',
-      type: 'number',
-      defaultValue: -0.1,
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    ColorPoor: {
-      ref: 'conditionalcoloring.color_poor',
-      label: 'Poor background color',
-      type: 'object',
-      component: 'color-picker',
-      dualOutput: true,
-      defaultValue: {
-        index: 10,
-        color: '#f93f17'
-      },
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    TextColorPoor: {
-      ref: 'conditionalcoloring.textcolor_poor',
-      label: 'Poor text color',
-      type: 'object',
-      component: 'color-picker',
-      dualOutput: true,
-      defaultValue: {
-        index: 1,
-        color: '#ffffff'
-      },
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    ThresholdFair: {
-      ref: 'conditionalcoloring.threshold_fair',
-      translation: 'Fair range limit',
-      type: 'number',
-      defaultValue: 0,
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    ColorFair: {
-      ref: 'conditionalcoloring.color_fair',
-      label: 'Fair background color',
-      type: 'object',
-      component: 'color-picker',
-      dualOutput: true,
-      defaultValue: {
-        index: 8,
-        color: '#ffcf02'
-      },
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    TextColorFair: {
-      ref: 'conditionalcoloring.textcolor_fair',
-      label: 'Fair text color',
-      type: 'object',
-      component: 'color-picker',
-      dualOutput: true,
-      defaultValue: {
-        index: 15,
-        color: '#000000'
-      },
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    ColorGood: {
-      ref: 'conditionalcoloring.color_good',
-      label: 'Good background color',
-      type: 'object',
-      component: 'color-picker',
-      dualOutput: true,
-      defaultValue: {
-        index: 3,
-        color: '#276e27'
-      },
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    },
-    TextColorGood: {
-      ref: 'conditionalcoloring.textcolor_good',
-      label: 'Good text color',
-      type: 'object',
-      component: 'color-picker',
-      dualOutput: true,
-      defaultValue: {
-        index: 1,
-        color: '#ffffff'
-      },
-      show (data) {
-        return data.conditionalcoloring.enabled;
-      }
-    }
-  }
-};
-
-export default conditionalColoring;

src/definition/header.js

@@ -1,10 +1,10 @@
 const header = {
   type: 'items',
-  label: 'Header format',
+  label: 'Header Format',
   items: {
     Align: {
       ref: 'HeaderAlign',
-      translation: 'Header alignment',
+      translation: 'Header Alignment',
       type: 'number',
       component: 'buttongroup',
       options: [
@@ -29,14 +29,14 @@ const header = {
         index: 6,
         color: '#4477aa'
       },
-      label: 'Background color',
+      label: 'Background Header Color',
       ref: 'HeaderColorSchema',
       type: 'object',
       dualOutput: true
     },
     HeaderTextColor: {
       ref: 'HeaderTextColorSchema',
-      label: 'Text color',
+      label: 'Text Header Color',
       component: 'color-picker',
       defaultValue: {
         index: 1,
@@ -47,7 +47,7 @@ const header = {
     },
     HeaderFontSize: {
       ref: 'lettersizeheader',
-      translation: 'Font size',
+      translation: 'Font Size',
       type: 'number',
       component: 'buttongroup',
       options: [

src/definition/index.js

@@ -1,7 +1,8 @@
 import pagination from './pagination';
 import header from './header';
 import tableFormat from './table-format';
-import conditionalColoring from './conditional-coloring';
+import conceptSemaphores from './concept-semaphores';
+import metricSemaphores from './metric-semaphores';
 
 const definition = {
   component: 'accordion',
@@ -17,37 +18,18 @@ const definition = {
       },
       uses: 'data'
     },
-    sorting: {
-      uses: 'sorting'
-    },
     settings: {
       items: {
+        ConceptSemaphores: conceptSemaphores,
         Formatted: tableFormat,
         Header: header,
-        ConditionalColoring: conditionalColoring,
+        MetricSemaphores: metricSemaphores,
         Pagination: pagination
       },
       uses: 'settings'
     },
-    about: {
-      component: 'items',
-      label: 'About',
-      items: {
-        header: {
-          label: 'P&L pivot',
-          style: 'header',
-          component: 'text'
-        },
-        paragraph1: {
-          label: `P&L pivot is a Qlik Sense chart which allows you to display Profit & Loss
-            reporting with color and font customizations.`,
-          component: 'text'
-        },
-        paragraph2: {
-          label: 'P&L pivot is based upon an extension created by Ivan Felipe Asensio.',
-          component: 'text'
-        }
-      }
+    sorting: {
+      uses: 'sorting'
     }
   },
   type: 'items'

src/definition/metric-semaphores.js

@@ -0,0 +1,112 @@
+const metricSemaphores = {
+  type: 'items',
+  label: 'Metric Semaphores',
+  items: {
+    AllMetrics: {
+      ref: 'allmetrics',
+      type: 'boolean',
+      component: 'switch',
+      label: 'All metrics affected',
+      options: [
+        {
+          value: true,
+          label: 'On'
+        },
+        {
+          value: false,
+          label: 'Off'
+        }
+      ],
+      defaultValue: false
+    },
+    MetricsAffected: {
+      ref: 'metricssemaphore',
+      translation: 'Metrics affected (1,2,4,...)',
+      type: 'string',
+      defaultValue: '-',
+      show (data) {
+        return !data.allmetrics;
+      }
+    },
+    MetricStatus1: {
+      ref: 'metricsstatus1',
+      translation: 'Critic is less than',
+      type: 'number',
+      defaultValue: -0.1
+    },
+    ColorStatus1: {
+      ref: 'colorstatus1',
+      label: 'Critic Color Fill',
+      type: 'object',
+      component: 'color-picker',
+      dualOutput: true,
+      defaultValue: {
+        index: 8,
+        color: '#f93f17'
+      }
+    },
+    ColorStatus1Text: {
+      ref: 'colorstatus1text',
+      label: 'Critic Color Text',
+      type: 'object',
+      component: 'color-picker',
+      dualOutput: true,
+      defaultValue: {
+        index: 11,
+        color: '#ffffff'
+      }
+    },
+    MetricStatus2: {
+      ref: 'metricsstatus2',
+      translation: 'Medium is less than',
+      type: 'number',
+      defaultValue: 0
+    },
+    ColorStatus2: {
+      ref: 'colorstatus2',
+      label: 'Medium Color Fill',
+      type: 'object',
+      component: 'color-picker',
+      dualOutput: true,
+      defaultValue: {
+        index: 9,
+        color: '#ffcf02'
+      }
+    },
+    ColorStatus2Text: {
+      ref: 'colorstatus2text',
+      label: 'Medium Color Text',
+      type: 'object',
+      component: 'color-picker',
+      dualOutput: true,
+      defaultValue: {
+        index: 12,
+        color: '#000000'
+      }
+    },
+    ColorStatus3: {
+      ref: 'colorstatus3',
+      label: 'Success Color Fill',
+      type: 'object',
+      component: 'color-picker',
+      dualOutput: true,
+      defaultValue: {
+        index: 10,
+        color: '#276e27'
+      }
+    },
+    ColorStatus3Text: {
+      ref: 'colorstatus3text',
+      label: 'Success Color Text',
+      type: 'object',
+      component: 'color-picker',
+      dualOutput: true,
+      defaultValue: {
+        index: 11,
+        color: '#ffffff'
+      }
+    }
+  }
+};
+
+export default metricSemaphores;

src/definition/pagination.js

@@ -6,7 +6,7 @@ const pagination = {
       ref: 'maxloops',
       type: 'number',
       component: 'dropdown',
-      label: 'Max pagination loops',
+      label: 'Max Pagination Loops',
       options: [
         {
           value: 1,
@@ -23,6 +23,30 @@ const pagination = {
         {
           value: 4,
           label: '40k cells'
+        },
+        {
+          value: 5,
+          label: '50k cells'
+        },
+        {
+          value: 6,
+          label: '60k cells'
+        },
+        {
+          value: 7,
+          label: '70k cells'
+        },
+        {
+          value: 8,
+          label: '80k cells'
+        },
+        {
+          value: 9,
+          label: '90k cells'
+        },
+        {
+          value: 10,
+          label: '100k cells'
         }
       ],
       defaultValue: 2
@@ -31,8 +55,7 @@ const pagination = {
       ref: 'errormessage',
       label: 'Default error message',
       type: 'string',
-      defaultValue: `Unable to display all the data. 
-      Change the pagination size supported or apply more filters to limit the amount of displayed data.`
+      defaultValue: 'Ups! It seems you asked for too many data. Please filter more to see the whole picture.'
     }
   }
 };

src/definition/table-format.js

@@ -1,53 +1,12 @@
-const qlik = window.require('qlik');
-
 // fixes case for when there are 3 dimensions, missies the case with 1 design dimension and 1 data dimension
 function hasDesignDimension (data) {
   return data.qHyperCubeDef.qDimensions.length > 2;
 }
 
-function getFieldList () {
-  return new Promise(function (resolve) {
-    const app = qlik.currApp();
-    app.getList('FieldList').then(function (model) {
-      // Close the model to prevent any updates.
-      app.destroySessionObject(model.layout.qInfo.qId);
-
-      // This is a bit iffy, might be smarter to reject and handle empty lists on the props instead.
-      if (!model.layout.qFieldList.qItems) {
-        return resolve([]);
-      }
-      // Resolve an array with master objects.
-      return resolve(model.layout.qFieldList.qItems.map(function (item) {
-        return {
-          value: item.qName,
-          label: item.qName
-        };
-      }));
-    });
-  });
-}
-
 const tableFormat = {
   type: 'items',
-  label: 'Table format',
+  label: 'Table Format',
   items: {
-    StylingField: {
-      ref: 'stylingfield',
-      disabledRef: '',
-      type: 'string',
-      component: 'dropdown',
-      label: 'Style template field',
-      options: function () {
-        return getFieldList().then(function (items) {
-          items.unshift(
-            {
-              value: '',
-              label: 'None'
-            });
-          return items;
-        });
-      }
-    },
     IndentBool: {
       ref: 'indentbool',
       type: 'boolean',
@@ -58,7 +17,7 @@ const tableFormat = {
     SeparatorColumns: {
       ref: 'separatorcols',
       type: 'boolean',
-      label: 'Column separators',
+      label: 'Separator Columns',
       defaultValue: false
     },
     rowEvenBGColor: {
@@ -89,7 +48,7 @@ const tableFormat = {
       ref: 'BodyTextColorSchema',
       type: 'string',
       component: 'dropdown',
-      label: 'Text body color',
+      label: 'Text Body Color',
       options: [
         {
           value: 'Black',
@@ -139,7 +98,7 @@ const tableFormat = {
       ref: 'FontFamily',
       type: 'string',
       component: 'dropdown',
-      label: 'Font family',
+      label: 'FontFamily',
       options: [
         {
           value: 'QlikView Sans, -apple-system, sans-serif',
@@ -174,7 +133,7 @@ const tableFormat = {
     },
     DataFontSize: {
       ref: 'lettersize',
-      translation: 'Font size',
+      translation: 'Font Size',
       type: 'number',
       component: 'buttongroup',
       options: [
@@ -191,7 +150,7 @@ const tableFormat = {
     },
     textAlignment: {
       ref: 'cellTextAlignment',
-      label: 'Cell text alignment',
+      label: 'Cell Text alignment',
       component: 'buttongroup',
       options: [
         {
@@ -209,33 +168,15 @@ const tableFormat = {
       ],
       defaultValue: 'right'
     },
-    FitChartWidth: {
-      ref: 'fitchartwidth',
-      type: 'boolean',
-      component: 'switch',
-      label: 'Fill chart width',
-      options: [
-        {
-          value: true,
-          label: 'On'
-        },
-        {
-          value: false,
-          label: 'Off'
-        }
-      ],
-      defaultValue: false
-    },
     ColumnWidthSlider: {
       type: 'number',
       component: 'slider',
-      label: 'Column width',
+      label: 'Column Width',
       ref: 'columnwidthslider',
-      min: 20,
-      max: 250,
-      step: 10,
-      defaultValue: 50,
-      show: data => !data.fitchartwidth
+      min: 1,
+      max: 3,
+      step: 1,
+      defaultValue: 2
     },
     SymbolForNulls: {
       ref: 'symbolfornulls',
@@ -264,7 +205,7 @@ const tableFormat = {
       ref: 'filteroncellclick',
       type: 'boolean',
       component: 'switch',
-      label: 'Allow selection in cells',
+      label: 'Filter data when cell clicked',
       options: [
         {
           value: true,

src/excel-export.js

@@ -1,31 +1,19 @@
-function cleanupNodes (node) {
-  const removables = node.querySelectorAll('.tooltip,input');
-  [].forEach.call(removables, removeable => {
-    if (removeable.parentNode) {
-      removeable.parentNode.removeChild(removeable);
+function removeAllTooltips (node) {
+  const tooltips = node.querySelectorAll('.tooltip');
+  [].forEach.call(tooltips, tooltip => {
+    if (tooltip.parentNode) {
+      tooltip.parentNode.removeChild(tooltip);
     }
   });
 }
 
-function buildTableHTML (containerElement, title, subtitle, footnote) {
+function buildTableHTML (title, subtitle, footnote) {
   const titleHTML = `<p style="font-size:15pt"><b>${title}</b></p>`;
   const subtitleHTML = `<p style="font-size:11pt">${subtitle}</p>`;
-  const footnoteHTML = `<p style="font-size:11pt">${footnote}</p>`;
-  const kpiTableClone = containerElement[0].querySelector('.kpi-table').cloneNode(true);
-  const dataTableClone = containerElement[0].querySelector('.data-table').cloneNode(true);
-  cleanupNodes(kpiTableClone);
-  cleanupNodes(kpiTableClone);
+  const footnoteHTML = `<p style="font-size:11pt"><i>Note:</i>${footnote}</p>`;
+  const dataTableClone = document.querySelector('.data-table').cloneNode(true);
 
-  const kpiTableBodies = kpiTableClone.querySelectorAll('tbody');
-  const dataTableBodies = dataTableClone.querySelectorAll('tbody');
-  const kpiHeader = kpiTableBodies[0].querySelector('tr');
-  const dataTableHeaders = dataTableBodies[0].querySelectorAll('tr');
-  const kpiRows = kpiTableBodies[1].querySelectorAll('tr');
-  const dataRows = dataTableBodies[1].querySelectorAll('tr');
-  let combinedRows = '';
-  for (let i = 0; i < kpiRows.length; i++) {
-    combinedRows += `<tr>${kpiRows[i].innerHTML}${dataRows[i].innerHTML}</tr>`;
-  }
+  removeAllTooltips(dataTableClone);
 
   const tableHTML = `
     <html
@@ -53,23 +41,8 @@ function buildTableHTML (containerElement, title, subtitle, footnote) {
       <body>
         ${titleHTML.length > 0 ? titleHTML : ''}
         ${subtitleHTML.length > 0 ? subtitleHTML : ''}
-        <div>
-          <table>
-            <tbody>
-              <tr>
-              ${kpiHeader.innerHTML}
-              ${dataTableHeaders[0].innerHTML}
-              </tr>
-              ${dataTableHeaders.length > 1 ? dataTableHeaders[1].outerHTML : ''}
-            </tbody>
-          </table>
-          <table>
-            <tbody>
-              ${combinedRows}
-            </tbody>
-          </table>
-        </div>
         ${footnoteHTML.length > 0 ? footnoteHTML : ''}
+        ${dataTableClone.outerHTML}
       </body>
     </html>
     `.split('>.<')
@@ -82,15 +55,15 @@ function buildTableHTML (containerElement, title, subtitle, footnote) {
 
 function downloadXLS (html) {
   const filename = 'analysis.xls';
-  const blobObject = new Blob([html], { type: 'application/vnd.ms-excel' });
-
   // IE/Edge
   if (window.navigator.msSaveOrOpenBlob) {
+    const blobObject = new Blob([html]);
     return window.navigator.msSaveOrOpenBlob(blobObject, filename);
   }
 
+  const dataURI = generateDataURI(html);
   const link = window.document.createElement('a');
-  link.href = URL.createObjectURL(blobObject);
+  link.href = dataURI;
   link.download = filename;
   document.body.appendChild(link);
   link.click();
@@ -99,8 +72,15 @@ function downloadXLS (html) {
   return true;
 }
 
-export function exportXLS (containerElement, title, subtitle, footnote) {
+function generateDataURI (html) {
+  const dataType = 'data:application/vnd.ms-excel;base64,';
+  const data = window.btoa(unescape(encodeURIComponent(html)));
+
+  return `${dataType}${data}`;
+}
+
+export function exportXLS (title, subtitle, footnote) {
   // original was removing icon when starting export, disable and some spinner instead, shouldn't take enough time to warrant either..?
-  const table = buildTableHTML(containerElement, title, subtitle, footnote);
+  const table = buildTableHTML(title, subtitle, footnote);
   downloadXLS(table);
 }

src/export-button.jsx

@@ -0,0 +1,41 @@
+import React from 'react';
+import PropTypes from 'prop-types';
+import { exportXLS } from './excel-export';
+
+class ExportButton extends React.PureComponent {
+  constructor (props) {
+    super(props);
+    this.handleExport = this.handleExport.bind(this);
+  }
+
+  handleExport () {
+    const { excelExport, general } = this.props;
+    const { title, subtitle, footnote } = general;
+    if (excelExport) {
+      exportXLS(title, subtitle, footnote);
+    }
+  }
+
+  render () {
+    const { excelExport } = this.props;
+    return excelExport === true && (
+      <input
+        className="icon-xls"
+        onClick={this.handleExport}
+        src="/Extensions/qlik-smart-pivot/Excel.png"
+        type="image"
+      />
+    );
+  }
+}
+
+ExportButton.defaultProps = {
+  excelExport: false
+};
+
+ExportButton.propTypes = {
+  excelExport: PropTypes.bool,
+  general: PropTypes.shape({}).isRequired
+};
+
+export default ExportButton;

src/headers-table/column-header.jsx

@@ -1,46 +1,38 @@
-/* eslint-disable object-shorthand */
-/* eslint-disable space-before-function-paren */
 import React from 'react';
 import PropTypes from 'prop-types';
-import { HEADER_FONT_SIZE } from '../initialize-transformed';
 import Tooltip from '../tooltip/index.jsx';
 
 class ColumnHeader extends React.PureComponent {
-  constructor(props) {
+  constructor (props) {
     super(props);
     this.handleSelect = this.handleSelect.bind(this);
   }
 
-  // fixes console error for column selected values
-  handleSelect() {
-    const { component, entry } = this.props;
-    component.selectValues(1, [entry.elementNumber], false);
+  handleSelect () {
+    const { entry, qlik } = this.props;
+    qlik.backendApi.selectValues(1, [entry.elementNumber], true);
   }
 
-  render() {
-    const { baseCSS, cellWidth, colSpan, component, entry, styling } = this.props;
-    const inEditState = component.inEditState();
-    const isMediumFontSize = styling.headerOptions.fontSizeAdjustment === HEADER_FONT_SIZE.MEDIUM;
+  render () {
+    const { baseCSS, cellSuffix, colSpan, entry, styling, qlik } = this.props;
+    const inEditState = qlik.inEditState();
 
     const style = {
       ...baseCSS,
       fontSize: `${14 + styling.headerOptions.fontSizeAdjustment}px`,
-      height: isMediumFontSize ? '43px' : '33px',
-      verticalAlign: 'middle',
-      minWidth: cellWidth,
-      maxWidth: cellWidth
+      height: '45px',
+      verticalAlign: 'middle'
     };
 
     return (
       <th
-        className="grid-cells"
+        className={`grid-cells2${cellSuffix}`}
         colSpan={colSpan}
         onClick={this.handleSelect}
         style={style}
       >
         <Tooltip
           isTooltipActive={!inEditState}
-          styling={styling}
           tooltipText={entry.displayValue}
         >
           {entry.displayValue}
@@ -51,14 +43,19 @@ class ColumnHeader extends React.PureComponent {
 }
 
 ColumnHeader.defaultProps = {
+  cellSuffix: '',
   colSpan: 1
 };
 
 ColumnHeader.propTypes = {
   baseCSS: PropTypes.shape({}).isRequired,
-  cellWidth: PropTypes.string.isRequired,
+  cellSuffix: PropTypes.string,
   colSpan: PropTypes.number,
-  component: PropTypes.shape({
+  entry: PropTypes.shape({
+    elementNumber: PropTypes.number.isRequired,
+    name: PropTypes.string.isRequired
+  }).isRequired,
+  qlik: PropTypes.shape({
     backendApi: PropTypes.shape({
       selectValues: function (props, propName) {
         if (props.isSnapshot || typeof props[propName] === 'function') {
@@ -68,10 +65,6 @@ ColumnHeader.propTypes = {
       }
     }).isRequired
   }).isRequired,
-  entry: PropTypes.shape({
-    displayValue: PropTypes.string.isRequired,
-    elementNumber: PropTypes.number.isRequired
-  }).isRequired,
   styling: PropTypes.shape({
     headerOptions: PropTypes.shape({
       fontSizeAdjustment: PropTypes.number.isRequired

src/headers-table/export-column-header.jsx

@@ -1,17 +1,16 @@
 import React from 'react';
 import PropTypes from 'prop-types';
+import ExportButton from '../export-button.jsx';
 import { HEADER_FONT_SIZE } from '../initialize-transformed';
-import Tooltip from '../tooltip/index.jsx';
 
-const Dim1Header = ({ component, baseCSS, title, hasSecondDimension, styling }) => {
-  const inEditState = component.inEditState();
+const ExportColumnHeader = ({ baseCSS, general, title, allowExcelExport, hasSecondDimension, styling }) => {
   const rowSpan = hasSecondDimension ? 2 : 1;
   const isMediumFontSize = styling.headerOptions.fontSizeAdjustment === HEADER_FONT_SIZE.MEDIUM;
   const style = {
     ...baseCSS,
     cursor: 'default',
     fontSize: `${16 + styling.headerOptions.fontSizeAdjustment}px`,
-    height: isMediumFontSize ? '90px' : '70px',
+    height: isMediumFontSize ? '100px' : '80px',
     verticalAlign: 'middle',
     width: '230px'
   };
@@ -22,20 +21,19 @@ const Dim1Header = ({ component, baseCSS, title, hasSecondDimension, styling })
       rowSpan={rowSpan}
       style={style}
     >
-      <Tooltip
-        isTooltipActive={!inEditState}
-        styling={styling}
-        tooltipText={title}
-      >
-        {title}
-      </Tooltip>
+      <ExportButton
+        excelExport={allowExcelExport}
+        general={general}
+      />
+      {title}
     </th>
   );
 };
 
-Dim1Header.propTypes = {
+ExportColumnHeader.propTypes = {
+  allowExcelExport: PropTypes.bool.isRequired,
   baseCSS: PropTypes.shape({}).isRequired,
-  component: PropTypes.shape({}).isRequired,
+  general: PropTypes.shape({}).isRequired,
   hasSecondDimension: PropTypes.bool.isRequired,
   styling: PropTypes.shape({
     headerOptions: PropTypes.shape({
@@ -45,4 +43,4 @@ Dim1Header.propTypes = {
   title: PropTypes.string.isRequired
 };
 
-export default Dim1Header;
+export default ExportColumnHeader;

src/headers-table/index.jsx

@@ -1,124 +1,121 @@
 import React from 'react';
 import PropTypes from 'prop-types';
-import Dim1Header from './dim1-header.jsx';
+import ExportColumnHeader from './export-column-header.jsx';
 import ColumnHeader from './column-header.jsx';
 import MeasurementColumnHeader from './measurement-column-header.jsx';
 import { injectSeparators } from '../utilities';
 
-class HeadersTable extends React.PureComponent {
-  render () {
-    const {
-      cellWidth,
-      columnSeparatorWidth,
-      component,
-      data,
-      isKpi,
-      styling
-    } = this.props;
+const HeadersTable = ({ data, general, qlik, styling }) => {
+  const baseCSS = {
+    backgroundColor: styling.headerOptions.colorSchema,
+    color: styling.headerOptions.textColor,
+    fontFamily: styling.options.fontFamily,
+    textAlign: styling.headerOptions.alignment
+  };
 
-    const baseCSS = {
-      backgroundColor: styling.headerOptions.colorSchema,
-      color: styling.headerOptions.textColor,
-      fontFamily: styling.options.fontFamily,
-      textAlign: styling.headerOptions.alignment
-    };
+  const {
+    dimension1,
+    dimension2,
+    measurements
+  } = data.headers;
 
-    const {
-      dimension1,
-      dimension2,
-      measurements
-    } = data.headers;
+  const hasSecondDimension = dimension2.length > 0;
 
-    const hasSecondDimension = dimension2.length > 0;
+  return (
+    <div className="header-wrapper">
+      <table className="header">
+        <tbody>
+          <tr>
+            <ExportColumnHeader
+              allowExcelExport={general.allowExcelExport}
+              baseCSS={baseCSS}
+              general={general}
+              hasSecondDimension={hasSecondDimension}
+              styling={styling}
+              title={dimension1[0].name}
+            />
+            {!hasSecondDimension && measurements.map(measurementEntry => (
+              <MeasurementColumnHeader
+                baseCSS={baseCSS}
+                general={general}
+                hasSecondDimension={hasSecondDimension}
+                key={`${measurementEntry.displayValue}-${measurementEntry.name}`}
+                measurement={measurementEntry}
+                styling={styling}
+              />
+            ))}
+            {hasSecondDimension && injectSeparators(dimension2, styling.useSeparatorColumns).map((entry, index) => {
+              if (entry.isSeparator) {
+                const separatorStyle = {
+                  color: 'white',
+                  fontFamily: styling.options.fontFamily,
+                  fontSize: `${13 + styling.headerOptions.fontSizeAdjustment}px`
+                };
 
-    const separatorStyle = {
-      minWidth: columnSeparatorWidth,
-      maxWidth: columnSeparatorWidth
-    };
-
-    return (
-      <div className="header-wrapper">
-        <table className="header">
-          <tbody>
-            <tr>
-              {isKpi ?
-                <Dim1Header
-                  baseCSS={baseCSS}
-                  component={component}
-                  hasSecondDimension={hasSecondDimension}
-                  styling={styling}
-                  title={dimension1[0].name}
-                /> : null
+                return (
+                  <th
+                    className="empty"
+                    key={index}
+                    style={separatorStyle}
+                  >
+                    *
+                  </th>
+                );
               }
-              {!isKpi && !hasSecondDimension && measurements.map(measurementEntry => (
-                <MeasurementColumnHeader
+              return (
+                <ColumnHeader
                   baseCSS={baseCSS}
-                  cellWidth={cellWidth}
-                  hasSecondDimension={hasSecondDimension}
-                  key={`${measurementEntry.displayValue}-${measurementEntry.name}-${measurementEntry.index}`}
-                  measurement={measurementEntry}
+                  cellSuffix={general.cellSuffix}
+                  colSpan={measurements.length}
+                  entry={entry}
+                  key={entry.displayValue}
+                  qlik={qlik}
                   styling={styling}
                 />
-              ))}
-              {!isKpi && hasSecondDimension && injectSeparators(dimension2, columnSeparatorWidth).map((entry, index) => {
-                if (entry.isSeparator) {
+              );
+            })}
+          </tr>
+          {hasSecondDimension && (
+            <tr>
+              {injectSeparators(dimension2, styling.useSeparatorColumns).map((dimensionEntry, index) => {
+                if (dimensionEntry.isSeparator) {
+                  const separatorStyle = {
+                    color: 'white',
+                    fontFamily: styling.options.fontFamily,
+                    fontSize: `${12 + styling.headerOptions.fontSizeAdjustment}px`
+                  };
+
                   return (
                     <th
                       className="empty"
                       key={index}
                       style={separatorStyle}
-                    />
+                    >
+                      *
+                    </th>
                   );
                 }
-                return (
-                  <ColumnHeader
+                return measurements.map(measurementEntry => (
+                  <MeasurementColumnHeader
                     baseCSS={baseCSS}
-                    cellWidth={cellWidth}
-                    colSpan={measurements.length}
-                    component={component}
-                    entry={entry}
-                    key={`${entry.displayValue}-${index}-separator`}
+                    dimensionEntry={dimensionEntry}
+                    general={general}
+                    hasSecondDimension={hasSecondDimension}
+                    key={`${measurementEntry.displayValue}-${measurementEntry.name}-${dimensionEntry.name}`}
+                    measurement={measurementEntry}
                     styling={styling}
                   />
-                );
+                ));
               })}
             </tr>
-            {!isKpi && hasSecondDimension && (
-              <tr>
-                {injectSeparators(dimension2, columnSeparatorWidth).map((dimensionEntry, index) => {
-                  if (dimensionEntry.isSeparator) {
-                    return (
-                      <th
-                        className="empty"
-                        key={index}
-                        style={separatorStyle}
-                      />
-                    );
-                  }
-                  return measurements.map(measurementEntry => (
-                    <MeasurementColumnHeader
-                      baseCSS={baseCSS}
-                      cellWidth={cellWidth}
-                      dimensionEntry={dimensionEntry}
-                      hasSecondDimension={hasSecondDimension}
-                      key={`${measurementEntry.displayValue}-${measurementEntry.name}-${measurementEntry.index}-${dimensionEntry.name}`}
-                      measurement={measurementEntry}
-                      styling={styling}
-                    />
-                  ));
-                })}
-              </tr>
-            )}
-          </tbody>
-        </table>
-      </div>
-    );
-  }
-}
+          )}
+        </tbody>
+      </table>
+    </div>
+  );
+};
 
 HeadersTable.propTypes = {
-  cellWidth: PropTypes.string.isRequired,
-  columnSeparatorWidth: PropTypes.string.isRequired,
   data: PropTypes.shape({
     headers: PropTypes.shape({
       dimension1: PropTypes.array,
@@ -126,12 +123,21 @@ HeadersTable.propTypes = {
       measurements: PropTypes.array
     })
   }).isRequired,
-  component: PropTypes.shape({}).isRequired,
+  general: PropTypes.shape({}).isRequired,
+  qlik: PropTypes.shape({
+    backendApi: PropTypes.shape({
+      selectValues: function (props, propName) {
+        if (props.isSnapshot || typeof props[propName] === 'function') {
+          return null;
+        }
+        return new Error('Missing implementation of qlik.backendApi.selectValues.');
+      }
+    }).isRequired
+  }).isRequired,
   styling: PropTypes.shape({
     headerOptions: PropTypes.shape({}),
     options: PropTypes.shape({})
-  }).isRequired,
-  isKpi: PropTypes.bool.isRequired
+  }).isRequired
 };
 
 export default HeadersTable;

src/headers-table/measurement-column-header.jsx

@@ -3,55 +3,63 @@ import PropTypes from 'prop-types';
 import { HEADER_FONT_SIZE } from '../initialize-transformed';
 import Tooltip from '../tooltip/index.jsx';
 
-const MeasurementColumnHeader = ({ baseCSS, cellWidth, hasSecondDimension, measurement, styling }) => {
-  const title = `${measurement.name}`;
+const MeasurementColumnHeader = ({ baseCSS, general, hasSecondDimension, measurement, styling }) => {
+  const title = `${measurement.name} ${measurement.magnitudeLabelSuffix}`;
   const { fontSizeAdjustment } = styling.headerOptions;
   const isMediumFontSize = fontSizeAdjustment === HEADER_FONT_SIZE.MEDIUM;
 
-  const cellStyle = {
-    ...baseCSS,
-    verticalAlign: 'middle',
-    minWidth: cellWidth,
-    maxWidth: cellWidth
-  };
-
   if (hasSecondDimension) {
     const isPercentageFormat = measurement.format.substring(measurement.format.length - 1) === '%';
     let baseFontSize = 14;
+    let cellClass = 'grid-cells2';
     if (isPercentageFormat) {
       baseFontSize = 13;
+      cellClass = 'grid-cells2-small';
     }
-    cellStyle.fontSize = `${baseFontSize + fontSizeAdjustment}px`;
-    cellStyle.height = isMediumFontSize ? '45px' : '35px';
-
+    const cellStyle = {
+      ...baseCSS,
+      cursor: 'default',
+      fontSize: `${baseFontSize + fontSizeAdjustment}px`,
+      height: isMediumFontSize ? '40px' : '25px',
+      verticalAlign: 'middle'
+    };
     return (
       <th
-        className="grid-cells"
+        className={`${cellClass}${general.cellSuffix}`}
         style={cellStyle}
       >
-        <Tooltip
-          tooltipText={title}
-          styling={styling}
-        >
-          {title}
-        </Tooltip>
+        <span className="wrapclass25">
+          <Tooltip
+            tooltipText={title}
+          >
+            {title}
+          </Tooltip>
+        </span>
       </th>
     );
   }
 
-  cellStyle.fontSize = `${15 + fontSizeAdjustment}px`;
-  cellStyle.height = isMediumFontSize ? '90px' : '70px';
+  const isLong = (title.length > 11 && fontSizeAdjustment === HEADER_FONT_SIZE.SMALL)
+    || (title.length > 12 && fontSizeAdjustment === HEADER_FONT_SIZE.MEDIUM);
+  const suffixWrap = isLong ? '70' : 'empty';
+  const style = {
+    ...baseCSS,
+    cursor: 'default',
+    fontSize: `${15 + fontSizeAdjustment}px`,
+    height: isMediumFontSize ? '100px' : '80px',
+    verticalAlign: 'middle'
+  };
   return (
     <th
-      className="grid-cells"
-      style={cellStyle}
+      className={`grid-cells2${general.cellSuffix}`}
+      style={style}
     >
-      <Tooltip
-        tooltipText={title}
-        styling={styling}
+      <span
+        className={`wrapclass${suffixWrap}`}
+        style={{ fontFamily: styling.headerOptions.fontFamily }}
       >
         {title}
-      </Tooltip>
+      </span>
     </th>
   );
 };
@@ -62,7 +70,9 @@ MeasurementColumnHeader.defaultProps = {
 
 MeasurementColumnHeader.propTypes = {
   baseCSS: PropTypes.shape({}).isRequired,
-  cellWidth: PropTypes.string.isRequired,
+  general: PropTypes.shape({
+    cellSuffix: PropTypes.string.isRequired
+  }).isRequired,
   hasSecondDimension: PropTypes.bool,
   measurement: PropTypes.shape({
     name: PropTypes.string.isRequired

src/index.js

@@ -1,18 +1,17 @@
-import definition from "./definition";
-import { exportXLS } from "./excel-export";
-import { initializeDataCube, initializeDesignList } from "./dataset";
-import initializeStore from "./store";
-import React from "react";
-import ReactDOM from "react-dom";
-import Root from "./root.jsx";
-import "./main.less";
+import paint from './paint.jsx';
+import definition from './definition';
+import './main.less';
 
-if (!window._babelPolyfill) {
-  // eslint-disable-line no-underscore-dangle
-  require("@babel/polyfill"); // eslint-disable-line global-require
+if (!window._babelPolyfill) { // eslint-disable-line no-underscore-dangle
+  require('@babel/polyfill'); // eslint-disable-line global-require
 }
 
 export default {
+  controller: [
+    '$scope',
+    '$timeout',
+    function controller () {}
+  ],
   design: {
     dimensions: {
       max: 1,
@@ -21,23 +20,16 @@ export default {
   },
   data: {
     dimensions: {
-      max (nMeasures) {
-        return nMeasures < 9 ? 2 : 1;
-      },
+      max: 3,
       min: 1,
       uses: 'dimensions'
     },
     measures: {
-      max (nDims) {
-        return nDims < 2 ? 9 : 8;
-      },
+      max: 8,
       min: 1,
       uses: 'measures'
     }
   },
-  // Prevent conversion from and to this object
-  exportProperties: null,
-  importProperties: null,
   definition,
   initialProperties: {
     version: 1.0,
@@ -45,14 +37,11 @@ export default {
       qDimensions: [],
       qInitialDataFetch: [
         {
-          qTop: 0,
-          qLeft: 0,
-          qWidth: 50,
-          qHeight: 50
+          qHeight: 1,
+          qWidth: 10
         }
       ],
-      qMeasures: [],
-      qSuppressZero: false
+      qMeasures: []
     }
   },
   support: {
@@ -60,67 +49,16 @@ export default {
     exportData: true,
     snapshot: true
   },
-  async paint ($element, layout, requestPage) {
-    const dataCube = await initializeDataCube(this, layout, requestPage);
-    const editmodeClass = this.inAnalysisState() ? '' : 'edit-mode';
-    let state, designList;
-    if (dataCube === null) {
-      state = {
-        $element,
-        component: this,
-        dataCube,
-        designList,
-        layout,
-        error: true
-      };
-    } else {
-      designList = await initializeDesignList(this, layout);
-      state = await initializeStore({
-        $element,
-        component: this,
-        dataCube,
-        designList,
-        layout,
-        error: false
-      });
+  paint ($element, layout) {
+    try {
+      paint($element, layout, this);
+    } catch (exception) {
+      console.error(exception); // eslint-disable-line no-console
+      throw exception;
     }
-    const jsx = (
-      <Root editmodeClass={editmodeClass} component={this} state={state} />
-    );
-
-    ReactDOM.render(jsx, $element[0]);
   },
   snapshot: {
     canTakeSnapshot: true
   },
-  async setSnapshotData (snapshotLayout) {
-    snapshotLayout.snapshotData.dataCube = await initializeDataCube(
-      this,
-      snapshotLayout
-    );
-    snapshotLayout.snapshotData.designList = await initializeDesignList(
-      this,
-      snapshotLayout
-    );
-    return snapshotLayout;
-  },
-  getContextMenu (obj, menu) {
-    if (this.backendApi.model.layout.qMeta.privileges.indexOf('exportdata') !== -1) {
-      menu.addItem({
-        translation: 'Export as XLS',
-        tid: 'export-excel',
-        icon: 'export',
-        select: () => {
-          exportXLS(
-            this.$element,
-            this.$scope.layout.title,
-            this.$scope.layout.subtitle,
-            this.$scope.layout.footnote
-          );
-        }
-      });
-    }
-    return menu;
-  },
   version: 1.0
 };

src/initialize-transformed.js

@@ -1,192 +1,231 @@
-import { distinctArray } from "./utilities";
+import { distinctArray } from './utilities';
 
 export const HEADER_FONT_SIZE = {
   SMALL: -1,
-  MEDIUM: 1,
+  MEDIUM: 1
 };
 
-function getAlignment(option) {
+function getAlignment (option) {
   const alignmentOptions = {
-    1: "left",
-    2: "center",
-    3: "right",
+    1: 'left',
+    2: 'center',
+    3: 'right'
   };
 
-  return alignmentOptions[option] || "left";
+  return alignmentOptions[option] || 'left';
 }
 
-function getFontSizeAdjustment(option) {
+function getFontSizeAdjustment (option) {
   const fontSizeAdjustmentOptions = {
     1: HEADER_FONT_SIZE.SMALL,
-    2: HEADER_FONT_SIZE.MEDIUM,
+    2: HEADER_FONT_SIZE.MEDIUM
   };
 
   return fontSizeAdjustmentOptions[option] || 0;
 }
 
-function generateMeasurements(information) {
-  return information.map((measurement) => {
+function getCellSuffix (option) {
+  const cellSuffixOptions = {
+    1: '-s',
+    3: '-l'
+  };
+
+  return cellSuffixOptions[option] || '';
+}
+
+function getMeasurementFormat (measurement) {
+  if (measurement.qNumFormat.qType === 'U' || measurement.qNumFormat.qFmt === '##############') {
+    return '#.##0';
+  } else if (measurement.qNumFormat.qType === 'R') {
+    return measurement.qNumFormat.qFmt.replace(/(|)/gi, '');
+  }
+  return measurement.qNumFormat.qFmt;
+}
+
+function getMagnitudeLabelSuffix (magnitudeOption) {
+  const magnitudeLabelSuffixOptions = {
+    'k': ' (k)',
+    'm': ' (m)'
+  };
+
+  return magnitudeLabelSuffixOptions[magnitudeOption] || '';
+}
+
+function generateMeasurements (information) {
+  return information.map(measurement => {
+    const format = getMeasurementFormat(measurement);
+    const formatMagnitude = format.substr(format.length - 1).toLowerCase();
     const transformedMeasurement = {
-      format: measurement.qNumFormat.qFmt || "#.##0",
-      name: measurement.qFallbackTitle,
+      format,
+      magnitudeLabelSuffix: getMagnitudeLabelSuffix(formatMagnitude),
+      name: measurement.qFallbackTitle
     };
 
     return transformedMeasurement;
   });
 }
 
-function generateDimensionEntry(information, data) {
+function generateDimensionEntry (information, data) {
   return {
-    displayValue: data.qText || data.qNum,
+    displayValue: data.qText,
     elementNumber: data.qElemNumber,
     name: information.qFallbackTitle,
-    value: data.qNum,
+    value: data.qNum
   };
 }
 
-function generateMatrixCell({
-  cell,
-  dimension1Information,
-  dimension2Information,
-  measurementInformation,
-}) {
+function generateMatrixCell ({ cell, dimension1Information, dimension2Information, measurementInformation }) {
   const matrixCell = {
     displayValue: cell.qText,
     format: measurementInformation.format,
+    magnitude: measurementInformation.magnitudeLabelSuffix.substring(
+      measurementInformation.magnitudeLabelSuffix.length - 2,
+      measurementInformation.magnitudeLabelSuffix.length - 1
+    ),
+    magnitudeLabelSuffix: measurementInformation.magnitudeLabelSuffix,
     name: measurementInformation.name,
     parents: {
       dimension1: {
         elementNumber: dimension1Information.qElemNumber,
-        header: dimension1Information.qText,
+        header: dimension1Information.qText
       },
       measurement: {
-        header: measurementInformation.name,
-        index: measurementInformation.index,
-      },
+        header: measurementInformation.name
+      }
     },
-    value: cell.qNum,
+    value: cell.qNum
   };
 
   if (dimension2Information) {
     matrixCell.parents.dimension2 = {
-      elementNumber: dimension2Information.qElemNumber,
-      header: dimension2Information.qText,
+      elementNumber: dimension2Information.qElemNumber
     };
   }
 
   return matrixCell;
 }
 
-function generateDataSet(
-  component,
-  dimensionsInformation,
-  measurementsInformation,
-  dataCube
-) {
-  const measurements = generateMeasurements(measurementsInformation);
+let lastRow = 0;
+function generateDataSet (component, dimensionsInformation, measurementsInformation, cubes) {
   let dimension1 = [];
   let dimension2 = [];
+  const measurements = generateMeasurements(measurementsInformation);
   let matrix = [];
 
-  const hasSecondDimension = dimensionsInformation.length > 1;
-  // eslint-disable-next-line no-undefined
-  for (let index = 0; dataCube[index] !== undefined; index++) {
-    // eslint-disable-next-line no-loop-func
-    dataCube[index].forEach((row) => {
-      const dimension1Entry = generateDimensionEntry(
-        dimensionsInformation[0],
-        row[0]
-      );
-      dimension1.push(dimension1Entry);
-      let dimension2Entry;
-      let firstDataCell = 1;
-      if (hasSecondDimension) {
-        dimension2Entry = generateDimensionEntry(
-          dimensionsInformation[1],
-          row[1]
-        );
-        dimension2.push(dimension2Entry);
-        firstDataCell = 2;
-      }
-      let matrixRow = row
-        .slice(firstDataCell, row.length)
-        .map((cell, cellIndex) => {
-          const measurementInformation = measurements[cellIndex];
-          measurementInformation.index = cellIndex;
-          const dimension1Information = row[0]; // eslint-disable-line prefer-destructuring
-          const dimension2Information = hasSecondDimension ? row[1] : null;
-          const generatedCell = generateMatrixCell({
-            cell,
-            dimension1Information,
-            dimension2Information,
-            measurementInformation,
-          });
-          return generatedCell;
+  const hasDesignDimension = cubes.design;
+  const hasSecondDimension = hasDesignDimension ? dimensionsInformation.length > 2 : dimensionsInformation.length > 1;
+  cubes.data.forEach(row => {
+    lastRow += 1;
+    const dimension1Entry = generateDimensionEntry(dimensionsInformation[0], row[0]);
+    dimension1.push(dimension1Entry);
+    let dimension2Entry;
+    let firstDataCell = 1;
+    if (hasSecondDimension) {
+      dimension2Entry = generateDimensionEntry(dimensionsInformation[1], row[1]);
+      dimension2.push(dimension2Entry);
+      firstDataCell = 2;
+    }
+    let matrixRow = row
+      .slice(firstDataCell, row.length)
+      .map((cell, cellIndex) => {
+        const measurementInformation = measurements[cellIndex];
+        const dimension1Information = row[0]; // eslint-disable-line prefer-destructuring
+        const dimension2Information = hasSecondDimension ? row[1] : null;
+        const generatedCell = generateMatrixCell({
+          cell,
+          dimension1Information,
+          dimension2Information,
+          measurementInformation
         });
 
-      let appendToRowIndex = matrix.length;
-      if (hasSecondDimension) {
-        // See if there already is a row for the current dim1
-        for (let i = 0; i < matrix.length; i++) {
-          if (
-            matrix[i][0].parents.dimension1.header ===
-            matrixRow[0].parents.dimension1.header
-          ) {
-            appendToRowIndex = i;
-            matrixRow = matrix[i].concat(matrixRow);
-          }
+        return generatedCell;
+      });
+
+    let appendToRowIndex = matrix.length;
+    if (hasSecondDimension) {
+      // See if there already is a row for the current dim1
+      for (let i = 0; i < matrix.length; i++) {
+        if (matrix[i][0].parents.dimension1.header === matrixRow[0].parents.dimension1.header) {
+          appendToRowIndex = i;
+          matrixRow = matrix[i].concat(matrixRow);
         }
       }
-      matrix[appendToRowIndex] = matrixRow;
-    });
-  }
+    }
+    matrix[appendToRowIndex] = matrixRow;
+  });
 
   // filter header dimensions to only have distinct values
   dimension1 = distinctArray(dimension1);
   dimension2 = distinctArray(dimension2);
 
+  // Make sure all rows are saturated, otherwise data risks being displayed in the wrong column
+  matrix = matrix.map((row, rowIndex) => {
+    if (row.length == dimension2.length) {
+      // Row is saturated
+      return row;
+    }
+
+    // Row is not saturated, so must add empty cells to fill the gaps
+    let newRow = [];
+    let cellIndex = 0;
+    dimension2.forEach(dim => {
+      measurements.forEach(measurement => {
+        if (cellIndex < row.length
+          && row[cellIndex].parents.dimension2.elementNumber === dim.elementNumber
+          && row[cellIndex].parents.measurement.header === measurement.name) {
+          newRow.push(row[cellIndex]);
+          cellIndex++;
+        } else {
+          newRow.push({
+            displayValue: '',
+            parents: {
+              dimension1: { elementNumber: rowIndex },
+              dimension2: { elementNumber: dim.elementNumber },
+              measurement: { header: measurement.name }
+            }
+          });
+        }
+      });
+    });
+
+    return newRow;
+  });
+
   return {
     dimension1: dimension1,
     dimension2: dimension2,
     matrix,
-    measurements,
+    measurements
   };
 }
 
-function initializeTransformed({
-  $element,
-  component,
-  dataCube,
-  designList,
-  layout,
-}) {
+function initializeTransformed ({ $element, component, cubes, layout }) {
   const dimensionsInformation = component.backendApi.getDimensionInfos();
   const measurementsInformation = component.backendApi.getMeasureInfos();
   const dimensionCount = layout.qHyperCube.qDimensionInfo.length;
-  const { dimension1, dimension2, measurements, matrix } = generateDataSet(
-    component,
-    dimensionsInformation,
-    measurementsInformation,
-    dataCube
-  );
+  const rowCount = component.backendApi.getRowCount();
+  const maxLoops = layout.maxloops;
+  const {
+    dimension1,
+    dimension2,
+    measurements,
+    matrix
+  } = generateDataSet(component, dimensionsInformation, measurementsInformation, cubes);
 
   const customSchemaBasic = [];
   const customSchemaFull = [];
   let customHeadersCount = 0;
 
-  if (designList && designList.length > 0) {
-    const headers = designList[0].split(";");
+  if (cubes.design) {
+    const allTextLines = cubes.design.map(entry => entry[0].qText);
+    const headers = allTextLines[0].split(';');
     customHeadersCount = headers.length;
-    for (let lineNumber = 0; lineNumber < designList.length; lineNumber += 1) {
+    for (let lineNumber = 0; lineNumber < allTextLines.length; lineNumber += 1) {
       customSchemaFull[lineNumber] = new Array(headers.length);
-      const data = designList[lineNumber].split(";");
+      const data = allTextLines[lineNumber].split(';');
 
       if (data.length === headers.length) {
-        for (
-          let headerIndex = 0;
-          headerIndex < headers.length;
-          headerIndex += 1
-        ) {
+        for (let headerIndex = 0; headerIndex < headers.length; headerIndex += 1) {
           [customSchemaBasic[lineNumber]] = data;
           customSchemaFull[lineNumber][headerIndex] = data[headerIndex];
         }
@@ -194,62 +233,45 @@ function initializeTransformed({
     }
   }
 
-  let cellWidth;
-  if (layout.fitchartwidth) {
-    // The widths are calculated based on the current element width. Note: this could use % to set
-    // the widths as percentages of the available width. However, this often results in random
-    // columns getting 1px wider than the others because of rounding necessary to fill the width.
-    // This 1px causes missalignment between the data- and header tables.
-    cellWidth = "";
-  } else {
-    // If using the previous solution just set 60px
-    cellWidth = `${
-      layout.columnwidthslider > 10 ? layout.columnwidthslider : 60
-    }px`;
-  }
-
   // top level properties could be reducers and then components connect to grab what they want,
   // possibly with reselect for some presentational transforms (moving some of the presentational logic like formatting and such)
   const transformedProperties = {
-    element: $element[0],
     data: {
       headers: {
         dimension1, // column headers
         dimension2, // parent row headers if exists
-        measurements, // row headers, looped for each dimension2 if exists
+        measurements // row headers, looped for each dimension2 if exists
       },
       matrix, // 2d array of all rows/cells to render in body of datatable
       meta: {
-        dimensionCount: dimensionsInformation.length,
-      },
+        dimensionCount: dimensionsInformation.length
+      }
     },
     general: {
       allowExcelExport: layout.allowexportxls,
       allowFilteringByClick: layout.filteroncellclick,
-      cellWidth: cellWidth,
+      cellSuffix: getCellSuffix(layout.columnwidthslider), // TOOD: move to matrix cells or is it headers.measurements?
       errorMessage: layout.errormessage,
       footnote: layout.footnote,
+      maxLoops,
       subtitle: layout.subtitle,
-      title: layout.title,
-      useColumnSeparator: layout.separatorcols && dimensionCount > 1,
+      title: layout.title
     },
     selection: {
-      dimensionSelectionCounts: dimensionsInformation.map(
-        (dimensionInfo) => dimensionInfo.qStateCounts.qSelected
-      ),
+      dimensionSelectionCounts: dimensionsInformation.map(dimensionInfo => dimensionInfo.qStateCounts.qSelected)
     },
     styling: {
       customCSV: {
         basic: customSchemaBasic,
         count: customHeadersCount,
-        full: customSchemaFull,
+        full: customSchemaFull
       },
-      hasCustomFileStyle: Boolean(designList),
+      hasCustomFileStyle: Boolean(cubes.design),
       headerOptions: {
         alignment: getAlignment(layout.HeaderAlign),
         colorSchema: layout.HeaderColorSchema.color,
         fontSizeAdjustment: getFontSizeAdjustment(layout.lettersizeheader),
-        textColor: layout.HeaderTextColorSchema.color,
+        textColor: layout.HeaderTextColorSchema.color
       },
       options: {
         backgroundColor: layout.rowEvenBGColor,
@@ -257,44 +279,64 @@ function initializeTransformed({
         color: layout.BodyTextColorSchema,
         fontFamily: layout.FontFamily,
         fontSizeAdjustment: getFontSizeAdjustment(layout.lettersize),
-        textAlignment: layout.cellTextAlignment,
+        textAlignment: layout.cellTextAlignment
       },
-      conditionalColoring: {
-        enabled: layout.conditionalcoloring.enabled,
-        colorAllRows: layout.conditionalcoloring.colorall,
-        rows: layout.conditionalcoloring.rows.map((row) => row.rowname),
-        colorAllMeasures:
-          typeof layout.conditionalcoloring.colorallmeasures === "undefined" ||
-          layout.conditionalcoloring.colorallmeasures,
-        measures: !layout.conditionalcoloring.measures
-          ? []
-          : layout.conditionalcoloring.measures
-              .split(",")
-              .map((index) => Number(index)),
-        threshold: {
-          poor: layout.conditionalcoloring.threshold_poor,
-          fair: layout.conditionalcoloring.threshold_fair,
+      semaphoreColors: {
+        fieldsToApplyTo: {
+          applyToAll: layout.allsemaphores,
+          applyToMetric: layout.allmetrics,
+          specificFields: [
+            layout.conceptsemaphore1,
+            layout.conceptsemaphore2,
+            layout.conceptsemaphore3,
+            layout.conceptsemaphore4,
+            layout.conceptsemaphore5,
+            layout.conceptsemaphore6,
+            layout.conceptsemaphore7,
+            layout.conceptsemaphore9,
+            layout.conceptsemaphore10
+          ],
+          metricsSpecificFields: layout.metricssemaphore.split(',').map(entry => Number(entry))
         },
-        colors: {
-          poor: {
-            color: layout.conditionalcoloring.color_poor,
-            textColor: layout.conditionalcoloring.textcolor_poor,
-          },
-          fair: {
-            color: layout.conditionalcoloring.color_fair,
-            textColor: layout.conditionalcoloring.textcolor_fair,
-          },
-          good: {
-            color: layout.conditionalcoloring.color_good,
-            textColor: layout.conditionalcoloring.textcolor_good,
-          },
+        status: {
+          critical: layout.metricsstatus1,
+          medium: layout.metricsstatus2
         },
+        statusColors: {
+          critical: {
+            backgroundColor: layout.colorstatus1.color,
+            color: layout.colorstatus1text.color
+          },
+          medium: {
+            backgroundColor: layout.colorstatus2.color,
+            color: layout.colorstatus2text.color
+          },
+          normal: {
+            backgroundColor: layout.colorstatus3.color,
+            color: layout.colorstatus3text.color
+          }
+        }
       },
       symbolForNulls: layout.symbolfornulls,
       usePadding: layout.indentbool,
-    },
+      useSeparatorColumns: dimensionCount === 1 ? false : layout.separatorcols
+    }
   };
 
+  if (rowCount > lastRow && rowCount <= (maxLoops * 1000)) {
+    const requestPage = [
+      {
+        qHeight: Math.min(1000, rowCount - lastRow),
+        qLeft: 0,
+        qTop: matrix.length,
+        qWidth: 10 // should be # of columns
+      }
+    ];
+    component.backendApi.getData(requestPage).then(() => {
+      component.paint($element, layout);
+    });
+  }
+
   return transformedProperties;
 }
 

src/linked-scroll/linked-scroll-wrapper.jsx

@@ -33,7 +33,7 @@ class LinkedScrollWrapper extends React.PureComponent {
   unlinkComponent (component) {
     const componentIndex = this.scrollElements.map(element => element.component).indexOf(component);
     if (componentIndex !== -1) {
-      this.scrollElements.splice(componentIndex, 1);
+      this.scrollElements.removeAt(componentIndex);
       // eslint-disable-next-line react/no-find-dom-node
       const node = ReactDOM.findDOMNode(component);
       node.onscroll = null;

src/main.less

@@ -1,5 +1,6 @@
 /* eslint-disable */
 .qv-object-qlik-smart-pivot {
+  @TableBorder: 1px solid #d3d3d3;
   @KpiTableWidth: 230px;
 
   *,
@@ -12,7 +13,9 @@
     pointer-events: none;
   }
 
-  .grid-cells {
+  ._cell(@Width: 50px) {
+    min-width: @Width !important;
+    max-width: @Width !important;
     cursor: pointer;
     line-height: 1em !important;
   }
@@ -30,17 +33,18 @@
   }
 
   table {
-    border-collapse: separate;
-    border-spacing: 1px;
+    border-collapse: collapse;
+    border-spacing: 0;
     width: auto;
+    border-left: @TableBorder;
+    border-right: @TableBorder;
+    border-top: @TableBorder;
   }
 
-  tr {
-    height: 25px;
-  }
-  
   td,
   th {
+    border: 1px solid #fff;
+    border-collapse: collapse;
     padding: 5px !important; // prevent overwriting from single object
     white-space: nowrap;
     overflow: hidden;
@@ -57,19 +61,107 @@
   }
 
   .empty {
+    width: 3%;
     background: #fff;
-    padding: 0 !important;
+    min-width: 4px !important;
+    max-width: 4px !important;
   }
 
   th.main-kpi {
     text-align: center;
     vertical-align: middle;
+    border-bottom: @TableBorder;
   }
 
   .numeric {
     text-align: right;
   }
 
+  // This is for wrap text in headers 
+  .wrapclass25 {
+    width: 100%;
+    height: inherit;
+    white-space: pre-line;
+    overflow: hidden;
+    display: block;
+    text-overflow: ellipsis;
+  }
+
+  .wrapclass70 {
+    width: 100%;
+    height: 70px;
+    white-space: pre-line;
+    overflow: hidden;
+    display: inline-block;
+    vertical-align: middle;
+    line-height: 20px;
+  }
+
+  .wrapclassEmpty {
+    width: 100%;
+  }
+
+  // ***************** 
+  // Medium column size 
+  // ***************** 
+
+  .grid-cells {
+    position: relative;
+    ._cell(70px);
+  }
+
+  .grid-cells2 {
+    ._cell(70px);
+  }
+
+  .grid-cells-small {
+    ._cell(52px);
+  }
+
+  .grid-cells2-small {
+    ._cell(52px);
+  }
+
+  // ***************** 
+  // Small column size 
+  // ***************** 
+  .grid-cells-s {
+    ._cell(67px);
+  }
+
+  .grid-cells2-s {
+    ._cell(67px);
+  }
+
+  .grid-cells-small-s {
+    ._cell(52px);
+  }
+
+  .grid-cells2-small-s {
+    ._cell(52px);
+  }
+
+  // ***************** 
+  // Large column size 
+  // ***************** 
+  .grid-cells-l {
+    ._cell(82px);
+  }
+
+  .grid-cells2-l {
+    ._cell(82px);
+  }
+
+  .grid-cells-small-l {
+    ._cell(66px);
+  }
+
+  .grid-cells2-small-l {
+    ._cell(66px);
+  }
+
+  // END OF GRID CELLS
+
   // First Column 
   .fdim-cells {
     min-width: 230px !Important;
@@ -78,12 +170,25 @@
     background-color: #fff;
   }
 
-  tbody tr:hover td {
+  .fdim-cells:hover {
+    background-color: #808080 !important;
+    color: #fff;
+  }
+
+  tbody tr:hover {
     cursor: default;
     background-color: #808080 !important;
     color: #fff;
   }
 
+  .grid-cells-header {
+    padding: 0;
+  }
+
+  .grid-cells-title {
+    min-width: 522px;
+  }
+
   .grid {
     height: 50px;
     width: 350px;
@@ -97,64 +202,33 @@
     border: groove;
   }
 
-  .root {
-    display: flex;
-    flex-direction: row;
-    flex-wrap: nowrap;
-    height: 100%;
-    width: 100%;
-  }
-
-  .error {
-    position: absolute; /*Define position */
-    width: 100%; /* Full width (cover the whole page) */
-    height: 100%; /* Full height (cover the whole page) */
-    top: 0;
-    left: 0;
-    right: 0;
-    bottom: 0;
-    z-index: 1000; /* Specify a stack order in case you're using a different order for other elements */
-    display: flex;
-    justify-content: center;
-    align-items: center;
-  }
-
   .kpi-table .fdim-cells,
   .data-table td {
     line-height: 1em !important;
   }
 
+  .data-table .fdim-cells {
+    display: none;
+  }
+
   .kpi-table {
-    display: flex;
-    flex-direction: column;
-    flex-wrap: nowrap;
-    flex: none;
     width: @KpiTableWidth !important;
+    overflow: hidden !important;
+    height: 100%;
     margin: 0;
     padding: 0;
-
-    .header-wrapper {
-      flex: none;
-      box-shadow: 4px 2px 8px #e1e1e1;
-    }
+    position: absolute;
+    top: 0;
+    left: 0;
+    border-right: 1px solid #fff;
+    box-shadow: 4px 2px 8px #e1e1e1;
 
     .row-wrapper {
+      height: calc(~"100% - 97px");
       overflow: scroll;
-      margin: 0;
-      margin-bottom: 8px;
+      position: absolute;
       padding: 0;
-      box-shadow: 4px 2px 8px #e1e1e1;
-      min-height: 0; /* This is to make flex size-filling work */
-
-      /* Adapt for Edge */
-      @supports (-ms-ime-align: auto) {
-        margin-bottom: 16px;
-      }
-
-      /* Adapt for IE11 */
-      @media screen and (-ms-high-contrast: none) {
-        margin-bottom: 16px;
-      }
+      margin-top: 0;
     }
   }
 
@@ -163,50 +237,27 @@
   }
 
   .data-table {
-    display: flex;
-    flex-direction: column;
-    flex-wrap: nowrap;
-    margin-left: 13px;
-    min-width: 0; /* This is to make flex size-filling work */
+    height: 100%;
+    width: calc(100% - 243px);
+    position: absolute;
+    margin-left: @KpiTableWidth + 13px;
 
     .header-wrapper {
-      flex: none;
       overflow: scroll;
-      margin-right: 8px;
+      width: 100%;
     }
 
     .row-wrapper {
-      overflow: scroll;
-      margin: 0;
-      padding: 0;
-      min-height: 0; /* This is to make flex size-filling work */
-
-      /* Style scrollbar for FF */
-      scrollbar-width: thin;
-      scrollbar-color: #d3d3d3 transparent;
-    }
-
-    /* Adapt for Edge */
-    @supports (-ms-ime-align: auto) {
-      .header-wrapper {
-        margin-right: 16px;
-      }
-    }
-
-    /* Adapt for IE11 */
-    @media screen and (-ms-high-contrast: none) {
+      height: calc(~"100% - 97px");
       width: 100%;
-      height: 100%;
-
-      .header-wrapper {
-        margin-right: 16px;
-      }
+      overflow: scroll;
+      padding: 0;
+      margin-top: 0;
     }
   }
 
   // hide scrollbars
   .kpi-table .header-wrapper,
-  .kpi-table .row-wrapper,
   .data-table .header-wrapper {
     // stylelint-disable-next-line property-no-unknown 
     scrollbar-width: none;

src/masking.js

@@ -0,0 +1,132 @@
+import { addSeparators } from './utilities';
+
+export function ApplyPreMask (mask, value) { // aqui
+  if (mask.indexOf(';') >= 0) {
+    if (value >= 0) {
+      switch (mask.substring(0, mask.indexOf(';'))) {
+        case '#.##0':
+          return (addSeparators(value, '.', ',', 0));
+        case '#,##0':
+          return (addSeparators(value, ',', '.', 0));
+        case '+#.##0':
+          return (addSeparators(value, '.', ',', 0));
+        case '+#,##0':
+          return (addSeparators(value, ',', '.', 0));
+        default:
+          return (applyMask(mask.substring(0, mask.indexOf(';')), value));
+      }
+    } else {
+      const vMyValue = value * -1;
+      let vMyMask = mask.substring(mask.indexOf(';') + 1, mask.length);
+      vMyMask = vMyMask.replace('(', '');
+      vMyMask = vMyMask.replace(')', '');
+      switch (vMyMask) {
+        case '#.##0':
+          return (`(${addSeparators(vMyValue, '.', ',', 0)})`);
+        case '#,##0':
+          return (`(${addSeparators(vMyValue, ',', '.', 0)})`);
+        case '-#.##0':
+          return (`(${addSeparators(vMyValue, '.', ',', 0)})`);
+        case '-#,##0':
+          return (`(${addSeparators(vMyValue, ',', '.', 0)})`);
+        default:
+          return (`(${applyMask(vMyMask, vMyValue)})`);
+      }
+    }
+  } else {
+    return (applyMask(mask, value));
+  }
+}
+
+function applyMask (originalMask, originalValue) {
+  if (!originalMask || isNaN(Number(originalValue))) {
+    return originalValue;
+  }
+
+  let isNegative;
+  let result;
+  let integer;
+  // find prefix/suffix
+  let len = originalMask.length;
+  const start = originalMask.search(/[0-9\-\+#]/);
+  const prefix = start > 0 ? originalMask.substring(0, start) : '';
+  // reverse string: not an ideal method if there are surrogate pairs
+  let str = originalMask.split('')
+    .reverse()
+    .join('');
+  const end = str.search(/[0-9\-\+#]/);
+  let offset = len - end;
+  const substr = originalMask.substring(offset, offset + 1);
+  let index = offset + ((substr === '.' || (substr === ',')) ? 1 : 0);
+  const suffix = end > 0 ? originalMask.substring(index, len) : '';
+
+  // mask with prefix & suffix removed
+  let mask = originalMask.substring(start, index);
+
+  // convert any string to number according to formation sign.
+  let value = mask.charAt(0) === '-' ? -originalValue : Number(originalValue);
+  isNegative = value < 0 ? value = -value : 0; // process only abs(), and turn on flag.
+
+  // search for separator for grp & decimal, anything not digit, not +/- sign, not #.
+  result = mask.match(/[^\d\-\+#]/g);
+  const decimal = (result && result[result.length - 1]) || '.'; // treat the right most symbol as decimal
+  const group = (result && result[1] && result[0]) || ','; // treat the left most symbol as group separator
+
+  // split the decimal for the format string if any.
+  mask = mask.split(decimal);
+  // Fix the decimal first, toFixed will auto fill trailing zero.
+  value = value.toFixed(mask[1] && mask[1].length);
+  value = String(Number(value)); // convert number to string to trim off *all* trailing decimal zero(es)
+
+  // fill back any trailing zero according to format
+  const posTrailZero = mask[1] && mask[1].lastIndexOf('0'); // look for last zero in format
+  const part = value.split('.');
+  // integer will get !part[1]
+  if (!part[1] || (part[1] && part[1].length <= posTrailZero)) {
+    value = (Number(value)).toFixed(posTrailZero + 1);
+  }
+  const szSep = mask[0].split(group); // look for separator
+  mask[0] = szSep.join(''); // join back without separator for counting the pos of any leading 0.
+
+  const posLeadZero = mask[0] && mask[0].indexOf('0');
+  if (posLeadZero > -1) {
+    while (part[0].length < (mask[0].length - posLeadZero)) {
+      part[0] = `0${part[0]}`;
+    }
+  } else if (Number(part[0]) === 0) {
+    part[0] = '';
+  }
+
+  value = value.split('.');
+  value[0] = part[0];
+
+  // process the first group separator from decimal (.) only, the rest ignore.
+  // get the length of the last slice of split result.
+  const posSeparator = (szSep[1] && szSep[szSep.length - 1].length);
+  if (posSeparator) {
+    integer = value[0];
+    str = '';
+    offset = integer.length % posSeparator;
+    len = integer.length;
+    for (index = 0; index < len; index++) {
+      str += integer.charAt(index); // ie6 only support charAt for sz.
+      // -posSeparator so that won't trail separator on full length
+      // jshint -W018
+      if (!((index - offset + 1) % posSeparator) && index < len - posSeparator) {
+        str += group;
+      }
+    }
+    value[0] = str;
+  }
+  value[1] = (mask[1] && value[1]) ? decimal + value[1] : '';
+
+  // remove negative sign if result is zero
+  result = value.join('');
+  if (result === '0' || result === '') {
+    // remove negative sign if result is zero
+    isNegative = false;
+  }
+
+  // put back any negation, combine integer and fraction, and add back prefix & suffix
+  return prefix + ((isNegative ? '-' : '') + result) + suffix;
+}

src/paint.jsx

@@ -0,0 +1,28 @@
+import initializeStore from './store';
+import React from 'react';
+import ReactDOM from 'react-dom';
+import Root from './root.jsx';
+import { initializeCubes } from './dataset';
+
+export default async function paint ($element, layout, component) {
+  const cubes = await initializeCubes({
+    component,
+    layout
+  });
+  const state = await initializeStore({
+    $element,
+    component,
+    cubes,
+    layout
+  });
+  const editmodeClass = component.inAnalysisState() ? '' : 'edit-mode';
+  const jsx = (
+    <Root
+      qlik={component}
+      state={state}
+      editmodeClass={editmodeClass}
+    />
+  );
+
+  ReactDOM.render(jsx, $element[0]);
+}

src/root.jsx

@@ -1,121 +1,60 @@
-import React from "react";
-import PropTypes from "prop-types";
-import HeadersTable from "./headers-table/index.jsx";
-import DataTable from "./data-table/index.jsx";
-import { LinkedScrollWrapper, LinkedScrollSection } from "./linked-scroll";
+import React from 'react';
+import PropTypes from 'prop-types';
+import HeadersTable from './headers-table/index.jsx';
+import DataTable from './data-table/index.jsx';
+import { LinkedScrollWrapper, LinkedScrollSection } from './linked-scroll';
 
-class Root extends React.PureComponent {
-  render () {
-    const { editmodeClass, component, state } = this.props;
-    const { data, general, styling, error, element } = state;
-
-    // Determine cell- and column separator width
-    let cellWidth = '0px';
-    let columnSeparatorWidth = '';
-    if (!error && element) {
-      const tableWidth = element.getBoundingClientRect().width;
-
-      if (general.cellWidth) {
-        cellWidth = general.cellWidth;
-        if (general.useColumnSeparator) {
-          columnSeparatorWidth = '8px';
-        }
-      } else {
-        // 230 is the left "header", rest is magic margins
-        const headerMarginRight = 8 + 230 + 20;
-        const borderWidth = 1;
-        const rowCellCount = data.matrix[0].length;
-
-        let separatorCount = 0;
-        let separatorWidth = 0;
-        if (general.useColumnSeparator) {
-          separatorCount = data.headers.dimension2.length - 1;
-          separatorWidth = Math.min(
-            Math.floor((tableWidth * 0.2) / separatorCount),
-            8
-          );
-          columnSeparatorWidth = `${separatorWidth}px`;
-        }
-
-        const separatorWidthSum =
-          (separatorWidth + borderWidth) * separatorCount;
-        cellWidth = `${Math.floor(
-          (tableWidth - separatorWidthSum - headerMarginRight - borderWidth) /
-            rowCellCount) - borderWidth}px`;
-      }
-    }
-
-    return (
-      <div className="root">
-        {error ? (
-          <div className={`error ${editmodeClass}`}>
-            {state.layout.errormessage}
-          </div>
-        ) : (
-          <LinkedScrollWrapper>
-            <div className={`kpi-table ${editmodeClass}`}>
-              <HeadersTable
-                cellWidth={cellWidth}
-                columnSeparatorWidth={columnSeparatorWidth}
-                component={component}
-                data={data}
-                general={general}
-                isKpi
-                styling={styling}
-              />
-              <LinkedScrollSection linkVertical>
-                <DataTable
-                  cellWidth={cellWidth}
-                  columnSeparatorWidth={columnSeparatorWidth}
-                  component={component}
-                  data={data}
-                  general={general}
-                  renderData={false}
-                  styling={styling}
-                />
-              </LinkedScrollSection>
-            </div>
-            <div
-              className={`data-table ${editmodeClass}`}
-              style={{ width: general.cellWidth ? 'auto' : '100%' }}
-            >
-              <LinkedScrollSection linkHorizontal>
-                <HeadersTable
-                  cellWidth={cellWidth}
-                  columnSeparatorWidth={columnSeparatorWidth}
-                  component={component}
-                  data={data}
-                  general={general}
-                  isKpi={false}
-                  styling={styling}
-                />
-              </LinkedScrollSection>
-              <LinkedScrollSection linkHorizontal linkVertical>
-                <DataTable
-                  cellWidth={cellWidth}
-                  columnSeparatorWidth={columnSeparatorWidth}
-                  component={component}
-                  data={data}
-                  general={general}
-                  styling={styling}
-                />
-              </LinkedScrollSection>
-            </div>
-          </LinkedScrollWrapper>
-        )}
-      </div>
-    );
-  }
-}
+const Root = ({ state, qlik, editmodeClass }) => (
+  <LinkedScrollWrapper>
+    <div className={`kpi-table ${editmodeClass}`}>
+      <HeadersTable
+        data={state.data}
+        general={state.general}
+        qlik={qlik}
+        styling={state.styling}
+      />
+      <LinkedScrollSection linkVertical>
+        <DataTable
+          data={state.data}
+          general={state.general}
+          qlik={qlik}
+          renderData={false}
+          styling={state.styling}
+        />
+      </LinkedScrollSection>
+    </div>
+    <div className={`data-table ${editmodeClass}`}>
+      <LinkedScrollSection linkHorizontal>
+        <HeadersTable
+          data={state.data}
+          general={state.general}
+          qlik={qlik}
+          styling={state.styling}
+        />
+      </LinkedScrollSection>
+      <LinkedScrollSection
+        linkHorizontal
+        linkVertical
+      >
+        <DataTable
+          data={state.data}
+          general={state.general}
+          qlik={qlik}
+          styling={state.styling}
+        />
+      </LinkedScrollSection>
+    </div>
+  </LinkedScrollWrapper>
+);
 
 Root.propTypes = {
-  component: PropTypes.shape({}).isRequired,
-  editmodeClass: PropTypes.string.isRequired,
+  qlik: PropTypes.shape({}).isRequired,
   state: PropTypes.shape({
-    data: PropTypes.object,
-    general: PropTypes.object,
-    styling: PropTypes.object
-  }).isRequired
+    data: PropTypes.object.isRequired,
+    general: PropTypes.object.isRequired,
+    styling: PropTypes.object.isRequired
+  }).isRequired,
+  editmodeClass: PropTypes.string.isRequired
 };
 
 export default Root;

src/store.js

@@ -1,11 +1,10 @@
 import initializeTransformed from './initialize-transformed';
 
-async function initialize ({ $element, layout, component, dataCube, designList }) {
+async function initialize ({ $element, layout, component, cubes }) {
   const transformedProperties = await initializeTransformed({
     $element,
     component,
-    dataCube,
-    designList,
+    cubes,
     layout
   });
 

src/tooltip/index.jsx

@@ -25,21 +25,23 @@ class Tooltip extends React.PureComponent {
   }
 
   render () {
-    const { children, styling, tooltipText } = this.props;
+    const { children, tooltipText } = this.props;
     const { showTooltip } = this.state;
+
     return (
       <div
         onMouseMove={handleCalculateTooltipPosition}
         onMouseOut={this.handleRenderTooltip}
         onMouseOver={this.handleRenderTooltip}
-        style={{ fontFamily: styling.options.fontFamily }}
       >
         {children}
 
         {showTooltip
           ? (
-            <div className="tooltip-wrapper">
-              <p style={{ fontFamily: styling.options.fontFamily }}>
+            <div
+              className="tooltip-wrapper"
+            >
+              <p>
                 {tooltipText}
               </p>
             </div>
@@ -54,11 +56,6 @@ Tooltip.propTypes = {
     PropTypes.arrayOf(PropTypes.node),
     PropTypes.node
   ]).isRequired,
-  styling: PropTypes.shape({
-    options: PropTypes.shape({
-      fontFamily: PropTypes.string.isRequired
-    }).isRequired
-  }).isRequired,
   tooltipText: PropTypes.string.isRequired
 };
 

src/utilities.js

@@ -9,6 +9,21 @@ export function distinctArray (array) {
     .map(entry => JSON.parse(entry));
 }
 
+export function addSeparators (number, thousandSeparator, decimalSeparator, numberOfDecimals) {
+  const numberString = number.toFixed(numberOfDecimals);
+  const numberStringParts = numberString.split('.');
+  let [
+    wholeNumber,
+    decimal
+  ] = numberStringParts;
+  decimal = numberStringParts.length > 1 ? decimalSeparator + decimal : '';
+  const regexCheckForThousand = /(\d+)(\d{3})/;
+  while (regexCheckForThousand.test(wholeNumber)) {
+    wholeNumber = wholeNumber.replace(regexCheckForThousand, `$1${thousandSeparator}$2`);
+  }
+  return wholeNumber + decimal;
+}
+
 export function Deferred () {
   this.promise = new Promise((resolve, reject) => {
     this.resolve = resolve;
@@ -16,7 +31,7 @@ export function Deferred () {
   });
 }
 
-export function injectSeparators (array, columnSeparatorWidth, suppliedOptions) {
+export function injectSeparators (array, shouldHaveSeparator, suppliedOptions) {
   const defaultOptions = {
     atEvery: 1,
     separator: { isSeparator: true }
@@ -26,7 +41,7 @@ export function injectSeparators (array, columnSeparatorWidth, suppliedOptions)
     ...suppliedOptions
   };
 
-  if (!columnSeparatorWidth) {
+  if (!shouldHaveSeparator) {
     return array;
   }
   return array.reduce((result, entry, index) => {

stylelint.config.js

@@ -84,7 +84,7 @@ module.exports = {
     'indentation': 2,
     'length-zero-no-unit': true,
     'max-empty-lines': 1,
-    'max-nesting-depth': 5,
+    'max-nesting-depth': 3,
     'media-feature-colon-space-after': 'always',
     'media-feature-colon-space-before': 'never',
     'media-feature-name-case': 'lower',

webpack.config.js

@@ -2,16 +2,13 @@ const StyleLintPlugin = require('stylelint-webpack-plugin');
 const packageJSON = require('./package.json');
 const path = require('path');
 
-const DIST = path.resolve('./dist');
-// eslint-disable-next-line no-process-env
+const DIST = path.resolve("./dist");
 const MODE = process.env.NODE_ENV || 'development';
-const SOURCE_MAP = 'source-map';
-const DEVTOOL = MODE === 'development' ? SOURCE_MAP : false;
 
 console.log('Webpack mode:', MODE); // eslint-disable-line no-console
 
 const config = {
-  devtool: DEVTOOL,
+  devtool: 'source-map',
   entry: ['./src/index.js'],
   externals: {
     jquery: {