| Summary: | EDITING: PasteSpecial Number of MID function - Error | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | bugquestcontri |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | gerard.fargeot |
| Priority: | medium | ||
| Version: | 4.1.4.2 release | ||
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | screenshot of range showing the error and test file used to create screenshot | ||
MID function returns a *string*, it is normal that paste number doesn't paste the string. |
Created attachment 93898 [details] screenshot of range showing the error and test file used to create screenshot Problem description: Copy and paste special (only number) of MID function does not show value (number) in target cell, target cell is empty. Copy and paste special (only number) of sum of cells shows only result (value, number) Other functions are not tested. For paste special number following methods deliver the same result: ctrl+shift+v and selecting only "number" and past right click and select paste special and selecting only "number" and past right click and select paste only number See screenshot and test file in attachement Expected behavior: Paste special only number results in the value of the copied formula. Operating System: Windows XP Version: 4.1.4.2 release