Log in to start a topic

PDF image cell low quality

Posted by: patrik on 9 February 2018, 4:51 pm EST

  • patrik

    • Post Options:
    • Link
      Copy

    Posted 9 February 2018, 4:51 pm EST

    Hi

    When I make a PDF image cell get very low quality(DPI)

    FpSpread1.EditMode = False
        Dim SaveD As New SaveFileDialog()
        Dim SaveD1 As String
        SaveD.FileName = FpSpread1.ActiveSheet.GetText(4, 3) & ".PDF"
        If Config_PDF_path <> "" Then SaveD.InitialDirectory = Config_PDF_path
        SaveD.Filter = "PDF (*.PDF)|*.PDF"
        SaveD1 = SaveD.ShowDialog()
        If SaveD1 <> 1 Then Exit Sub

        Dim printset As New FarPoint.Win.Spread.PrintInfo
        Dim printmar As New FarPoint.Win.Spread.PrintMargin
        printmar.Left = 60
        printmar.Top = 20
        printmar.Right = 20
        printmar.Bottom = 20

        printset.PrintType = FarPoint.Win.Spread.PrintType.CellRange
        printset.ShowBorder = False
        printset.RowStart = 0
        printset.ColStart = 0
        printset.RowEnd = 59
        printset.ColEnd = 5
        printset.Footer = ""
        printset.Margin = printmar
        printset.PdfFileName = SaveD.FileName
        printset.PrintToPdf = True
        printset.ShowColor = True
        'printset.Footer = "/g""1""/r/cl""4""This is page /p of /pc"


        ' Print the sheet.
        With FpSpread1
            For i = 0 To .Sheets.Count - 1
                FpSpread1.Sheets(i).PrintInfo = printset
            Next
        End With
        FpSpread1.PrintSheet(-1)
        Application.DoEvents() : Application.DoEvents()
        OpenDocument(SaveD.FileName, "")

  • deepak.sharma

    Posted 11 February 2018, 5:13 pm EST

    Hello,

    Currently Spread exported the images as jpeg when saved to PDF which makes the resolution low. This has been added as an enhancement request for future version of Spread for Windows Forms. The tracking id for this issue is #254293.

    Thanks,

    Deepak Sharma

  • mikael.stridfeldt

    Posted 8 September 2020, 5:13 pm EST

    Hello

    Any updates on this issue ?

    Best regads

    Mikael

  • Ruchir.Agarwal

    Posted 9 September 2020, 6:05 pm EST

    Hello,

    The issue was fixed in Spread.NET 11 SP1 release. You can download the latest Spread.NET 11 version from here: https://cdn.grapecity.com/SpreadNET/installer/11.0.20183.0/offlineDownload_Full.zip

    To see the fix, you can use the following code:```

    fpSpread1.Open(@“D:\sample.xml”);

    fpSpread1.ActiveSheet.PrintInfo.PdfQualityMode = System.Drawing.Drawing2D.QualityMode.High;

    fpSpread1.ActiveSheet.PrintInfo.PdfFileName = “Test.pdf”;

    fpSpread1.ActiveSheet.PrintInfo.PrintToPdf = true;

    fpSpread1.PrintSheet(0);

    [zip filename="sample_xml.zip"]https://gccontent.blob.core.windows.net/forum-uploads/file-704beba4-fd75-47d4-bbb0-1074cd5f11ac.zip[/zip]

  • mikael.stridfeldt

    Posted 9 September 2020, 8:37 pm EST - Updated 30 September 2022, 4:25 am EST

    Hello Ruchir

    Thank you for the answer.

    I have tried the Spread .Net 13 in trial mode:

    The orginal that is visible in program:

    492×536 11.7 KB

    Then the one in PDF:

    Even the cell lines and fillings looks wrong if i zoom in:

    Image in next post

    The code :```

    var sheets = summarySheetPDFExport.SelectedSheets;

    foreach (SheetView sv in sheets)

    {

    if (sv.PrintInfo == null)

    sv.PrintInfo = new PrintInfo();

                sv.PrintInfo.ShowBorder = false;
            sv.PrintInfo.ShowGrid = false;

            sv.PrintInfo.ShowPrintDialog = false;
            sv.PrintInfo.Preview = false;
            sv.PrintInfo.Centering = Centering.Horizontal;
            sv.PrintInfo.PrintToPdf = true;
            sv.PrintInfo.PdfFileName = sfd.FileName;
            sv.PrintInfo.ShowColor = true;
            sv.PrintInfo.PdfQualityMode = System.Drawing.Drawing2D.QualityMode.High;
            sv.PrintInfo.ShowColumnHeader = PrintHeader.Hide;
            sv.PrintInfo.ShowRowHeaders = false;

           
            tempSpread.Sheets.Add(sv);
        }

        tempSpread.PrintSheet(-1);

    
It seams like there is somthing wrong here :(

Best regads
Mikael

  • mikael.stridfeldt

    Posted 9 September 2020, 8:41 pm EST - Updated 30 September 2022, 4:25 am EST

    Image refered to in post above where the fill and lines are wrong:

  • Ruchir.Agarwal

    Posted 11 September 2020, 3:41 am EST

    Hello,

    I do not see the issue at my end, I would recommend you to set the Style of ImageCelltype to either Stretch or StretchAndScale to get proper results. For reference I have attached the application and the output at my end. Can you run the application and see, if you still see the issue.

    Thanks,

    Ruchir

    PrintToPDF.zip[img]https://gccontent.blob.core.windows.net/forum-uploads/file-a8828432-4eea-48c9-8492-ff0a49a15b9d.PNG[/img]

  • mikael.stridfeldt

    Posted 13 September 2020, 4:00 am EST - Updated 30 September 2022, 4:25 am EST

    Hello

    I have modified the project you sent to use my xml:

    Spread_Win_Error.zip

    Still like this:

    1090×712 45.4 KB

    Best regards

    Mikael

  • mohitg

    Posted 14 September 2020, 7:02 pm EST

    Hello,

    I am able to reproduce the issue. I have escalated the issue to the development team(SPNET-12015) and will inform you once I get any updates from them.

    Thanks,

    Mohit

  • Ruchir.Agarwal

    Posted 22 September 2020, 1:42 am EST

    Hi Mikael,

    The team has provided information that as in this case the image is a Rectangle shape with the picture, when exporting to pdf spread will use the GIF Format to support the transparent. So this is as limitation of shape feature.

    Is the feature critical and urgent for your application?

    Thanks,

  • mikael.stridfeldt

    Posted 22 September 2020, 4:13 am EST

    Hi Rachir

    Im sad to hear that.

    As im evaluating upgrade from Farspread 8.2 → Spread.Net 13 (Or later) i would say its critical. This and the https://www.grapecity.com/forums/spread-winforms/pdf-cells-are-not-filled-c are major flaws that would stop an upgrade. And in the long term we would have to look for alternatives. We already have customer annoyed over theese problems thats why im looking into this.

    Best regards

  • Ruchir.Agarwal

    Posted 22 September 2020, 9:42 pm EST

    Hello Mikael,

    Thank you for confirming.

    I have forwarded this information to the team and the feature would be available in a future release version [ID: 12326]. I will get back to you as soon as there is an ETA available.

    Regards,

  • mikael.stridfeldt

    Posted 22 September 2020, 10:10 pm EST

    Hello

    Ruchir Thanks for the answers. Looking forward to test the new release :slight_smile:

    Best regards

  • Ruchir.Agarwal

    Posted 28 September 2020, 8:49 pm EST

    Hi Mikael,

    Just to mention, w.r.t. exporting image cell to PDF, the behavior in v13 is the same as as v8 and is not a breaking change but an enhancement request. This request has been submitted to dev, which will be considered in one of the future v14 release.

    Regards,

  • mikael.stridfeldt

    Posted 1 October 2020, 5:19 pm EST

    Hello

    Hope it will make it then. Maybe this problem i seen more now when screen resolutions are higher then when the v8 was released.

    Best regards

  • Ruchir.Agarwal

    Posted 1 October 2020, 10:21 pm EST

    Hi,

    Yes, that could be the cause, as this is the same behavior as v8. We will keep you updated with the progress on this.

    Regards,

  • mikael.stridfeldt

    Posted 15 November 2020, 6:58 pm EST - Updated 30 September 2022, 4:25 am EST

    Hello Ruchir

    I have tried the V14 and it looks like the quality of my image changed to better:

    Best Regards

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels

  • © 2023 MESCIUS inc. All Rights Reserved.  ·  1.800.858.2739

    All product and company names herein may be trademarks of their respective owners.