Desktop Integration Framework Custom Attribute Properties

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current solutions for custom attribute properties in spreadsheet software require extensive server-side programming, limiting the ability to drive dynamic interactions and customize the user interface experience.

Innovation Solution

The desktop integration framework provides evaluation support for custom attribute properties, allowing developers to define and bind custom properties to UI components using expressions, enabling dynamic customization of the user interface without the need for complex server-side code.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If custom attribute properties are implemented in spreadsheet software, then the ability to customize UI components and drive dynamic interactions is improved, but the complexity of server-side programming increases

Engineering Contradiction:
Improvecustomization capabilityVSAvoidserver-side programming complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent introduces an intermediary layer between the spreadsheet software and the server-side application logic. This intermediary consists of custom attribute properties that can be defined on data model attributes and referenced within expressions bound to UI components. The intermediary enables customization without requiring complex server-side programming by allowing developers to define custom properties (e.g., cell style, font properties, visibility) that are evaluated client-side through expressions like '#{bindings.{attr_id}.hints.{custom_property}}'. This resolves the contradiction by providing adaptability through custom properties while avoiding server-side complexity.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Extent of automation

If custom properties are bound to UI component properties using expressions, then the dynamic interaction capability is improved, but the evaluation complexity increases

Engineering Contradiction:
Improvedynamic interactionVSAvoidevaluation complexity
Core Design Contradiction:
Extent of automationVSDevice complexity

Solution Approach 1:

The patent implements self-service evaluation where the spreadsheet application itself evaluates the expressions containing custom attribute properties without requiring external server-side processing. The expression evaluation mechanism is built into the desktop integration framework, allowing UI components to automatically evaluate expressions like '#{bindings.EmpCompView1.hints.EmployeeId.cellStyle}' and apply the resulting custom properties. This resolves the contradiction by enabling dynamic interaction through automated expression evaluation while keeping the evaluation complexity manageable through integrated client-side processing.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS9948700B2ADFDI support for custom attribute properties
Publication Date: 2018.04.17 ORACLE INT CORP
  • US9948700B2 patent drawing
  • US9948700B2 patent drawing
  • US9948700B2 patent drawing

AI summary

In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that expand the ability of integrated workbook developers to drive the integrated workbook experience from model metadata by defining custom properties on model attributes and then binding those custom properties to UI component properties in desktop UI components.