147
|
ADOR, MDB (JET)
![](images/expivotq147.png)
with AxPivot1 do
begin
rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset')) as ADODB.Recordset);
with rs do
begin
Open('Data','Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.mdb',3,3,Nil);
end;
DataSource := (rs as ADODB.Recordset);
end
|
146
|
ImageSize property on 32 (specifies the size of control' icons/images/check-boxes/radio-buttons)
![](images/expivotq146.png)
with AxPivot1 do
begin
BeginUpdate();
ImageSize := 32;
DefaultItemHeight := 36;
HeaderHeight := DefaultItemHeight;
Font.Size := 16;
FilterBarFont.Size := AxPivot1.Font.Size;
ToolTipFont.Size := AxPivot1.Font.Size;
Indent := 26;
Images('gBJJgBAIDAAEg4AEEKAD/hz/EMNh8TIRNGwAjEZAEXjAojKAjMLjABhkaABAk0plUrlktl0vmExmUzmk1m03nE5nU7nk9miAoE+oVDolFo1HpFJpU5h8Sf9OqFNqUOqN' +
'UqdPq9VrFWrlbr1QpdhAFAkFis1ntFptVrtkrpszrNvmVxqk3uVtm1kmF3sdBvF/wGBmV+j9BYGHwWJulfxdax2NyFdx2JlV6l9Nw7AAGZymdz2Cy2GxErvWcz9ivlwy' +
'V21cuxugwktzGIzmvwtl0+53U5y0a0Wazmmyu/3dCyOMyXHx/J5nIr9q3uyqnBxFN3G46ma4vb7mD2Ng4nZze00fDkHC7t7us2rOX5tguetpHRlmz4HVqnXk1PjHO+CM' +
'Po9MBMC+j2vC8j7wS8cFNI4kBo05UIvfCT/NsnsApU+0Fqg/T+oy/kPxC0sEQfErKQK96+w28UWRI8UGvO8sTLS9r2PWmsMJTDTask3CsIbIEQRA3shOXEEAO/GclJ9F' +
'EKrrA8FRbKMXRIlb0JxCkjS1LMswhCcvuel0cv26cSMa8Ufx+2sQwhEUoSXOCjSbLcnxjKc7sdKUVyq28NtVI71P9P7JxtQEapjQ6fzfM8zPfNE2PhIsLL63E40slk5y' +
'7N89LcyU9SvMb3SdUc6VJLj5VLVLfO/PS9KzNFHUa/0XyBD0dxlS9cxhMlTRSoNXypPErWDPyfNS+MwprRNO0FD8wVVZ1AI08URwVRjtJ1WCn21QkkUrXVLVPQS/XIkF' +
'gTxT9iONZ9xVTdq+L1eKg3kkF6Upe68XtfV51/MtrVjBlwYFL1ev8y1/P6/lyzzYl02wntj0RVFmS1Qa+M5as93QxEUW9e993rfmQ2+vy65M/mL1lhl/2bj2ByVduMtN' +
'hCJT9hdz41nN14Ld12Z9UjfI/oUAaGseiw6+uFLLhcVabJOS5RqOE0BHlZ5VnEr5fOMs3st+aa/bbRzrJGV51Y0b0DbqaWXZD90hIsPbjWu52+6Wyadpe66hhO+P/Xio' +
'W5rD8ZbrUZuVg6n1dsE/cXmewu1m9PVwnd35/nueXho/NaJzmjc61W76esuT77eG8pTquy9TwWH8LEzG8RDfFalx3Gcfvna9rvG/cptGLd9tuI6TZOP5Fiqi99vea+X4' +
'VRcBq/JZZtVQ9cwSs5lsXE372+a9z7PbfB3VVqHyvMctLto8uob6eV0m/cD6MN2v+T33t6sBut42vdv2bJ8a997x2maFJfK+qArbGJPEKE+1qTflMsIdW/GCJX17KcT6' +
'/czr/X+u1g29B7j/4BQfWkkx4zIHisjhPCmE0K4SwtXM+d4BvHRwNZOoBph9IJvPek9d40FoMJxf691jj2ywQQcHEWET4XJwkTszlVqm2GokewxtBT1DpQjRxDN0rUVD' +
'NKdC3lb6tzNOwh6upMSSYfv4YBCl/bsn9PxiFCEo7SI6Obc9HeOrnY8x4jtHtdpN4GRbaorhsbu18Pph5CiHymI0RpSXGJ/z2oUOxYxG858AyiI+bfJtuTcG5yelBJyT' +
'8okhqFd4a5yxL0rvulYtKCsZiWxWkc1s1cRoxxwhA31DLE0mR9l9HqX8fJgTDmFMVH0MIsRzVYnwnMi1dyzmhLt2kS2pxIiU62Wj5ptQGlSYFakLonTUJNLKaM5Wzlff' +
'EkuFkk5wTrhVO2eE7G6lJhxFFYUZ55zmn0WuBCD4pzhirFCKkbomsOoIYmZx5p90LoYWGPdD5g0QmJRKYxbZ6zYoVQ2jVGylSak7KSkFH6RSjpHKFuU+YMyNo5SulkC6' +
'I0vonTCitMXPoEpVS2H5FQfEqp2R1opIgAEkJISYARTCukOhmPNI5Ex/wzGHUsicMwA1LHgQ90Y/KpoQHAD+pB/R4NzIaMAB9Xaw1gqaAOsh/A/ptIkWUfhGK1kZH8Rg' +
'H5GqvgArqRmt4AAPrTroRofBGADkqr6Rmu4D7CEaHARiwpJrEEZsXXwlVjyMWRsaRqwdkLGNBABZmytmyMnaINZqyVpLR2ftKAAAdd6h2osbaskdiq4EZtgSmyNcbVWR' +
'JNXe3AA7REar3b0stlAAXBtoRmvJGLjEYAHUWsFcwCD/rnaop9aEICMAPdK5hT6xpeuzdOtAgKuJeGfdq6ggEbkTvAP+p9UCHXrvKkcgIA==');
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABfICg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' +
'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' +
'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsOatVqjG5sYjcGC3La9cz3Pq/bpuDCbMxuaK1TrYXr1TTrcofBDldAxXRKDxR' +
'DWVhLnYOw9i6XxzjuXprCaOoKB6EwbiCZZCGOdZYlcT4xHmbhMnwNxtn+G5bmqdZ7n4Pw/i+X5zm+dQ9g4CAFjsfAJheOI8HsDoWDWTB/lwSAQkmA5PEgRYoDyDwYFYF' +
'oFmGCBmBqBphDgRJ0gOTIYBGRB/lyRh0iSCZbjYWJzgWDwIjYLoLmMCJGDKDJjBgWgqG6YhyhGHRzA2aJ1mCABOAiOJvhCZBJBYRoRmSCQmEqEQimkAZgg8TZnDCV4Uk' +
'mCUmBKZYJGYWoWCUUhiFMNZckNUh2GENoaGaGZmgmJhqhqZpGGIEx2GYIxSGGGJdggWJth2Z4JmYeoemeSZ2H6H4hGmQhihyTRHGYLg7CiCgmgqIpokoNoOiOaJ4jqAo' +
'chqaZGgaCxpAoZoaiaaJqEmWIcGgShcnCJwqEqFoR3YOoFlgchflqNouiuawHmWSYqGkWZQhcatzmaOoumuSp2j6L5bBaKo0GQKRnGGCxqiyCwmkqMpsksNpOGUGI7A0' +
'ew1G0Rxlg0PptgsZuDG2Sx2l6N5tnYNZZjUDRXDCVo5l2FoymqOpukuNpujubwLjmWY5k0ZwxkaFxYlWdp6j6b5Lnafo/nABQdg2FxcUsY5BkmXAkmeQpckwNRrkKTh8' +
'CSHZBk4NwyC4KxxgMDwakOMZDn8GgwnGAo2C4cwthMcwmCcMoHBMHRehwTIghySYNksZwcH4HBMEsHx5hyPItiweYxnwSZEH4Mozn0fR+DMAo7EYJ50gkdZelKdNql2U' +
'gJn0GIukwH4HicQRai2GI4mSVpNl0dZGledgNgcYpYDWUx3FsOQi5YV5anaTY3G6W53A2RxylydxFjiaxEFCCgBBAQ==');
Add(2,'gBFLBCJwBAEHhEJAAEhABcoFg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' +
'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' +
'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4n' +
'GKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEokiEN5NCKfJ9DyTRjnSc' +
'g1CEYxOBmBpPCgagdgcIZoHoGIFA4AxQkCAxKAgKBwgGSpIBCZhjF2E5UnQPQMiMCJBCIBwxkSQgsgo+JtDKT4ziiQw+k6EwAnsOgLnkHI+yCQ4iEuE4klkPhShEJBpA' +
'oPgymOMoaDgHBjFMBgyD0HYTiCZSZhIIIGC4ChiHSew5kwM5omILZPiOBI0hwZw5kodIdA+M4Uj4PxOmMSJ9DuTQzmyZgviceZagaHVfj4awwmaAh2GUIYmCOEZZDaDR' +
'DFGdwcg4EwyHMN4LBOaJbCoaZqgKH8qkMfIyD8DozDyfA7A0Coui0OpMmOZJdCsahKg6NooioChwmEMxLEoXJbDUTRXGSUgykyMgQG0GpPHMdI3D4TRCgSeQ0kmaw+lG' +
'NAtCOZJVCiT5DhyRQwAqMg0EoDBBGEGAsASC5yiSCw+k4Mp6lWNQuksTpRjMTxDGzJwGmGMpDDKXYTECSAxl6Q5olkK4PgMMIVkASRMBMBgzEkaZEjsNALhIZA6AeQBg' +
'k0ZJEgAAJ0CIAgODMNIsD6DRih9uYwFyAwfCUb5ijmbI+gwdxkk8MZMGeMpPCkDxzBiC5MHMPJLDSSROFMLIoBEQogEMFJPnENYQGgE4DCOaJfC7tYkhGTQ0kyWwykuX' +
'pMiyRpKjKR4wngM4JmOWJACCdYtHMWw+Eych4nINYLAEYA8AgdAEEsQZajaQoog4GxPiMVIolcdxNG8XZVkmNoRwWRVBlFeFEeAZQJgnFiHgHwcAhjhHgGMSI5xki2Cy' +
'A4EQsA3i0HkBsLwKRFgAHcPkHopBJBcBeDUYI7xyDOHqKkWo2hLCsDIBIY4qQ5A8DoMMYwOAqCSBGKgU4yB2iDBwIgB4hxQgAAWNgBoAgsBdEcBUQ4sQ9A/HqD0JI8Rp' +
'BzH2OYVgahLBHFiJQJweQiDhDUE4SAARQAzFsG0EQwA6AOWSBkFgVAIBCHeGERQFQiCQHeFkC4vkiB8DyB4F4QxVDvGMNEOQexMjlBeOAKQiQLgfDA7QEAaRiBdEkH8T' +
'I7AZiFBAGYBIABWjYBiGACioQ4C1A+AMMgWhfgxHgPsT4URIB0COKgPgjRwiAB8AYUArxBgCF6J4GY5hrAOCAPAAoGRRCsCIMEXATXfgAF8BMJwURuEQDgD4Q4OBoAeH' +
'GFgLIwQrC2D0JoSQ+QvhrHoSgQI8AbDFGID8C4Ah6BQAQAASACwgCYCMAUMARAvCKAiAMCAokeCKBEOAKgCBoDaHuMsEAqwJDiACDURg8R6gPCyDofYWAhgoDIJ4ZAuh' +
'oiGAYGgRoQw/A0GMMga4GwxiEDeIYYInATCDBQAoBAwAoDlA0KMBoVRGiDGwDQUYIRsgaGGDgM4LAwDWB8EcIA1APhjEgGQVwgRIgjFIIQHokgZA+CSEkLIKQSjHAwMs' +
'CwDAsAEB2ABTIwRwD6A8CMToSxkAxE4HYIw+BsgbBEDAHYBwojCBoIYFgXSjABE4MsHIbQWhlGILQS4UhvBdAUKEEwHgxDAAABQQQUAhgKHiDwE4JS4A7BGLQZwCR4ga' +
'BEMUYAqgKApHgGwVAIRNgvBMMQXImwZDtE4I8UIyAZCDCAE8AwrhgAdEEBACQLRCg4FEB4AYtA7CdEiPQMoJAMDNCkOMCAXAFDhH0D0Q4EgfAaGSK4NYzRUj9BuCgAgs' +
'wOBjB4Fqpw8B2ADAwE4A4Qx2DAE6JIaQPQGhAGKBcIQ5B5gHByKIFARwADbAyKUfgdBKBBGyEcVIAB/ijHoIoSA0gdBNl+OATYERZgBGSDYWIWAUCEGKA4FAhR7CIBtY' +
'QGYZg4CMAiKEcAOwkBjHWE8Z4lQgA+DkBoTohwwCeAaMEEgBQCCABgHMRwQRhhMEWFQd4HwZgwDqFESItAbAGEANCpINAzANCCJkK4ah+heFYBURwsQrS2CsMYMoWGBh' +
'YDWI0EInQgiApXaOVI1QFDsC8MUNoMBMA1HMJga4eh+BeAWOgNNowGjYzCGAAwax+iJBeBVT4gxoBIAGFsJFBxgBiGKFkKQ7g5DFFQEcAo4AzDDACKEQQLgCiJDYB0Mg' +
'RBCCQAgQEA==');
Add(3,'gBFLBCJwBAEHhEJAAEhABQ4Fg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' +
'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' +
'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4n' +
'GKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEosiYN5NHMOJ+D4TpTnSe' +
'Q7CEY4uBmBpPhgagdgcIZoHibIEyUBJZDQIJShoCgcCAcoyAQOYYlcZJ1D0DxDCiQgwEiAZMHEMJLFKPJ9D2DoDnidQ4k+Y5QmKEROBkIhKD0JIZDIS4TGUCQuEeEJjn' +
'OIg8CuY4RkYNgwGMM5RllGpThDRYIGKZIpCkJFUH0PINyWcQ3CaaZCG+HBnEOTJhD8Tx4GoeQ/GcaZSHOH5nCmQhshoZhihYYwhiYA4RlkNoNEMUZ3ByDjwEsPxOnMaJ' +
'9DuDR6F6GYmCmKh0nANtMioP4Gg8aoSiIO5NhodociqaY6GaFYkEyOg8lsNRNTaUgykyMgQG0GpPiONJbD8DpDEyfA6k0KwOkWMQsGsAJU0SagwkoJQJDIPISCQCJTGS' +
'UwyGaM4KkmMgtksHpFjAZ4TGCBAbgaSpcksdhNAMIJHHsD5TjSWWMAMOpwjyLwbk6cAz0KRJiDkDYzESCwiggcgcgYIQwCIEINCMCITj6TVxkMXp2j0cQLlCTo7E2F4y' +
'mkMZdhMPJHDGHpLAyVg+k4UwrCCSIyByDJ8DuDY8CiWY0kiXAXC6QJwFKGIjCeJpjgyezjlyDw6klHx5myRoMGwZwbkcToTEiew4kwbQfEmUgPkOKJUD4DpTHSHQmgkX' +
'I/ASTA1g0XIEDMTBimyfI7jSLYHEiUoPk0Fw/kadAsHGao8A0A5smEMJ2mNyg5gzJZwDgCpChyIZVyIZwFCMJEPASRkBqE+IcHInRcDxA2H4bIsx0AtDsIBpwZwYicD6' +
'BscwDwUBgHCIYaIfgtiVH2O4WgUwJjEFeAEQA7y4hMCiBMS4aRdB9A4CYE4LxljyBMHcDItBxinDCLcTYmgejBFQ9UTg9gFBOEmAQTI7A4iZGMGkQAWQ7jYA2HIL8BRA' +
'jDG4HcCwARbjZHiNoDw1nLDnGyNINQ+wjCpBMEgcovQUgICQJEcgWRuBvAyJ4d4ugpCUAINcHogxIgnDiM4N4axzD3F2JMTY/hRqYF6FsWIxhYAGGoAALQYgYirBwBEB' +
'wpAjBEAAIEIYsA2gOHCMAGgXAACIDmMITAUgFABH0D0I4WwvhNFGMAOIvxRD2GKNcMA8gjAPDCPwBogRPAxA8PgRwZRICYDED8RAXQEghEAN8DIgwIBdB4JYWwMgtiQH' +
'oFQKAiRFguFKGwGQhglDsEOVwEQQRkCKBwOIHgSREDRBYHEXQcQdD7GIGARQHRxipBrMobgewDCUCADsEYWAzgMHKHQDQxxsDzA6EMfAeQHB4GQDkUYPA0iECiKoGgRh' +
'cDdA2GMQA8AOCjDSPgHI4QnApAKBICwHg1A+BcAwcYsgbjGGQNkCIgRsA6EcBEWANADjsB0B8YYzQQDIGSBcEYZBCCPEkFIHQSgkgZAwG4IwBAbAYGGAgL4Ch4g8BOCQ' +
'AA2KKC0GcAke4AAXAFCoHkDw4xbBFEcJkE4JRSiEFeJYKQVRMgJHODwX4xAgC/AsIIZAeAHDRG0HYI40RKCLEGDUI4jAghwBWIceA+whCpHMFYZYOQxglDMHMBQGxYjV' +
'HiAoBIPgfgHGwPsHYJRSB6A0IERQLhCjJHMA4OQoAoCOACLYGYSx8DpBQIMWQdRnDRH+DsE4fB3CeAmM67kAAXBFEIDYDI7wLBtEoEIfYNwjiUGGJQYQMAjCHEAO0C4z' +
'xW29CoCgfIxR9AKA6J8BgUAIhDGMIoJ40hqgwCgKETgnBhhqCGI0AIqgZhGDANQDIlBDCRGkCoJISR0g1BSKQOgfAzBRG0DYHARh4DeDAOwANuw8ApCKKkYg/RPhjBsH' +
'0J4yg5hPGWN0GwFBHQBFaDoQIURljFAoB4GgzRVzbBECQFQRQoguHGHANwDRdCKy8CgSIGwhhoDYJYYI1giBICSAEgI=');
Add(4,'gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjHL' +
'UXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKBU' +
'rGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo3' +
'NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDsY' +
'YDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoVm' +
'WCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoVo' +
'WiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZiS' +
'e41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbhF' +
'CcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==');
end;
(GetOcx() as EXPIVOTLib.Pivot).BackColorHeader := $4c6c6c6;
(GetOcx() as EXPIVOTLib.Pivot).SelBackColor := $4000000;
SelForeColor := Color.FromArgb(0,0,1);
set_CheckImage(EXPIVOTLib.CheckStateEnum.Unchecked,16777216);
set_CheckImage(EXPIVOTLib.CheckStateEnum.Checked,33554432);
set_CheckImage(EXPIVOTLib.CheckStateEnum.PartialChecked,50331648);
set_Background(EXPIVOTLib.BackgroundPartEnum.exSelBackColorFilter,SelBackColor);
set_Background(EXPIVOTLib.BackgroundPartEnum.exSelForeColorFilter,SelForeColor);
set_Background(EXPIVOTLib.BackgroundPartEnum.exBackColorFilter,BackColor);
set_Background(EXPIVOTLib.BackgroundPartEnum.exForeColorFilter,ForeColor);
set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,$ffffffff);
set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$4000000);
set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarActive,$4010101);
set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$40000ff);
HeaderAppearance := EXPIVOTLib.AppearanceEnum.Etched;
GridLineStyle := EXPIVOTLib.GridLinesStyleEnum.exGridLinesGeometric;
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '12,0';
PivotColumns := 'sum(5)';
PivotTotals := '/sum';
DataColumns.Item[TObject(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
EndUpdate();
end
|
145
|
ImageSize property on 16 (default) (specifies the size of control' icons/images/check-boxes/radio-buttons)
![](images/expivotq145.png)
with AxPivot1 do
begin
BeginUpdate();
ImageSize := 16;
Images('gBJJgBAIDAAEg4ACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjMLjABAAgjUYkUnlUrlktl0vmExmUzmk1m03nE5nU7nkrQCAntBoVDolFo1HoM/ADAplLptImdMYFOqd' +
'SqlXq1QrVbrlGpVWsFNrNdnNjsk7pQAtNroFnt0sh8Yr9iulTuNxs1Eu8OiT/vsnsNVutXlk/oGGtVKxGLxWNtsZtN8iUYuNvy0Zvd+xNYwdwvl4p870GCqc8vOeuVtt' +
'mp1knyOayWVy+WzN/ze1wOElenm+12WUz/Bv2/3UyyWrzeutux2GSyGP2dQ33C1ur3GD3M4zUNzHdlWjq/E3nGzVpjWv4HA7fRy/Tv2IrN8rPW6nZ3ve7mUlfu20Z8ac' +
'vQyb+vY9jasYoDwMm+LytVBDqKG3z8O3Cb8P+mkAuY9cCQ2uL4KaxDKvkp8RNLEjqugnrwQo/UWPzFyeQw5sNLZFENrI4kOqU66pw8uzmOKvTqNqjULJvGL1JO48GtTG' +
'sbLdEL3scxLlyiw8dQeoUVxdLTtyKmUjwGlslRPJsnK1HbAKbKCrsQo8uQk/CeP44iaR/ATnTNPLvyxPU+z9P9AUDQVBowiofJXQ6Oo+kKMpIkjztE4TKn4P6JowfgPn' +
'wD5/nAjB8AOeAPo0eAA1IAFH07UhAIMpYAVIYFHqBUhwVjV1S1EtQAHxW65V0AZwAeuQAnwB5gAPYViEDVhwAHTQBkCjB4gOhwDmCyhH0sACAg==');
with VisualAppearance do
begin
Add(4,'gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjHL' +
'UXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKBU' +
'rGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo3' +
'NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDsY' +
'YDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoVm' +
'WCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoVo' +
'WiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZiS' +
'e41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbhF' +
'CcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==');
end;
(GetOcx() as EXPIVOTLib.Pivot).BackColorHeader := $4c6c6c6;
(GetOcx() as EXPIVOTLib.Pivot).SelBackColor := $4000000;
SelForeColor := Color.FromArgb(0,0,1);
set_Background(EXPIVOTLib.BackgroundPartEnum.exSelBackColorFilter,SelBackColor);
set_Background(EXPIVOTLib.BackgroundPartEnum.exSelForeColorFilter,SelForeColor);
set_Background(EXPIVOTLib.BackgroundPartEnum.exBackColorFilter,BackColor);
set_Background(EXPIVOTLib.BackgroundPartEnum.exForeColorFilter,ForeColor);
set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,$ffffffff);
set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$4000000);
set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarActive,$4010101);
set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$40000ff);
HeaderAppearance := EXPIVOTLib.AppearanceEnum.Etched;
GridLineStyle := EXPIVOTLib.GridLinesStyleEnum.exGridLinesGeometric;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '12,0';
PivotColumns := 'sum(5)';
PivotTotals := '/sum';
DataColumns.Item[TObject(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
EndUpdate();
end
|
144
|
Is it possible to view all events the control fires
// Event event - Notifies the application once the control fires an event.
procedure TWinForm1.AxPivot1_Event(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_EventEvent);
begin
with AxPivot1 do
begin
OutputDebugString( get_EventParam(-2) );
end
end;
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatConditionalAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
EndUpdate();
end
|
143
|
Does your control support images
![](images/expivotq143.png)
with AxPivot1 do
begin
BeginUpdate();
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
DataColumns.Item[TObject(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
EndUpdate();
end
|
142
|
Is it possible to rename the generated-columns
![](images/expivotq142.png)
with AxPivot1 do
begin
BeginUpdate();
HeaderAppearance := EXPIVOTLib.AppearanceEnum.Etched;
HeaderHeight := 24;
Import('Item;1;2;3#A;10;20;30#A;20;40;50#A;20;30;20#B;10;10;10#B;20;50;30','str=`''` eor=''#'' eof='';'' hdr=1');
PivotRows := 0;
PivotColumns := 'sum(1),sum(2),sum(3)';
FormatPivotHeader := '(iaggregate ? (proper(aggregate) + ` <off -4>` + (caption case (default:`None`; 1:`Sunday`; 2:`Monday`; 3:`Tuesday`; 4:`Wednesda' +
'y`; 5:`Thursday`; 6:`Friday`; 7:`Saturday`)) + `</b>`) : caption)';
EndUpdate();
end
|
141
|
Is it possible to rename the columns
![](images/expivotq141.png)
with AxPivot1 do
begin
BeginUpdate();
AppendData('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
DataColumns.Item[TObject(0)].Caption := '<b>Nation';
Refresh();
EndUpdate();
end
|
140
|
The pivot's rows and columns arer lost once I call the AppendData. Can I add/append data in the background so the layout of the pivot is not lost
![](images/expivotq140.png)
with AxPivot1 do
begin
BeginUpdate();
AppendData('Def',Nil);
AppendData('A',Nil);
AppendData('A',Nil);
AppendData('A',Nil);
PivotRows := 0;
PivotColumns := 'count(0)';
s := Layout;
AppendData('B',Nil);
AppendData('B',Nil);
Layout := s;
EndUpdate();
end
|
139
|
Is it possible to add data without clearing the previously data
![](images/expivotq139.png)
with AxPivot1 do
begin
BeginUpdate();
AppendData('Column',Nil);
AppendData('1',Nil);
AppendData('2',Nil);
AppendData('3',Nil);
EndUpdate();
end
|
138
|
How can I change the visual appearance of the Total button
![](images/expivotq138.png)
with AxPivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(2,'gBFLBCJwBAEHhEJAAEhABAoCg6AADACAxRDgMQBQKAAzQFAcDBvBgABoGEZIJhUAIIRZGMIjFDcEwxC6NIpjeIBSDUJYkSZEAyjBI8ExXFqMQCkGKocgONYgQLHcgxeA' +
'0XRYFoYRinWA5PoAMoyTYMdIAnTOM4eU6AATwTSccw0fisAAfeq4Wh+HwIQiUBomGahajkMqDYRVagyCI2a4ZDZCIoVJalLAxCw8KDqGJnMr1R5/MDgOBYogXBqHYhiO' +
'AsdhjSYdBK/WLeHI6Y1GS7MMxzLK8cxVaqfMpoMI4FjuS5NU7TMC0PAXdy3LqvbBsOxbHqma5nVSBcC2ba9cz3PK4ABuW7bM6TRKNYbkOA4LiNQaxVSrNKmIwPI5DJ5M' +
'l2co1h0d5vBWDJQEkCI7mIJpykyTZblqdhYDyR5TlmX5RBgeI+D4BxLDkO5nlieh5g2FQ5DOZAiDkDASAmYh7l0RxZncPxfhadZkBmH5jvKLhamMcItBYXgoC4B4CBgF' +
'oskEP4hkgdgegcD4zlycA1goAJ5mIc4KjgfJ+D0ToTFGbx4h8Qh2CqDJjEeJg0gyT4DkCYg5kyAhCDeBxjkIQgDHSIgTkIP4NGGFplgGEZkkifhFgSIRHgCXwtAYeQ2B' +
'+DYlGkZgqgsIpnEoJxzmWGRiFqGJhmkBhDAwJBZDIYoZCYSQ+BOFAmBkJZBhKZpJlYHIXCYR4lFuHpnkmdh+h+aAKAaAogF6FhWgOIZogoJh/GuHoTl6DojmkChGhKJJ' +
'pEoVoWiUHAGDCTg6CmSheh6J5qAoTJriiWQUCSb4ploEwpgq4BKjWBomhmc4pAkOpRAQJQBICA==');
Add(1,'CP:2 -10 -6 8 8');
end;
set_Background(EXPIVOTLib.BackgroundPartEnum.exPivotBarTotal,$1000000);
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
EndUpdate();
end
|
137
|
Is it possible to highlight the column's header once a filter is applied
![](images/expivotq137.png)
with AxPivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(2,'gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgANJ' +
'0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8YN' +
'YuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4h' +
'hKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mgb' +
'hOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhWB' +
'MJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=');
Add(1,'CP:2 -8 -4 2 4');
end;
HeaderHeight := 28;
set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$1fefefe);
set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarActive,$1010101);
set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,$ffffffff);
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' +
'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( match' +
'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' +
't + ` item(s)`) )))';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
136
|
How can I change the format the column displays (for instance, displaying no 0:00:00)
![](images/expivotq136.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FormatContents.Add('notime','value replace `0:00:00` with ``',Nil);
PivotRows := '9[content=notime]';
EndUpdate();
end
|
135
|
Is it possible to show the filterbar on top of the rows
![](images/expivotq135.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarTop) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
134
|
How can I uses the control in window-less mode (with no user interface, option 3)
![](images/expivotq134.png)
with AxPivot1 do
begin
with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot')) as EXPIVOTLib.Pivot) do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'avg(5)';
OutputDebugString( Export(Nil,Nil) );
end;
end
|
133
|
How can I uses the control in window-less mode (with no user interface, option 2)
![](images/expivotq133.png)
with AxPivot1 do
begin
with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot')) as EXPIVOTLib.Pivot) do
begin
rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset')) as ADODB.Recordset);
with rs do
begin
Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb',3,3,Nil);
end;
DataSource := (rs as ADODB.Recordset);
PivotRows := '0';
PivotColumns := 'max(5)';
OutputDebugString( Export(Nil,Nil) );
end;
end
|
132
|
How can I uses the control in window-less mode (with no user interface, option 1)
![](images/expivotq132.png)
with AxPivot1 do
begin
with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot')) as EXPIVOTLib.Pivot) do
begin
LoadXML('http://www.exontrol.net/testing.xml');
PivotRows := '1';
PivotColumns := 'max(6)';
OutputDebugString( Export(Nil,Nil) );
end;
end
|
131
|
How can I connect to a DBF file
![](images/expivotq131.png)
with AxPivot1 do
begin
BeginUpdate();
rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADODB.Recordset')) as ADODB.Recordset);
with rs do
begin
Open('Select * From foxcode.DBF','Provider=vfpoledb;Data Source=C:\Program Files\Microsoft Visual FoxPro 9\',3,3,Nil);
end;
DataSource := (rs as ADODB.Recordset);
PivotRows := '0';
PivotColumns := 'count(0)[content=numeric],avg(7)[negative,content=numeric]';
EndUpdate();
end
|
130
|
Export Data in HTML format
![](images/expivotq130.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' +
'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( match' +
'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' +
't + ` item(s)`) )))';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
with FormatConditionalAppearances do
begin
Add('G1000','> 1000','value > 1000').ForeColor := $ff0000;
Add('L1000','< 1000','value < 1000').ForeColor := $ff;
Add('Zero','zero','value = 0').BackColor := $e0e0e0;
end;
with FormatAppearances do
begin
Add('grayed',Nil).ForeColor := $808080;
Add('red',Nil).ForeColor := $ff;
Add('green',Nil).ForeColor := $ff00;
Add('blue',Nil).ForeColor := $ff0000;
Add('bgrayed',Nil).BackColor := $808080;
Add('bred',Nil).BackColor := $ff;
Add('bgreen',Nil).BackColor := $ff00;
Add('bblue',Nil).BackColor := $ff0000;
end;
PivotRows := '0[bold],2[grayed]';
PivotColumns := 'sum(5)[L1000],sum(5)[G1000]/12:A';
PivotTotals := 'sum[bold,content=currency,bgrayed]';
AutoDrag := EXPIVOTLib.AutoDragEnum.exAutoDragScroll;
BackColorAlternate := Color.FromArgb(240,240,240);
FilterBarPromptType := EXPIVOTLib.FilterPromptEnum.exFilterPromptContainsAny;
FilterBarPromptPattern := 'France Germany';
EndUpdate();
OutputDebugString( Export('htm',Nil) );
end
|
129
|
Export Data in HTML format (IE)
![](images/expivotq129.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' +
'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( match' +
'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' +
't + ` item(s)`) )))';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
with FormatConditionalAppearances do
begin
Add('G1000','> 1000','value > 1000').ForeColor := $ff0000;
Add('L1000','< 1000','value < 1000').ForeColor := $ff;
Add('Zero','zero','value = 0').BackColor := $e0e0e0;
end;
with FormatAppearances do
begin
Add('grayed',Nil).ForeColor := $808080;
Add('red',Nil).ForeColor := $ff;
Add('green',Nil).ForeColor := $ff00;
Add('blue',Nil).ForeColor := $ff0000;
Add('bgrayed',Nil).BackColor := $808080;
Add('bred',Nil).BackColor := $ff;
Add('bgreen',Nil).BackColor := $ff00;
Add('bblue',Nil).BackColor := $ff0000;
end;
ShowBranchRows := Integer(EXPIVOTLib.ShowBranchRowsEnum.exBranchIncludeAggregate) Or Integer(EXPIVOTLib.ShowBranchRowsEnum.exBranchTree);
PivotRows := '0[bold],2[grayed]';
PivotColumns := 'sum(5)[L1000],sum(5)[G1000]/12:A';
PivotTotals := '/sum[bold,content=currency,bgrayed]';
AutoDrag := EXPIVOTLib.AutoDragEnum.exAutoDragScroll;
BackColorAlternate := Color.FromArgb(240,240,240);
FilterBarPromptType := EXPIVOTLib.FilterPromptEnum.exFilterPromptContainsAny;
FilterBarPromptPattern := 'France Germany';
EndUpdate();
sFile := 'c:/temp/export.htm';
Export(TObject(sFile),'vis');
with (ComObj.CreateComObject(ComObj.ProgIDToClassID('InternetExplorer.Application')) as SHDocVw.ShellBrowserWindow) do
begin
end;
end
|
128
|
Export Data in CSV format
![](images/expivotq128.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5),sum(5)/12:A';
PivotTotals := 'sum[bold,content=currency]';
AutoDrag := EXPIVOTLib.AutoDragEnum.exAutoDragScroll;
BackColorAlternate := Color.FromArgb(240,240,240);
EndUpdate();
OutputDebugString( Export(Nil,Nil) );
end
|
127
|
Is it possible to change the visual appearance of the update / reload button being displayed in the control's pivot bar
![](images/expivotq127.png)
with AxPivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABMsGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwCgkBYJDSMAiiaLETwHFKVRwkWBBWjMAAxDZFcggA7' +
'7fwxHaOAghGgobjaPY+UbGERAAKQahLJamablCSqLjCS4kSLHEbQHTcRSzLKQZBBCCSQKkYx0HScRiwPBIbQkIQmbajOaYDCiQ53QLCAYRXS9PwvI7AMBwLA8EwXBo9D' +
'ZiIy4WyuGj3R4WchAbIwIxUK6XHhmLjZXg+Bz9T6LQZ0JStEx2SYjAJqOiKU62W9xbAUOxQTpIBJXW7Oc7GTa8dQfPoJaIDLicHgoZ6NLIcOR0abSO42CRrdByfRYMwv' +
'isCQKnYOh9i4LwbBINpBHeBxeC6X4TAIEpzkIWgei8L4Qk2boEhWPg9C4SJijIOZ7mEXA/iAX5yBKDx/lmVhEC0Z5ZlKHgGAAYIHkGcQxiCQ5eA4PghAKNgSG0VYXEiJ' +
'YFl+QAtiCBpdjcDJkB0IgAiYIgBmIQAWCYCoigYZB4DQYpAjoLh3h6SJFgcOpXlAAQBICA==');
end;
set_Background(EXPIVOTLib.BackgroundPartEnum.exPivotBarReload,$1000000);
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatConditionalAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
EndUpdate();
end
|
126
|
Is it possible to change the visual appearance of the plus/add new button being displayed in the control's pivot bar
![](images/expivotq126.png)
with AxPivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQSB' +
'cQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+OpfD' +
'xXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4l' +
'lWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5JlgX' +
'IcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIRg' +
'wZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOMI' +
'NCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=');
end;
set_Background(EXPIVOTLib.BackgroundPartEnum.exPivotBarAddNew,$1000000);
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
EndUpdate();
end
|
125
|
Is it possible to change the visual appearance of the position signs when user changes the column's position by drag and drop
![](images/expivotq125.png)
with AxPivot1 do
begin
BeginUpdate();
HeaderAppearance := EXPIVOTLib.AppearanceEnum.Etched;
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzVI' +
'UcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4a' +
'DhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DBe' +
'EMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDIB' +
'ICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAokG' +
'KHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI=');
Add(2,'CP:1 0 -36 0 0');
end;
set_Background(EXPIVOTLib.BackgroundPartEnum.exColumnsPositionSign,$2000000);
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
EndUpdate();
end
|
124
|
FilterBarCaption ALL Keyword ( sample 2, result )
![](images/expivotq124.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' +
'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( match' +
'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' +
't + ` item(s)`) )))';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
123
|
FilterBarCaption ALL Keyword ( sample 1 )
![](images/expivotq123.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := 'all';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
122
|
FilterBarCaption ALLUI Keyword ( sample 2, result )
![](images/expivotq122.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := '(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' +
'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( match' +
'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' +
't + ` item(s)`) )))';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
121
|
FilterBarCaption ALLUI Keyword ( sample 1 )
![](images/expivotq121.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := 'allui';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
120
|
FilterBarCaption AVAILABLE Keyword ( sample 2, result )
![](images/expivotq120.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := '(( ( value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` ) + ` ` + ( avai' +
'lable replace `[` with `<bgcolor=C0C0C0><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` replace `<s>` with ``' +
' replace `</s>` with `` ) + `<fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount ' +
'+ 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount + ` item(s)`) )))';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
119
|
FilterBarCaption AVAILABLE Keyword ( sample 1 )
![](images/expivotq119.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := 'value + ` ` + available';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
118
|
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 3, results )
![](images/expivotq118.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := '(`<b>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ' +
'` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )) replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace' +
' `]` with ` </b></bgcolor></fgcolor>`';
FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle;
EndUpdate();
end
|
117
|
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 2 )
![](images/expivotq117.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := 'value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>`';
FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle;
EndUpdate();
end
|
116
|
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 1 )
![](images/expivotq116.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
FilterBarCaption := 'value replace `[` with `<fgcolor=808080>[` replace `]` with `]</fgcolor>`';
FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle;
EndUpdate();
end
|
115
|
Is it possible to automatically displays the control's filter label to the right
![](images/expivotq115.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarCaption := '`<r>` + value';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle);
EndUpdate();
end
|
114
|
How can I get the number of results/items being shown in the control's filter bar (sample 4)
![](images/expivotq114.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
FilterBarPrompt := FormatABC('`<b>` + value',TObject(FilterBarPrompt),Nil,Nil);
FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount +' +
' 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
113
|
How can I get the number of results being shown in the control's filter bar (sample 3)
![](images/expivotq113.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount +' +
' 1) + ` result(s)` ) : ``)';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
112
|
How can I get the number of results being shown in the control's filter bar (sample 2, compact)
![](images/expivotq112.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
111
|
How can I get the number of results being shown in the control's filter bar (sample 1)
![](images/expivotq111.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
FilterBarCaption := '`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
110
|
FilterBarCaption Predefined Keywords
![](images/expivotq110.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
LinesAtRoot := EXPIVOTLib.LinesAtRootEnum.exLinesAtRoot;
FilterInclude := EXPIVOTLib.FilterIncludeEnum.exItemsWithChilds;
FilterBarFont := (Font as stdole.StdFont);
FilterBarCaption := '`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</i' +
'></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>:' +
' ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><' +
'i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</i' +
'></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=80' +
'8080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount + ' +
'`</fgcolor>`';
FilterBarPromptPattern := 'USA';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
109
|
I am using filter prompt feature, and also column's filter, just wondering if possible to compact displaying the filter bar so it won't show on multiple lines
![](images/expivotq109.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarFont := (Font as stdole.StdFont);
FilterBarCaption := '`<r><i><fgcolor=808080><upline><solidline><sha ;;0>` + value';
FilterBarPromptPattern := 'USA';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
108
|
Just wondering if it is possible to show the filter bar's close button on the right ( sample 2 )
![](images/expivotq108.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
FilterBarPrompt := FormatABC('`<r>` + value',TObject(FilterBarPrompt),Nil,Nil);
EndUpdate();
end
|
107
|
How can I change the visual appearance of the filter bar's close button (EBN)
![](images/expivotq107.png)
with AxPivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJj' +
'yI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKmS' +
'ZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8ORO' +
'icbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2D' +
'YxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJXA' +
'iAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaKJ' +
'DCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G0' +
'TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEAk' +
'jIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRSM' +
'RsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhAQ' +
'HkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ');
end;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$1000000);
EndUpdate();
end
|
106
|
How can I change the visual appearance of the filter bar's close button (solid)
![](images/expivotq106.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$ff);
EndUpdate();
end
|
105
|
Is it possible to prevent definitely showing the filter bar's close button
![](images/expivotq105.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$ffffffff);
EndUpdate();
end
|
104
|
Is it possible to show the close button only if there is a filter applied
![](images/expivotq104.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
103
|
The control's filter bar is not closed once I click the close button (toggle)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarCaption := '`<r><fgcolor=808080>` + value';
FilterBarPromptPattern := 'USA';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
102
|
How can I display the control's filter on a single line
![](images/expivotq102.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarCaption := 'len(value) ? `filter for: <fgcolor 808080>` + value : `<fgcolor 808080>no filter`';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible);
EndUpdate();
end
|
101
|
How can I display the control's filter on a single line (prompt-combined)
![](images/expivotq101.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarCaption := '`<r>` + value';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
100
|
How can I programmatically clear the control's filter
// Click event - Occurs when the user presses and then releases the left mouse button over the control.
procedure TWinForm1.AxPivot1_ClickEvent(sender: System.Object; e: System.EventArgs);
begin
with AxPivot1 do
begin
ClearFilter();
end
end;
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
FilterBarPromptPattern := 'USA';
EndUpdate();
end
|
99
|
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)
![](images/expivotq99.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptPattern := 'USA';
FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
EndUpdate();
end
|
98
|
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)
![](images/expivotq98.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
FilterBarPromptPattern := 'USA';
EndUpdate();
end
|
97
|
Is it possible to prevent closing the control's filter bar, so it is always shown
![](images/expivotq97.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FilterBarCaption := 'len(value) = 0 ? `<fgcolor=808080>no filter` : value';
FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible;
EndUpdate();
end
|
96
|
How can I find if the control is running in DPI mode
with AxPivot1 do
begin
OutputDebugString( FormatABC('dpi = 1 ? `normal/stretch mode` : `dpi mode`',Nil,Nil,Nil) );
end
|
95
|
If I connect it to a datasource, all works perfectly but the records that I see in the control is a little number of total of the recordset. I need to show all 60.000 rows of the recordset without click on the [...] button. It’s possible to setting up this parameters
with AxPivot1 do
begin
DisplayPivotData := -1;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
end
|
94
|
How do I change the drop down filter icon/button (white)
![](images/expivotq94.png)
with AxPivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(2,'gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgANJ' +
'0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8YN' +
'YuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4h' +
'hKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mgb' +
'hOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhWB' +
'MJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=');
Add(1,'CP:2 -6 -4 2 4');
end;
set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$1000000);
set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,BackColor);
HeaderVisible := True;
HeaderHeight := 24;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
DisplayFilterList := Integer(EXPIVOTLib.FilterListEnum.exShowCheckBox) Or Integer(EXPIVOTLib.FilterListEnum.exSortItemsAsc);
PivotBarVisible := EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible;
EndUpdate();
end
|
93
|
How do I change the drop down filter icon/button (black)
![](images/expivotq93.png)
with AxPivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQg' +
'mPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYThd' +
'r4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA');
end;
set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$1000000);
set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,$ffffffff);
BackColorHeader := Color.FromArgb(0,0,0);
ForeColorHeader := Color.FromArgb(255,255,255);
HeaderVisible := True;
HeaderHeight := 22;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
DisplayFilterList := Integer(EXPIVOTLib.FilterListEnum.exShowCheckBox) Or Integer(EXPIVOTLib.FilterListEnum.exSortItemsAsc);
EndUpdate();
end
|
92
|
How do I prevent showing the control's BackColorAlternate property on empty / non-items part of the control
![](images/expivotq92.png)
with AxPivot1 do
begin
BeginUpdate();
(GetOcx() as EXPIVOTLib.Pivot).BackColorAlternate := $7ff0f0f0;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '12';
PivotColumns := 'sum(5)';
EndUpdate();
end
|
91
|
How can I find out if the user clicks the grid's header
// MouseMove event - Occurs when the user moves the mouse.
procedure TWinForm1.AxPivot1_MouseMoveEvent(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_MouseMoveEvent);
begin
with AxPivot1 do
begin
OutputDebugString( 'Type of ColumnFromPoint: ' );
OutputDebugString( get_ColumnFromPoint(-1,-1) );
OutputDebugString( ' should not be VT_NULL' );
OutputDebugString( 'Type of ValueFromPoint: ' );
OutputDebugString( get_ValueFromPoint(-1,-1) );
OutputDebugString( ' should be VT_NULL' );
end
end;
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)';
end
|
90
|
What should I set FormatPivotHeader to, to show it on the columns header only
![](images/expivotq90.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)/12';
FormatPivotHeader := '(iaggregate ? ( caption + ` <off -6><font ;6>(` + lower(caggregate) + '')</off></font>'') : caption) + ( ( display=1 ? `<c>Date: <' +
'b><upline><dotline>` + date(`now`) : `` ) + `</dotline> </b>` )';
EndUpdate();
end
|
89
|
What should I set FormatPivotHeader to, to show "Report Generated on 7/9/2016 14:20" etc when the report is executed (ie the date and time will change)
![](images/expivotq89.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)/12';
FormatPivotHeader := '(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + '')</off></font>'') : caption) + `<r>ReportDate: ' +
'` + date(`now`)';
EndUpdate();
end
|
88
|
Is it possible to display aggregate result on parent rows as well
![](images/expivotq88.png)
with AxPivot1 do
begin
BeginUpdate();
HeaderHeight := 22;
DefaultItemHeight := 20;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '12[bold],0';
with FormatConditionalAppearances.Add('nempty','not empty','') do
begin
Expression := 'len(value) != 0';
BackColor := $f0f0f0;
end;
PivotColumns := 'sum(5)[nempty]/6';
IncludeExpandColumn := EXPIVOTLib.IncludeExpandColumnEnum.exIncludeExpandColumn;
DrawGridLines := EXPIVOTLib.GridLinesEnum.exNoLines;
ShowBranchRows := Integer(EXPIVOTLib.ShowBranchRowsEnum.exBranchIncludeAggregate) Or Integer(EXPIVOTLib.ShowBranchRowsEnum.exBranchTree);
EndUpdate();
end
|
87
|
How do I show expanded/collapsed rows
![](images/expivotq87.png)
with AxPivot1 do
begin
BeginUpdate();
HeaderHeight := 22;
DefaultItemHeight := 20;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '12[bold],0';
with FormatConditionalAppearances.Add('nempty','not empty','') do
begin
Expression := 'len(value) != 0';
BackColor := $f0f0f0;
end;
PivotColumns := 'sum(5)[nempty]/6';
IncludeExpandColumn := EXPIVOTLib.IncludeExpandColumnEnum.exIncludeExpandColumn;
DrawGridLines := EXPIVOTLib.GridLinesEnum.exNoLines;
EndUpdate();
end
|
86
|
How do I show expanded/collapsed columns
![](images/expivotq86.png)
with AxPivot1 do
begin
BeginUpdate();
HeaderHeight := 22;
DefaultItemHeight := 20;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
with FormatConditionalAppearances.Add('nempty','not empty','') do
begin
Expression := 'len(value) != 0';
BackColor := $f0f0f0;
end;
PivotColumns := 'sum(5)[nempty]/12';
FormatPivotHeader := '(iaggregate ? ( caption + ` <r>[` + lower(caggregate) + `]` ) : caption)';
IncludeExpandColumn := EXPIVOTLib.IncludeExpandColumnEnum.exIncludeExpandColumn;
EndUpdate();
end
|
85
|
Where you have say "Sum of ...." as the first row heading of the pivot are there and options to be able to change this text as a whole
![](images/expivotq85.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
with FormatConditionalAppearances.Add('nempty','not empty','') do
begin
Expression := 'len(value) != 0';
BackColor := $f0f0f0;
end;
PivotColumns := 'sum(5)[nempty]/12';
FormatPivotHeader := '(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + '' )'') : caption)';
EndUpdate();
end
|
84
|
How can I get the data column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TWinForm1.AxPivot1_MouseMoveEvent(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_MouseMoveEvent);
begin
with AxPivot1 do
begin
OutputDebugString( 'DataColumn' );
OutputDebugString( get_DataColumnFromPoint(-1,-1) );
end
end;
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[content=numeric]';
Refresh();
end
|
83
|
Is there any way for the user to change the alignment at runtime (using excontextmenu)
![](images/expivotq83.png)
// RClick event - Occurs once the user right clicks the control.
procedure TWinForm1.AxPivot1_RClick(sender: System.Object; e: System.EventArgs);
begin
// FlatImageWidth = 0
// ToString = "Alignment[align=1][dis],[group=0x71](Left[typ=2][grp=100][close=0][id=0],Center[typ=2][grp=100][close=0][id=1],Right[typ=2][grp=100][close=0][id=2])"
// item(h).Checked = True
// h = Select()
with AxPivot1 do
begin
h := DataColumns.Item[TObject(5)].Alignment;
with c do
begin
end;
with DataColumns.Item[TObject(5)] do
begin
Alignment := h;
HeaderAlignment := h;
end;
Refresh();
end
end;
with AxPivot1 do
begin
PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
with DataColumns.Item[TObject(5)] do
begin
Alignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
HeaderAlignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
end;
PivotRows := '0';
PivotColumns := 'sum(5)[content=numeric]';
Refresh();
end
|
82
|
Is there any way for the user to change the alignment at runtime
![](images/expivotq82.png)
// RClick event - Occurs once the user right clicks the control.
procedure TWinForm1.AxPivot1_RClick(sender: System.Object; e: System.EventArgs);
begin
with AxPivot1 do
begin
OutputDebugString( 'The column gets aligned to the center' );
with DataColumns.Item[TObject(5)] do
begin
Alignment := EXPIVOTLib.AlignmentEnum.CenterAlignment;
HeaderAlignment := EXPIVOTLib.AlignmentEnum.CenterAlignment;
end;
Refresh();
end
end;
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
with DataColumns.Item[TObject(5)] do
begin
Alignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
HeaderAlignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
end;
PivotRows := '0';
PivotColumns := 'sum(5)[content=numeric]';
Refresh();
end
|
81
|
How can I align a column to the right
![](images/expivotq81.png)
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
with DataColumns.Item[TObject(5)] do
begin
Alignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
HeaderAlignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
end;
PivotRows := '0';
PivotColumns := 'sum(5)[content=numeric]';
Refresh();
end
|
80
|
How can I display the control's content on an single A3 paper size, when using PDF format
with AxPivot1 do
begin
BeginUpdate();
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
PivotRows := '0';
PivotColumns := 'sum(5)[positive,negative]/12';
ExpandAll();
var_CopyTo := get_CopyTo('C:\Temp\Preview.pdf|11.69 in x 16.53 in||single');
OutputDebugString( 'Look for C:\Temp\Preview.pd file.' );
EndUpdate();
end
|
79
|
How can I display the control's content on an A3 paper size, when using PDF format
with AxPivot1 do
begin
BeginUpdate();
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
PivotRows := '0';
PivotColumns := 'sum(5)[positive,negative]/12';
ExpandAll();
var_CopyTo := get_CopyTo('C:\Temp\Preview.pdf|11.69 in x 16.53 in');
OutputDebugString( 'Look for C:\Temp\Preview.pd file.' );
EndUpdate();
end
|
78
|
How can I export the control's content to a PDF document (method 1)
with AxPivot1 do
begin
BeginUpdate();
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
PivotRows := '0';
PivotColumns := 'sum(5)[positive,negative]/12';
ExpandAll();
EndUpdate();
with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
begin
PrintExt := (AxPivot1.GetOcx() as EXPIVOTLib.Pivot).DefaultDispatch;
CopyTo('c:/temp/xtest.pdf');
end;
OutputDebugString( 'Look for C:\Temp\xtest.pdf file.' );
EndUpdate();
end
|
77
|
How can I export the control's content to a PDF document (method 2)
with AxPivot1 do
begin
BeginUpdate();
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
PivotRows := '0';
PivotColumns := 'sum(5)[positive,negative]/12';
ExpandAll();
var_CopyTo := get_CopyTo('c:/temp/xtest.pdf');
OutputDebugString( 'Look for C:\Temp\xtest.pdf file.' );
EndUpdate();
end
|
76
|
Does / could the control have a read-only mode by where I could load the data and layout and just use the control to display it and allow the user to scroll around it / print it but not change it
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[content=numeric]';
DisplayFilterList := EXPIVOTLib.FilterListEnum.exNoItems;
PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarReadOnly) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
Refresh();
end
|
75
|
Is it possible to edit the conditional-expression at runtime
![](images/expivotq75.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
with FormatConditionalAppearances.Add('custom','custom','') do
begin
Bold := True;
FontSize := 12;
Expression := 'value > 2000';
ContextEditExpression := True;
end;
PivotRows := '0';
PivotColumns := 'sum(5)[custom]/12';
EndUpdate();
end
|
74
|
How can I highlight values using EBN colors
![](images/expivotq74.png)
with AxPivot1 do
begin
BeginUpdate();
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
PivotRows := '0';
PivotColumns := 'sum(5)[positive,negative]/12';
EndUpdate();
end
|
73
|
How do I mark not-empty values in the chart
![](images/expivotq73.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
with FormatConditionalAppearances.Add('nempty','not empty','') do
begin
Expression := 'len(value) != 0';
BackColor := $f0f0f0;
end;
PivotColumns := 'sum(5)[nempty]/12';
EndUpdate();
end
|
72
|
How can I highlight negative and positive values in the same chart
![](images/expivotq72.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[negative,positive]/12';
EndUpdate();
end
|
71
|
How can I highlight values that starts with a letter
![](images/expivotq71.png)
with AxPivot1 do
begin
BeginUpdate();
with FormatConditionalAppearances.Add('f','starts with f','lower(value) startwith `f`') do
begin
Expression := 'lower(value) startwith `f`';
Shadow := $1;
ShadowOffset := 0;
end;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0[f]';
EndUpdate();
end
|
70
|
How can I mark values greater than a value, 100 for instance
![](images/expivotq70.png)
with AxPivot1 do
begin
BeginUpdate();
with FormatConditionalAppearances.Add('greater100','>100','value > 100') do
begin
Expression := '( dbl(value) != 0 ) ? (value > 100) : 0';
ForeColor := $ff;
end;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[greater100,content=numeric]';
EndUpdate();
end
|
69
|
How can I remove the Conditional context-menu
![](images/expivotq69.png)
with AxPivot1 do
begin
BeginUpdate();
PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[content=numeric]';
EndUpdate();
end
|
68
|
How do change the way the negative/positive numbers show when using conditional-format
![](images/expivotq68.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
with FormatConditionalAppearances.Item['negative'] do
begin
BackColor := $0;
ForeColor := $808080;
FontSize := 8;
end;
with FormatConditionalAppearances.Item['positive'] do
begin
BackColor := $0;
ForeColor := $1;
FontSize := 11;
end;
PivotRows := '0';
PivotColumns := 'sum(5)[negative,positive,content=numeric]';
EndUpdate();
end
|
67
|
How do I highlight the negative values with white color or black
![](images/expivotq67.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
with FormatConditionalAppearances.Item['negative'] do
begin
BackColor := $1;
ForeColor := $ffffff;
end;
PivotRows := '0';
PivotColumns := 'sum(5)[negative,content=numeric]';
EndUpdate();
end
|
66
|
Does your control support conditional-format, so I can highlight certain values
![](images/expivotq66.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[negative,content=numeric]';
EndUpdate();
end
|
65
|
How do I add a computed column/field, like VAT for instance (method 2)
![](images/expivotq65.png)
with AxPivot1 do
begin
BeginUpdate();
with Aggregates do
begin
Add('vat19','sum','VAT 19%','VAT 19%').FormatValue := 'value * 0.19';
Add('vat24','sum','VAT 24%','VAT 24%').FormatValue := 'value * 0.24';
end;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[content=numeric],vat19(5)[bold,content=numeric],vat24(5)[bold,content=numeric]';
EndUpdate();
end
|
64
|
How do I add a computed column/field, like VAT for instance (method 1)
![](images/expivotq64.png)
with AxPivot1 do
begin
BeginUpdate();
with FormatContents.Add('vat19','VAT 19%',Nil) do
begin
Expression := 'len(value) ? ((value * 1.19) format '''') : ''''';
end;
with FormatContents.Add('vat24','VAT 24%',Nil) do
begin
Expression := 'len(value) ? ((value * 1.24) format '''') : ''''';
end;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[content=numeric],sum(5)[bold,content=vat19],sum(5)[bold,content=vat24]';
EndUpdate();
end
|
63
|
How can I hide some values for instance negative values
![](images/expivotq63.png)
with AxPivot1 do
begin
BeginUpdate();
with FormatContents.Add('hiden','hide negative',Nil) do
begin
Expression := 'value < 0 ? `` : value';
end;
with FormatContents.Add('hidep','hide positive',Nil) do
begin
Expression := 'value > 0 ? `` : value';
end;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)[bold],sum(5)[content=hiden],sum(5)[content=hidep]';
EndUpdate();
end
|
62
|
How can I decode the Layout property
![](images/expivotq62.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)/12';
Layout := 'Columns =1;C0.Width = 64';
with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
begin
OutputDebugString( Decode64TextW[AxPivot1.Layout] );
end;
EndUpdate();
end
|
61
|
How can I specify the sorting type, so the column gets sorted as numeric for instance
![](images/expivotq61.png)
with AxPivot1 do
begin
Import('1,1#11,11#101,101','eor=''#'' eof='','' hdr=0');
with DataColumns.Item[TObject(0)] do
begin
Caption := 'Numeric';
SortType := EXPIVOTLib.SortTypeEnum.SortNumeric;
end;
DataColumns.Item[TObject(1)].Caption := 'String (default)';
PivotRows := '0';
Refresh();
end
|
60
|
How can I disable the control's context menu
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
end
|
59
|
How do I get the captions of the columns
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
OutputDebugString( DataColumns.Count );
OutputDebugString( DataColumns.Item[TObject(0)].PivotCaption );
OutputDebugString( DataColumns.Item[TObject(0)].Caption );
OutputDebugString( DataColumns.Item[TObject(1)].PivotCaption );
OutputDebugString( DataColumns.Item[TObject(1)].Caption );
end
|
58
|
How can I specify the default-format for a specified column, so it always shows as numeric for instance
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
with DataColumns.Item['Freight'] do
begin
DefaultFormatContent := 'numeric';
DefaultFormatAppearances := 'bold';
SortOrder := EXPIVOTLib.SortOrderEnum.SortAscending;
SortType := EXPIVOTLib.SortTypeEnum.SortNumeric;
end;
PivotTotalDefaultFormatContent := 'currency';
PivotTotalDefaultFormatAppearances := 'strikeout,bold';
PivotRows := '0';
PivotColumns := 'sum(5)[bold,content=numeric]';
PivotTotals := 'sum[strikeout,bold,content=currency]';
PivotColumnsFloatBarVisible := True;
Refresh();
end
|
57
|
How can I display the percentage column
![](images/expivotq57.png)
with AxPivot1 do
begin
FormatContents.Add('percent','value + `%`',Nil);
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '5[content=percent]';
Refresh();
end
|
56
|
How do I change the name for months in the drop-down filter window (localization)
![](images/expivotq56.png)
with AxPivot1 do
begin
OutputDebugString( get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateMonths) );
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateMonths,'Ianuarie Februarie Martie Aprilie Mai Iunie Iulie August Septembrie Octombrie Noiembrie Decembrie');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAll,'(Toate)');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarBlanks,'(Gol)');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarNonBlanks,'(Plin)');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarFilterForCaption,'Filtreaza:');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateTodayCaption,'Azi');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateWeekDays,'D L Ma Mi J V S');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarExclude,'Exclud');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exColumnsFloatBar,'Coloane');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,'si');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDate,'Data:');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateTitle,'Data');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateTo,'la');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarNot,'nu');
set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarOr,'sau');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
DataColumns.Item['OrderDate'].SortType := EXPIVOTLib.SortTypeEnum.SortDate;
PivotRows := '9';
Refresh();
end
|
55
|
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageHeight but infinite width etc
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '6';
PivotColumns := 'sum(5)/3';
Refresh();
with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
begin
Options := 'FitToPage = x 5';
PrintExts := (AxPivot1.GetOcx() as EXPIVOTLib.Pivot);
Preview();
end;
end
|
54
|
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageWidth but infinite height etc
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '6';
PivotColumns := 'sum(5)/3';
Refresh();
with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
begin
Options := 'FitToPage = 5 x';
PrintExts := (AxPivot1.GetOcx() as EXPIVOTLib.Pivot);
Preview();
end;
end
|
53
|
How can I get the column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TWinForm1.AxPivot1_MouseMoveEvent(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_MouseMoveEvent);
begin
with AxPivot1 do
begin
OutputDebugString( get_ColumnFromPoint(-1,-1) );
end
end;
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
Refresh();
end
|
52
|
How can I get the value from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TWinForm1.AxPivot1_MouseMoveEvent(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_MouseMoveEvent);
begin
with AxPivot1 do
begin
OutputDebugString( get_ValueFromPoint(-1,-1) );
end
end;
with AxPivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
Refresh();
end
|
51
|
How can I specify a column to display HTML format
![](images/expivotq51.png)
with AxPivot1 do
begin
Import('Bold <b>1,Bold <b>2#Bold <b>3,Bold <b>4#Bold <b>5,Bold <b>6','eor=''#'' eof='','' hdr=0');
DataColumns.Item[TObject(0)].HTML := True;
DataColumns.Item[TObject(1)].HTML := True;
PivotRows := '0';
Refresh();
end
|
50
|
Does your control supports scrolling by touching the screen
![](images/expivotq50.png)
with AxPivot1 do
begin
rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset')) as ADODB.Recordset);
with rs do
begin
Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb',3,3,Nil);
end;
DataSource := (rs as ADODB.Recordset);
AutoDrag := Integer(EXPIVOTLib.AutoDragEnum.exAutoDragScrollOnShortTouch) Or Integer(EXPIVOTLib.AutoDragEnum.exAutoDragScroll);
end
|
49
|
How can I specify programatically the width of the pivot column ( first column )
![](images/expivotq49.png)
with AxPivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)/12';
Layout := 'Columns =1;C0.Width = 64';
EndUpdate();
end
|
48
|
How can I show the total of each row, when columns are shown as expanded
![](images/expivotq48.png)
with AxPivot1 do
begin
BeginUpdate();
IncludeExpandColumn := EXPIVOTLib.IncludeExpandColumnEnum.exIncludeExpandColumn;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
PivotRows := '0';
PivotColumns := 'sum(5)/12';
EndUpdate();
end
|