Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Rantai Pasokan
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Diskusi
    • Approval
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri-Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Estate Management
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Temui penasihat
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Akuntansi
  • Inventaris
  • PoS
  • Project
  • MRP
All apps
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

Where can we learn about spreadsheet formula’s (v16)?

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
spreadsheetsodoo16features
4 Replies
9300 Tampilan
Avatar
Caribbean Data Challengers

Where can customers and partners find documentation about the new Odoo Spreadsheet app? There are some specific  formulas that pull data from Odoo, which are they and how do they work?

3
Avatar
Buang
Ayoub Aouad

have u get ur answer yet ?

Caribbean Data Challengers
Nope, documentation seems to be Odoo's weak spot ... 

On Thu, Nov 3, 2022 at 3:25 PM Ayoub Aouad <notifications@mail.odoo.com> wrote:

have u get ur answer yet ?

--
Ayoub Aouad

Envoyé par Odoo S.A. utilisant Odoo.

Ayoub Aouad
alright thank you

Le ven. 4 nov. 2022, 19:55, Toon van der ploeg <notifications@mail.odoo.com> a écrit :
Nope, documentation seems to be Odoo's weak spot ... 

On Thu, Nov 3, 2022 at 3:25 PM Ayoub Aouad <notifications@mail.odoo.com> wrote:

have u get ur answer yet ?

--
Ayoub Aouad

Envoyé par Odoo S.A. utilisant Odoo.

--
Caribbean Data Challengers

Sent by Odoo S.A. using Odoo.

Avatar
Edi Šuc
Jawaban Terbai

The documentation is here: https://www.odoo.com/documentation/16.0/applications/productivity/spreadsheet.html

0
Avatar
Buang
Avatar
Ray Carnes (ray)
Jawaban Terbai

We have some documentation of functions inside Odoo, where you use them:




1
Avatar
Buang
Florian Pichl

Hi Ray, those formulars are fantastic as they allow you to build reports without creating a pivot before, right?
Can you help me with this:
I would like to use a formula similar to "ODOO.BALANCE" but looking not for account codes but to any dimenions. E.g. I would like to use account.tags or account.types or anything else. Is that possible somehow? Are ther emore formulas available or only those 9 displayed?
Thank you in advance!

Ray Carnes (ray)

Hi Florian, the list you see is the complete list of formulas available. None of them provide access to account tags or types. If you list all accounts in your spreadsheet, and use the balance formula to get the balance, you can then use the 'relation' filtering feature of the spreadsheet to further filter by group or tag.

Avatar
Peatrick Schlaefli
Jawaban Terbai

first I look for the formula in google spreadsheet and then I look for it in odoo, there are similar functions

0
Avatar
Buang
Avatar
Ricardo Gross
Jawaban Terbai

Unfortunately there isn't yet a comprehensive documentation, but some hints can be found in the answers from:

https://www.odoo.com/fr_FR/forum/aide-1/how-to-migrate-excel-enthusiasts-to-odoo-spreadsheet-198613

0
Avatar
Buang
Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
Date format in Spreadsheets
spreadsheets odoo16features
Avatar
Avatar
1
Jul 25
2591
bug saving on spreadsheet document Diselesaikan
documents spreadsheets odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
9
Apr 25
4833
Can pivots from different models coexist in the same spreadsheet?
spreadsheets
Avatar
Avatar
1
Okt 25
2473
How do I build a Dashboard from a Spreadsheet?
spreadsheets
Avatar
Avatar
Avatar
2
Sep 25
978
Dashboard & Spreadsheet
spreadsheets
Avatar
1
Sep 25
2207
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Tugas
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo adalah rangkaian aplikasi bisnis open source yang mencakup semua kebutuhan perusahaan Anda: CRM, eCommerce, akuntansi, inventaris, point of sale, manajemen project, dan seterusnya.

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now