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

Free Support Forum - aspose.com

Data (with multiple line) to be hidden when convert from Excel to PDF

Hi all,

I have processed converting data from Excel to PDF (as below attachments).

When viewing file in Adobe Reader, some selection data have been hidden although you can search it and copy it (such as “Option 1, …”). It seems a part of data has white color and you can’t see it on PDF result. I’m using \n character for creating line break in Excel file.

I don’t know why. Please tell me how to fix this issue.
(You can see description image in ExcelImage.JPG file and PdfImage.JPG file)

I have converted Excel to Pdf as following sample :
https://docs.aspose.cloud/cells/saveas-other-formats/

Thanks,
Chien

Hi Chien,

Thanks for providing us template files.

After an initial test, I observed the issue with the following lines of code with your template file, the Options… bullets are missing in the output PDF as per your attached screen shot:
https://forum.aspose.com/t/18208

I even tried the line instead, I set some auto-fitting rows options but still last two options are missing in the output (see the “outtesttimeline2.pdf” file attached here):

string strURI = “http://api.aspose.com/v1.1/cells/test-multiline.xlsx/saveAs?newfilename=outtest-multiline1.pdf&isAutoFitRows=true&isAutoFitColumns=false”;

e.g
Sample code:


//Data (with multiple line) to be hidden when convert from Excel to PDF.
APPKey.AppSID = “7xxxxxxxxxxxxxxxxxxxa”;
APPKey.AppKey = “3xxxxxxxxxxxxxxxxxxxxxxxa”;

string xml = @“
false
false
None
**false**
90
70
Pdf
”;

//build URI
string strURI = “http://api.aspose.com/v1.1/cells/test-multiline.xlsx/saveAs?newfilename=outtest-multiline1.pdf”;
// I even tried to set some autofitting options
// string strURI = “http://api.aspose.com/v1.1/cells/test-multiline.xlsx/saveAs?newfilename=outtest-//multiline1.pdf&isAutoFitRows=true&isAutoFitColumns=false”;
//sign URI
string signedURI = Sign(strURI);
POST(signedURI, xml);
//build URI
strURI = “https://api.aspose.com/v1.1/storage/file/outtest-multiline1.pdf”;

signedURI = Sign(strURI);

using (HttpWebResponse response = GET(signedURI))
{
using (var stream = File.Create(@“e:\test2\outtesttimeline2.pdf”))

{ response.GetResponseStream().CopyTo(stream); }

}

I have logged a ticket with an id “SAASCELLS-96” for your issue. We will look into it soon.

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

Thank you.

Hi Amjad,

Thanks for your detail explanation. It seems better in outtesttimeline3.pdf. But the content in cells have wrong break lines. For examples :
✓ Option
1 ✓ Option
2 ✓ Option
3 ✓ Option
4


I think it should be :
✓ Option 1
✓ Option 2
✓ Option 3
✓ Option 4

Is it another issue ?

Thanks,
Chien

Hi Chien,


You are right the Options symbols are wrongly rendered. We have already logged a ticket “SAASCELLS-96” for it, we will be looking into it soon.

Thank you.


Hi Amjad,

Have you fixed this issue yet? And if not, when will you release new version of Cloud for fixing it (SAASCELLS-96) in your estimate ?

Thanks,
Chien

Hi,

We have fixed the issue "SAASCELLS-96" now. I will check with the relevant developers to give you the estimated release date when the next version of Cloud APIs would be made live.

Thank you.

Hi,


This fix/version of Cloud APIs has been made live. Could you please try it now and let us know if you see any issue.

Thank you.