As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at email@example.com for further assistance. Reference the community FAQ to learn more about the community.
i think its an excel issue- from my memory cells can often default to date format when copying and pasting data in there and think it may be defaulting to a date format behind the scenes- try opening up the sheet and reformatting the cells to a number; if that solves it you will need to either raise a case with IB or ask someone whose good at macros and stuff to see if they can help you with a work around- but im pretty sure its excel
Developer Studio 7.64 Win XP Output: mostly HTML, also Excel and PDF
"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
Posts: 285 | Location: UK | Registered: October 26, 2007
Hi Focus Guys, These seem to be American Fellows on the Line. ON TABLE SET CDN ON should be the solution. We, Europeans, are fond of Commas instead of dots. In the old days Focus was conscious of that and had the variable CDN to comply our old habits Cordialement and Focusly PS : glad that a platinum member put CDN on the line (Wish I could turn into a lead member)
Focus Mainframe 7.6.11 Dev Studio 7.6.11 and !!! PC Focus, Focus for OS/2, FFW Six, MSO
converting your dates back to numbers in excel will not give you the wanted result. Your format is MM YY but the internal number will be something like 30217. Try converting it to a flat number and you will see what I mean. The comma suggestion (CDN) might do the tric, but that also may cause a problem if your excel basic format is NOT setup with a decimal comma.
I would try the EXL2K format and see if you can get the grid in an other way.
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006
The SET CDN = ON method worked well with the customer in Europe. Unfortunately the report is also currently being used by customers in the US. So had to scratch that idea off.
When I use export the excel document using EXL2K, the value is displayed correctly, however there were issues with the grid lines not being able to displayed. Search through the forums and looks like there is no solution to this unless you use a template or something like that.
So the final solution was to change the value to display 3 (D10.3) decimal values like 5.556. That seem to solve the issue plus the customer was ok with it.
Once again thanks to all that responded.
WebFOCUS 767 Server 64bit On Windows 2003 Server
WebFOCUS 767 Server for Developer Studio On windows XP
I guess you Brits always haveto make things a little more difficult, but then as a Canuck I am used to the British way of doing thinhs, except ofr driving on the wrong side of the road. Be that as it may, then the problem with the date/amount would not be a problem with UK only Frnace/Germany etc.
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit