span8
span4
span8
span4
Since I upgraded to latest Build 17650 I first had problems with a corrupt FME Installation where e.g. StatisticsCalculator outputted only NULL-values (see this thread).
Now I executed all our statistics batches finding out FME is now writing data in white font color with white borderlines, you can say as "white boxes". It ignores formatting of the template-Excelfile.
The data itself is there, but not visible because of white color. The XLS-Template used (since 4 years unchanged) has standard formating in black with light grey borderlines...
Are there any known bugs in the excel writer since Build 17291?
If you change font color and borderline color manually you can see the values:
感谢您沿着工作区发送和模板文件。在进行一些测试并稍微考虑这一点后,这是使用Microsoft“主题”颜色时忽略单元字体和背景颜色的模板文件的现有问题。(PR#59453) - 我们将在此处解决PR后更新。
A way to work around this: In your template file, if you choose a standard colour or a custom colour/more colour for the background it appears to work as expected. For the cell font colour, you can select it to be the automatic colour, a standard colour or custom colour/more colour.
Let me know if you are still running into any issues.
自从升级到FME 2017.1.0.0 Build 17539以来,我有类似的问题,其中FME覆盖了模板格式,是否有问题?
Thanks for your information, but I still can't get it to work.
I defined custom coloured backgrounds in the templatewa-vorlage.xlsx,但FME仍然覆盖着
白色背景。对我最有意义的是缺少的细胞边界。无论我如何在模板中定义它们,它们始终缺少出口...wa-stats-2017-10-16.xlsx
(忽略第一张纸,它只是取得其他纸张的值,所以FME在第一张“Zusammenfassung”中没有写任何东西)
与此同时,我可以通过重新分配模板中的正确字体颜色来获得字体再次成为黑色。较新的FME构建中的Excel Writer是否有可能(从17291开启)不使用标准字体颜色?相反,它使用白色字体,当时没有分配给细胞?
我现在无法修复的是边界线。无论我改变什么,他们都会保持白色
在the template file...wa-stats-2017-10-13.xlsx
Hey@TiaAtSafe,
Yes, Everything was working perfectly on 2017.0 (17291/17259).
Attached you can find the workspace (statistik-wa.zip), the Excel-Template (wa-vorlage.xlsx), current problematic Excel-Export (wa-stats-2017-10-12.xlsx) as well as an old correct Excel-Export (wa-stats-2017-10-03.xlsx)
© 2020 Safe Software Inc |Legal