Tag: #data-format
4 articles
-
When Search and Deduplication Quietly Fail on Japanese Data — Normalizing Full-Width / Half-Width Text in a C# App
An address in half-width kana, a phone number in full-width digits, the same company filed twice as "(株)" and "（株）" — Japanese input data mixes full-width and half-width characters, and as-is, search, deduplication, and totals all silently break. With ReoGrid you can bulk-convert using the Excel-compatible JIS / ASC functions, and auto-normalize on entry via AfterCellEdit. Build business data in C# that doesn't break on width inconsistency.
-
Stop Invoice Totals From Drifting by a Yen — Currency Formatting, Consumption Tax, and Rounding in C# with ReoGrid
Hold money in a double and you get rounding error; turn it into a string and totals and sorting break; round consumption tax in the wrong place and your invoice is off by a yen. Money breaks in business apps for predictable reasons. With ReoGrid, cell data stays numeric while it displays as ¥1,234,567 — and reduced-rate (8%/10%) subtotals and invoice-compliant rounding are just formulas.
-
Stop CSV Data From Being 'Fixed' When Opened in Excel — Control Encoding and Column Types in Your C# App
ZIP code 01950 becomes 1950, product code 1-2-3 becomes a date, and a UTF-8 file shows up as garbled text — CSV breaks because the file carries no type information and whatever opens it guesses. In your own app, you declare the encoding and the per-column types. Build a CSV viewer / importer in C# with ReoGrid that doesn't corrupt your data.
-
Japanese Era (Wareki) Date Cells in C# — Display 令和8年6月6日 While the Data Stays a DateTime
Invoices, contracts, birthdates — apps for the Japanese market must show dates in the era calendar (Reiwa, Heisei, Showa). Convert to strings and you break sorting and formulas. With ReoGrid, one format pattern shows wareki while every cell keeps a real DateTime.