Targeted row id anchor is above title when freeze_headers=true

[JoeJordan1]

When targeting a table row anchor, using _sqlpage_id, and the table has 'true' as freeze_headers, it appears that the user is then redirected to the row below.

I do think the anchor is technically working 'correctly' but because of the frozen headers, it is underneath the title, so appears to be directed to the subsequent row, which is incorrect from a user perspective.

Although, this is a horrible mock-up, it demonstrates the issue if you click the rows near the top and watch them disappear above the title:

select 
    'table' as component,
    'true' as hover,
    'true' as sort,
    'true' as search,
    'true' as small,
    'true' as freeze_headers,
    'RowTarget' as markdown;

select top 100
	'row-' + convert(varchar,x.rowVal) as '_sqlpage_id',
    quotename('row-' + convert(varchar,x.rowVal)) +'(#row-' + convert(varchar,x.rowVal) + ')' as [RowTarget]
from
	(values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30)) as x(rowVal);

• Database: MS SQL Server 2019
• SQLPage Version [found when hovering the default footer of pages]: 0.33.1

[lovasoa]

Thanks for the report ! The fix will be in 0.34 and can already be tested in lovasoa/sqlpage:main