I just rolled out the latest 15.1.7 to my clients.
Now there is a problem. Spreadsheets that used to print on a single page are now printing on 3 pages.
For example, if I have a spreadsheet 15 rows, it shows 5 rows on one page ,and 5 rows on the next, and 5 on the third.
How can I fix this? This worked just fine with v14.2, so is there a new setting or something?
Thanks!
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
Hello Jimmy,
According to the How to resolve issues with unexpected output content of Printing, Reporting, RichEditDocumentServer, PDF libraries on Azure Web Site KB article, if you deploy your web site in an Azure environment, these properties should be defined.
Also, for the hotfix… should my webconfig change too?
<add assembly="DevExpress.Web.v15.1, Version=15.1.7.0, Culture=neutral, PublicKeyToken=B88D1754D700E49A" />
vs
<add assembly="DevExpress.Web.v15.1, Version=15.1.7.15288, Culture=neutral, PublicKeyToken=B88D1754D700E49A" />
Hello Jimmy,
The information about the version in the web.config file should not be changed after installing a hotfix, since the revision info is not displayed there.
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Hello,
Would you please send us a sample project where the behavior you described is reproducible?
It is unclear from your description how can I reproduce the issue on my side.
Here is our code;
<dx:ASPxSpreadsheet ID="ASPxSpreadsheet1" ClientInstanceName="ASPxSpreadsheet1" runat="server" Visible="true" Width="100%" Height="600">
<ClientSideEvents SelectionChanged="sheet_SelectionChanged" />
<SettingsDocumentSelector UploadSettings-Enabled="true" />
Is there some new setting to make it fit on one page?
Again, this use to work just fine in 14.2 but its not in 15.1.7. Thanks! Desperately need to get this fixed as my client needs printouts from 17 of their locations today.
the problem you can see here is that this spreadsheet spans 3 pages instead of just one and adds in extra padding around each cell.
Screenshot 1: The devexpress spreadsheet control with normal padding.
Screenshot 2: What actually devexpress prints.
None of these seem to keep the spreadsheet to printing one page either. It is a very short spreadsheet in height and should easily fit on one spreadsheet. the issue is that devexpress is adding large amounts of padding around each cell upon printing.
ASPxSpreadsheet1.Document.Worksheets[0].PrintOptions.FitToPage = true;
ASPxSpreadsheet1.Document.Worksheets[0].PrintOptions.FitToWidth = 0;
ASPxSpreadsheet1.Document.Worksheets[0].PrintOptions.FitToHeight = 1;
ASPxSpreadsheet1.Document.Worksheets[0].PrintOptions.Scale = 50;
How can i get the spreadsheet to print on one page?
Can someone, please help me. I am in desperate need to get this fixed. Thank you!
Hello,
I created a test project based on your description but was not able to reproduce the issue. Please see the attached screencast. It would be helpful if you provide me with a sample project or modify my sample so the issue is reproduced. Also, send me a document for testing since its content can affect the result. I will do my best to find the cause of the issue and provide you with a solution as soon as possible.
Also, this is in an AZURE environment. Does that have an impact on the printing format?
The problem is this line below that Pavlo (devexpress support) said I need to add to prevent memory leaks (https://www.devexpress.com/Support/Center/Question/Details/T296866):
DevExpress.Office.AzureCompatibility.Enable = true;
If I comment out this line, the spreadsheet printing works just fine.
If I leave this line in, the spreadsheet does not print properly, but I am afraid I will get memory leak errors again.
What should I do?
Correction. With 15.1.7, it will now print properly locally, but not on Azure.
So the printing format works locally if I comment out DevExpress.Office.AzureCompatibility.Enable = true;
But it makes no difference in the azure environment as it will not print properly with it commented or not.
What should I do? I really need this fixed in the next few hours. My client has been waiting several days now for resolution.
Can you please help me?
also, you asked for a project, but mine is too large to upload here. but if i upload yours to my azure env, it doesn't work either.
i can send you a private link to my azure site so you can see what I am talking about.
Hello Jimmy,
I have reproduced this behavior and redirected the ticket to our developers for thorough research. We will keep you informed about our progress.
Yes, this is a very Urgent issue for us. If we can please expedite in any way, please let me know. I am very desperate to get this fixed. Another option would be for me to re-deploy my dx14.1 version so that it will work again, but then we get the Azure out-of-memory issue. So, I'm in a very difficult position here.