Issue 118445 - error when reading a ftp file
Summary: error when reading a ftp file
Status: CONFIRMED
Alias: None
Product: General
Classification: Code
Component: ui (show other issues)
Version: OOo 3.3
Hardware: PC Linux, all
: P5 (lowest) Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-05 09:12 UTC by fa.van-den-bussche
Modified: 2014-01-19 14:47 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description fa.van-den-bussche 2011-09-05 09:12:41 UTC
Using a macro like:

...
dim oF as object
...
   oF=ThisComponent.sheets.getByname("Sheetname")
...
dim FileNo as integer, File as string
dim nl as integer, CurLine as string
   nl=0
   FileNo=FreeFile
   Fichier="ftp://user:pass@server/directory/file.txt"
   Open Fichier For Input As #FileNo
   Do while not eof(FileNo)
      Line Input #FileNo, CurLine
      oF.getCellByPosition(0,nl).setString(CurLine)
      nl=nl+1
   Loop
   Close #FileNo
...

I get this error "Erreur d'exécution BASIC. Erreur d'E/S de périphérique". It occurs near the end of the file (possibly without a CR or LF or CR+LF for ending the file).

The same error happens when writing to FTP.
Comment 1 Rob Weir 2012-03-01 15:56:46 UTC
Did this work with OOo 3.3. If it is a regression, and related to the libserf integration, then this is interesting.  If the bug existing previously then I don't think it is a blocker.
Comment 2 fa.van-den-bussche 2012-03-01 16:35:46 UTC
I confirm, it doesn't work with OOo 3.3. I don't know if it's a bloker or not.
Comment 3 Oliver-Rainer Wittmann 2012-03-07 11:34:32 UTC
I played around with the given BASIC script and with the user interface in order to access files via FTP. I used OOo 3.1, OOo 3.3, OOo 3.4 Beta and AOO 3.4 latest developer snapshot (rev. 1296433).
Results (valid for all used offices):
- the BASIC script does not work.
- browsing an FTP server works.
- opening files via Open File dialog - I have switched to the OpenOffice.org dialogs in Menu Tools - Options - General - does not work.
- inserted a linked images or section whose content is located on a FTP server does not work.

Thus, it seems that main parts of FTP access are broken at least since OOo 3.1.

--> from my point of view no show-stopper for AOO 3.4 --> adjusting importance from "blocker" to "major"


BTW, the FTP access is not handled via serf in AOO (respectively neon in former OOo versions)
Comment 4 Edwin Sharp 2014-01-19 14:47:27 UTC
Confirmed per comment 3