Replies: 4 comments 2 replies
-
If you can test against PR #3962, please do so and let me know if it addresses your problem. As for equals sign in a cell, one way is: $sheet->setCellValueExplicit('A1','=', DataType::TYPE_STRING); |
Beta Was this translation helpful? Give feedback.
0 replies
-
Hi
I’ve tested both.
* On the =sign I get an error: Fatal error: Uncaught Error: Class "DataType" not found
* For the @ nothing changed
I composed the library with composer require phpoffice/phpspreadsheet:dev-master
Must I have used other options?
Jan
Van: oleibman ***@***.***>
Verzonden: maandag 15 april 2024 5:01
Aan: PHPOffice/PhpSpreadsheet ***@***.***>
CC: jr212 ***@***.***>; Author ***@***.***>
Onderwerp: Re: [PHPOffice/PhpSpreadsheet] ArrayFunctions like sort and sortby (Discussion #3864)
If you can test against PR #3962 <#3962> , please do so and let me know if it addresses your problem.
As for equals sign in a cell, one way is:
$sheet->setCellValueExplicit('A1','=', DataType::TYPE_STRING);
—
Reply to this email directly, view it on GitHub <#3864 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AKXCIPNKXPJIGMBLVW63KZLY5M7FRAVCNFSM6AAAAABBWI2QCGVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TCMJSHA2TM> .
You are receiving this because you authored the thread. <https://github.com/notifications/beacon/AKXCIPO5NIB5G7TR57W76GTY5M7FRA5CNFSM6AAAAABBWI2QCGWGG33NNVSW45C7OR4XAZNRIRUXGY3VONZWS33OINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQARMGRQ.gif> Message ID: ***@***.*** ***@***.***> >
|
Beta Was this translation helpful? Give feedback.
1 reply
-
hi
the =-sign works fine. However not for multiple cells. It would be nice to
note that in the manual.
thanks.
Any news for the @-problem?
Jan
Op di 16 apr 2024 om 15:45 schreef oleibman ***@***.***>:
… To avoid the DataType problem:
use PhpOffice\PhpSpreadsheet\Cell\DataType;;
—
Reply to this email directly, view it on GitHub
<#3864 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AKXCIPLAFV2TRXOMPECUYX3Y5UTPFAVCNFSM6AAAAABBWI2QCGVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TCMZQGQ2TO>
.
You are receiving this because you authored the thread.Message ID:
***@***.***
com>
--
Met vriendelijke groeten
Jan
***@***.***
|
Beta Was this translation helpful? Give feedback.
1 reply
-
Multiplecell like range a1:b2
Op wo 17 apr. 2024 04:14 schreef oleibman ***@***.***>:
… No news about at-sign. As I said, testing with the code from PR 3962 seems
to work adequately, albeit not perfectly.
Also, it seems that $sheet->getCell('A1')->setValue('='); works without
having to use setValueExplicit. If you have a case where it doesn't
please suppply more information. I am not sure what you mean by 'not for
multiple cells'.
—
Reply to this email directly, view it on GitHub
<#3864 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AKXCIPKUYSOBP322XEQV4C3Y5XLJFAVCNFSM6AAAAABBWI2QCGVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TCMZWGYZTQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***
com>
|
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Just tested version 2.0-Development hoping that I can use the new sort functions (https://support.microsoft.com/en-au/office/sortby-function-cd2d7a62-1b93-435c-b561-d6a35134f28f)
Unfortunately without luck. Meaning the function starts but must fill multiple rows and columns and only 1 cell is filled and a @ is in front of the formula. How can I correctly enter the formula?
Also How can I use only and nothing else that the equal sign in a cell? In Excel add a ‘ in front of the formula does the trick but here it’s Error 😊
Beta Was this translation helpful? Give feedback.
All reactions