Author |
Message |
21/04/2023 13:57:33
|
unger
Power User
Joined: 22/07/2008 05:19:28
Messages: 261
Offline
|
Hello,
I have a dynamic content for a fixgrid that is a right part of a combined pair of two grids (fixed columns).
Code:
t:fixgrid width:100% rowheight:20 horizontalscrollmode:always rowpopupmenuOPUPMENU_1 sbvisibleamount:50 objectbinding:#{d.d_1.SpezVariablenMBean.spezVariablenGrid} height:100%
t:gridheader rendered:#{d.SpezVariablenMBean.filterZeile} avoidexport:true
t:field actionListener:#{d.d_1.SpezVariablenMBean.onSuchFlush} flush:true background:#{d.d_1.SpezVariablenMBean.filterBackground} width:100% tooltip:Suchzeichen sind * und ? popupmenu:VALIDATEPOPUP text:#{d.d_1.SpezVariablenMBean.suchValue.stuecklisteIndex.value} height:100%
t:field actionListener:#{d.d_1.SpezVariablenMBean.onSuchFlush} flush:true background:#{d.d_1.SpezVariablenMBean.filterBackground} width:100% tooltip:Suchzeichen sind * und ? popupmenu:VALIDATEPOPUP text:#{d.d_1.SpezVariablenMBean.suchValue.material.value} height:100%
...
t:gridheader avoidexport:true
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:field width:100% enabled:false height:100%
t:gridheader avoidexport:true rowheight:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:pane border:top:2;color:#000000 bgpaint:rectangle(0,0,100%,100%,#000000) width:100% height:2
t:gridcol sortreference:.{object.stuecklisteIndex} searchenabled:true width:60 text:Stkl.-Idx
t:field width:100% text:.{object.stuecklisteIndex} enabled:false height:100%
t:gridcol sortreference:.{object.material.name} searchenabled:true width:100 text:Material
t:field width:100% text:.{object.material.name} enabled:false height:100%
t:gridcol sortreference:.{object.variantenGruppe.name} searchenabled:true tooltip:Variantengruppe width:200 text:Variantengruppe
t:field width:100% text:.{object.variantenGruppe.name} enabled:false height:100%
t:gridcol searchenabled:true tooltip:Blechdicke width:100 text:Blechdicke
t:formattedfield width:100% format:bigdecimal formatmask:0.0# align:right value:.{adapter.value["Blechdicke"]} enabled:false height:100%
t:gridcol searchenabled:true tooltip:Legierung width:100 text:Legierung
t:field width:100% text:.{adapter.svalue["Legierung"]} align:left enabled:false height:100%
t:gridcol searchenabled:true tooltip:Y2 width:100 text:Y2
t:formattedfield width:100% format:bigdecimal formatmask:null align:right value:.{adapter.value["Y2"]} enabled:false height:100%
t:gridcol searchenabled:true tooltip:Y3 width:100 text:Y3
t:formattedfield width:100% format:bigdecimal formatmask:null align:right value:.{adapter.value["Y3"]} enabled:false height:100%
t:gridcol searchenabled:true tooltip:Y4 width:100 text:Y4
t:formattedfield width:100% format:bigdecimal formatmask:null align:right value:.{adapter.value["Y4"]} enabled:false height:100%
t:gridcol searchenabled:true tooltip:Y5 width:100 text:Y5
t:formattedfield width:100% format:bigdecimal formatmask:null align:right value:.{adapter.value["Y5"]} enabled:false height:100%
t:gridcol searchenabled:true tooltip:Y6 width:100 text:Y6
t:formattedfield width:100% format:bigdecimal formatmask:null align:right value:.{adapter.value["Y6"]} enabled:false height:100%
t:gridcol width:100% text:
t:label width:100% text: height:100%
Gridcols are result of :
Code:
..
for (String columnName : spezVariablenColNameList) {
GRIDCOLNode gcn = new GRIDCOLNode();
gcn.setText(columnName);
gcn.setTooltip(columnName);
gcn.setWidth("100");
gcn.setSearchenabled(true);
Long typ = spezVariablenColTypMap.get(columnName);
String format = spezVariablenColFormatMap.get(columnName);
if (typ.longValue() == FLOAT_TYPE) { // 0
FORMATTEDFIELDNode fn = new FORMATTEDFIELDNode();
fn.setValue(".{adapter.value[\"" + columnName + "\"]}");
fn.setEnabled(false);
fn.setWidth("100%");
fn.setHeight("100%");
fn.setAlign("right");
fn.setFormat("bigdecimal");
if (format != null)
fn.setFormatmask(format);
gcn.addSubNode(fn);
} else if (typ.longValue() == INTEGER_TYPE) { // 1
FORMATTEDFIELDNode fn = new FORMATTEDFIELDNode();
fn.setValue(".{adapter.value[\"" + columnName + "\"]}");
fn.setEnabled(false);
fn.setWidth("100%");
fn.setHeight("100%");
fn.setAlign("right");
fn.setFormat("long");
if (format != null)
fn.setFormatmask(format);
gcn.addSubNode(fn);
} else if (typ.longValue() == TEXT_TYPE) { // 2
FIELDNode fn = new FIELDNode();
fn.setText(".{adapter.svalue[\"" + columnName + "\"]}");
fn.setEnabled(false);
fn.setWidth("100%");
fn.setHeight("100%");
fn.setAlign("left");
gcn.addSubNode(fn);
}
fgn.addSubNode(gcn);
}
[code]
All headers of bigdecimal columns are not rendered when exported into excel. Without any formatmask the formatting of the bigdecimal is like hardcopy.
Any other export PDF, XML,CSV, works!
[code]
if (enumExportTyp.equals(EnumExportTyp.CLIPBOARD)) {
clipboardContent = exporter.exportToTabSeparatedStringWholeGrid(false);
triggerCopy2ClipBoard.trigger();
}
else if (enumExportTyp.equals(EnumExportTyp.PDF)) {
BrowserContent bc = new BrowserContent(exporter.exportToPDFWholeGrid(false), "unbekannt");
BufferedContentMgr.add(bc);
aktFilename = "con_exp.pdf";
aktDownloadURL = bc.getURL();
downloadTrigger.trigger();
}
else if (enumExportTyp.equals(EnumExportTyp.CSV)) {
BrowserContent bc = new BrowserContent(exporter.exportToCSVStringWholeGrid(false).getBytes(), "unbekannt");
BufferedContentMgr.add(bc);
aktFilename = "con_exp.csv";
aktDownloadURL = bc.getURL();
downloadTrigger.trigger();
}
else if (enumExportTyp.equals(EnumExportTyp.XML)) {
BrowserContent bc = new BrowserContent(exporter.exportToXMLWholeGrid(false), "unbekannt");
BufferedContentMgr.add(bc);
aktFilename = "con_exp.xml";
aktDownloadURL = bc.getURL();
downloadTrigger.trigger();
}
else if (enumExportTyp.equals(EnumExportTyp.EXCEL)) {
BrowserContent bc = new BrowserContent(exporter.exportToXLSXWholeGrid(false), "unbekannt");
BufferedContentMgr.add(bc);
aktFilename = "con_exp.xlsx";
aktDownloadURL = bc.getURL();
downloadTrigger.trigger();
}
Any idea?
Regards,
Joachim
Filename |
grid.JPG |
Download
|
Description |
|
Filesize |
27 Kbytes
|
Downloaded: |
104 time(s) |
|
|
|
22/04/2023 05:47:40
|
CaptainCasa
Power User
Joined: 21/11/2007 12:23:06
Messages: 5521
Offline
|
Hi Joachim,
I just tested with the attached example and things are corrected ok.
Could you compare against your dynamic cretion?
Kind regards! Björn
Filename |
M13.xml |
Download
|
Description |
|
Filesize |
2 Kbytes
|
Downloaded: |
104 time(s) |
Filename |
M13UI.java |
Download
|
Description |
|
Filesize |
4 Kbytes
|
Downloaded: |
107 time(s) |
|
Björn Müller, CaptainCasa GmbH |
|
|
24/04/2023 06:59:41
|
unger
Power User
Joined: 22/07/2008 05:19:28
Messages: 261
Offline
|
Hallo Björn,
I set up a new project,
1) added poi.jar, poi-ooxml.jar, poi-scratchpad.jar.
2) added JDK11 addons
Now
byte[] g = m_grid.getExporter().exportToXLSXWholeGrid(false);
returns null.
No log.
What is missing?
Regards,
Joachim
Code:
Using CATALINA_BASE: "tomcat"
Using CATALINA_HOME: "tomcat"
Using CATALINA_TMPDIR: "tomcat\temp"
Using JRE_HOME: "jre"
Using CLASSPATH: "tomcat\bin\bootstrap.jar;tomcat\bin\tomcat-juli.jar"
Using CATALINA_OPTS: ""
NOTE: Picked up JDK_JAVA_OPTIONS: --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
Listening for transport dt_socket at address: 50010
24-Apr-2023 06:32:33.464 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.39
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Oct 6 2020 14:11:46 UTC
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.39.0
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: K:\excalibur-4.0-rc1\EnterpriseClientRISC_20220509\server\jre
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 11.0.9+10-202010172339
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: AdoptOpenJDK
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: K:\excalibur-4.0-rc1\EnterpriseClientRISC_20220509\server\tomcat
24-Apr-2023 06:32:33.479 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: K:\excalibur-4.0-rc1\EnterpriseClientRISC_20220509\server\tomcat
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=tomcat\conf\logging.properties
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms128m
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Duser.timezone=UTC
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Duser.language=en
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Duser.country=US
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -agentlib:jdwp=transport=dt_socket,address=50010,server=y,suspend=n
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=tomcat
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=tomcat
24-Apr-2023 06:32:33.494 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=tomcat\temp
|
|
|
24/04/2023 14:36:15
|
unger
Power User
Joined: 22/07/2008 05:19:28
Messages: 261
Offline
|
The problem has been fixed in a newer version of Enterprise Client. My version was 20220509.
|
|
|
|
|
|