تبدیل عدد به حروف فارسی در گوگل شیت

				
					/**
 * یک عدد را به معادل حروفی فارسی آن (شامل بخش صحیح و اعشار) تبدیل می‌کند.
 *
 * @param {number} num عددی که باید به حروف تبدیل شود.
 * @return {string} معادل حروفی فارسی عدد.
 * @customfunction
 * @ساخته شده توسط محمود بنی اسدی
 */
function NUMBERTOTEXTPERSIAN(num) {
  if (typeof num !== 'number') {
    return "";
  }

  const sign = num < 0 ? "منفی " : "";
  const numAbs = Math.abs(num);
  const intPart = Math.floor(numAbs);

  // Function equivalent to LAMBDA w in Google Sheets formula - converts a 3-digit number to Persian words.
  function convertThreeDigits(x) {
    // Ensure the input string is always 3 digits for consistent parsing
    const paddedX = String(x).padStart(3, '0'); 
    
    const h = ["", "صد", "دویست", "سیصد", "چهارصد", "پانصد", "ششصد", "هفتصد", "هشتصد", "نهصد"];
    const t = ["", "", "بیست", "سی", "چهل", "پنجاه", "شصت", "هفتاد", "هشتاد", "نود"];
    const o_single = ["", "یک", "دو", "سه", "چهار", "پنج", "شش", "هفت", "هشت", "نه"];
    const o_teen = ["ده", "یازده", "دوازده", "سیزده", "چهارده", "پانزده", "شانزده", "هفده", "هجده", "نوزده"];

    const h_val = parseInt(paddedX.substring(0, 1));
    const t_val = parseInt(paddedX.substring(1, 2));
    const o_val = parseInt(paddedX.substring(2, 3));

    let hundredWord = h[h_val];
    let tenWord = t[t_val];
    let oneWord;

    if (t_val === 1) { // Numbers 10-19
      oneWord = o_teen[o_val];
    } else {
      oneWord = o_single[o_val];
    }

    const parts = [];
    if (hundredWord) parts.push(hundredWord);
    if (tenWord) parts.push(tenWord);
    if (oneWord) parts.push(oneWord);

    return parts.filter(Boolean).join(" و ").trim();
  }

  // New helper function to convert a string of digits (up to 6) into Persian words,
  // focusing on its direct numerical value without adding large unit names like 'میلیون'.
  // This is specifically for the *value* of the decimal part.
  function convertDecimalValueToWords(digitsStr) {
    const len = digitsStr.length;
    if (len === 0 || parseInt(digitsStr) === 0) return "";

    // For up to 3 digits (e.g., "5", "54", "123")
    if (len <= 3) {
      return convertThreeDigits(digitsStr);
    } 
    // For 4 to 6 digits (e.g., "1234", "12345", "123456")
    else if (len >= 4 && len <= 6) {
      const val = parseInt(digitsStr, 10);
      if (val === 0) return "";

      // Pad to 6 digits to easily extract thousands and units parts
      const sixDigitPadded = String(val).padStart(6, '0');
      
      const parts = [];
      const thousandsPart = sixDigitPadded.substring(0, 3); // e.g., for "006548", this is "006"
      const unitsPart = sixDigitPadded.substring(3, 6);    // e.g., for "006548", this is "548"

      if (parseInt(thousandsPart, 10) !== 0) {
        parts.push(convertThreeDigits(thousandsPart) + " هزار");
      }
      if (parseInt(unitsPart, 10) !== 0) {
        parts.push(convertThreeDigits(unitsPart));
      }
      return parts.filter(Boolean).join(" و ");
    }
    return ""; // Should not reach here for expected inputs
  }

  // --- Integer Part Conversion ---
  // Pad the integer part with leading zeros to 15 digits
  const a = String(intPart).padStart(15, '0');

  let intText;
  if (a === "000000000000000") {
    intText = "صفر";
  } else {
    const intParts = [];
    if (a.substring(0, 3) !== "000") intParts.push(convertThreeDigits(a.substring(0, 3)) + " تریلیارد");
    if (a.substring(3, 6) !== "000") intParts.push(convertThreeDigits(a.substring(3, 6)) + " میلیارد");
    if (a.substring(6, 9) !== "000") intParts.push(convertThreeDigits(a.substring(6, 9)) + " میلیون");
    if (a.substring(9, 12) !== "000") intParts.push(convertThreeDigits(a.substring(9, 12)) + " هزار");
    if (a.substring(12, 15) !== "000") intParts.push(convertThreeDigits(a.substring(12, 15)));
    intText = intParts.filter(Boolean).join(" و ");
  }

  // --- Decimal Part Conversion ---
  const numAbsString = String(numAbs);
  let decAll = "";
  const decimalIndex = numAbsString.indexOf('.');
  if (decimalIndex !== -1) {
    decAll = numAbsString.substring(decimalIndex + 1);
  }

  // Trim trailing zeros from decAll for accurate length calculation
  decAll = decAll.replace(/0+$/, ''); 

  let decUsed = "";
  let decLen = 0;

  if (decAll !== '') { // If there are significant decimal digits
    decUsed = decAll.substring(0, 6); // Still limit to 6 digits for conversion
    decLen = decUsed.length; // Use the actual length of significant digits
  }
  
  let decText = "";
  if (decUsed !== "") {
    // Check if decimal part is not all zeros
    if (parseFloat(decUsed) !== 0) {
      let decWords = convertDecimalValueToWords(decUsed); // Use the new helper function

      const units = ["دهم", "صدم", "هزارم", "ده هزارم", "صد هزارم", "میلیونم"];
      const effectiveDecUnitIndex = decLen - 1; // Direct index based on significant length

      if (effectiveDecUnitIndex >= 0 && effectiveDecUnitIndex < units.length) {
          const unit = units[effectiveDecUnitIndex];
          decText = decWords + " " + unit;
      } else {
          decText = "اعشار نامعتبر"; // Fallback for unexpected lengths
      }
    }
  }

  // --- Final Result Assembly ---
  let result;
  if (decText !== "") {
    if (intText === "صفر" && numAbs < 1) { 
      result = sign + decText;
    } else { 
      result = sign + intText + " ممیز " + decText;
    }
  } else {
    result = sign + intText;
  }

  return result.trim();
}