Not printing whole grid - Printing only 1 page (Aspose 2.5.3.2003)

Last post 06-07-2011, 6:30 AM by MEENAa. 7 replies.
Sort Posts: Previous Next
  •  06-02-2011, 12:08 AM 307855

    Not printing whole grid - Printing only 1 page (Aspose 2.5.3.2003) .NET

    Attachment: Present (inaccessible)
    Hi,
    I am not able to print the whole grid.  It is printing only 1 page. I give the color for heading. but that color is not print. My requirements are

    1.  Print Whole grid
    2. Colour printing
    3. No need extra content (no need url, date time etc)-> Only grid content to be print

    Please suggest me

    Meenaa

     
  •  06-02-2011, 3:55 AM 307921 in reply to 307855

    Re: Not printing whole grid - Printing only 1 page (Aspose 2.5.3.2003)

    Attachment: Present (inaccessible)
    Hi,

    We wrote a method named “printGrid” to print whole grid with color in Default2.aspx (attached with this post just remove its txt extension). It works fine in IE6.

    To avoid printing extra content (no need url, date time etc), you should open the “File -> Page Setup” menu to setup it.

    Please download Aspose.Cells.GridWeb v2.5.3.2004.
    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
  •  06-02-2011, 5:49 AM 307945 in reply to 307921

    Re: Not printing whole grid - Printing only 1 page (Aspose 2.5.3.2003) .NET

    Attachment: Present (inaccessible)
    Hi,

    Thanks for your quick reply. I tried your printGrid() function in IE 9 and Firefox 4.0.1. But i got the error message screen which i attached for you. And print Dialog window is not shown.

    I want another one suggestion from you.
               How to show a popup window when right click? (No need to display context menu instead of this i want popup window )

    Please suggest me

    Advance thanks
    Meenaa
     
  •  06-02-2011, 10:32 AM 307994 in reply to 307945

    Re: Not printing whole grid - Printing only 1 page (Aspose 2.5.3.2003)

    Hi Meenaa,

    The printGrid method was initially created and tested with IE6. We have logged a Ticket in our database to enhance this feature for IE9 and FireFox. Ticket ID for your reference is CELLSNET-28030. We will get back to you on this very soon.

    MEENAa:

    I want another one suggestion from you.
               How to show a popup window when right click? (No need to display context menu instead of this i want popup window )

    Regarding the above question please see this post, as your requirement seems to be related.  

    Babar Raza
    Support Developer,
    Aspose Sialkot Team
    http://www.aspose.com/
    Aspose - Your File Format Experts
     
  •  06-02-2011, 11:03 PM 308106 in reply to 307945

    Re: Not printing whole grid - Printing only 1 page (Aspose 2.5.3.2003)

    Attachment: Present (inaccessible)
    Hi,

    We add a button to invoke ‘printGrid’ function in your default2.aspx. It works fine in IE9 and FireFox. Please setup your browser to enable printing background and images.

    GridWeb provides an attribute named "OnContextMenuShowClientFunction” to be invoked on client.

    C#
    OnContextMenuShowClientFunction="onshowmenu"

    function onshowmenu()
    {
                    var g = document.getElementById("g");
                      g.ContextMenu.hide();

                      window.open();
    }


    This can suit your need.


    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
  •  06-04-2011, 9:50 AM 308348 in reply to 308106

    print - fit to page like excel page setup(Aspose 2.5.3.2005) .NET

    Attachment: Present (inaccessible)

    Hi,

    I tried: to print directly from Gridweb , data is printing correctly, but not fitted in single sheet and formatting and colours are not printed. Please find the attached file for reference. Once printing functionality is working correctly I’ve to give user 2 options(LIKE excel page setup screen) 1)A3 sheet or 2)A4 sheet and hard code Fit to=1 and wide by=1(tall). So that all my data fits in a single sheet to print( Please note: Data in my Gridweb will be less than 1 or l.5 pages) .


    If formatting and color is not going to work. My client has asked me to try the below requirement
    I’ve export my Webgrid data to excel sheet, It is exported correctly with formatting and colour codes. As per my requirement I’ve to import it back and ask user for two options 1)A3 sheet or 2)A4 sheet and hard code Fit to=1 and wide by=1(tall). So that all my data fits in a single sheet to print(Data will be less 1 or l.5 pages .

    Can you please reply me which method we can follow with your suggestions how to do.

    I tried to hide the context menu. But it is not working. Please find the attached sample code for reference.

    thanks in advance

    Urgent please

     
  •  06-06-2011, 11:35 PM 308723 in reply to 308348

    Re: print - fit to page like excel page setup(Aspose 2.5.3.2005)

    Attachment: Present (inaccessible)

    Hi,

    We checked your default.aspx, we found there is a syntax error in your script i.e. (alert(""+row+""col);). Please correct it accordingly, the onshowmenu function will work fine. 

    In our previous reply, the default2.aspx can print the grid with formats and colors. Please try it and check your browser’s page settings to enable printing images and background. The attachment is the print result.

    Thank you.

     


    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  06-07-2011, 6:30 AM 308841 in reply to 308723

    Re: print - fit to page like excel page setup(Aspose 2.5.3.2005)

    Hi,

    Thanks for your reply. It works fine. Right click and print with formatting aslo work fine



    Meenaa
     
View as RSS news feed in XML