Hi Luca,

Thank you for the provided additional information.

I logged an item in our backlog to provide only an import/export functionality in order to split the task in smaller and easier to develop tasks: SpreadProcessing: Implement text orientation for cell content import/export from/to XLSX format. You can cast your vote for the implementation as well as subscribe to the task by clicking the Follow button.

Until this feature is developed I could suggest you to customize our code as follows in order import and export the textRotation attribute:

I. In the Spreadsheet.FormatProviders.OpenXml_WPF project

• AlignmentElement class:

Here you should add a text rotation field and property:

private readonly IntOpenXmlAttribute textRotation;

public int TextRotation
{
	get
	{
		return this.textRotation.Value;
	}
	set
	{
		this.textRotation.Value = value;
	}
}

to include the setting of the filed in the AlignmentElement constructor:

this.textRotation = this.RegisterAttribute(new IntOpenXmlAttribute("textRotation"));

to extend the CopyProertiesFrom() method with the following code:

if (format.TextRotation.HasValue)
{
	this.TextRotation = format.TextRotation.Value;
}

and ApplyAllignment() method with the following: 

if (this.textRotation.HasValue)
{
	format.TextRotation = this.TextRotation;
}

• FormattingRecord class:

add TextRotation property:

public int? TextRotation {get; set;}

include its setting in the constructor:

this.TextRotation = record.TextRotation;

and extend Equals() and GetHashCode() methods respectively as follows:

// in the EqualsOfT method
TelerikHelper.EqualsOfT(this.TextRotation, other.TextRotation) &&

// in the GetHashCode method
this.TextRotation.GetHashCodeOrZero(),

• XlsxWorkbookImportContext class:

extend the CreateStyleFromStyleInfo() method in the using block with:

if (formattingRecord.TextRotation.HasValue)
{
	cellStyle.TextRotation = formattingRecord.TextRotation.Value;
}

• XlsxWorksheetImportContext class:

extend the ImportDirectFormattingInRange() method with:

this.UpdatePropertyInRangeIfNotNull(propertyBag, CellPropertyDefinitions.TextRotationProperty, start, end, directFormatting.TextRotation);

• XlsxWorkbookExportContext class:

extend the InitStyleFormatting() method with:

if (cellStyle.IsPropertyValueSet(CellPropertyDefinitions.TextRotationProperty))
{
	formattingRecord.TextRotation = cellStyle.TextRotation;
}

• XlsxWorksheetExportContext class:

add a worksheetEntityToTextRotationCompressedList  field:

private readonly Dictionary<WorksheetEntityBase, ICompressedList<int>> worksheetEntityToTextRotationCompressedList;

and initialize it in the constructor:

this.worksheetEntityToTextRotationCompressedList = new Dictionary<WorksheetEntityBase, ICompressedList<int>>();

then extend the InitDirectFormattingRecords() method with:

this.UpdateProperty(tableEntity,
	this.worksheetEntityToTextRotationCompressedList[tableEntity],
	this.worksheetEntryToDirectFormattingCompressedList[tableEntity],
	(formattingRecord, value) =>
	{
		formattingRecord.TextRotation = value;
		return formattingRecord;
	});

and InitAlignments() method in the foreach statement with:

this.worksheetEntityToTextRotationCompressedList[entity] = entity.PropertyBagBase.GetPropertyValueCollection(CellPropertyDefinitions.TextRotationProperty);

These were the changes in the FormatProvider, now we should make some changes in the SpreadsheetDocuments_WPF project.

II. SpreadsheetDocuments_WPF project

• CellPropertyDefinitions class:

add this property definition:

public static readonly IPropertyDefinition<int> TextRotationProperty = new PropertyDefinition<int>(TextRotation", true, StylePropertyGroup.Alignment);

and add TextRotationProperty to the AllPropertyDefinitions collection.

• CellStyle class:

add text rotation field and property:

private readonly StyleProperty<int> textRotation;

public int TextRotation
{
	get
	{
		return this.textRotation.GetValue();
	}
	set
	{
		this.SetStyleProperty(this.textRotation, value);
	}
}

and extends the constructors as follows:

// static CellStyle()
propertyDefinitionToStyleProperty.Add(CellPropertyDefinitions.TextRotationProperty, (style) => { return style.textRotation; });

// internal CellStyle(Workbook workbook, string name, CellStyleCategory category, bool isRemoveable = true, int? builtinId = null)
this.textRotation = new StyleProperty<int>(this, CellPropertyDefinitions.TextRotationProperty);

• WorksheetPropertyBagBase class:

extend the constructor with:

this.RegisterProperty(CellPropertyDefinitions.TextRotationProperty);

After this setup you should be able to preserve the text orientation after import/export of the document.

Regards,
Martin
Progress Telerik

Hi Luca,

If I understand you right, you need to keep the imported cell`s text orientation unchanged after export to XLSX format, right? Could you share more information about the specific case?

Looking forward to hearing from you.

Regards,
Martin
Progress Telerik

Hi Luca,

I apologize for the inconvenience this missing functionality might be causing you. At this point, I am unable to provide you with a timeframe for releasing this feature as it is currently not scheduled for implementation. Please, make sure you cast your vote for the implementation as well as subscribe to the task by clicking the Follow button so you can receive an update when its status changes.

Regards,
Martin
Progress Telerik

Hello Muhammad,

The task is still not scheduled. This item will be updated accordingly once the team starts working on it, so continue following it to receive email updates.

Regards,
Tanya  

Hi Dewald,

This portal is related with our backlog system and if there is an update on the feature, this item will be updated too. If the feature is already implemented, its status will be "Completed". 

For the time being it is not scheduled and we are not able to give you a specific time frame when it might be available.

Regards, 
Tanya