Diagramma bilan faylni ochishda yana bir bor Excel dastur xatolariga duch keldim . An’anaga ko’ra, MS Office uchun keyingi yangilanishlarni o’rnatgandan so’ng muammolar paydo bo’la boshlaydi . Xato oxirgi foydalanuvchi tomonidan Excel 2016 da kuzatilgan. Ushbu xatolar guruhining xarakterli xususiyatlari quyidagilardan iborat:
- Grafiklar bilan faylni ochishda Excel dasturi ishlamay qoladi (yopiladi);
- Grafikni o’z ichiga olgan faylni ochmoqchi bo’lganingizda Excel dasturi xatosi paydo bo’ladi;
Xulosa shuki, diagrammalarni (grafiklarni) o’z ichiga olgan .xlsx faylini ochish jarayonida dastur ochilish (yuklash) bosqichida ishlamay qoladi va tegishli xato paydo bo’ladi: Microsoft Excel ishlashni to’xtatdi va xarakterli bildirishnoma oynasi:
Voqealar jurnalida biz 1000 hodisa kodi uchun yozuvni ko’ramiz va manba Ilova xatosi :
1
2
3
4
5
6
7
8
9
10
11
. . .
Имя сбойного приложения: EXCEL.EXE, версия: 16.0.4266.1001, отметка времени: 0x55ba1551
Имя сбойного модуля: chart.dll, версия: 16.0.4678.1000, отметка времени 0x5aa7ed63
Код исключения: 0xc0000005
Смещение ошибки: 0x00000000001ba0ac
Идентификатор сбойного процесса: 0x1cd0
Время запуска сбойного приложения: 0x01d6778ba326e37b
Путь сбойного приложения: C:\Program Files\Microsoft Office\Office16\EXCEL.EXE
Путь сбойного модуля: C:\Program Files\Microsoft Office\Office16\chart.dll
Код отчета: e98a17b4-e37e-11ea-b6ea-24be051d473e
. . .
Ilovaning ishdan chiqishini ( *.hdmp ) tahlil qilganda, siz odatda shunday istisno maʼlumotlarini koʻrasiz (chiqish kesiladi):
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
. . .
EXCEPTION_RECORD: (.exr -1)
ExceptionAddress: 000007fecc2ca0ac (CHART+0x00000000001ba0ac)
ExceptionCode: c0000005 (Access violation)
ExceptionFlags: 00000000
NumberParameters: 2
Parameter[0]: 0000000000000001
Parameter[1]: 0000000000000000
Attempt to write to address 0000000000000000
DEFAULT_BUCKET_ID: NULL_POINTER_WRITE
PROCESS_NAME: EXCEL.EXE
ERROR_CODE: (NTSTATUS) 0xc0000005 – <Unable to get error code text>
EXCEPTION_CODE: (NTSTATUS) 0xc0000005 – <Unable to get error code text>
EXCEPTION_CODE_STR: c0000005
EXCEPTION_PARAMETER1: 0000000000000001
EXCEPTION_PARAMETER2: 0000000000000000
WRITE_ADDRESS: 0000000000000000
. . .
ko’p hollarda bu kod bilan NTSTATUSc0000005– Kirish buzilishi, kirish taqiqlangan. Muayyan hodisa uchun mavzuning qo’ng’iroqlar to’plami quyidagicha ko’rinishga ega edi (chiqish yaxshiroq taqdimot uchun optimallashtirilgan):
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
. . .
STACK_TEXT:
00000000`001dd440 00000000`0b1adca0 : 000007fe`00000001 00000000`0b1a4b98 : CHART+0x1ba0ac
00000000`001dd448 000007fe`00000000 : 00000000`0b1a4b98 000007fe`cc14c52e : 0xb1adca0
00000000`001dd450 00000000`0b1adca0 : 000007fe`cc14c52e 00000000`0b15a0e0 : 0x000007fe`00000000
00000000`001dd458 000007fe`00000001 : 00000000`0b15a0e0 000007fe`cc1d17da : 0xb1adca0
00000000`001dd460 00000000`0b1a4b98 : 000007fe`cc1d17da 00000000`001dd5b0 : 0x000007fe`00000001
00000000`001dd468 000007fe`cc14c52e : 00000000`001dd5b0 00000000`8007000e : 0xb1a4b98
00000000`001dd470 00000000`0b15a0e0 : 00000000`8007000e 00000000`0b1a4b98 : CHART+0x3c52e
00000000`001dd478 000007fe`cc1d17da : 00000000`0b1a4b98 000007fe`cc2c5cd5 : 0xb15a0e0
00000000`001dd480 00000000`001dd5b0 : 000007fe`cc2c5cd5 00000000`0b134d70 : CHART+0xc17da
00000000`001dd488 00000000`8007000e : 00000000`0b134d70 00000000`00000009 : 0x1dd5b0
00000000`001dd490 00000000`0b1a4b98 : 00000000`00000009 00000000`00000001 : 0x8007000e
00000000`001dd498 000007fe`cc2c5cd5 : 00000000`00000001 00000000`00000000 : 0xb1a4b98
00000000`001dd4a0 00000000`0b134d70 : 00000000`00000000 00000000`0b05b7c0 : CHART+0x1b5cd5
00000000`001dd4a8 00000000`00000009 : 00000000`0b05b7c0 000007fe`cc41bcba : 0xb134d70
00000000`001dd4b0 00000000`00000001 : 000007fe`cc41bcba 00000000`0b183bd0 : 0x9
00000000`001dd4b8 00000000`00000000 : 00000000`0b183bd0 00000000`0b183bd0 : 0x1
. . .
Qo’ng’iroqlar to’plami shuni ko’rsatadiki, diagramma bilan faylni ochishda Excel dasturining xatosi chart.dll kutubxonasining (muayyan) funktsiyalarining chuqurligida sodir bo’ladi (kutubxona nomiga ko’ra grafiklar/diagrammalar uchun javobgardir), ichiga yuklangan. [asosiy] dastur jarayonining manzil maydoni. Bu odatda grafiklar deb ataladigan diagramma protsessoridagi muammolarni ko’rsatadi. Ma’lum bo’lishicha, xatolik qiymatlari filtr yordamida filtrlangan sana o’qi bo’lgan diagrammalarni o’z ichiga olgan fayllarda yuzaga keladi.
Yechim 1
- Office 2013: KB4018330 yangilanishini olib tashlang ;
- Office 2016: KB4018319 yangilanishini olib tashlang ;
Yechim 2
Yechim 3: universal
Aslida, ushbu bo’limda tasvirlanganlarga o’xshash echimlar uchun (hatto vaqtinchalik bo’lsa ham), mahalliy, yuqori darajada ixtisoslashgan muammoni yoritib beradigan bunday materiallar yaratilgan. Ushbu yechimlarning asosiy qiymati shundan iboratki, ular keyinchalik Microsoft Excel bilan, shuningdek, Microsoft Office to’plamidagi boshqa bir qator ilovalar bilan o’xshash hodisalar uchun kengaytirilishi mumkin. Quyida tavsiflangan harakatlar ketma-ketligi ishlab chiquvchidan tuzatishni (yamoqni) kutmasdan muammoni hal qilish imkonini beradi.
- Microsoft Office-ni tizimdan olib tashlash (o’chirish);
- Qolgan fayllarni C:\Program Files\Microsoft Office\Office XXkatalogidan o’chirib tashlaymiz , bu erda XX MS Office versiyasiga mos keladi;
- Microsoft Office-ni qayta o’rnating (tarqatishni toza o’rnatish);
- C:\Program Files\Microsoft Office\Office XX Office ishchi katalogining ildizida chart.dllfaylini toping va nusxasini yarating (uni istalgan [uchinchi tomon] vaqtinchalik papkasida saqlang).
- Biz Windows Update orqali Office uchun barcha mavjud yamoqlarni o’rnatamiz;
- Biz saqlagan chart.dll faylini [biz avvalroq] Office ishchi katalogiga nusxalash: C:\Program Files\Microsoft Office\Office 16 ;
Excel (yoki boshqa har qanday MS Office ilovasi) tomonidan foydalaniladigan kutubxona funksiyasi (.dll) kodidagi nosozlik tufayli yuzaga kelgan va [maʼlum] kutubxonalardan biri boʻlmagan har qanday muammoga taʼriflangan usulni nima uchun ekstrapolyatsiya qilmaslik kerak? muammolar boshqa (ko’proq ixtisoslashgan) usullar bilan hal qilinadimi? Ha, berilgan yechim juda egri va mashaqqatli, ammo shunga qaramay, agar sizga diagrammalar bilan faylni ochishda Excel xatosini yo’q qilish vazifasi berilgan bo’lsa va hozir, agar ertaga mos kelmasa va kecha kerak bo’lsa, demak u butunlay oqlangan. Ba’zan rasmiy echimni kutish juda uzoq vaqt talab etadi (amaliyot shuni ko’rsatadiki, ishlab chiquvchilarga ular aniqlangan paytdan boshlab bunday mikromuammolarni tuzatish uchun bir necha oy kerak bo’ladi);