Focal Point Banner


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 community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
WF & OPEN OFFICE
 Login/Join
 
Busca
Silver Member
posted
Is WF compliance with calc of open office ?
That is I can't open a spreadsheet created by WF as xls with Open-office. It read the file as txt.
Any idea ?
Thanks in advance
Paolo
 
Posts: 36 | Location: Bologna Italy | Registered: March 11, 2004Report This Post
Alan B
Virtuoso
posted Hide Post
Paolo

If you use ON TABLE PCHOLD FORMAT EXCEL then this will work for calc.

The EXL2K produces an XML file which calc does not recognise, so open office opens it with writer.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Busca
Silver Member
posted Hide Post
Thanks Alan,
It works ok
but so I can't use WF compound (like BYTOC) with calc of OPEN Office.
Paolo

WF 5.2.3 AIX5.3/Apache self service
WF 7.1.4 AIX5.3/Apache self service (test)
 
Posts: 36 | Location: Bologna Italy | Registered: March 11, 2004Report This Post
Alan B
Virtuoso
posted Hide Post
I believe the answer to that is basically no. Most of this stuff is designed for Excel only, calc will not recognise these files.

I have tried fooling open office to open these in calc but it refuses to do so.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
<JG>
posted
If you want to convert Webfocus EXL2K documents into real .XLS files then you need to use a
conversion tool that has a batch command line capability.

A very good one is CZ-Excel Converter this costs $160 for a single user licence and $960
for a site or developer licence and worth every cent if you need to go to a plugin that only supports real
.XLS format. This will work on windows only, but there are some unix alternatives out there.

download the trial version and give it a try for example
(just google CZ-Excel Converter and you'll get plenty of hits)

The command line option will do exactly what you need. to run it you only need to give the
explicit path to the tool

 
FILEDEF ZZ DISK ZZ.mht
-RUN
TABLE FILE CAR
SUM
     DEALER_COST
BY MODEL
ON TABLE SUBHEAD
"My report"
ON TABLE NOTOTAL
ON TABLE HOLD AS ZZ FORMAT EXL2K
END
-RUN
-*   convert the file to a real .xls
!c:\temp\cz-xlsvt .\zz.mht /f:-4143 /d:c:\ibi\apps\excelout /h
-RUN
-*
-HTMLFORM BEGIN
<html>
<head>
<title>A real .xls document </title>
</head>
<frameset rows="*">
  <frame name="EXCEL2K" src="http://Localhost:8080/approot/excelout/ZZ.xls" 
  scrolling="auto" >
  <noframes>
  <body>
  <p>This page uses frames, but your browser doesn't support them.</p>
  </body>
  </noframes>
</frameset>
</html>
-HTMLFORM END


Items to beware of ,
you must have a work directory to hold the xls that can be seen by the webserver so
maintenance will be required for cleanup.

You must make sure that your application server knows how to handle an xls document
- mime type settings- otherwise the binary will just be displayed in plain text
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders