Когда я импортирую текстовые файлы с разделителями тильды, Excel 365 обрезает их до 50 столбцов, а оставшиеся столбцы молча отбрасываются. Я не могу найти параметр, который контролирует этот предел. Как я могу импортировать файлы с разделителями более 50 столбцов?
Вот одна строка из файла (425 столбцов):
Schema_InvcHead ~ RptLanguageID ~ AGAuthorizationCode ~ AGAuthorizationDate ~ AGDocConcept ~ AGDocumentLetter ~ AGInvoicingPoint ~ AGLegalNumber ~ AGPrintingControlType ~ AGUseGoodDefaultMark ~ ApplyDate ~ ARLOCID ~ AutoPrintReady ~ BillingDate ~ BillingNumber ~ BillToInvoiceAddress ~ BlockedFinChrg ~ BlockedFinChrgReason ~ BlockedRemLetters ~ BlockedRemLettersReason ~ BranchID ~ ChangeDate ~ ChangedBy ~ ChangeTime ~ CHISRCodeLine ~ CMReason ~ CMType ~ CNConfirmDate ~ CNTaxInvoiceType ~ CollectionsCust ~ Компания ~ Consolidated ~ ContractDate ~ ContractRef ~ CopyLatestInvoice ~ CorrectionInv ~ CounterARForm ~ CreditMemo ~ CurrRateDate ~ CustAgentName ~ CustAgentTaxRegNo ~ CustNum ~ CycleCode ~ CycleInactive ~ DebitNote ~ Отложенный ~ DepositAmt ~ DepositCredit ~ DepUnallocatedAmt ~ DNComments ~ DNCustNbr ~ DocDepApplied ~ DocDepositAmt ~ DocDepositCredit ~ DocDepUnallocatedAmt ~ DocInvoiceAmt ~ DocMaxValueAmt ~ DocPECharges ~ DocPECommissions ~ DocPEDetTaxAmt ~ DocPEDischargeAmt ~ DocPEInterest ~ DocPENoPayPenalty ~ DocRecurBalance ~ DocRounding ~ DocumentPrinted ~ DocWithholdAmt ~ DueDate ~ Продолжительность ~ EDIReady ~ EInvExceptio п ~ EInvoice ~ EInvRefNum ~ EInvStatus ~ EInvTimestamp ~ EInvUpdatedBy ~ EndDate ~ Исключен ~ ExportDocDate ~ ExportDocRefNum ~ ExportReportNo ~ ExportType ~ FiscalCalendarID ~ FiscalYearSuffix ~ GUIDateOfExport ~ GUIDeductCode ~ GUIExportBillNumber ~ GUIExportBillType ~ GUIExportMark ~ GUIExportType ~ GUIFormatCode ~ GUITaxTypeCode ~ HeadNum ~ HoldInvoice ~ INExportProcedure ~ InPrice ~ INShippingPortCode ~ InstanceNum ~ INTaxTransactionID ~ InvInCollections ~ InvoiceAmt ~ InvoiceComment ~ InvoiceDate ~ InvoiceNum ~ InvoiceNumList ~ InvoiceRef ~ InvoiceType ~ IsAddedToGTI ~ IsRecurring ~ LastChrgCalcDate ~ LastDate ~ LegalNumber ~ LockTaxRate ~ MainSite ~ MaxValueAmt ~ MXAccountNumber ~ MXApprovalNum ~ MXApprovalYear ~ MXCancellationMode ~ MXCancelledDate ~ MXCBB ~ MXCertificate ~ MXCertificateSN ~ MXCertifiedTimestamp ~ MXConfirmationCode ~ MXDigitalSeal ~ MXDomesticTransfer ~ MXExportCertOrigin ~ MXExportCertOriginNum ~ MXExportConfNum ~ MXExportCustDocCode ~ MXExportOperationType ~ MXExternalCode ~ MXFiscalFolio ~ MXFolio ~ MXIncoterm ~ MXInvoiceRelationType ~ MXMovingReason ~ MXMovingReasonFlag ~ MXNumRegIdTrib ~ MXOr iginalAmount ~ MXOriginalDate ~ MXOriginalFolio ~ MXOriginalSeries ~ MXOriginalString ~ MXOriginalStringTFD ~ MXPaidAs ~ MXPartPmt ~ MXPaymentName ~ MXPaymentNum ~ MXPostedTimeStamp ~ MXPurchaseType ~ MXResidenCountryNum ~ MXSATCertificateSN ~ MXSATSeal ~ MXSerie ~ MXTaxRcptType ~ MXTaxRegime ~ MXTotalPayments ~ OrdExchangeRate ~ OrigDueDate ~ OurBank ~ OurSupplierCode ~ переплатили ~ OverrideEndDate ~ OvrDefTaxDate ~ PayDiscDays ~ PayDiscPartPay ~ PayDiscPer ~ PBProjectID ~ PEAPPayNum ~ PEBankNumber ~ PEBOEIsMultiGen ~ PEBOEPosted ~ PEBOEStatus ~ PECharges ~ PECommissions ~ PEDebitNote ~ PEDebitNoteReasonCode ~ PEDetTaxAmt ~ PEDetTaxCurrencyCode ~ PEDischargeAmt ~ PEDischargeDate ~ PEGuaranteeAddress1 ~ PEGuaranteeAddress2 ~ PEGuaranteeAddress3 ~ PEGuaranteeCity ~ PEGuaranteeCountry ~ PEGuaranteeName ~ PEGuaranteePhoneNum ~ PEGuaranteeState ~ PEGuaranteeTaxID ~ PEGuaranteeZip ~ PEInterest ~ PENoPayPenalty ~ PEReasonCode ~ PEReasonDesc ~ PERefDocID ~ PESUNATDepAmt ~ PESUNATDepDate ~ PESUNATDepNum ~ PIPayment ~ завод ~ PMUID ~ PONum ~ PostedRecog ~ RateGrpCode ~ ReadyToBill ~ ReadyToCalc ~ RealEstateNo ~ RecalcBeforePost ~ Повторять Баланс ~ RecurringState ~ RecurSource ~ RefCancelled ~ RefCancelledBy ~ ReversalDocAmount ~ RevisionDate ~ RevisionNum ~ Округление ~ Rpt1DepGainLoss ~ Rpt1DepositAmt ~ Rpt1DepUnallocatedAmt ~ Rpt1MaxValueAmt ~ Rpt1PECharges ~ Rpt1PECommissions ~ Rpt1PEDischargeAmt ~ Rpt1PEInterest ~ Rpt1PENoPayPenalty ~ Rpt1RecurBalance ~ Rpt1WithholdAmt ~ Rpt2DepGainLoss ~ Rpt2DepositAmt ~ Rpt2DepUnallocatedAmt ~ Rpt2MaxValueAmt ~ Rpt2PECharges ~ Rpt2PECommissions ~ Rpt2PEDischargeAmt ~ Rpt2PEInterest ~ Rpt2PENoPayPenalty ~ Rpt2RecurBalance ~ Rpt2WithholdAmt ~ Rpt3DepGainLoss ~ Rpt3DepositAmt ~ Rpt3DepUnallocatedAmt ~ Rpt3MaxValueAmt ~ Rpt3PECharges ~ Rpt3PECommissions ~ Rpt3PEDischargeAmt ~ Rpt3PEInterest ~ Rpt3PENoPayPenalty ~ Rpt3RecurBalance ~ Rpt3WithholdAmt ~ SEBankRef ~ ServiceInvoice ~ ShipDate ~ SiteCode ~ SoldToCustNum ~ SoldToInvoiceAddress ~ SummarizationDate ~ SysRevID ~ SysRowID ~ TaxPoint ~ TaxRateDate ~ TaxRateGrpCode ~ TaxRegionCode ~ THIsImmatAdjustment ~ TotFinChrg ~ TranDocTypeID ~ TWDeclarePeriod ~ TWDeclareYear ~ TWGenerationType ~ TWGUIExportDocumentName ~ TWGUIExportRemarks ~ TWGUIExportVerification ~ Т WGUIGroup ~ TWGUIRegNumBuyer ~ TWGUIRegNumSeller ~ TWPeriodPrefix ~ UseAltBillTo ~ UseAltBillToID ~ WithholdAmt ~ WithTaxConfirm ~ XRefContractDate ~ XRefContractNum ~ Division_c ~ Calc_BillToAddressList ~ Calc_BottomAddress ~ Calc_BTAddressList ~ Calc_CHBankAcctIBANCode ~ Calc_CHBankAcctISRPartyID ~ Calc_CompanyAddressList ~ Calc_ConReference ~ Calc_ConStartDate ~ Calc_CounterARForm ~ Calc_CreditMemo ~ Calc_CurrDesc ~ Calc_CurrDocDecimalsGeneral ~ Calc_CurrDocDecimalsPrice ~ Calc_CurrDocDesc ~ Calc_CurSymbol ~ Calc_CustContactName ~ Calc_CustEMailAddress ~ Calc_CustFax ~ Calc_CustID ~ Calc_CustPartOpts ~ Calc_CustPhone ~ Calc_CustResaleID ~ Calc_DiscountTotal ~ Calc_DocDspTaxAmt ~ Calc_DocInvoiceAmt ~ Calc_DropShipPackSlip ~ Calc_DteOrdrd ~ Calc_ExtPriceTotal ~ Calc_fFOB ~ Calc_GuiFormatCodeDesc ~ Calc_InvoiceRefDate ~ Calc_InvoiceRefLegalNumber ~ Calc_InvSubTotal ~ Calc_InvSuffix ~ Calc_IsBaseCurr ~ Calc_IsDraftCopy ~ Calc_MscTotal ~ Calc_MtlTotal ~ Calc_MulPackNum ~ Calc_mulponum ~ Calc_MulShipDate ~ Calc_MulShipTo ~ Calc_MulShipVia ~ Calc_MulShpCon ~ Calc_MultSoldTo ~ Calc_MultTaxID ~ Calc_MXA pprovalNumber ~ Calc_MXApprovalYear ~ Calc_MXCBB ~ Calc_MXCertificateSN ~ Calc_MXCertifiedTimeStamp ~ Calc_MXDigitalSeal ~ Calc_MXExpeditionAddress ~ Calc_MXFiscalFolio ~ Calc_MXFolio ~ Calc_MXOrigFiscalFolio ~ Calc_MXOrigFiscalFolioAmount ~ Calc_MXOrigFiscalFolioDate ~ Calc_MXOrigFiscalFolioSeries ~ Calc_MXOriginalString1 ~ Calc_MXOriginalString10 ~ Calc_MXOriginalString2 ~ Calc_MXOriginalString3 ~ Calc_MXOriginalString4 ~ Calc_MXOriginalString5 ~ Calc_MXOriginalString6 ~ Calc_MXOriginalString7 ~ Calc_MXOriginalString8 ~ Calc_MXOriginalString9 ~ Calc_MXOriginalStringTFD ~ Calc_MXPaidAs ~ Calc_MXPaymentAccountNum ~ Calc_MXPaymentMethod ~ Calc_MXPaymentNum ~ Calc_MXSATCertificateSN ~ Calc_MXSATSeal ~ Calc_MXSerie ~ Calc_MXTaxRegime ~ Calc_MXTotalPayments ~ Calc_NumRecordPerPage ~ Calc_NumTotalParts ~ Calc_PackNum ~ Calc_PELegalText ~ Calc_PeriodEndDate ~ Calc_PPAllowPcnt ~ Calc_PrintBottomAddress ~ Calc_RefInvAmt ~ Calc_RefInvNum ~ Calc_RevisionDate ~ Calc_RevisionNum ~ Calc_RUBTLegalName ~ Calc_RUCorrToInvDate ~ Calc_RUCorrToInvLegalNumber ~ Calc_RUCorrToInvRevDate ~ Calc_RUCorrT oInvRevNum ~ Calc_RULessDeposits ~ Calc_RusNumber ~ Calc_SalesPerson ~ Calc_SalesTerms ~ Calc_SEBankRef ~ Calc_ShipDate ~ Calc_ShipTo ~ Calc_ShipToAddressList ~ Calc_ShipToContactName ~ Calc_ShipVia ~ Calc_ShpConNum ~ Calc_SoldToAddressList ~ Calc_SubTotal ~ Calc_TaxMethod ~ Calc_TotalMiscChrg ~ Calc_vDocPayAmounts ~ Calc_VoucherString ~ Calc_VoucherString ~ Calc_vPayAmounts ~ Calc_vPayDates ~ CurrencyCode_CurrDesc ~ CurrencyCode_CurrName ~ CurrencyCode_CurrSymbol ~ CurrencyCode_DocumentDesc ~ Customer_BTName ~ Customer_CustID ~ CUSTOMER_NAME ~ Customer_TradingPartnerName ~ FOB_DeliveryTerms ~ FOB_Description ~ Plant_Address1 ~ Plant_Address2 ~ Plant_Address3 ~ Plant_City ~ Plant_Company ~ Plant_CountryNum ~ Plant_Name ~ RMANum_RMADate ~ RMANum_RMANum ~ RMANum_ShipToNum ~ RMANum_XRefRMANumber ~ TermsCode_Description ~ TermsCode_NumberOfPayments ~ TermsCode_TermsCode ~
Если я помещаю эту строку в файл и пытаюсь импортировать ее в Excel, опция выбора разделителя исчезает (не отключается, он полностью исчез из пользовательского интерфейса) и обрабатывается как один столбец. OO Calc импортирует одну строку или полный файл без проблем.
