Re: Strange Behavior Importing Excel Spreadsheet

From	jahn <jahnbigbooty@yahoo.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Strange Behavior Importing Excel Spreadsheet
Date	2012-03-21 20:52 -0700
Organization	http://groups.google.com
Message-ID	<c11e7232-a5d2-4fc8-9e32-d0488c301b9e@gr6g2000vbb.googlegroups.com> (permalink)
References	<951c4121-ddec-47a8-964e-c0d9c0190622@fk28g2000vbb.googlegroups.com> <HelpfulHarry-2103121317490001@203-118-187-251.dsl.dyn.ihug.co.nz> <e7c955ce-0d8f-4996-8961-a75d4b5aa74d@wb9g2000pbc.googlegroups.com> <1khbynp.1oo86f41u004m6N%yapu@invivo.edu>

Show all headers | View raw

On Mar 21, 4:22 pm, y...@invivo.edu (Philippe Manet) wrote:
> jahn <jahnbigbo...@yahoo.com> wrote:
> >  FM just stops reading at a cell that's literally numbers,
> > letters and spaces: a cell that's practically identical to the ones
> > before and above it.
>
> did you try retyping in XL the cells before and after the breaking cell
> ?
> --
> Philippe Manet
> en fait, c'est manet avant @

Hi, Philippe -

Thanks for the note.  The problem with retyping the data in the cell
is that then you have to click Save -- and as I note above, opening
and saving the file -- even if _no_ changes are made -- resolves the
issue.  So the problem isn't that the data isn't readable, but that
the data isn't readable _unless_ the file is opened in Excel first,
then saved, then closed again.  Which might not seem like much of a
hurdle, but it's more than the client should have to go through.
Especially given a client's tendency to find ways of making a mess
once they start poking around inside a file.

Thanks again.

Best,
-J.

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Strange Behavior Importing Excel Spreadsheet jahn <jahnbigbooty@yahoo.com> - 2012-03-20 13:51 -0700
  Re: Strange Behavior Importing Excel Spreadsheet HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-21 13:17 +1200
    Re: Strange Behavior Importing Excel Spreadsheet jahn <jahnbigbooty@yahoo.com> - 2012-03-21 13:51 -0700
      Re: Strange Behavior Importing Excel Spreadsheet yapu@invivo.edu (Philippe Manet) - 2012-03-22 00:22 +0100
        Re: Strange Behavior Importing Excel Spreadsheet jahn <jahnbigbooty@yahoo.com> - 2012-03-21 20:52 -0700
          Re: Strange Behavior Importing Excel Spreadsheet David Stone <no.email@domain.invalid> - 2012-03-22 15:14 -0400
            Re: Strange Behavior Importing Excel Spreadsheet jahn <jahnbigbooty@yahoo.com> - 2012-03-27 14:37 -0700
      Re: Strange Behavior Importing Excel Spreadsheet HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-22 11:39 +1200
        Re: Strange Behavior Importing Excel Spreadsheet jahn <jahnbigbooty@yahoo.com> - 2012-03-22 10:32 -0700

csiph-web