Recent

Author Topic: If you draw cell borders then you can't format cell style in excel, bug?  (Read 9300 times)

wp

  • Hero Member
  • *****
  • Posts: 11916
Here is it.
The file with the incomplete palette contains the correct number of palette entries, but fpspreadsheet neglects duplicate colors when building the palette. The original Excel palette, however, does contain duplicate palette items. Therefore, the non-assigned palette colors were assigned to white by fpspreadsheet.

In the new revision, the xls writers accept duplicate palette colors, and hence the white spaces in the Excel color dialog should disappear. Please check.

SunyD

  • Guest
You did it man, big thanks, look at the screenshot  :)

Loading of embedded images isn't important, but adding images would be nice.
It is usefull report output or export.
I downloaded ExcelFileFormat.pdf from OpenOffice.og, it is big format.

wp

  • Hero Member
  • *****
  • Posts: 11916
OK, when I have some more time I can try to approach the image issue with xls again. But it seems to me that you only want to write files. In this case you could also try the xlsx format, fpspreadsheet supports writing to this format - and there a converter so that Office XP can read these files (https://support.microsoft.com/en-us/help/924074/how-to-open-new-file-formats-in-earlier-versions-of-microsoft-office).

SunyD

  • Guest
Thanks, but forget it. Do not waste your time, you already did too much.
I can switch to other formats and the end user of program can take openoffice.
« Last Edit: May 18, 2017, 10:49:39 pm by Soner A. »

 

TinyPortal © 2005-2018