FastCube - Export Excel

Comments

• ivan8888

  November 2009 edited 10:01AM

  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
  
• -=paul=-

  November 2009 edited 10:01AM

  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.
• -=paul=-

  November 2009 edited 10:01AM

  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.