Freeze titles (Figer les volets)

[Guest]

Hi everyone,
If I select A4 and freeze the titles, a line appears above line 4. Is it
possible to make this line disappear by code?
Thanks.

 

[Tom Ogilvy]

No, it isn't.

 

[David McRitchie]

Hi Jac,
That is part of Freeze Panes, you're stuck with it.
I don't find it a problem. Perhaps if you bolded your column and
row headings, you'd accept the lines as part of the headings.

You could choose a border at least as thick as the freeze lines..
Remember borders and interior color will override gridlines.

 

[Guest]

Hi Tom,
That's what my coworkers and I thought. Just wanted to make sure.
Thanks for your answer. I appreciate.

 

[Guest]

Hi David,
I do not find it a problem either myself, but the customers do and some
other developpers as well. Of course, we tried the borders, but the header
line extends beyond the current region which is sort of macramé looking. I
guess we will have to live with it. There are bigger problems in life
anyway...
Thanks for your answer. It is appreciated.

 

[David McRitchie]

Hi Jac,

I don't think I would tell them right now, But at some time in the
future you could point out that when rows or columns are hidden
there is a thick border between the visible cells. Perhaps they
will then find out on their own the logical connection with how headers
in the repeated rows may be separated from the other rows/columns
shown in the screen at the moment. They again they might complain
that the bold line is there even if row 2 is also showing.

 

[Guest]

Thanks for your answer, David.
By the way, I checked your site and found a lot of interesting topics. That
will keep me busy for hours.