DirkBlaas 2009-09-12 Thanks for publishing this recipe. It is another good effort to make working with large tables more easy. I came across a small bug: when a column is center or right aligned, the markup for heading (!) is not recognized. For left aligned it is working ok. This happens both in text2tbl mode and flextbl mode. In text2tbl mode you can see that the ! is not placed directly next to the table-seperators (|| !Headertext in stead of ||! Headertext).
Thanks for this HUGE timesaver. It's making very short work of some really gnarly tables. I have just one request to improve the output. Currently, any cells where alignment is not specified are marked with
align=left which displays fine but is superfluous as left alignment is the default behaviour. One might argue that all left alignment could be left out but there may be reasons not to. However, could any default alignment be left out? It would reduce the clutter somewhat in the edit window. Meanwhile I'll just use a simple find-and-replace.
$t2tSuppressDefaultAlignconfiguration variable will address this as of this 2009-09-15 version. Peter Bowers September 23, 2013, at 01:26 AM
I just found an issue with the conversion from data cut and pasted from Excel. I specified
input=tsv output=advanced (and no other options) and the output tripped up on two things.
1. Blank rows seem to cause the row following the blank row to be appended to the row preceding the blank row.
2. Blank cells seem to be skipped, causing variable width rows. My tables were quite complex so it was hard to see what was going where. The workaround for this, at least in Excel, is to search for blank cells (leave the Find what: box empty) and replace with either Alt-0160 (Windows) for a non-breaking space or just
for more literal output.
I've really not investigated the precise behaviours as I have workarounds for now, but thought it worth bringing up.
Goodguy00 2020-05-31 recipe NOT compatible with newest version of pmwiki, NOT compatible with PHP7.3+ (reg_replace /e)