Home› Devices
ReportBuilder 22.04 now available including Delphi 12.1 support!
New Blog Post: Helper Routines

Unable to format in Excel 2000

rbuserrbuser
edited August 2011 in Devices
A related Excel formatting issue is when you click on the currency button
(In Excel 2000, 2003 and 2007) the cell does change to currency format but
it also reverts to the default font for the spreadsheet when editing a RB
Exported sheet. When you create a new sheet, change the font to something
other than default the cell font is retained when clicking the currency
button.

RB 12.04 Server / Delphi 2007 / Oracle 10G

Comments

  • nardmoseleynardmoseley
    edited August 2011
    The RB XLS export is using Excel 97-2003 format, also known as BIFF8. There
    are cell attributes that get set for the data, font, display format, etc.

    I have Excel 2010 installed on my machine and do not have any issues editing
    cells. When I click on a cell, the toolbar is updated to reflect the font,
    text alignment, etc. When I right click over a cell and choose Format
    cells... the format dialog is displayed and reflects the cell font, display
    format, etc. I can click on currency and the format is changed, the font
    stays the same.

    If you can view cells, but not edit them, then perhaps Excel is running in a
    protected read-only mode.

    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.