This was just cutting and pasting a section of column to try and remove those
pesky underscore characters pcb adds when building arrays. It caused an
exception error when I tried pasting back the updated designators into Protels
spreadsheet. It suggested it was good practice to reboot after this type of
error and I certainly didnt follow its advice.
Higlighting a column, clicking Format, Protection and unticking Locked does not
result in that column remaining unlocked.
Only after going to Options, Preferences and unticking Protection would it allow
the paste.
[EMAIL PROTECTED] on 05/31/2002 08:48:22 AM
Please respond to "Protel EDA Forum" <[EMAIL PROTECTED]>
To: "Protel EDA Forum" <[EMAIL PROTECTED]>
cc: (bcc: Clive Broome/sdc)
Subject: Re: [PEDA] Unlocking Spreadsheets
I've cut and pasted from Excel many tmes and have had no issues with crashes.
I only cut and paste the cells that I need to edit so maybe this is why...
I start by exporting the spreadsheet, then open it in Excel. I add a column
in Excel that denotes the order (cell formula n+1 which I copy and paste
values only). This is so that the fields I paste are in the same order as
those I exported, keeping the hidden "B" column identifiers in sync. I leave
Protel open so I can still update the parts when I'm done with Excel and the
copy-paste...
In a message dated 5/30/2002 10:33:25 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> >I just discovered another 'bug' fix for the spreadsheet editor. It always
> >seems
> >to default to locked and therefore any update you try to paste back from
> Excel
> >(a usable spreadsheet package) causes a crash and suggests a reboot.
>
> That the default is locked is an irritating undocumented feature. That an
> attempt to paste into a locked spreadsheet causes Protel to crash is a bug,
>
> and a moderately serious one.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To leave this list visit:
* http://www.techservinc.com/protelusers/leave.html
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
*
* Forum Guidelines Rules:
* http://www.techservinc.com/protelusers/forumrules.html
*
* Browse or Search previous postings:
* http://www.mail-archive.com/[email protected]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *