We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Alignment and Display format

Hi,

I am trying to render attached excel sheet on Gridweb but it changes the style, alignment and formatting of data. These are the defects reported by testers.
1. DOB/Date- In Original sheet it is Right Alignment and in the Template it is Left Alignment.
2. Accounting Field: Original Sheet Value: $ 100.00, In the Automation Template: $*100.00
3. Time Format: Origial Sheet: 4:12:00 PM
Template excel sheet: 16:12:00A12/P1
4. Fractionals: Original Sheet: 212
Template Sheet: 212/

This is how i am rendering the excel sheet. Variable path is a path to the attached excel file. I am attaching original excel sheet and screen output. Ideally it should preserve the style, alignment and formatting ...for each cell while rendering it on gridweb. Please help me to solve this problem?

Workbook workbook = new Workbook(path);

//Delete blank rows from each worksheet

foreach (var sheet in workbook.Worksheets) {

sheet.Cells.DeleteBlankRows();

}

//Save the workbook into memory stream

MemoryStream ms = new MemoryStream();

workbook.Save(ms,SaveFormat.Auto);

ms.Position = 0;

//Import excel file from memory stream

GridWeb1.ForceValidation = false;

GridWeb1.WebWorksheets.Clear();

GridWeb1.WebWorksheets.ImportExcelFile(ms);

GridWeb1.ShowSaveButton = false;

GridWeb1.ShowContextMenu = false;

GridWeb1.ShowSubmitButton = false;

GridWeb1.ShowUndoButton = false;

foreach (var ws in workbook.Worksheets) {

if (!ws.IsVisible)

GridWeb1.WebWorksheets.RemoveAt(ws.Name);

}

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe these issues using the latest version of Aspose.Cells for GridWeb which can be downloaded from this link: Aspose.Cells for .NET 8.1.0.

There are alignment and display format issues which are highlighted in screenshot below for a reference.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42745.

C#


protected void Page_Load(object sender, EventArgs e)

{

if (Page.IsPostBack == false)

{

Aspose.Cells.GridWeb.License lic = new Aspose.Cells.GridWeb.License();

lic.SetLicense(@“F:\Shak-Data-R\Aspose\License\Aspose.Total.lic”);


string filePath = @“F:\Shak-Data-RW\Downloads\WIT_VIN_Test+Data.xlsx”;

Workbook workbook = new Workbook(filePath);


//Delete blank rows from each worksheet

foreach (Aspose.Cells.Worksheet sheet in workbook.Worksheets)

{

sheet.Cells.DeleteBlankRows();

}


//Save the workbook into memory stream


MemoryStream ms = new MemoryStream();

workbook.Save(ms, SaveFormat.Auto);

ms.Position = 0;


//Import excel file from memory stream

GridWeb1.ForceValidation = false;

GridWeb1.WebWorksheets.Clear();

GridWeb1.WebWorksheets.ImportExcelFile(ms);


}

}

Hi,

Thanks for using Aspose.Cells for GridWeb.

It is very difficult to fix all the display issues in current design, we will provide new version of GridWeb based on new design months later.then we will fix all the display issues.

Hi,

Is there an update on this?

Thanks

Hi,

Thanks for your posting and using Aspose.Cells for GridWeb.

We are afraid, there is no update for you at this moment. However, we have logged your comments in our database against this issue and requested the development team to provide some fix or update regarding this issue. Once, it is available, we will let you know asap.

Hi,


To update you on your issue, as we are working over your issue(s), we hope after two months or so we might release the first trial version that should support your needs.

We will keep you posted about any update in this regard.

Thank you.

Hi,

Is there an update on this?

Thanks

Hi,


As per my previous post, we may release a trial version at the end of September to address your issue. We are currently working over it. Please spare us time a bit.

Once we have any update on it, we will let you know here.

Thank you.

The issues you have found earlier (filed as CELLSNET-42745) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.