Border not working for fixed cells lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- witenite · 2017-03-15 10:42 Hi, my table is looking quite presentable, complete with a border as seen here However when I fix the two rows in my table (by the addition of the code  tblProperties.fixedrows := 2;  where tblProperties is of type TsWorksheetGrid) my borders are no longer visible. It just appears as if they are blanked out by white grid-lines as seen here. Note I have the grid lines disabled, yet I have tried enabling them, or even setting them to red, yet the white lines between cells remain white at all times (as long as I have fixed rows). I therefore do not think these are grid lines at all, so they must be border lines, but then why am I not able to programmatically set them correctly? What am I doing wrong for setting the border for fixed cells. ---------------------------------------------------------------------- wp · 2017-03-16 21:10 This is just a notification that I am working on this issue. It turned out, however, that the WorksheetGrid has several other painting issues, some of them not seen so far, some of them slipped in during the time. Therefore it may take some time until everything is fixed. ---------------------------------------------------------------------- witenite · 2017-03-17 09:01 Quote from: wp on March 16, 2017, 10:10:07 pmThis is just a notification that I am working on this issue. It turned out, however, that the WorksheetGrid has several other painting issues, some of them not seen so far, some of them slipped in during the time. Therefore it may take some time until everything is fixed. No hassle WP, I think you've done one hang of a job with this component so far. I/we can keep working with what we have (I still have plenty other code of my own to write and bugs to fix) until you have a few more issues ironed out. I'll keep logging bug reports if I find anything else, though I'm going to try and take my focus away from the table for now and get into the "meat" of my application. Good luck! ---------------------------------------------------------------------- wp · 2017-03-21 17:37 Please try out the current trunk version of fpspreadsheet. It has some improvements in grid painting of frozen cells. ---------------------------------------------------------------------- wp · 2017-03-28 09:05 Sorry, too much diffuse information for my crystal ball... You must strip down the part of your project which is not working to a little demo and upload it here. Without code I cannot help, too many places where things can go wrong. Please add the pas, lfm, lpr and lpi files to a common zip and upload it here. Avoid non-standard components (no PKSheet, no PKComponent). Crashes often occur if components are not created. If you want to reuse my border code why don't you add the worksheet to the parameter list? Don't introduce global variables for this purpose. Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i procedure Border(ASheet: TsWorksheet; ARow, ACol: Integer; ABorder: TsCellBorder;   AColor: Integer;  ALineStyle: TsLineStyle);var  cell: PCell;  currentBorders: TsCellBorders;begin  cell := ASheet.GetCell(ARow, ACol);  // Use GetCell to create a new cell if required  currentBorders := ASheet.ReadCellBorders(cell);  Include(currentBorders, ABorder);  ASheet.WriteBorders(cell, currentBorders);  ASheet.WriteBorderColor(cell, ABorder, AColor);  ASheet.WriteBorderLineStyle(cell, ABorder, ALineStyle);end; P.S. If you refer to other thread please add a link. I write so many answers to different topics, and it is quite difficult to understand to which one you refer.