https://bugs.documentfoundation.org/show_bug.cgi?id=149578
Bug ID: 149578
Summary: FILESAVE: WORKDAY function saved incorrectly in XLSX
format
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When opening a spreadsheet in Excel that has been saved by LibreOffice in XLSX
format the WORKDAY function instead shows up as:
com.sun.star.sheet.addin.Analysis.getWorkday
Steps to Reproduce:
1. create a cell containing a date ( for example, A1: =TODAY() )
2. create a cell containing a number of dates ( for example, B1: 1 )
3. create a cell containing the workday function that uses those cells ( C1:
=WORKDAY(A1,B1) )
4. save the document in XLSX format
5. open the document in MS Excel or Google Sheets
Actual Results:
C1: =com.sun.star.sheet.addin.Analysis.getWorkday(A1,B1)
Expected Results:
C1: =WORKDAY(A1,B1)
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.3.2.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 12; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.3-0ubuntu0.22.04.1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
