I notice that the Grid Export filters do not export angled text. This prevents me from exporting properly the top heading row of an AdvStringGrid where the text is at 90 degrees. I see a tall cell with only the first two characters of the cell content in each cell.
Is this a limitation or a bug? If I export to XLSX I can manually change the orientation of the row afterwards (or could reload and fix it in Flexcel), but this does not help for PDF.
To what format exactly do you export?
If this is to Excel, do you use TMS Grid Filters with TMS Flexcel
Yes, I confirm that am exporting to Excel using TMS Grid Export Filters from the link you show, and that I also have TMS Flexcel. But as I said, all export formats with this feature are affected.
I have tried the export to PDF (and to HTML) and they also leave the text with normal orientation, just showing the first couple of characters in a tall thin cell. In the grid, the orientation is set to 900 and the text appears as expected. Word-wrap is off.
This is a very basic string grid, with mainly default settings. I just wrote a quick, simple program to read some files, do some calculations, and fill a sparse grid, but it is 54 columns across and so vertical headings are essential. I had hoped to do a plain export to XLSX and PDF.
Hi,
Is the text rotated with Grid.AddRotated?
If this is the case, it should work. I've made a sample app here:
In the export to html, the text is rotated by creating an image, because rotated text is not allowed in html 4, which is what the export targets. But in xlsx or pdf, the text should be rotated without issues.
I imagine that maybe you are using something different from AddRotated to rotate the text? Please let us know what you are doing different from the example app so we can see how it can be fixed.
Thanks, that fixed it. Since it was a "quick and dirty" program to analyse and report some data, I had simply loaded the list of all the column headings in the IDE, and set the font orientation to 900, which worked well until I came to do the export.