Making new thread for this since our old release thread was a mile long.
From the tight chambers of the Ellington hotel in Berlin I am releasing ExcelWriter Plugin 1.0 and e-CryptIt Engine 13.1.1
ExcelWriter Plugin for Xojo is new, but we have had it in beta testing for many weeks.
[b]Plugin feature highlights:
ExcelWriter Plugin for Xojo.[/b]
Native modern xlsx file format
Full UTF8 support
Works on all platforms, and Excel application does not need to be present
Formulas
Formatting
Graphs
Pictures
And much much more
I know there is more that we can add and we will continue to gradually add to it.
e-CryptIt Engine 13.1.1 is needed to provide compressor for the ExcelWriter file format. Note 13.1 will not work and will likely just crash, so be sure to update to 13.1.1
New in e-CryptIt Engine 13.1.1:
Improved the ZipEngineHandle object internally to support the ExcelWriter plugin.
Björn
PythonScript Plugin 2.5 is out
With PythonScript you can make your Xojo Application scriptable with Python. Or you can use the plugin to bridge into scientific and other libraries that exist for Python, giving your Xojo application ability to use them.
New in 2.5:
[i] * Added DictionaryValue Getter / Setter to the PythonParameter
class to allow to assign dictionaries to parameters.
- Added IsDictionary function to the PythonParameter class.
- Added TupleValue Getter / Setter to the PythonParameter class
to allow to assign PythonParameters (Tuples) to parameters. - Added IsTuple function to the PythonParameter class.[/i]
More info to be found at www.einhugur.com
ExcelWriter Plugin 1.1 has been released
[b]Plugin feature highlights:
ExcelWriter Plugin for Xojo.
[/b]
Native modern xlsx file format
Full UTF8 support
Works on all platforms, and Excel application does not need to be present
Formulas
Formatting
Graphs
Pictures
And much much more
New in 1.1:
Added ExcelWriterChartFont class.
Added ChartAreaSetPattern method to the ExcelWriterChart class.
Added PlotAreaSetPattern method to the ExcelWriterChart class.
Added SetNameFont method to the ExcelWriterChart class.
Added SetNameFont method to the ExcelWriterAxis class.
Added SetNumberFont method to the ExcelWriterAxis class.
Added SetLegendFont method to the ExcelWriterChart class.
Added HideSpecificSeries method to the ExcelWriterChart class.
Added InvertIfNegative property to the ExcelWriterSeries class.
Added DoughnutHoleSize property to the ExcelWriterChart class.
Added PrintingSetRepeatColumns method to the ExcelWriterWorksheet class.
Added PrintingSetRepeatRows method to the ExcelWriterWorksheet class.
e-CryptIt Engine 13.1.1 is needed to provide compressor for the ExcelWriter file format. Note 13.1 will not work and will likely just crash, so be sure to update to 13.1.1
More info to be found at www.einhugur.com
TreeView 7.5 has been released.
The TreeView is a Xojo control plugin to create tree views. The TreeView will run with native theme rendering look and feel on all platforms.
New in TreeView 7.5:
- Added Hi-DPI support for Windows systems.
(Note: known issue currently is that Xojo’s rounding causes row line artifact when on uneven DPI)
more info at www.einhugur.com
PDF Plugin 1.2.4 is out
[b]PDF Plugin is a Xojo plugin to generate PDF documents.
The plugin supports:
[/b]
Embedding TrueType fonts
Automatic encoding detection and mapping to PDF stock encodings.
Images.
Clickable links from the PDF document to web pages.
Clickable links from the PDF document to different locations within the PDF document.
Clickable zones to get text annotations in popup bubbles.
Advanced drawing.
Setting up the PDF outline tree.
And more.
New in 1.2.4:
[i]* Fixed the MeasureText function on the Page class so that it now actually returns what it is documented to return.
- Added another variation of the MeasureText function that can also measure the real with of the text.[/i]
more info at www.einhugur.com
[b]PDF Plugin 1.3
PDF Plugin is a Xojo plugin to generate PDF documents.[/b]
The plugin supports:
Embedding TrueType fonts
Automatic encoding detection and mapping to PDF stock encodings.
Images.
Clickable links from the PDF document to web pages.
Clickable links from the PDF document to different locations within the PDF document.
Clickable zones to get text annotations in popup bubbles.
Advanced drawing.
Setting up the PDF outline tree.
PDF Coordinates with Y1 at bottom or Xojo Coordinates with Y1 at top.
And more.
New in 1.3:
[i]* Added TransformCoordinates property to the Page class, allowing you to draw the PDF pages in coordinate system that your used to with y starting at top.
- Added two new example projects to show use of Top to bottom coordinates.
- Fixed bug with MoveTextPositionNextLine function on the Page class where it was internally calling wrong function on most platforms.
- Fixed issue deep in the library that is used under the hood that would cause TextRect function and on the Page class to leave the TextLeading property in different state after the function is called than it was before the call.[/i]
more info at www.einhugur.com
I also wanted to touch on the subject of Gtk3 in Xojo 2017r2.
[i]Right now we do not have anything that supports Gtk3, so if you want to compile for Linux using plugins then use Xojo older than 2017r2.
Some plugins that do not use any controls, user interface or Pictures might work, like Cryptography is likely to just work as is.
We will soon start to put out Gtk3 plugins updating our line of plugins one by one.
[/i]
PictureEffectsRaw 2.5, TypeLib 8.1 and TypeLibF 2.2 are out
PictureEffectsRaw is a Xojo plugin to do effects on Raw picture buffers, that originate from MemoryBlocks, using up to 8 CPU cores at once. (We use RawBitmaps for example in our PDF Plugin, Excel Writer, and Barcode plugin). We also have this Plugins big brother that has more effects and operates on Picture objects.
New in PictureEffectsRaw 2.5:
* Added example project for the new Polygon making feature that comes from the new TypeLib 8.1, all effects in the plugin that support masking, old and new can do Polygon masking.
* Added MapEffectRaw class that inherits from MPImageFilterRaw.
* Added GainEffectRaw class that inherits from MapEffectRaw.
* Added EqualizeEffectRaw class that inherits from MapEffectRaw.
* Added ExposureEffectRaw class that inherits from MapEffectRaw.
* Added ContrastStretchEffectRaw class that inherits from
MapEffectRaw.
* Added example projects for all the new effects.
* The plugin has been tested against Xojo 2017r2 on Linux
(for GTK3 issues).
New in TypeLib 8.1:
* The plugin now comes in two versions one for Xojo 2017r1 and older (GTK2 on Linux systems) and one for Xojo 2017r2 and newer (GTK3 on Linux systems).
* Added DrawBitmap method to the RawBitmap class.
* Added two new constructors to the RawBitmapMask class that add Polygon masking feature.
New in TypeLibF 2.2:
* Updated the PolygonF class to be able to internally support the new Polygon masking feature in TypeLib’s RawBitmapMask class.
* The plugin has been tested against Xojo 2017r2 on Linux (for GTK3 issues).
more info at www.einhugur.com
ExcelWriter Plugin 1.2 and e-CryptIt Engine 13.1.4 are out
New in ExcelWriter Plugin 1.2:
[i] * Added missing Console safe flag on ExcelWriterWorkbook.Create
shared method (both variations).
- Added missing Console safe flag on ExcelWriterSheet.NameToRow
shared method. - Added missing Console safe flag on ExcelWriterSheet.NameToColumn
shared method. - Added missing Console safe flag on ExcelWriterSheet.NameToLastColumn
shared method.[/i]
Plugin feature highlights:
Native modern xlsx file format
Full UTF8 support
Works on all platforms, and Excel application does not need to be present
Formulas
Formatting
Graphs
Pictures
And much much more
Console and Desktop applications
Those changes make the plugin no work in Console application
The plugin has also been tested against Xojo’s 2017r2 GTK3 on Linux and passes without issues as long as the new TypeLib 8.1 is used.
New in e-CryptIt Engine 13.1.4:
* ZStream.GetZipEngineHandle is now marked as Console safe
so that other plugins such as ExcelWriter and PDF Plugin
can work in console applications.
Those changes help making the ExcelWriter Plugin and PDF plugin work in console applications.
The plugin has also been partially tested against Xojo’s 2017r2 GTK3 on Linux and passes without issues as long as the new TypeLib 8.1 is used.
(Other parts of the plugin are expected to pass Gtk3 test as well)
more info at www.einhugur.com
WindowSplitter 9.0 is out
WindowSplitter is a Xojo plugin control to create split views in forms.
New in WindowSplitter 9.0:
- Added support for HiDPI on Linux systems.
- The plugin now comes in two versions one for Xojo 2017r1 and older (GTK2 on Linux systems) and one for Xojo 2017r2
and newer (GTK3 on Linux systems).
Note that on Ubuntu when the WindowSplitter is in Linux Native mode it draws nothing. Ubuntu’s GTK3 test code for this theme part seems to give same result. We were able to verify that drawing is working when testing on Armbian under native mode where it does actually draw the knob.
more info at www.einhugur.com
Thanks, Bjorn!!!
CalendarControl 7.0 is out
New in 7.0: [i]
- Added retina support on Mac systems.
- Added Hi-DPI support on Windows systems.
- Added Hi-DPI support on Linux systems.
- Added GTK3 support on Linux systems.
- Fine tuned drawing on Mac, Linux and Windows systems.
- Added new retina and high DPI compatible icon for the control.[/i]
Note that the header will be white on some distros under GTK3 until Xojo fixes bug number:
49442 - FillColor not working correctly on GTK3.
Note though white looks pretty decent, so good actually that we will probably add property to set the header color in next version.
The following images are from Ubuntu 16 - 64 bit showing Hi-DPI mode 1x, 2x and 3x
more info at www.einhugur.com
TypeLib 8.2 is out
New in 8.2:
Added supporting for Picture type: pictureD2DPBGRAPtr in the RawBitMapConverter class for the ToPicture and FromPicture functions. Supporting this is very important since Xojo 2017 uses mostly this type on Windows systems for Pictures.
(Basically this update is must have for Windows user that uses Xojo 2017 (maybe late 2016) and uses ExcelWriter, PDF Plugin or any plugin that does RawBitmap handling in some way)
more info at www.einhugur.com
At the MBS Xojo conference in Berlin when I released the Excel Writer plugin then at least 2 users asked me if I would do ExcelReader also. I told them I would do basic reading of data but never full scale formatting. Nor would the reader ever be connected to the writer so you could open a document make one change and save it again.
Now ExcelReader 1.0 is out, and it has Basic reading of Data and some basic reading of formatting (Borders, colors, and some font info)
ExcelReader 1.0 can do basic import of data from Excel xlsx documents. As well as some import of basic formatting.
This component is at version 1.0 and is very basic, but we will add to it more depending on what we can do and what users need.
The ExcelReader 1.0 is Xojo Component and not a plugin but needs the Einhugur e-CryptIt Engine Compression and Einhugur TypeLib plugins.
more info at www.einhugur.com
PDF Plugin 1.3.2 is out
The plugin supports:
Embedding TrueType fonts
Automatic encoding detection and mapping to PDF stock encodings.
Images.
Clickable links from the PDF document to web pages.
Clickable links from the PDF document to different locations within the PDF document.
Clickable zones to get text annotations in popup bubbles.
Advanced drawing.
Setting up the PDF outline tree.
PDF Coordinates with Y1 at bottom or Xojo Coordinates with Y1 at top.
And more.
New in 1.3.2:
[i]* Changed MoveTextPositionNextLine on the Page class so that if TextLeading is zero then MoveTextPositionNextLine now auto calculates new TextLeading and sets TextLeading back to zero upon finishing.
- Changed ShowTextNextLine on the Page class so that if TextLeading is zero then ShowTextNextLine now auto calculates new TextLeading and sets TextLeading back to zero upon finishing.
- Added SuggestedTextLeading function to the Page class.
- The plugin has also passed tests for Gtk3 now[/i]
more info at www.einhugur.com
ExcelReader component 1.1 is out.
ExcelReader component is to read Excel documents with Xojo code. The component can read basic data from xlsx Excel documents as well as some formatting.
The component uses Einhugur e-CryptIt Engine Plugin and Einhugur TypeLib plugin.
New in 1.1:
[i] * Reading info about cell merges is now supported.
- Added MergeInfo property to the Cell class.
- Added New class called CellMergeInfo
- Added CellMergeInfoRecordCount read only property to the Worksheet class.
- Added CellMergeInfoRecord function to the Worksheet class.
- Added CellAddressToIndexes shared method to the Worksheet class
- Added ApplyAlignment property to the Format class
- Added HorizontalAlignment property to the Format class
- Added VerticalAlignment property to the Format class
- Added HorizontalAlignmentValues Enum to the Format class
- Added VerticalAlignmentValues Enum to the Format class
- Added AlignmentWrapText property to the Format class
- Added AlignmentTextRotation property to the Format class.
- Color conversion added support for Indexed color in addition to the existing Theme and RGB colors.
- Renamed the ForeColor property on the Format class to ForegroundColor
- Improved theme color handling
- Added support for reading fill colors.
- Added Fill class.
- Added Fill property to the Format class.[/i]
more info at www.einhugur.com
Any idea if/when other controls are going to get updated for Linux GTK3? In need of Date, Time control for a current project.
Its in the works PictureButton is close to ready, but has been on hold because of Xojo bug on windows that they say now has been fixed. TimeControl is something that will be attempted soon, as that one is like minor subset of the problems that we will face in the date control.
If everything goes well with the TimeControl then there is possibility of taking temporary shortcut with the DateControl, that is to put out DateControl without dropdown on Gtk3 to get it out faster.
But first thing is to see what problems we hit in the TimeControl since things are won or lost depending on what Theme elements can be rendered and how.
DateControl 7.0 and TimeControl 6.5 are out
New in DateControl 7.0:
* Added Hi-DPI support on Linux systems.
* Added GTK3 support on Linux systems.
New in TimeControl 6.5:
* Added Hi-DPI support on Linux systems.
* Added GTK3 support on Linux systems.
DateControl is a control to select dates, it works on all the desktop platforms, offers ability to select Null Dates (empty dates) and has many other features.
TimeControl is a control to select time and like the DateControl it works on all the desktop platforms.
more info at www.einhugur.com
[b]DateControl 7.0.2 is out
New in 7.0.2:[/b]
* Fixed the Checkbox for empty dates for the new Gtk3.
* Improved Checkbox disabled state for legacy Gtk2.
more info at www.einhugur.com