Table 370 Excel Buffer

Base Application, System.IO

src/Layers/W1/BaseApp/System/DataExchange/ExcelBuffer.Table.al48 procedures and triggers, in source order. Copyright (c) Microsoft Corporation. MIT

EnterCellByCellName line 239

  1. 247callsCloseBook
  2. 256writesTable 370 Excel Buffer Modify
  3. 259validatesTable 370 Excel Buffer Row No.
  4. 260validatesTable 370 Excel Buffer Column No.
  5. 262writesTable 370 Excel Buffer Insert

SetActiveWriterSheet line 267

  1. 275callsCloseBook

GetWriterSheetNameByNumber line 281

  1. 286callsCloseBook

CreateNewBook line 291

  1. 293callsCreateBook

CreateBook line 297

  1. 303callsCodeunit 419 File Management ServerTempFileName
  2. 310callsCodeunit 419 File Management IsAllowedPath
  3. 319callsCodeunit 6223 OpenXML Management SetupWorksheetHelper

OpenBook line 354

  1. 365callsCodeunit 419 File Management IsAllowedPath
  2. 370callsCloseBook

OpenBookStream line 375

  1. 387callsCloseBook

OpenBookForUpdate line 394

  1. 397callsCodeunit 419 File Management IsAllowedPath

UpdateBook line 402

  1. 404callsUpdateBookExcel

UpdateBookExcel line 408

  1. 417callsCodeunit 419 File Management IsAllowedPath
  2. 419raisesOnUpdateBookExcelOnAfterXlWrkBkWriterOpen
  3. 427callsCodeunit 6223 OpenXML Management SetupWorksheetHelper
  4. 429callsCloseBook

UpdateBookStream line 434

  1. 436callsCodeunit 419 File Management InstreamExportToServerFile
  2. 438callsUpdateBookExcel

SetActiveReaderSheet line 469

  1. 477callsCloseBook

WriteSheet line 482

  1. 496callsGetExcelReference
  2. 496callsCodeunit 10 Type Helper LFSeparator
  3. 500callsGetExcelReference
  4. 500callsGetExcelReference
  5. 500callsCodeunit 10 Type Helper LFSeparator
  6. 503raisesOnWriteSheetOnBeforeAddAndInitializeCommentsPartIsHandled
  7. 505callsCodeunit 6223 OpenXML Management AddAndInitializeCommentsPart
  8. 510callsWriteAllToCurrentSheet
  9. 515raisesOnWriteSheetOnBeforeUseXmlTextWriterIsHandled
  10. 525callsSelectOrAddSheet
  11. 526callsWriteAllToCurrentSheet

WriteAllToCurrentSheet line 530

  1. 539callsCodeunit 5370 Excel Buffer Dialog Management Open
  2. 545callsUpdateProgressDialog
  3. 546callsCloseBook
  4. 550callsWriteCellValueInternal
  5. 552callsWriteCellFormula
  6. 554callsCodeunit 5370 Excel Buffer Dialog Management Close

WriteCellValue line 557

  1. 559callsWriteCellValueInternal

WriteCellValueInternal line 562, local

  1. 568callsGetCellDecorator
  2. 578raisesOnWriteCellValueOnBeforeSetCellValue
  3. 593callsCodeunit 6223 OpenXML Management SetCellComment
  4. 594callsCodeunit 6223 OpenXML Management CreateCommentVmlShapeXml

WriteCellFormula line 598

  1. 604raisesOnBeforeWriteCellFormulaIsHandled
  2. 608callsGetCellDecorator
  3. 610callsTable 370 Excel Buffer GetFormula

CreateRangeName line 679

  1. 687validatesTable 370 Excel Buffer Row No.
  2. 688validatesTable 370 Excel Buffer Column No.
  3. 692callsGetExcelReference
  4. 692callsGetExcelReference
  5. 694callsGetExcelReference
  6. 694callsGetExcelReference

ReadSheet line 697

  1. 699callsReadSheetContinous

ReadSheetContinous line 710

  1. 721callsSetActiveReaderSheet
  2. 723callsCodeunit 5370 Excel Buffer Dialog Management Open
  3. 724writesTable 370 Excel Buffer DeleteAll
  4. 731callsShouldReadCellData
  5. 732validatesTable 370 Excel Buffer Row No.
  6. 733validatesTable 370 Excel Buffer Column No.
  7. 734callsParseCellValue
  8. 735writesTable 370 Excel Buffer Insert
  9. 736callsUpdateProgressDialog
  10. 737callsCloseBook
  11. 747callsCloseBook
  12. 748callsCodeunit 5370 Excel Buffer Dialog Management Close

ParseCellValue line 751, protected

  1. 766raisesOnBeforeParseCellValueIsHandled
  2. 790callsConvertDateTimeDecimalToDateTime
  3. 800callsConvertDateTimeDecimalToDateTime
  4. 806raisesOnParseCellValueOnBeforeRoundDecimal

SelectSheetsName line 811

  1. 819callsCodeunit 419 File Management IsAllowedPath
  2. 820callsCodeunit 419 File Management BLOBImportFromServerFile
  3. 821callsCodeunit 4100 Temp Blob CreateInStream
  4. 822callsSelectSheetsNameStream

SelectSheetsNameStream line 825

  1. 830callsGetSheetsNameListFromStream
  2. 835runsPage 823 Name/Value Lookup

ExportBudgetFilterToFormula line 882

  1. 896writesTable 370 Excel Buffer Insert
  2. 913callsTable 370 Excel Buffer ClearFormula
  3. 925callsTable 370 Excel Buffer AddToFormula
  4. 928callsTable 370 Excel Buffer AddToFormula
  5. 931callsTable 370 Excel Buffer SetFormula
  6. 931callsTable 370 Excel Buffer GetExcelReference
  7. 937callsTable 370 Excel Buffer AddToFormula
  8. 940callsTable 370 Excel Buffer AddToFormula
  9. 943callsTable 370 Excel Buffer SetFormula
  10. 943callsTable 370 Excel Buffer GetExcelReference
  11. 948callsTable 370 Excel Buffer SetFormula
  12. 948callsTable 370 Excel Buffer GetFormula
  13. 949writesTable 370 Excel Buffer Modify

AddToFormula line 956

  1. 961callsGetFormula
  2. 972callsSetFormula

SetFormula line 981

  1. 983callsClearFormula

NewRow line 1004

  1. 1006callsSetCurrent

AddColumn line 1009

  1. 1011callsAddColumnToBuffer

AddInfoColumn line 1014

  1. 1016callsAddColumnToBuffer

AddColumnToBuffer line 1019, local

  1. 1022callsNewRow
  2. 1026validatesTable 370 Excel Buffer Row No.
  3. 1027validatesTable 370 Excel Buffer Column No.
  4. 1029callsTable 370 Excel Buffer SetFormula
  5. 1038writesTable 370 Excel Buffer Insert
  6. 1039raisesOnAfterAddColumnToBuffer

EnterCell line 1042

  1. 1045validatesTable 370 Excel Buffer Row No.
  2. 1046validatesTable 370 Excel Buffer Column No.
  3. 1050validatesTable 370 Excel Buffer Cell Type
  4. 1052validatesTable 370 Excel Buffer Cell Type
  5. 1054validatesTable 370 Excel Buffer Cell Type
  6. 1061writesTable 370 Excel Buffer Insert(true)

StartRange line 1064

  1. 1068validatesTable 370 Excel Buffer Row No.
  2. 1069validatesTable 370 Excel Buffer Column No.

EndRange line 1075

  1. 1079validatesTable 370 Excel Buffer Row No.
  2. 1080validatesTable 370 Excel Buffer Column No.

CreateRange line 1086

  1. 1090callsGetExcelReference
  2. 1090callsGetExcelReference
  3. 1092callsGetExcelReference
  4. 1092callsGetExcelReference

ClearNewRow line 1095

  1. 1097callsSetCurrent

UTgetGlobalValue line 1105

  1. 1110raisesOnBeforeUTgetGlobalValueIsHandled

CreateValidationRule line 1142

  1. 1146callsGetExcelReference
  2. 1146callsGetExcelReference
  3. 1148callsGetExcelReference
  4. 1148callsGetExcelReference

CreateValidationRule line 1151

  1. 1155callsGetExcelReference
  2. 1156callsGetExcelReference
  3. 1156callsGetExcelReference
  4. 1158callsGetExcelReference
  5. 1158callsGetExcelReference

QuitExcel line 1161

  1. 1163callsCloseBook

OpenExcel line 1166

  1. 1168callsOpenUsingDocumentService
  2. 1171callsCodeunit 419 File Management DownloadHandler
  3. 1171callsGetFriendlyFilename

DownloadAndOpenExcel line 1175

  1. 1177callsOpenExcelWithName
  2. 1177callsGetFriendlyFilename

OpenExcelWithName line 1181

  1. 1186callsOpenUsingDocumentService
  2. 1189callsCodeunit 419 File Management DownloadHandler

OpenUsingDocumentService line 1192, local

  1. 1202raisesOnBeforeOpenUsingDocumentServiceIsHandled
  2. 1210callsCodeunit 9510 Document Service Management IsConfigured
  3. 1215callsCodeunit 9510 Document Service Management IsServiceUri
  4. 1218callsCodeunit 419 File Management GetFileName
  5. 1222callsCodeunit 9510 Document Service Management SaveFile
  6. 1223callsCodeunit 9510 Document Service Management OpenDocument

CreateBookAndOpenExcel line 1232

  1. 1234callsCreateBook
  2. 1235callsWriteSheet
  3. 1236callsCloseBook
  4. 1237callsOpenExcel

UpdateProgressDialog line 1240, local

  1. 1246raisesOnBeforeUpdateProgressDialogIsHandled
  2. 1255callsCodeunit 5370 Excel Buffer Dialog Management SetProgress

GetFriendlyFilename line 1262, local

  1. 1267callsCodeunit 419 File Management StripNotsupportChrInFileName

SaveToStream line 1289

  1. 1294callsCodeunit 419 File Management BLOBImportFromServerFile
  2. 1295callsCodeunit 4100 Temp Blob CreateInStream

GetSheetsNameListFromStream line 1301

  1. 1309writesTable 823 Name/Value Buffer DeleteAll
  2. 1327writesTable 823 Name/Value Buffer Insert
  3. 1331callsCloseBook