FastCube - Export Excel

edited 9:59PM in FastCube
The problem is the following. Export to Excel has a problem with shifting fields such as "01/09, 02/09," because they are seen as in Excel 01. Sep., 02 Sep.

Comments

  • edited 9:59PM
    ivan8888 wrote: »
    The problem is the following. Export to Excel has a problem with shifting fields such as "01/09, 02/09," because they are seen as in Excel 01. Sep., 02 Sep.



    Is there a solution for this problem
  • edited 9:59PM
    ivan8888 wrote: »
    Is there a solution for this problem

    Yes since excel can save/load values correctly. I will look what and how we can fix in the FastCube code.
  • edited 9:59PM
    Can you test the next fix for the fcExportHTML.pas unit:
      procedure WriteStyle(StyleID: Integer; Style: TfcGridStyle);
      begin
        WriteLn('.gs' + IntToStr(StyleID) + ' {');
        WriteLn('  background: #' + HTMLColor(Style.FillColor) + ';');
        WriteLn('  color: #' + HTMLColor(Style.TextColor) + ';');
        WriteLn('  font: normal; ');
        WriteLn('  vertical-align: top;');
        if StyleID in [gsActiveItem, gsInactiveItem, gsMeasureItem, gsFieldsItem] then
          WriteLn('  font-weight: bold;');
        if (ExportFormat = hfExcel) and not (StyleID in [gsDataArea, gsDataCells, gsDataCellsTotals, gsDataCellsSelected]) then
          WriteLn('  mso-number-format:"\@";'); // text format
        WriteLn('}');
      end;
    

    Here we changed axis format to text and therefore it should not be converted by Excel. We will include the fix into the next version if you confirm it.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.