meinsiedler / exceltableconverter Goto Github PK

The hash (#) and dollar symbols ($) are currently not considered as special char for LaTeX output. Add it to the list of special chars.

To allow unit testing of the Excel Extractors, wrap all classes in the Microsoft.Office.Interop.Excel namespace with own interfaces/classes to allow unit testing and mocking without needing to access the Interop-namespace directly.

Note, that this also allows running the unit tests on CI-servers, because an installed Excel is not required any more.

Provide a set of information for the Excel-Add in.
Possible information items are:

• Current version number (e.g. in the dialog title)
• Author
• Release date
• Link to GitHub repository
• License information

Check out the following blog post on how to create a "high quality table" with LaTeX: http://blog.explore-it.at/latex/high-quality-tables-with-latex

Add a border configuration method for LaTeX to support "high quality tables".

Currently, the "Quick Convert" context menu entry icon has a grey background.
=> Remove the grey background and set it to white/transparent.

• update to .NET 4.5
• remove prerequist .NET 3.5
• replace solution item with NuGet reference (e.g. nunit)
• create new PFX key for signing
• change NUnit assert.AreEqual(..) to new Assert.That(...) syntax
• fix NUnit tests

Link to releases: https://github.com/meinsiedler/ExcelTableConverter/releases
Link to changelog: https://github.com/meinsiedler/ExcelTableConverter/blob/master/CHANGELOG.md (this is the CHANGELOG from the master build, meaning the latest released changelog)

Currently, the table environment of the LaTeX converter is generated with \begin{table}[!ht]. Remove the [!ht] position setting.

Position settings should not be concerned by the ExcelTableConverter, because the ExcelTableConverter is just good for converting to target formats, but does not consider additional position settings for the produced table in the target environment.

Add a "Save as default" button which saves the current settings for the user. When restarting Excel, these settings should automatically get applied.
With this feature it is possible that a user stores his favored target table format and other extended settings.

Implementation notes

• Configuration is stored in users's AppData folder
• Stored configuration will be overridden when "Save as default" button is pressed multiple times
• also consider "auto save" option so instead of "Save as default" button

The convert dialog opens always on the upper left corner of the screen with some horizontal and vertical offset.

When working with two screens and Excel is open on the right screen, the convert dialog still opens in the upper left corner of the left screen.

=> Open the convert dialog in the middle of the Excel window

Add support for markdown tables which look like this:

| Tables | Are  | Cool |
| ------ |------| -----|
| 1      | 2    | 3    |
| 4      | 5    | 6    |
| 7      | 8    | 9    |

Notes:

1. Since most of the markdown parsers do not support tables without headers, the first row will always be a header row.
2. Alignment of columns is not supported in the first step.
3. Pretty printing is also not implemented in the first step. (see #12)

When clicking on "Save" when no file is specified, a messagebox is shown ("specify file first")
=> Instead, open the save dialog when no file has been specified before. This improves the user experience.

When running multiple Excel instances, the Quick Convert context menu entry does only work on the first opened Excel instance.

The QuickConvertButton_Click event handler does not get fired for all other than the first instance.

Add a new "Extended Feature" for "Atlassian Jira" table format:
A checkbox "First row is header" which indicates that the first row in the selection should be treated as a header row in the converted Jira table.

Add an extended feature option "Pretty print" for LaTeX, Jira and Markdown output which aligns the columns so, that all column separators will be aligned one below the other.

For Jira output for example, instead of

| 1 | 22 | 333 |
| 4444 | 55 | 6666 |

with "Pretty print" enabled, the output is

| 1    | 22 | 333  |
| 4444 | 55 | 6666 |

Note that there are basically three options how the content should be aligned:

1. Let the user manually set the alignment of the content (left, right, center) for all cells.
2. Set alignment based on content type (e.g. right align numbers, left align text).
3. Set alignment based on the cell alignment in Excel.

❗️ Also note that column separators can have different length. For example, the Jira header column separator is || while the normal column separator is |.

Text is formatted bold => Jira format: *strong*
Text is formatted italics => Jira format: _emphasis_

This feature extends #14

Add two new Menu-Items:

• File -> Import Settings
• File -> Export Settings

where currently defined settings (Selected converter and Extended Features) can be imported and exported from/into a XML file.

The "Quick Convert" option is currently accessible through the context menu. It uses the current settings from the Convert-Dialog.

Create a new shortcut for the "Quick Convert" option to allow a faster conversion by using this shortcut.

TODO: Define, which shortcut should be used (check which shortcut is not in use and does not overlap with other shortcuts)

• Check if the current implementation allows an non-modal dialog. This would increase the user experience.
• Check if leaving the dialog open and then changing the selection still works. (The conversion considers the new selection)
• Also check, if this has any effect on the "Quick Convert" functionality.

When everything works out as expected, change the dialog from modal to non-modal.

Update the year from 2015 to 2017