Examples with FormulaTooltipErrorReporter org.eclipse.nebula.widgets.nattable.formula.FormulaTooltipErrorReporter used on opensource projects

Example 1 with FormulaTooltipErrorReporter

use of org.eclipse.nebula.widgets.nattable.formula.FormulaTooltipErrorReporter in project nebula.widgets.nattable by eclipse.

the class _305_FormulaDataExample method createExampleControl.

@Override
public Control createExampleControl(Composite parent) {
    Composite panel = new Composite(parent, SWT.NONE);
    panel.setLayout(new GridLayout());
    GridDataFactory.fillDefaults().grab(true, true).applyTo(panel);
    // TODO add combo box and text field for editing formulas
    Composite gridPanel = new Composite(panel, SWT.NONE);
    gridPanel.setLayout(new GridLayout());
    GridDataFactory.fillDefaults().grab(true, true).applyTo(gridPanel);
    Composite buttonPanel = new Composite(panel, SWT.NONE);
    buttonPanel.setLayout(new GridLayout());
    GridDataFactory.fillDefaults().grab(true, false).applyTo(buttonPanel);
    ConfigRegistry configRegistry = new ConfigRegistry();
    final FormulaGridLayer gridLayer = new FormulaGridLayer();
    final NatTable natTable = new NatTable(gridPanel, gridLayer, false);
    natTable.setConfigRegistry(configRegistry);
    natTable.addConfiguration(new DefaultNatTableStyleConfiguration());
    final FormulaBodyLayerStack bodyLayer = gridLayer.getBodyLayer();
    natTable.addConfiguration(new FillHandleConfiguration(bodyLayer.getSelectionLayer()));
    // This is the formula specific configuration
    natTable.addConfiguration(new DefaultFormulaConfiguration(bodyLayer.getFormulaDataProvider(), bodyLayer.getSelectionLayer(), natTable.getInternalCellClipboard()));
    bodyLayer.getFormulaDataProvider().setErrorReporter(new FormulaTooltipErrorReporter(natTable, bodyLayer.getDataLayer()));
    natTable.addConfiguration(new AbstractRegistryConfiguration() {

        @Override
        public void configureRegistry(IConfigRegistry configRegistry) {
            PoiExcelExporter exporter = new HSSFExcelExporter();
            exporter.setApplyBackgroundColor(false);
            exporter.setFormulaParser(bodyLayer.getFormulaDataProvider().getFormulaParser());
            configRegistry.registerConfigAttribute(ExportConfigAttributes.EXPORTER, exporter);
        }
    });
    natTable.configure();
    GridDataFactory.fillDefaults().grab(true, true).applyTo(natTable);
    final Button toggleFormulaButton = new Button(panel, SWT.PUSH);
    toggleFormulaButton.setText("Disable Formula Evaluation");
    toggleFormulaButton.addSelectionListener(new SelectionAdapter() {

        @Override
        public void widgetSelected(SelectionEvent e) {
            _305_FormulaDataExample.this.evaluationEnabled = !_305_FormulaDataExample.this.evaluationEnabled;
            if (_305_FormulaDataExample.this.evaluationEnabled) {
                natTable.doCommand(new EnableFormulaEvaluationCommand());
                toggleFormulaButton.setText("Disable Formula Evaluation");
            } else {
                natTable.doCommand(new DisableFormulaEvaluationCommand());
                toggleFormulaButton.setText("Enable Formula Evaluation");
            }
        }
    });
    return panel;
}