11import { EnvironmentId } from "@t3tools/contracts" ;
22import { act , type ReactNode } from "react" ;
33import { create , type ReactTestRenderer } from "react-test-renderer" ;
4+ import * as XLSX from "xlsx" ;
45import { afterEach , beforeEach , describe , expect , it , vi } from "vite-plus/test" ;
56
67import { AttachmentFilePreview } from "./AttachmentFilePreview" ;
8+ import {
9+ parseOfficeDocument ,
10+ type OfficeWorkerRequest ,
11+ type OfficeWorkerResponse ,
12+ } from "./officeDocumentParser" ;
713
814const { refresh } = vi . hoisted ( ( ) => ( { refresh : vi . fn < ( ) => Promise < string | null > > ( ) } ) ) ;
915
@@ -16,6 +22,13 @@ vi.mock("~/components/ChatMarkdown", () => ({ default: () => null }));
1622vi . mock ( "~/components/ui/scroll-area" , ( ) => ( {
1723 ScrollArea : ( { children } : { children : ReactNode } ) => children ,
1824} ) ) ;
25+ vi . mock ( "~/components/ui/button" , ( ) => ( {
26+ Button : ( {
27+ variant : _variant ,
28+ size : _size ,
29+ ...props
30+ } : React . ComponentProps < "button" > & { variant ?: string ; size ?: string } ) => < button { ...props } /> ,
31+ } ) ) ;
1932vi . mock ( "./ReadOnlySourcePreview" , ( ) => ( {
2033 default : ( { text } : { text : string } ) => < pre > { text } </ pre > ,
2134} ) ) ;
@@ -130,4 +143,87 @@ describe("attachment HTML preview recovery", () => {
130143 expect ( renderer . root . findAllByProps ( { role : "alert" } ) ) . toHaveLength ( 0 ) ;
131144 expect ( renderer . root . findByType ( "iframe" ) . props . title ) . toBe ( "document.html" ) ;
132145 } ) ;
146+
147+ it ( "renders an actual xlsx attachment with the legacy Excel MIME as Unicode cells and cached formulas" , async ( ) => {
148+ await import ( "./OfficeDocumentPreview" ) ;
149+ const workbook = XLSX . utils . book_new ( ) ;
150+ const sheet = XLSX . utils . aoa_to_sheet ( [
151+ [ "商品 🐈" , "数量" , "単価" , "合計" ] ,
152+ [ "りんご café" , 12 , 150 , 1800 ] ,
153+ ] ) ;
154+ sheet . D2 = { t : "n" , f : "B2*C2" , v : 1800 } ;
155+ XLSX . utils . book_append_sheet ( workbook , sheet , "売上" ) ;
156+ const file = new Blob (
157+ [ XLSX . write ( workbook , { type : "array" , bookType : "xlsx" , bookSST : true } ) ] ,
158+ { type : "application/vnd.ms-excel" } ,
159+ ) ;
160+ let complete : ( ( ) => void ) | undefined ;
161+ const parsed = new Promise < void > ( ( resolve ) => {
162+ complete = resolve ;
163+ } ) ;
164+ const terminate = vi . fn ( ) ;
165+ const formats : string [ ] = [ ] ;
166+ vi . stubGlobal (
167+ "Worker" ,
168+ class extends EventTarget {
169+ terminate = terminate ;
170+ constructor ( ) {
171+ super ( ) ;
172+ queueMicrotask ( ( ) =>
173+ this . dispatchEvent (
174+ new MessageEvent < OfficeWorkerResponse > ( "message" , { data : { type : "ready" } } ) ,
175+ ) ,
176+ ) ;
177+ }
178+ postMessage ( request : OfficeWorkerRequest ) {
179+ formats . push ( request . format ) ;
180+ let response : OfficeWorkerResponse ;
181+ try {
182+ response = {
183+ id : request . id ,
184+ ok : true ,
185+ document : parseOfficeDocument ( new Uint8Array ( request . buffer ) , request . format ) ,
186+ } ;
187+ } catch ( error ) {
188+ response = {
189+ id : request . id ,
190+ ok : false ,
191+ error : error instanceof Error ? error . message : "Could not parse workbook" ,
192+ } ;
193+ }
194+ this . dispatchEvent ( new MessageEvent < OfficeWorkerResponse > ( "message" , { data : response } ) ) ;
195+ complete ?.( ) ;
196+ }
197+ } ,
198+ ) ;
199+ await act ( async ( ) => {
200+ renderer = create (
201+ < AttachmentFilePreview
202+ name = "report.xlsx"
203+ mimeType = { file . type }
204+ sizeBytes = { file . size }
205+ file = { file }
206+ /> ,
207+ ) ;
208+ } ) ;
209+ await parsed ;
210+ await act ( async ( ) => { } ) ;
211+ expect ( formats ) . toEqual ( [ "xlsx" ] ) ;
212+ expect ( renderer . root . findByType ( "table" ) . props [ "aria-label" ] ) . toBe ( "売上 cell values" ) ;
213+ expect ( renderer . root . findAllByType ( "td" ) . map ( ( cell ) => cell . children . join ( "" ) ) ) . toEqual ( [
214+ "商品 🐈" ,
215+ "数量" ,
216+ "単価" ,
217+ "合計" ,
218+ "りんご café" ,
219+ "12" ,
220+ "150" ,
221+ "1800" ,
222+ ] ) ;
223+ expect ( renderer . root . findAllByProps ( { role : "alert" } ) ) . toHaveLength ( 0 ) ;
224+ expect ( renderer . root . findAllByType ( "pre" ) ) . toHaveLength ( 0 ) ;
225+ expect ( fetch ) . not . toHaveBeenCalled ( ) ;
226+ expect ( refresh ) . not . toHaveBeenCalled ( ) ;
227+ expect ( terminate ) . toHaveBeenCalledOnce ( ) ;
228+ } ) ;
133229} ) ;
0 commit comments