Microsoft Technology Licensing, LLC

Anson An-Chun Tsao

Steven Mark Drucker

Roland Lucas Fernandez

Danyel Aharon Fisher

Xiaoji Chen

Yang Cao

Vikram Padmakar Bapat

Oscar Pawel Kozlowski

Robert Scott Silverstein

Pusheng Zhang

Descried herein are various technologies to visualizing data in a spreadsheet application. Customized visualizations are generated by binding a user-defined equation with a parameter of a primitive visual shape that has been selected by the user to visualized a dataset. The user-defined equation takes as input a value of data in a cell of the spreadsheet application, and the primitive visual shape is displayed to the user as a function of the output of the user-defined equation.

Generating customized data bound visualizations

Porting between local, cluster, and cloud execution is aided by using the same source code for multiple data sources. A data source identifier recited in source code maps to data sources at different execution targets. Executable codes tailored to successive targets are produced using a resolution API without changing the developer's source code. An editable data source mapping is per-project, maintained in a file or project property, and placed in a distributable software package with executable code. Burdens on developers to determine execution targets in their source code and explicitly handle different execution locations in the source code are reduced. Source code can be freed of absolute path data source identifiers or code for detecting execution location. Source-to-source translation injects calls to create a folder, file, or cloud container. Data source resolution can be based on a relative path rooted at the data source identifier.

Transformational context-aware data source management

Growing community of inventors

Redmond, WA, United States of America

Anson An-Chun Tsao