Bug 164230 - Unexpected negative number/time behavior with trailing minus sign
Summary: Unexpected negative number/time behavior with trailing minus sign
Status: RESOLVED DUPLICATE of bug 98362
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-12-07 12:29 UTC by gplhust955
Modified: 2024-12-07 12:56 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description gplhust955 2024-12-07 12:29:14 UTC 
Description:
When entering a number or time value followed by a minus sign in LibreOffice Calc, the value is unexpectedly converted to a negative number/time. Is it intended or not?

Steps to Reproduce:
1. Enter "123-" in a cell
2. Enter "12:34- am" in another cell
3. Enter "12:34 -" in another cell (with space)

Actual Results:
1. -123
2. -00:34:00
3. -12:34:00

Expected Results:
Calc treat them all as Text.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.3.2 (AARCH64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: macOS 15.0; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_CN.UTF-8); UI: en-US
Calc: threaded
Comment 1 Mike Kaganski 2024-12-07 12:56:59 UTC 

*** This bug has been marked as a duplicate of bug 98362 ***