excel-projects / script-help Goto Github PK

Add ribbon.ActivateTab("tabScriptHelp"); in the C# project

• Clipboard
  • Copy Visible Cells
• Format Data Table
  • Format As Table - add predefined table style
  • Convert to NULL
  • Clear Interior Color
  • Separate Values
• Add Script Column
  • T-SQL Create Table
  • T-SQL Insert Values
  • T-SQL Merge Values
  • T-SQL Select Union
  • T-SQL Update Values
  • PL/SQL Create Table
  • PL/SQL Insert Values
  • PL/SQL Merge Values
  • PL/SQL Select Union
  • PL/SQL Update Values
  • DQL Append
  • DQL Append/Locked
  • DQL Create
  • DQL Truncate/Append
  • DQL Update
  • DQL Update/Locked
  • GitHub Table
  • HTML Table
  • XML Values
• Format Script Options
  • Table Alias
  • Date Format
  • Paste Format
  • Create File List

• Add Script Formula
  • T-SQL Create Table
  • T-SQL Insert Values
  • T-SQL Merge Values
  • T-SQL Select Values
  • T-SQL Select Union
  • T-SQL Update Values
  • PL/SQL Create Table
  • PL/SQL Insert Values
  • PL/SQL Merge Values
  • PL/SQL Select Union
  • PL/SQL Update Values
  • DQL Append
  • DQL Append/Locked
  • DQL Create
  • DQL Truncate/Append
  • DQL Update
  • DQL Update/Locked
  • Markdown Table
  • HTML Table
  • XML Values

• PL/SQL Create Table - update the syntax from Microsoft to Oracle
• PL/SQL Merge Values - create a CTE with SELECT from DUAL for values in a MERGE statement
• PL/SQL Select Values - create a CTE with SELECT from DUAL for values

• Fix Separate Values button fails on column with all zero strings in C# version
• add keytips
• Change date format button to only work on selected column and change zero strings to null
• Change find and replace textboxes to date and time.
• Add getLabelText callback for script menu button labels
• Add a table for time formats
• Fix error on "Add Script Column" procedure on protected rows
• PL/SQL Create Table - update the syntax from Microsoft to Oracle
• PL/SQL Merge Values - create a CTE with SELECT from DUAL for values in a MERGE statement
• PL/SQL Select Values - create a CTE with SELECT from DUAL for values

• add new feature to insert value from ribbon combobox to datatable
• add keytips
• add Format Time Columns button
• update script syntax highlighting

Update install instructions for both VBA and VSTO versions.

• update date format to replace format
• update paste format to find format
• change order of dropdowns

• add logging to VBA version

Expected Behavior

Actual Behavior

Steps to Reproduce the Problem

Specifications

• Version:
• Platform:
• Subsystem:

• Separate Values button fails on column with all zero strings in C# version

I got the idea from https://www.codeproject.com/Articles/296288/Excel-Add-in-for-Exporting-Excel-data-to-XML

• change screenshots

• Create a new procedure to insert a new record to a data table if it doesn't exist and if the user selects to do so.

Update the published .Net GitHub version to current build

Add all functionality from C# version

• Fix certificate issue
  • Currently user must install AnthonyDuguid.pfx to the root of the machine before the install will run from GitHub
• Add version table to SQL Server CE (.sdf) file
  • Copy database to temp folder location and compare version table record
  • Delete existing database and copy new database if version is newer
• Add install instructions to Read Me file
  • C#
  • VB.NET
  • VBA

Calc font size based on current height & width of user control. Resize on event as well as drop-down in toolbar. 2 options "fit" and reference current font size in sheet.