BuyLog In
Bug Report T135360
Visible to All Users

Spreadsheet Report Link - The last row and column are not printed

created 11 years ago

Hi,
I cannot understand how is defined the  ExpressSpreadSheets's print area.

I think there is a problem, which I realized after experimenting with the SpreadSheetFeaturesDemo
When I filling some cells by code and previewing the spreadsheet I saw that the last column was not included
in the print preview.
This behavior can be reproduced in the SpreadSheetFeaturesDemo by commenting the last 2 rows
of the procedure TfrmInvoice.CreateVariativePart(AGoodsCount: Integer);
  //CreateContactInfoRange(Rect(1, ATotalRowIndex + 4, 5, ATotalRowIndex + 5));
  //CreateThankfulRange(Rect(1, ATotalRowIndex + 7, 5, ATotalRowIndex + 7));

Then the preview doesn't include the last column.
See attached image also.
Is there a workaround or a hint to bypass this since this is very crusial for my project if I cannot preview correctly the
excel file.

Best Regards,
Manolis Perrakis

Comments (1)
DevExpress Support Team 11 years ago

    Hello Manolis,

    Thank you for your detailed report. I have reproduced the described behavior and forwarded this ticket to our developers for research.

    Sign in to comment on this post

    Answers approved by DevExpress Support

    created 11 years ago

    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.

      Comments (3)
      MP MP
      Manolis Perrakis 11 years ago

        Unfortunately an error occurs after applying the hot fix:
        Cannot compile dxPSdxSpreadSheetLnkRS15.dpk
        Compiler: C:\Program Files (x86)\Embarcadero\RAD Studio\8.0\Bin\dcc32.exe
        Embarcadero Delphi for Win32 compiler version 22.0
        Copyright © 1983,2010 Embarcadero Technologies, Inc.
        cxVer.inc(445)
        dxPSdxSpreadSheetLnk.pas(2492) Error: E2003 Undeclared identifier: 'GetMeaningContainersArea'
        dxPSdxSpreadSheetLnk.pas(2492) Error: E2029 ')' expected but identifier 'Right' found
        dxPSdxSpreadSheetLnk.pas(2494) Error: E2029 ';' expected but 'IF' found
        dxPSdxSpreadSheetLnk.pas(2496) Error: E2029 '.' expected but ';' found
        dxPSdxSpreadSheetLnk.pas(2532) Error: E2003 Undeclared identifier: 'GetMeaningContainersArea'
        dxPSdxSpreadSheetLnk.pas(2532) Error: E2029 ')' expected but identifier 'Bottom' found
        dxPSdxSpreadSheetLnk.pas(2534) Error: E2029 ';' expected but 'IF' found
        dxPSdxSpreadSheetLnk.pas(2536) Warning: W1011 Text after final 'END.' - ignored by compiler
        dxPSdxSpreadSheetLnk.pas(2934)
        dxPSdxSpreadSheetLnk.pas(238) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.GetMergedCells'
        dxPSdxSpreadSheetLnk.pas(239) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.SetOptionsView'
        dxPSdxSpreadSheetLnk.pas(240) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.SetPrintArea'
        dxPSdxSpreadSheetLnk.pas(241) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.GetSSCellObject'
        dxPSdxSpreadSheetLnk.pas(242) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.GetSSCellStyle'
        dxPSdxSpreadSheetLnk.pas(243) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.GetSSDefaultCellSideColor'
        dxPSdxSpreadSheetLnk.pas(244) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.GetSSDefaultStyle'
        dxPSdxSpreadSheetLnk.pas(245) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.GetFlatIndex'
        dxPSdxSpreadSheetLnk.pas(246) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.GetRealColor'
        dxPSdxSpreadSheetLnk.pas(247) Error: E2065 Unsatisfied forward or external declaration: 'TdxSpreadSheetCustomReportLink.IsSSDefaultStyle'
        dxPSdxSpreadSheetLnk.pas(402) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.chbxFixedRowsOnEveryPageClick'
        dxPSdxSpreadSheetLnk.pas(403) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.chbxOnlySelectedClick'
        dxPSdxSpreadSheetLnk.pas(404) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.btnFixedFontClick'
        dxPSdxSpreadSheetLnk.pas(405) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.chbxRowAutoHeightClick'
        dxPSdxSpreadSheetLnk.pas(406) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.chbxOptionsViewChanged'
        dxPSdxSpreadSheetLnk.pas(407) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.chbxFixedTransparentClick'
        dxPSdxSpreadSheetLnk.pas(408) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.ccbxColorChange'
        dxPSdxSpreadSheetLnk.pas(409) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.pbxPreviewPaint'
        dxPSdxSpreadSheetLnk.pas(410) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.lblColorClick'
        dxPSdxSpreadSheetLnk.pas(411) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.pgctrlMainChange'
        dxPSdxSpreadSheetLnk.pas(412) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.stTransparentClick'
        dxPSdxSpreadSheetLnk.pas(413) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.stFixedTransparentClick'
        dxPSdxSpreadSheetLnk.pas(416) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.GetReportLink'
        dxPSdxSpreadSheetLnk.pas(417) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.CreateControls'
        dxPSdxSpreadSheetLnk.pas(418) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.SetReportLink'
        dxPSdxSpreadSheetLnk.pas(419) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.CMDialogChar'
        dxPSdxSpreadSheetLnk.pas(421) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.DoInitialize'
        dxPSdxSpreadSheetLnk.pas(422) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.GetPreviewHost'
        dxPSdxSpreadSheetLnk.pas(423) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.LoadGroupsIcons'
        dxPSdxSpreadSheetLnk.pas(424) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.LoadStrings'
        dxPSdxSpreadSheetLnk.pas(425) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.PaintPreview'
        dxPSdxSpreadSheetLnk.pas(426) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.UpdateControlsState'
        dxPSdxSpreadSheetLnk.pas(427) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.UpdatePreview'
        dxPSdxSpreadSheetLnk.pas(429) Error: E2065 Unsatisfied forward or external declaration: 'TfmdxSpreadSheet2DesignWindow.Create'
        dxPSdxSpreadSheetLnk.pas(244) Hint: H2219 Private symbol 'GetSSDefaultStyle' declared but never used
        dxPSdxSpreadSheetLnk.pas(245) Hint: H2219 Private symbol 'GetFlatIndex' declared but never used
        dxPSdxSpreadSheetLnk.pas(415) Hint: H2219 Private symbol 'FPreviewBox' declared but never used
        dxPSdxSpreadSheetLnk.pas(417) Hint: H2219 Private symbol 'CreateControls' declared but never used
        dxPSdxSpreadSheetLnkRS15.dpk(56) Fatal: F2063 Could not compile used unit 'dxPSdxSpreadSheetLnk.pas'

        DevExpress Support Team 11 years ago

          It seems that the development has "gone too far" and there are too many changes in our sources to provide patches. I suggest that you wait for a while for the new VCL 14.1.3 release that we are going to build next week.

          MP MP
          Manolis Perrakis 11 years ago

            OK,
            As a workaround I will write one dot at a cell next to the last column of my excel worksheet in order to print correctly.
            Thanks,
            Manolis

            Sign in to comment on this post

            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.